I can't figure quit figure this out.
In an FB admin tool I can do:
select * from "T"('some text orig', 'wbruhin');
or
execute procedure "T"('some text orig', 'wbruhin');
And they return:
a varchar "some text orig auf Deutsch"
The following runs without error:
...
me = session.query(db.Users).get(1)
cur = engine.raw_connection().cursor()
result = cur.callproc('t', ('some text orig', me.name))
but result just contains "('some text orig', me.name)"
What is the correct way to run a stored procedure with Firebird and SA?
And could I define a stored procedure in a mapper, to create an
additional column, i.e. something like the above in a mapper, i.e.:
class Sample(Base):
__table__ = sa.Table(u'sample', metadata,
sa.Column(u'id', sa.Integer(), sa.Sequence('gen_sample_id'),
primary_key=True, nullable=False),
sa.Column(u'name', sa.String(length=256, convert_unicode=False)),
'name_trans': column_property(
select([func.t(sample_table.c.name, me.name)]).
label('address_count')
)
Thanks for any hints.
Werner
--~--~---------~--~----~------------~-------~--~----~
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
sqlalchemy+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/sqlalchemy?hl=en
-~----------~----~----~----~------~----~------~--~---
