How do I use prepared statements for inserting MULTIPLE records in SQlite using Python / Django? How do I use prepared statements for inserting MULTIPLE records in SQlite using Python / Django? django django

How do I use prepared statements for inserting MULTIPLE records in SQlite using Python / Django?


python django sqlite 

http://docs.python.org/library/sqlite3.html#cursor-objects

Python's SQLite libraries don't have prepared statement objects, but they do allow you to use parameterized queries, and to provide more than one set of parameters.

Edit: An example of executemany as requested:

values_to_insert = [(1,"foo"), (2, "bar"), (3, "baz")]cursor.executemany("""    INSERT INTO some_table ('item_num', 'item_name')    VALUES (?, ?)""", values_to_insert)

python django sqlite

You can use executemany() and pass an iterator object, e.g. to insert 100 integers and their squares:

def my_iter(x):    for i in range(x):        yield i, i*icursor.executemany("INSERT INTO my_table VALUES (?, ?)", my_iter(100))

python django sqlite

If you are trying to insert just one row as with a PreparedStatement, 

cursor.execute("""INSERT INTO table_name ('column1', 'column2') VALUES (?, ?)""", ("value1", "value2"))

should work as well. Values are being passed in as python tuples.

Recent Posts
How can I color dots in a xy scatterplot according to column value?
How to update a claim in ASP.NET Identity?
What does {0} mean when initializing an object?
Accessing members of items in a JSONArray with Java
How to log SQL statements in Spring Boot?
Powershell Get-WebSite name parameter is ignored
How to detect scroll to bottom of html element
Java synchronized method
How to test controllers with CodeIgniter?
Detect Visual Composer
Matplotlib: Specify format of floats for tick labels
Rails join a list of strings with commas and "and" before the last