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

Reply via email to