| import sqlite3 |
| |
| persons = [ |
| ("Hugo", "Boss"), |
| ("Calvin", "Klein") |
| ] |
| |
| con = sqlite3.connect(":memory:") |
| |
| # Create the table |
| con.execute("create table person(firstname, lastname)") |
| |
| # Fill the table |
| con.executemany("insert into person(firstname, lastname) values (?, ?)", persons) |
| |
| # Print the table contents |
| for row in con.execute("select firstname, lastname from person"): |
| print(row) |
| |
| # Using a dummy WHERE clause to not let SQLite take the shortcut table deletes. |
| print("I just deleted", con.execute("delete from person where 1=1").rowcount, "rows") |