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
del self.messages[:] ...