/Doc/includes/sqlite3/shortcut_methods.py
http://unladen-swallow.googlecode.com/ · Python · 21 lines · 11 code · 6 blank · 4 comment · 1 complexity · 4dc077c8efa7882fa8a82ba8c463c9b1 MD5 · raw file
- 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"