% confuses python raw sql query

Question

Following this SO question, I'm trying to "truncate" all tables related to a certain django application using the following raw sql commands in python:

cursor.execute("set foreign_key_checks = 0")
cursor.execute("select concat('truncate table ',table_schema,'.',table_name,';') as sql_stmt from information_schema.tables where table_schema = 'my_db' and table_type = 'base table' AND table_name LIKE 'some_prefix%'")
for sql in [sql[0] for sql in cursor.fetchall()]:
    cursor.execute(sql)
cursor.execute("set foreign_key_checks = 1")

Alas I receive the following error:

C:\dev\my_project>my_script.py
Traceback (most recent call last):
  File "C:\dev\my_project\my_script.py", line 295, in <module>
    cursor.execute(r"select concat('truncate table ',table_schema,'.',table_name,';') as sql_stmt from information_schema.tables where table_schema = 'my_db' and table_type = 'base table' AND table_name LIKE 'some_prefix%'")
  File "C:\Python26\lib\site-packages\django\db\backends\util.py", line 18, in execute
    sql = self.db.ops.last_executed_query(self.cursor, sql, params)
  File "C:\Python26\lib\site-packages\django\db\backends\__init__.py", line 216, in last_executed_query
    return smart_unicode(sql) % u_params
TypeError: not enough arguments for format string

Is the % in the LIKE making trouble? How can I workaround it?

Jess · Accepted Answer · 2011-01-28 23:21:54Z

8

Have you tried %%? That quotes a % in Python string-formatting.

answered Jan 28, 2011 at 23:21

Jess

7,0271 gold badge31 silver badges37 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Jess Over a year ago

For added examples/amusement, guess what this does: '%%%%s %%s %s' % 'three' % 'two' % 'one'

Collectives™ on Stack Overflow

% confuses python raw sql query

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related