String of cursor.execute without executing

Question

I am using the following approach to using pymysql to parametrize the SQL+args query but not execute it (legitimately, at least):

try:
    self.cursor.execute(self.sql + ' ***', self.sql_args or tuple())    
except pymysql.err.ProgrammingError:                                      
    self._sql_formatted = self.cursor._last_executed.rstrip('* ')

Is there actually a method that pymysql has where it just formats the SQL string without executing it, or do I need to use something like the above? Or, another option:

self.cursor.execute('DESCRIBE ' + self.sql, self.sql_args or tuple())
self._sql_formatted = self.cursor._last_executed.replace('DESCRIBE ', '')

snakecharmerb · Accepted Answer · 2020-05-03 06:43:32Z

1

The cursor.mogrify method

Returns the exact string that is sent to the database by calling the execute() method.

>>> conn = pymysql.connect(host='localhost', user='root', password='password', database='test')
>>> cur = conn.cursor()
>>> stmt1 = """SELECT id, password FROM my_user WHERE name = %s;"""
>>> print(cur.mogrify(stmt1, ('Alice',)))
SELECT id, password FROM my_user WHERE name = 'Alice';

answered May 3, 2020 at 6:43

snakecharmerb

57.2k13 gold badges137 silver badges200 bronze badges

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

1 Comment

snakecharmerb Over a year ago

I'd guess that it's a back-formation from "transmogrify", wich is a [jocular] word meaning "transform".

Collectives™ on Stack Overflow

String of cursor.execute without executing

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related