executemany(): Behind the scenes

As seen previously, it is not necessary to have an intimate knowledge of the entire process behind executemany() in order to use it. But to truly know what you are doing with it, you must follow the Python motto for learning:

Use the source, Luke!

In that vein, let's take a look at the underlying code of executemany(). The definition line indicates that executemany() requires the SQL query to be processed as well as the arguments for that statement.

def executemany(self, query, args):

As noted under executemany(): Basic syntax section, previously, both the statement and the arguments are mandatory. executemany() expects you to feed it a template for query and the values to be inserted for args.

        del self.messages[:]
        db = self._get_db()
        if not args: return

We will skip the docstring as you can access it through help(cursor.executemany) in a Python shell. The method starts by deleting the contents of the messages attribute.

Note

More on the del...