not really. execute_text() takes **params (and *args). heres some
unit test code:
conn.execute("insert into users (user_id, user_name) values (%(id)s, %
(name)s)", id=4, name='sally')
conn.execute("insert into users (user_id, user_name) values (%(id)s, %
(name)s)", {'id':2, 'name':'ed'}, {'id':3, 'name':'horse'})
conn.execute("insert into users (user_id, user_name) values (%s, %s)",
[2,"ed"], [3,"horse"])
conn.execute("insert into users (user_id, user_name) values (%s, %s)",
4, 'sally')
postgreSQL is going to want "pyformat" params for what youre doing.
On Jun 13, 4:17 pm, kwarg <[EMAIL PROTECTED]> wrote:
> Calling a PostgreSQL stored procedure using a DB connection object:
> conn.execute("select * from my_stored_procedure(:p1)", p1 = 10)
> throws the following
> TypeError: execute_text() got an unexpected keyword argument 'p1'.
> Any ideas?
> Thanks.
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
