Hi,
my program tries to read data from a configurable, unknown user table.
So I came up with such a statement:
result = self.session.execute("SELECT * FROM :mytable", {"mytable":
self.table})
But when I run it, I get this, what I do not understand:
result = self.session.execute("SELECT * FROM :mytable", {"mytable":
"wp_users"})
File "/usr/lib/python2.7/dist-packages/sqlalchemy/orm/session.py", line
791, in execute
clause, params or {})
File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line
1405, in execute
params)
File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line
1538, in _execute_clauseelement
compiled_sql, distilled_params
File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line
1646, in _execute_context
context)
File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line
1639, in _execute_context
context)
File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/default.py",
line 330, in do_execute
cursor.execute(statement, parameters)
File "/usr/lib/python2.7/dist-packages/MySQLdb/cursors.py", line 174, in
execute
self.errorhandler(self, exc, value)
File "/usr/lib/python2.7/dist-packages/MySQLdb/connections.py", line 36,
in defaulterrorhandler
raise errorclass, errorvalue
sqlalchemy.exc.ProgrammingError: (ProgrammingError) (1064, "You have an
error in your SQL syntax; check the manual that corresponds to your MySQL
server version for the right syntax to use near ''wp_users'' at line 1")
'SELECT * FROM %s' ('wp_users',)
Something like this works out:
t = "SELECT * from %s" % self.table
result = self.session.execute(t)
But I do not not not want to do this, since I do not want to check the
self.table variable... ;-)
I am running ubuntu 12.04 with old sqla 0.7.4.
Thanks a lot and kind regards
Cornelius
--
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to sqlalchemy+unsubscr...@googlegroups.com.
To post to this group, send email to sqlalchemy@googlegroups.com.
Visit this group at http://groups.google.com/group/sqlalchemy.
For more options, visit https://groups.google.com/d/optout.
