sql = select([func.add_user_f(xxx)],autocommit=True)
session.execute(sql)
Thanks
Madhu Alagu
On Apr 8, 8:07 pm, "Rick Morrison" <[EMAIL PROTECTED]> wrote:
> Would you please post the traceback that you're getting with this?
>
> Note that you don't need the session.begin() and session.flush() with a
> transactional sessions, the .begin() is implicit and the .flush() will be
> issued by the .commit()
>
>
>
>
>
> On Tue, Apr 8, 2008 at 1:51 AM, Madhu Alagu <[EMAIL PROTECTED]> wrote:
>
> > Hi,
>
> > I would like to use advantage of the Sqlalchemy & Stored Procedures.
>
> > engine = create_engine('postgres://postgres:[EMAIL PROTECTED]:5432/
> > neithal', echo=True)
> > session =
> > scoped_session(sessionmaker(bind=eng,transaction=True,autoflush=False))
> > trans=session.begin()
> > sql = select([func.add_user_f(108,'kk','kk')])
> > result = session.execute(sql)
> > result.close()
> > session.flush()
> > session.commit()
>
> > Thanks
>
> > Madhu Alagu
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To post to this group, send email to sqlalchemy@googlegroups.com
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
-~----------~----~----~----~------~----~------~--~---
