Message from discussion
Propel Migration -- how to test?
Received: by 10.204.5.194 with SMTP id 2mr1554098bkw.7.1349874490400;
Wed, 10 Oct 2012 06:08:10 -0700 (PDT)
X-BeenThere: propel-users@googlegroups.com
Received: by 10.204.151.24 with SMTP id a24ls318634bkw.1.gmail; Wed, 10 Oct
2012 06:08:09 -0700 (PDT)
Received: by 10.204.145.140 with SMTP id d12mr1555990bkv.6.1349874489011;
Wed, 10 Oct 2012 06:08:09 -0700 (PDT)
Received: by 10.204.145.140 with SMTP id d12mr1555988bkv.6.1349874488968;
Wed, 10 Oct 2012 06:08:08 -0700 (PDT)
Return-Path: <fzanino...@gmail.com>
Received: from mail-lb0-f182.google.com (mail-lb0-f182.google.com [209.85.217.182])
by gmr-mx.google.com with ESMTPS id 27si153159bks.3.2012.10.10.06.08.08
(version=TLSv1/SSLv3 cipher=OTHER);
Wed, 10 Oct 2012 06:08:08 -0700 (PDT)
Received-SPF: pass (google.com: domain of fzanino...@gmail.com designates 209.85.217.182 as permitted sender) client-ip=209.85.217.182;
Authentication-Results: gmr-mx.google.com; spf=pass (google.com: domain of fzanino...@gmail.com designates 209.85.217.182 as permitted sender) smtp.mail=fzanino...@gmail.com; dkim=pass header...@gmail.com
Received: by mail-lb0-f182.google.com with SMTP id b5so382847lbd.41
for <propel-users@googlegroups.com>; Wed, 10 Oct 2012 06:08:08 -0700 (PDT)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
d=gmail.com; s=20120113;
h=mime-version:in-reply-to:references:from:date:message-id:subject:to
:content-type;
bh=G4uMziID+aIFa7E6mdD41blCf3O62r1kSOnbwJDWoak=;
b=oIfbSXqgWzg/sNR3bD5vycWPVDsWF/6l8AIep0N0lgKRWM2Ss9hheMT+Gs9KxFlyFs
UL+ce55LEg7FQbQ8VRfO4GICAsiN0ge3E8Iy2eeURo2gUKz3CgzeaMsuuzW8MBFHuzlO
ktEj/RHaWPUcMSBg+3NLLyaw7BS0ApSn9TTFaQzGVsjASVvv5Z3RxlSCOmKyau44+kjn
6Bloj+wafTM3bPJWUXu1RM/J+ggEBdZKJXWSsC4RwUga04/jkv6SuuiRY5FE9Da8IbKE
2xDqucDYuK/9RwTbdZc8mzAjZROB8EBpeS97ZCliZF9gtrBR8mH97YqLEbxzfflpADGY
2AUQ==
Received: by 10.152.132.168 with SMTP id ov8mr20048435lab.0.1349874488487;
Wed, 10 Oct 2012 06:08:08 -0700 (PDT)
MIME-Version: 1.0
Received: by 10.114.10.162 with HTTP; Wed, 10 Oct 2012 06:07:48 -0700 (PDT)
In-Reply-To: <CAM2ujmATTzU9dcdae_Bs2w8h_=cL__--r0GRk4gqc2XmP4R...@mail.gmail.com>
References: <CAM2ujmDMdUoHi+4tKRwwLsuPoo=u3nBRSZ2Xf7Cbt-k2ds0...@mail.gmail.com>
<CAJQoyD0xTV-_MeG8C=MEDk8WRE1ZbxoVe_iRegENGof25Dg...@mail.gmail.com>
<CAM2ujmALdT-UvEXC-EM+rcYEhy-5hHTaf5wveqmCbf9z0PP...@mail.gmail.com>
<e76c170a-268c-4c61-97f9-1559aa0aa396@googlegroups.com> <CAM2ujmATTzU9dcdae_Bs2w8h_=cL__--r0GRk4gqc2XmP4R...@mail.gmail.com>
From: Francois Zaninotto <fzanino...@gmail.com>
Date: Wed, 10 Oct 2012 15:07:48 +0200
Message-ID: <CAJQoyD1nO2mH6aARO5=E-c8An8afkbY_=6Fr7oiwJ36up2m...@mail.gmail.com>
Subject: Re: [propel] Propel Migration -- how to test?
To: propel-users@googlegroups.com
Content-Type: multipart/alternative; boundary=f46d043085f460aee404cbb4259a
--f46d043085f460aee404cbb4259a
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Hi Tac,
As of now, in Propel2, this is not possible. Both generator and runtime
rely on a single class defining all the types, used for binding and special
cases.
However, the refactoring necessary to support custom column types, which
implies to create a class for each of the currently supported column types,
is not incredibly difficult. And it would be very useful IMHO.
Would you like to give it a try?
Fran=E7ois
2012/10/10 Tac Tacelosky <tac...@gmail.com>
> No solution. I keep thinking that when Propel2 is closer to release I
> can test it and there and maybe get it into the test suite. There are
> also issues with PostGRES fields / tables not being quoted.
>
> We love PostGRES, and in the recently-released 9.2, it now supposed
> native JSON fields. I'm hoping that Propel2 will allow developers to
> define their own mappings, so that things like array, json, xml,
> lat/long and geometry can be mapped into the ORM. I don't know if
> that's really the case though. William? Francois?
>
> Tac
>
> On Tue, Oct 9, 2012 at 6:56 PM, RayOnAir <rayrigamo...@gmail.com> wrote:
> > Hello Tac,
> >
> > I'm having the same problem as yours, it seems. After runing:
> > app/console propel:migration:generate-diff
> > I just get: "Reading databases structure..."
> >
> > And no migration class is generated. Using --verbose does not add any
> > details.
> > I'm using Symfony2, PropelBundle and PostgreSQL. Is this issue connecti=
on
> > related? Were you able to find a solution?
> >
> > Best Regards,
> >
> > Ray
> >
> > On Monday, January 9, 2012 5:18:35 PM UTC-4:30, Tac Tacelosky wrote:
> >>
> >> The problem is that I have multiple database connections in my
> config.yml,
> >> and I don't think PropelBundle (or maybe it's PropelBridge) handles
> that.
> >>
> >> I tried to wander my way through the Phing code and config file
> >> generation, but couldn't isolate the problem. But definitely there's
> some
> >> issue related to the way Symfony and Propel talk to each other.
> >>
> >> There's a similar issue when trying to generate the sql and model file=
s,
> >> the --connection parameter is ignored. I have a legacy MySQL database
> with
> >> a read-only connection, a read/write MySQL connection for my
> application,
> >> and a sqlite connection for a city/zip code file. I can't build or
> >> insert-sql using --connection, all the models / sql is built/inserted
> >> regardless of the parameter.
> >>
> >> Any pointers on where to look to fix this?
> >>
> >> Thx,
> >>
> >> Tac
> >>
> >> On Mon, Jan 9, 2012 at 4:14 PM, Francois Zaninotto <fzani...@gmail.com=
>
> >> wrote:
> >>>
> >>> Hi Tac,
> >>>
> >>> diff should give you more output with --verbose. Is there nothing mor=
e
> >>> than what you pasted? Then it must be a connection problem. Not sure
> how
> >>> PropelBundle handles that.
> >>>
> >>> Cheers,
> >>>
> >>> Fran=E7ois
> >>>
> >>> 2012/1/4 Tac Tacelosky <tac...@gmail.com>
> >>>>
> >>>> I'm not able to get the migration commands to work in my Symfony
> >>>> installation, and am wondering how to debug them. I'm following
> along at
> >>>>
> >>>> http://www.propelorm.org/cookbook/symfony2/working-with-symfony2.htm=
l
> >>>>
> >>>> but not getting meaningful output:
> >>>>
> >>>> $ php app/console propel:migration:generate-diff
> >>>> Reading databases structure...
> >>>>
> >>>> $ php app/console propel:migration:migrate
> >>>>
> >>>> I've tried --verbose and --force, but those fail, it doesn't seem t=
o
> >>>> even be writing any sql alter table statements, so I'm probably doin=
g
> >>>> something wrong in the setup. Any ideas where to look.
> >>>>
> >>>> On a related note, William suggested I fork and fix. Most of Propel
> is
> >>>> probably out of my reach for contributing right now, but adding
> --verbose to
> >>>> the command and getting more debug info seems within my grasp. But
> I'm new
> >>>> to contributing code fixes via github, and in particular keeping the
> >>>> versions in sync should I do that. Is there a "Guide to Propel Code
> >>>> Contributions" somewhere?
> >>>>
> >>>> Thx,
> >>>>
> >>>> Tac
> >>>>
> >>>> --
> >>>> You received this message because you are subscribed to the Google
> >>>> Groups "Propel Users" group.
> >>>> To post to this group, send email to propel...@googlegroups.com.
> >>>> To unsubscribe from this group, send email to
> >>>> propel-users...@googlegroups.com.
> >>>>
> >>>> For more options, visit this group at
> >>>> http://groups.google.com/group/propel-users?hl=3Den.
> >>>
> >>>
> >>> --
> >>> You received this message because you are subscribed to the Google
> Groups
> >>> "Propel Users" group.
> >>> To post to this group, send email to propel...@googlegroups.com.
> >>> To unsubscribe from this group, send email to
> >>> propel-users...@googlegroups.com.
> >>>
> >>> For more options, visit this group at
> >>> http://groups.google.com/group/propel-users?hl=3Den.
> >>
> >>
> > --
> > You received this message because you are subscribed to the Google Grou=
ps
> > "Propel Users" group.
> > To view this discussion on the web visit
> > https://groups.google.com/d/msg/propel-users/-/aOtwDja1sl4J.
> >
> > To post to this group, send email to propel-users@googlegroups.com.
> > To unsubscribe from this group, send email to
> > propel-users+unsubscribe@googlegroups.com.
> > For more options, visit this group at
> > http://groups.google.com/group/propel-users?hl=3Den.
>
> --
> You received this message because you are subscribed to the Google Groups
> "Propel Users" group.
> To post to this group, send email to propel-users@googlegroups.com.
> To unsubscribe from this group, send email to
> propel-users+unsubscribe@googlegroups.com.
> For more options, visit this group at
> http://groups.google.com/group/propel-users?hl=3Den.
>
>
--f46d043085f460aee404cbb4259a
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Hi Tac,<div><br></div><div>As of now, in Propel2, this is not possible. Bot=
h generator and runtime rely on a single class defining all the types, used=
for binding and special cases.</div><div><br></div><div>However, the refac=
toring necessary to support custom column types, which implies to create a =
class for each of the currently supported column types, is not incredibly d=
ifficult. And it would be very useful IMHO.</div>
<div><br></div><div>Would you like to give it a try?</div><div><br></div><d=
iv>Fran=E7ois<br><br><div class=3D"gmail_quote">2012/10/10 Tac Tacelosky <s=
pan dir=3D"ltr"><<a href=3D"mailto:tac...@gmail.com" target=3D"_blank">t=
ac...@gmail.com</a>></span><br>
<blockquote class=3D"gmail_quote" style=3D"margin:0 0 0 .8ex;border-left:1p=
x #ccc solid;padding-left:1ex">No solution. =A0I keep thinking that when Pr=
opel2 is closer to release I<br>
can test it and there and maybe get it into the test suite. =A0There are<br=
>
also issues with PostGRES fields / tables not being quoted.<br>
<br>
We love PostGRES, and in the recently-released 9.2, it now supposed<br>
native JSON fields. =A0I'm hoping that Propel2 will allow developers to=
<br>
define their own mappings, so that things like array, json, xml,<br>
lat/long and geometry can be mapped into the ORM. =A0I don't know if<br=
>
that's really the case though. =A0William? Francois?<br>
<span class=3D"HOEnZb"><font color=3D"#888888"><br>
Tac<br>
</font></span><div class=3D"HOEnZb"><div class=3D"h5"><br>
On Tue, Oct 9, 2012 at 6:56 PM, RayOnAir <<a href=3D"mailto:rayrigamonti=
@gmail.com">rayrigamo...@gmail.com</a>> wrote:<br>
> Hello Tac,<br>
><br>
> I'm having the same problem as yours, it seems. After runing:<br>
> app/console propel:migration:generate-diff<br>
> I just get: "Reading databases structure..."<br>
><br>
> And no migration class is generated. Using --verbose does not add any<=
br>
> details.<br>
> I'm using Symfony2, PropelBundle and PostgreSQL. Is this issue con=
nection<br>
> related? Were you able to find a solution?<br>
><br>
> Best Regards,<br>
><br>
> Ray<br>
><br>
> On Monday, January 9, 2012 5:18:35 PM UTC-4:30, Tac Tacelosky wrote:<b=
r>
>><br>
>> The problem is that I have multiple database connections in my con=
fig.yml,<br>
>> and I don't think PropelBundle (or maybe it's PropelBridge=
) handles that.<br>
>><br>
>> I tried to wander my way through the Phing code and config file<br=
>
>> generation, but couldn't isolate the problem. =A0But definitel=
y there's some<br>
>> issue related to the way Symfony and Propel talk to each other.<br=
>
>><br>
>> There's a similar issue when trying to generate the sql and mo=
del files,<br>
>> the --connection parameter is ignored. =A0I have a legacy MySQL da=
tabase with<br>
>> a read-only connection, a read/write MySQL connection for my appli=
cation,<br>
>> and a sqlite connection for a city/zip code file. =A0I can't b=
uild or<br>
>> insert-sql using --connection, all the models / sql is built/inser=
ted<br>
>> regardless of the parameter.<br>
>><br>
>> Any pointers on where to look to fix this?<br>
>><br>
>> Thx,<br>
>><br>
>> Tac<br>
>><br>
>> On Mon, Jan 9, 2012 at 4:14 PM, Francois Zaninotto <<a href=3D"=
mailto:fzani...@gmail.com">fzani...@gmail.com</a>><br>
>> wrote:<br>
>>><br>
>>> Hi Tac,<br>
>>><br>
>>> diff should give you more output with --verbose. Is there noth=
ing more<br>
>>> than what you pasted? Then it must be a connection problem. No=
t sure how<br>
>>> PropelBundle handles that.<br>
>>><br>
>>> Cheers,<br>
>>><br>
>>> Fran=E7ois<br>
>>><br>
>>> 2012/1/4 Tac Tacelosky <<a href=3D"mailto:tac...@gmail.com"=
>tac...@gmail.com</a>><br>
>>>><br>
>>>> I'm not able to get the migration commands to work in =
my Symfony<br>
>>>> installation, and am wondering how to debug them. =A0I'=
;m following along at<br>
>>>><br>
>>>> <a href=3D"http://www.propelorm.org/cookbook/symfony2/work=
ing-with-symfony2.html" target=3D"_blank">http://www.propelorm.org/cookbook=
/symfony2/working-with-symfony2.html</a><br>
>>>><br>
>>>> but not getting meaningful output:<br>
>>>><br>
>>>> $ php app/console propel:migration:generate-diff<br>
>>>> Reading databases structure...<br>
>>>><br>
>>>> $ php app/console propel:migration:migrate<br>
>>>><br>
>>>> I've tried --verbose and =A0--force, but those fail, i=
t doesn't seem to<br>
>>>> even be writing any sql alter table statements, so I'm=
probably doing<br>
>>>> something wrong in the setup. =A0Any ideas where to look.<=
br>
>>>><br>
>>>> On a related note, William suggested I fork and fix. =A0Mo=
st of Propel is<br>
>>>> probably out of my reach for contributing right now, but a=
dding --verbose to<br>
>>>> the command and getting more debug info seems within my gr=
asp. =A0But I'm new<br>
>>>> to contributing code fixes via github, and in particular k=
eeping the<br>
>>>> versions in sync should I do that. =A0Is there a "Gui=
de to Propel Code<br>
>>>> Contributions" somewhere?<br>
>>>><br>
>>>> Thx,<br>
>>>><br>
>>>> Tac<br>
>>>><br>
>>>> --<br>
>>>> You received this message because you are subscribed to th=
e Google<br>
>>>> Groups "Propel Users" group.<br>
>>>> To post to this group, send email to <a href=3D"mailto:pro=
pel...@googlegroups.com">propel...@googlegroups.com</a>.<br>
>>>> To unsubscribe from this group, send email to<br>
>>>> <a href=3D"mailto:propel-users...@googlegroups.com">propel=
-users...@googlegroups.com</a>.<br>
>>>><br>
>>>> For more options, visit this group at<br>
>>>> <a href=3D"http://groups.google.com/group/propel-users?hl=
=3Den" target=3D"_blank">http://groups.google.com/group/propel-users?hl=3De=
n</a>.<br>
>>><br>
>>><br>
>>> --<br>
>>> You received this message because you are subscribed to the Go=
ogle Groups<br>
>>> "Propel Users" group.<br>
>>> To post to this group, send email to <a href=3D"mailto:propel.=
..@googlegroups.com">propel...@googlegroups.com</a>.<br>
>>> To unsubscribe from this group, send email to<br>
>>> <a href=3D"mailto:propel-users...@googlegroups.com">propel-use=
rs...@googlegroups.com</a>.<br>
>>><br>
>>> For more options, visit this group at<br>
>>> <a href=3D"http://groups.google.com/group/propel-users?hl=3Den=
" target=3D"_blank">http://groups.google.com/group/propel-users?hl=3Den</a>=
.<br>
>><br>
>><br>
> --<br>
> You received this message because you are subscribed to the Google Gro=
ups<br>
> "Propel Users" group.<br>
> To view this discussion on the web visit<br>
> <a href=3D"https://groups.google.com/d/msg/propel-users/-/aOtwDja1sl4J=
" target=3D"_blank">https://groups.google.com/d/msg/propel-users/-/aOtwDja1=
sl4J</a>.<br>
><br>
> To post to this group, send email to <a href=3D"mailto:propel-users@go=
oglegroups.com">propel-users@googlegroups.com</a>.<br>
> To unsubscribe from this group, send email to<br>
> <a href=3D"mailto:propel-users%2Bunsubscribe@googlegroups.com">propel-=
users+unsubscribe@googlegroups.com</a>.<br>
> For more options, visit this group at<br>
> <a href=3D"http://groups.google.com/group/propel-users?hl=3Den" target=
=3D"_blank">http://groups.google.com/group/propel-users?hl=3Den</a>.<br>
<br>
--<br>
You received this message because you are subscribed to the Google Groups &=
quot;Propel Users" group.<br>
To post to this group, send email to <a href=3D"mailto:propel-users@googleg=
roups.com">propel-users@googlegroups.com</a>.<br>
To unsubscribe from this group, send email to <a href=3D"mailto:propel-user=
s%2Bunsubscribe@googlegroups.com">propel-users+unsubscribe@googlegroups.com=
</a>.<br>
For more options, visit this group at <a href=3D"http://groups.google.com/g=
roup/propel-users?hl=3Den" target=3D"_blank">http://groups.google.com/group=
/propel-users?hl=3Den</a>.<br>
<br>
</div></div></blockquote></div><br></div>
--f46d043085f460aee404cbb4259a--