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
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
