That's fixed it. Thanks very much for replying so quickly,
John
On 7 Sep, 18:33, "Uwe C. Schroeder" <[EMAIL PROTECTED]> wrote:
> On Friday 07 September 2007, Uwe C. Schroeder wrote:
>
>
>
> > On Friday 07 September 2007, johnbraduk wrote:
> > > When I try to use autoload=True to access existing tables I get the
> > > following error with SQLAlchemy. I see this has been reported before,
> > > but I did not see a solution. Is there a fix?
> > > Thanks
> > > John Bradbury
>
> > > "This SchemaItem is not connected to any Engine or Connection."
>
> > > First lines from model.py below:
>
> > > from datetime import datetime
> > > from sqlalchemy import *
> > > from turbogears.database import metadata, session
> > > from sqlalchemy.ext.assignmapper import assign_mapper
> > > from turbogears import identity
> > > # The identity schema.
>
> > > transjobs_table = Table('JOBS',metadata, autoload=True)
>
> > Add
>
> > from turbogears.database import bind_meta_data, get_engine
> > bind_meta_data()
> > engine=get_engine()
>
> > to the top of your model.py
>
> Just noticed: probably you don't need the engine= line - I'm just using the
> engine directly for some queries that were just too tedious to set up with
> python syntax.
>
> Uwe
>
> --
> Open Source Solutions 4U, LLC 1618 Kelly St
> Phone: +1 707 568 3056 Santa Rosa, CA 95401
> Cell: +1 650 302 2405 United States
> Fax: +1 707 568 6416
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"TurboGears" 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?hl=en
-~----------~----~----~----~------~----~------~--~---
