db.engine = engine
sm = sessionmaker(autoflush=True,
transactional=True,bind=db.engine)
db.Session =scoped_session(sm)
trans=db.Session.begin()
db.Session.execute('set search_path to neithal,public')
trans.commit()
db.Session.commit()
_f = select([func.login_f(xxx)])
rs = db.Session.execute(_f)
Now,It's working fine.
Thanks
Madhu Alagu
On Apr 8, 5:41 pm, Michael Bayer <[EMAIL PROTECTED]> wrote:
> On Apr 8, 2008, at 10:33 AM, Madhu Alagu wrote:
>
>
>
> > Hi,
>
> > How to set schema in sqlalchemy ?.(Set search_path To neithal,public)
>
> > #neithal.login_f
> > #select([func.login_f(username,password,lang)])
>
> try func.neithal.login_f(xxx)
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"sqlalchemy" 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/sqlalchemy?hl=en
-~----------~----~----~----~------~----~------~--~---