I added a ticket for this here:
http://trac.turbogears.org/ticket/1701
If you get time to throw a patch up there, that would be awesome.
Thanks!
On Jan 24, 2008 7:27 AM, Luciano G. Panaro <[EMAIL PROTECTED]> wrote:
>
> I can create a new ticket on trac, and submit a patch by adapting
> pylons' environment.py and model.__init__.py if you guys agree with
> it.
>
> -- Luciano
>
> On Jan 24, 2:38 am, "Mark Ramm" <[EMAIL PROTECTED]> wrote:
> > I guess we need to pull over the init_model() method, or show people
> > how to write their own. I origonally was leaning towards "write your
> > own" but this is really something we should be providing.
> >
> > --Mark Ramm
> >
>
> > On Jan 23, 2008 7:58 AM, Luciano G. Panaro <[EMAIL PROTECTED]> wrote:
> >
> >
> >
> >
> >
> > > Thanks for your help Mark
> >
> > > Here are the steps I followed:
> >
> > > * quickstarted my app
> > > * updated development.ini's sqlalchemy.url to use a mysql database
> > > * added the following code to model.__init__.py
> >
> > > t_clients = Table("clients", metadata, autoload=True,
> > > autoload_with=config['pylons.g'].sa_engine)
> >
> > > class Client(object):
> > > pass
> >
> > > mapper(Client, t_clients)
> >
> > > Nothing more than that (I have just followed these steps again). As I
> > > said before, I made it work in a new pylons-trunk project, but
> > > model.__init__.py works different: it has an init_model(engine)
> > > method, which is called from environment.py (this way, i didn't need
> > > to get the engine via the config).
> >
> > > Thanks again for your help.
> >
> > > On Jan 23, 10:23 am, "Mark Ramm" <[EMAIL PROTECTED]> wrote:
> > > > Could you post some code for us?
> >
> > > > We're more than happy to help, but I think we need a bit more
> > > > information.
> >
> > > > --Mark Ramm
> >
> > > > On Jan 22, 2008 2:30 PM, Luciano G. Panaro <[EMAIL PROTECTED]> wrote:
> >
> > > > > Hi guys,
> >
> > > > > I am trying tg2 and I've come across an issue when trying to reflect a
> > > > > table for my model. So I quickstarted my app, and followed the
> > > > > instructions
> > > > > athttp://wiki.pylonshq.com/display/pylonscookbook/SQLAlchemy+0.4+for+pe...
> >
> > > > > However, when the model.__init__.py tries to get
> > > > > config['pylons.g'].sa_engine, it crashes: "AttributeError: 'NoneType'
> > > > > object has no attribute 'sa_engine'"
> >
> > > > > So it looks that the config is not loaded when the model is imported.
> >
> > > > > I tried doing the reflection with a new Pylons (trunk) app and I was
> > > > > able to do it. However, the code inside environment.py and
> > > > > model.__init__.py is different, and I didn't need to get sa_engine to
> > > > > make it work.
> >
> > > > > Am I missing something? Have any of you guys got sqlalchemy's
> > > > > reflection working?
> >
> > > > > Thanks in advance :)
> >
> > > > --
> > > > Mark Ramm-Christensen
> > > > email: mark at compoundthinking dot com
> > > > blog:www.compoundthinking.com/blog
> >
> > --
> > Mark Ramm-Christensen
> > email: mark at compoundthinking dot com
> > blog:www.compoundthinking.com/blog
> >
>
--
Mark Ramm-Christensen
email: mark at compoundthinking dot com
blog: www.compoundthinking.com/blog
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"TurboGears Trunk" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/turbogears-trunk?hl=en
-~----------~----~----~----~------~----~------~--~---
