Execute a SQL query against the database applying a set of parameters.
Cursor.execute_many(query [,args])
| query | The select statement to be executed |
| args | A list of tuples each containing a set of one or more parameters to be inserted wherever a question mark appears in the query string. |
This method executes a SQL query against the database. This is a DB API compliant call. Parameters are substituted using question marks, e.g. "SELECT name FROM table WHERE id=?". The parameter args is a list of tuples each containing a set of one or more parameters. The query will be executed for each set of parameters in the list. It returns None on success or raises an exception in the case of an error.
| None | The query was executed successfully |
conn = db.connect()
cursor = conn.cursor()
sql = "INSERT INTO Quote(ikey, symbol, stamp, low, high, open, close, volume) VALUES (?,?,?,?,?,?,?,?)"
params = []
for i in xrange(N_QUOTES / 2, N_QUOTES):
params.append((i, 'AA%s' % i, datetime.datetime(2017, 8, 16, 9, 30+i), 1.0, 4.0, 2.0, 3.0, i*1000))
cursor.execute_many(sql, params)
...
cursor.close()
conn.rollback()