Hello pyramid friends,
I am currently using SQLAlchemy for a current pyramid project, however, I
have come to a point where I need to be able to run some raw Postgres
queries that have been parameterized (word?).
I have tried the following to no avail:
DBSession().execute(
''
INSERT INTO users(id, user_name)
VALUES (:id, :user_name)
''',
{
'id': 2422,
'user_name': 'someguy'
})
The query appears to work since no error is thrown, however, no data is
inserted into the database. What is the best way to run parameterized
queries with SQLAlchemy?
Thanks for your help.
-Vincent
--
You received this message because you are subscribed to the Google Groups
"pylons-discuss" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at http://groups.google.com/group/pylons-discuss?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.
