Account Options

  1. Sign in
The old Google Groups will be going away soon, but your browser is incompatible with the new version.
Google Groups Home
« Groups Home
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">&lt;<a href=3D"mailto:tac...@gmail.com" target=3D"_blank">t=
ac...@gmail.com</a>&gt;</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&#39;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&#39;t know if<br=
>
that&#39;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 &lt;<a href=3D"mailto:rayrigamonti=
@gmail.com">rayrigamo...@gmail.com</a>&gt; wrote:<br>
&gt; Hello Tac,<br>
&gt;<br>
&gt; I&#39;m having the same problem as yours, it seems. After runing:<br>
&gt; app/console propel:migration:generate-diff<br>
&gt; I just get: &quot;Reading databases structure...&quot;<br>
&gt;<br>
&gt; And no migration class is generated. Using --verbose does not add any<=
br>
&gt; details.<br>
&gt; I&#39;m using Symfony2, PropelBundle and PostgreSQL. Is this issue con=
nection<br>
&gt; related? Were you able to find a solution?<br>
&gt;<br>
&gt; Best Regards,<br>
&gt;<br>
&gt; Ray<br>
&gt;<br>
&gt; On Monday, January 9, 2012 5:18:35 PM UTC-4:30, Tac Tacelosky wrote:<b=
r>
&gt;&gt;<br>
&gt;&gt; The problem is that I have multiple database connections in my con=
fig.yml,<br>
&gt;&gt; and I don&#39;t think PropelBundle (or maybe it&#39;s PropelBridge=
) handles that.<br>
&gt;&gt;<br>
&gt;&gt; I tried to wander my way through the Phing code and config file<br=
>
&gt;&gt; generation, but couldn&#39;t isolate the problem. =A0But definitel=
y there&#39;s some<br>
&gt;&gt; issue related to the way Symfony and Propel talk to each other.<br=
>
&gt;&gt;<br>
&gt;&gt; There&#39;s a similar issue when trying to generate the sql and mo=
del files,<br>
&gt;&gt; the --connection parameter is ignored. =A0I have a legacy MySQL da=
tabase with<br>
&gt;&gt; a read-only connection, a read/write MySQL connection for my appli=
cation,<br>
&gt;&gt; and a sqlite connection for a city/zip code file. =A0I can&#39;t b=
uild or<br>
&gt;&gt; insert-sql using --connection, all the models / sql is built/inser=
ted<br>
&gt;&gt; regardless of the parameter.<br>
&gt;&gt;<br>
&gt;&gt; Any pointers on where to look to fix this?<br>
&gt;&gt;<br>
&gt;&gt; Thx,<br>
&gt;&gt;<br>
&gt;&gt; Tac<br>
&gt;&gt;<br>
&gt;&gt; On Mon, Jan 9, 2012 at 4:14 PM, Francois Zaninotto &lt;<a href=3D"=
mailto:fzani...@gmail.com">fzani...@gmail.com</a>&gt;<br>
&gt;&gt; wrote:<br>
&gt;&gt;&gt;<br>
&gt;&gt;&gt; Hi Tac,<br>
&gt;&gt;&gt;<br>
&gt;&gt;&gt; diff should give you more output with --verbose. Is there noth=
ing more<br>
&gt;&gt;&gt; than what you pasted? Then it must be a connection problem. No=
t sure how<br>
&gt;&gt;&gt; PropelBundle handles that.<br>
&gt;&gt;&gt;<br>
&gt;&gt;&gt; Cheers,<br>
&gt;&gt;&gt;<br>
&gt;&gt;&gt; Fran=E7ois<br>
&gt;&gt;&gt;<br>
&gt;&gt;&gt; 2012/1/4 Tac Tacelosky &lt;<a href=3D"mailto:tac...@gmail.com"=
>tac...@gmail.com</a>&gt;<br>
&gt;&gt;&gt;&gt;<br>
&gt;&gt;&gt;&gt; I&#39;m not able to get the migration commands to work in =
my Symfony<br>
&gt;&gt;&gt;&gt; installation, and am wondering how to debug them. =A0I&#39=
;m following along at<br>
&gt;&gt;&gt;&gt;<br>
&gt;&gt;&gt;&gt; <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>
&gt;&gt;&gt;&gt;<br>
&gt;&gt;&gt;&gt; but not getting meaningful output:<br>
&gt;&gt;&gt;&gt;<br>
&gt;&gt;&gt;&gt; $ php app/console propel:migration:generate-diff<br>
&gt;&gt;&gt;&gt; Reading databases structure...<br>
&gt;&gt;&gt;&gt;<br>
&gt;&gt;&gt;&gt; $ php app/console propel:migration:migrate<br>
&gt;&gt;&gt;&gt;<br>
&gt;&gt;&gt;&gt; I&#39;ve tried --verbose and =A0--force, but those fail, i=
t doesn&#39;t seem to<br>
&gt;&gt;&gt;&gt; even be writing any sql alter table statements, so I&#39;m=
 probably doing<br>
&gt;&gt;&gt;&gt; something wrong in the setup. =A0Any ideas where to look.<=
br>
&gt;&gt;&gt;&gt;<br>
&gt;&gt;&gt;&gt; On a related note, William suggested I fork and fix. =A0Mo=
st of Propel is<br>
&gt;&gt;&gt;&gt; probably out of my reach for contributing right now, but a=
dding --verbose to<br>
&gt;&gt;&gt;&gt; the command and getting more debug info seems within my gr=
asp. =A0But I&#39;m new<br>
&gt;&gt;&gt;&gt; to contributing code fixes via github, and in particular k=
eeping the<br>
&gt;&gt;&gt;&gt; versions in sync should I do that. =A0Is there a &quot;Gui=
de to Propel Code<br>
&gt;&gt;&gt;&gt; Contributions&quot; somewhere?<br>
&gt;&gt;&gt;&gt;<br>
&gt;&gt;&gt;&gt; Thx,<br>
&gt;&gt;&gt;&gt;<br>
&gt;&gt;&gt;&gt; Tac<br>
&gt;&gt;&gt;&gt;<br>
&gt;&gt;&gt;&gt; --<br>
&gt;&gt;&gt;&gt; You received this message because you are subscribed to th=
e Google<br>
&gt;&gt;&gt;&gt; Groups &quot;Propel Users&quot; group.<br>
&gt;&gt;&gt;&gt; To post to this group, send email to <a href=3D"mailto:pro=
pel...@googlegroups.com">propel...@googlegroups.com</a>.<br>
&gt;&gt;&gt;&gt; To unsubscribe from this group, send email to<br>
&gt;&gt;&gt;&gt; <a href=3D"mailto:propel-users...@googlegroups.com">propel=
-users...@googlegroups.com</a>.<br>
&gt;&gt;&gt;&gt;<br>
&gt;&gt;&gt;&gt; For more options, visit this group at<br>
&gt;&gt;&gt;&gt; <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>
&gt;&gt;&gt;<br>
&gt;&gt;&gt;<br>
&gt;&gt;&gt; --<br>
&gt;&gt;&gt; You received this message because you are subscribed to the Go=
ogle Groups<br>
&gt;&gt;&gt; &quot;Propel Users&quot; group.<br>
&gt;&gt;&gt; To post to this group, send email to <a href=3D"mailto:propel.=
..@googlegroups.com">propel...@googlegroups.com</a>.<br>
&gt;&gt;&gt; To unsubscribe from this group, send email to<br>
&gt;&gt;&gt; <a href=3D"mailto:propel-users...@googlegroups.com">propel-use=
rs...@googlegroups.com</a>.<br>
&gt;&gt;&gt;<br>
&gt;&gt;&gt; For more options, visit this group at<br>
&gt;&gt;&gt; <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>
&gt;&gt;<br>
&gt;&gt;<br>
&gt; --<br>
&gt; You received this message because you are subscribed to the Google Gro=
ups<br>
&gt; &quot;Propel Users&quot; group.<br>
&gt; To view this discussion on the web visit<br>
&gt; <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>
&gt;<br>
&gt; To post to this group, send email to <a href=3D"mailto:propel-users@go=
oglegroups.com">propel-users@googlegroups.com</a>.<br>
&gt; To unsubscribe from this group, send email to<br>
&gt; <a href=3D"mailto:propel-users%2Bunsubscribe@googlegroups.com">propel-=
users+unsubscribe@googlegroups.com</a>.<br>
&gt; For more options, visit this group at<br>
&gt; <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&quot; 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--