Figured out how to run the called procedure.
sql = db.sa.text(select trans_value from t(:totrans, :username),
bindparams=[db.sa.bindparam('totrans', 'some text
orig'),
db.sa.bindparam('username', me.name)])
result =
Werner F. Bruhin wrote:
Figured out how to run the called procedure.
sql = db.sa.text(select trans_value from t(:totrans, :username),
bindparams=[db.sa.bindparam('totrans', 'some text
orig'),
db.sa.bindparam('username', me.name)])
result
Michael Bayer wrote:
Werner F. Bruhin wrote:
Figured out how to run the called procedure.
sql = db.sa.text(select trans_value from t(:totrans, :username),
bindparams=[db.sa.bindparam('totrans', 'some text
orig'),
Correction, have to do a fetchxxx on the cursor to get the result.
me = session.query(db.Users).get(1)
cur = engine.raw_connection().cursor()
cur.callproc('t', ('some text orig', me.name))
print cur.fetchone()
On Aug 2, 6:04 pm, Werner F. Bruhin wbru...@gmail.com wrote:
I can't figure quit