| /external/python/cpython2/Doc/includes/sqlite3/ |
| connect_db_1.py | 3 con = sqlite3.connect("mydb") variable
|
| connect_db_2.py | 3 con = sqlite3.connect(":memory:") variable
|
| ctx_manager.py | 3 con = sqlite3.connect(":memory:") variable
4 con.execute("create table person (id integer primary key, firstname varchar unique)")
6 # Successful, con.commit() is called automatically afterwards
7 with con:
8 con.execute("insert into person(firstname) values (?)", ("Joe",))
10 # con.rollback() is called after the with block finishes with an exception, the
13 with con:
14 con.execute("insert into person(firstname) values (?)", ("Joe",))
|
| load_extension.py | 3 con = sqlite3.connect(":memory:") variable
6 con.enable_load_extension(True)
9 con.execute("select load_extension('./fts3.so')")
12 # con.load_extension("./fts3.so")
15 con.enable_load_extension(False)
18 con.execute("create virtual table recipe using fts3(name, ingredients)")
19 con.executescript("""
25 for row in con.execute("select rowid, name, ingredients from recipe where name match 'pie'"):
|
| execsql_printall_1.py | 4 con = sqlite3.connect("mydb") variable
6 # Get a Cursor object that operates in the context of Connection con:
7 cur = con.cursor()
|
| executescript.py | 3 con = sqlite3.connect(":memory:") variable
4 cur = con.cursor()
|
| rowclass.py | 3 con = sqlite3.connect(":memory:") variable
4 con.row_factory = sqlite3.Row
6 cur = con.cursor()
|
| shortcut_methods.py | 8 con = sqlite3.connect(":memory:") variable
11 con.execute("create table person(firstname, lastname)")
14 con.executemany("insert into person(firstname, lastname) values (?, ?)", persons)
17 for row in con.execute("select firstname, lastname from person"):
20 print "I just deleted", con.execute("delete from person").rowcount, "rows"
|
| adapter_datetime.py | 9 con = sqlite3.connect(":memory:") variable
10 cur = con.cursor()
|
| collation_reverse.py | 6 con = sqlite3.connect(":memory:") variable
7 con.create_collation("reverse", collate_reverse)
9 cur = con.cursor()
15 con.close()
|
| complete_statement.py | 5 con = sqlite3.connect(":memory:") variable
6 con.isolation_level = None
7 cur = con.cursor()
30 con.close()
|
| createdb.py | 12 con = sqlite3.connect(DB_FILE) variable
13 cur = con.cursor()
25 con.commit()
28 con.close()
|
| execsql_fetchonerow.py | 3 con = sqlite3.connect("mydb") variable
5 cur = con.cursor()
|
| execute_1.py | 3 con = sqlite3.connect(":memory:") variable
4 cur = con.cursor()
|
| execute_3.py | 3 con = sqlite3.connect("mydb") variable
5 cur = con.cursor()
|
| executemany_2.py | 8 con = sqlite3.connect(":memory:") variable
9 cur = con.cursor()
|
| insert_more_people.py | 3 con = sqlite3.connect("mydb") variable
5 cur = con.cursor()
16 con.commit()
|
| md5func.py | 7 con = sqlite3.connect(":memory:") variable
8 con.create_function("md5", 1, md5sum)
9 cur = con.cursor()
|
| parse_colnames.py | 4 con = sqlite3.connect(":memory:", detect_types=sqlite3.PARSE_COLNAMES) variable
5 cur = con.cursor()
|
| row_factory.py | 9 con = sqlite3.connect(":memory:") variable
10 con.row_factory = dict_factory
11 cur = con.cursor()
|
| text_factory.py | 3 con = sqlite3.connect(":memory:") variable
4 cur = con.cursor()
14 con.text_factory = str
25 con.text_factory = lambda x: unicode(x, "utf-8", "ignore")
33 con.text_factory = sqlite3.OptimizedUnicode
|
| pysqlite_datetime.py | 4 con = sqlite3.connect(":memory:", detect_types=sqlite3.PARSE_DECLTYPES|sqlite3.PARSE_COLNAMES) variable
5 cur = con.cursor()
|
| adapter_point_1.py | 11 con = sqlite3.connect(":memory:") variable
12 cur = con.cursor()
|
| adapter_point_2.py | 12 con = sqlite3.connect(":memory:") variable
13 cur = con.cursor()
|
| countcursors.py | 12 con = sqlite3.connect(":memory:", factory=CountCursorsConnection) variable
13 cur1 = con.cursor()
14 cur2 = con.cursor()
15 print con.numcursors
|
