| /external/python/cpython2/Doc/includes/sqlite3/ |
| execsql_printall_1.py | 7 cur = con.cursor() variable
10 cur.execute("select * from people order by age")
13 print cur.fetchall()
|
| executescript.py | 4 cur = con.cursor() variable
5 cur.executescript("""
|
| rowclass.py | 6 cur = con.cursor() variable
7 cur.execute("select 'John' as name, 42 as age")
8 for row in cur:
|
| adapter_datetime.py | 10 cur = con.cursor() variable
13 cur.execute("select ?", (now,))
14 print cur.fetchone()[0]
|
| collation_reverse.py | 9 cur = con.cursor() variable
10 cur.execute("create table test(x)")
11 cur.executemany("insert into test(x) values (?)", [("a",), ("b",)])
12 cur.execute("select x from test order by x collate reverse")
13 for row in cur:
|
| complete_statement.py | 7 cur = con.cursor() variable
22 cur.execute(buffer)
25 print cur.fetchall()
|
| createdb.py | 13 cur = con.cursor() variable
14 cur.execute("""
22 cur.execute("insert into people (name_last, age) values ('Yeltsin', 72)")
23 cur.execute("insert into people (name_last, age) values ('Putin', 51)")
27 cur.close()
|
| execsql_fetchonerow.py | 5 cur = con.cursor() variable
10 cur.execute(SELECT)
11 for (name_last, age) in cur:
15 cur.execute(SELECT)
16 for row in cur:
|
| execute_1.py | 4 cur = con.cursor() variable
5 cur.execute("create table people (name_last, age)")
11 cur.execute("insert into people values (?, ?)", (who, age))
14 cur.execute("select * from people where name_last=:who and age=:age", {"who": who, "age": age})
16 print cur.fetchone()
|
| execute_3.py | 5 cur = con.cursor() variable
10 cur.execute("select name_last, age from people where name_last=:who and age=:age",
12 print cur.fetchone()
|
| executemany_2.py | 9 cur = con.cursor() variable
10 cur.execute("create table characters(c)")
12 cur.executemany("insert into characters(c) values (?)", char_generator())
14 cur.execute("select c from characters")
15 print cur.fetchall()
|
| insert_more_people.py | 5 cur = con.cursor() variable
13 cur.execute("insert into people (name_last, age) values (?, ?)", person)
|
| md5func.py | 9 cur = con.cursor() variable
10 cur.execute("select md5(?)", ("foo",))
11 print cur.fetchone()[0]
|
| parse_colnames.py | 5 cur = con.cursor() variable
6 cur.execute('select ? as "x [timestamp]"', (datetime.datetime.now(),))
7 dt = cur.fetchone()[0]
|
| row_factory.py | 11 cur = con.cursor() variable
12 cur.execute("select 1 as a")
13 print cur.fetchone()["a"]
|
| text_factory.py | 4 cur = con.cursor() variable
9 cur.execute("select ?", (AUSTRIA,))
10 row = cur.fetchone()
15 cur.execute("select ?", (AUSTRIA,))
16 row = cur.fetchone()
26 cur.execute("select ?", ("this is latin1 and would normally create errors" +
28 row = cur.fetchone()
34 cur.execute("select ?", (AUSTRIA,))
35 row = cur.fetchone()
38 cur.execute("select ?", ("Germany",)
[all...] |
| /external/python/cpython3/Doc/includes/sqlite3/ |
| execsql_printall_1.py | 7 cur = con.cursor() variable
10 cur.execute("select * from people order by age")
13 print(cur.fetchall())
|
| executescript.py | 4 cur = con.cursor() variable
5 cur.executescript("""
|
| rowclass.py | 6 cur = con.cursor() variable
7 cur.execute("select 'John' as name, 42 as age")
8 for row in cur:
|
| adapter_datetime.py | 11 cur = con.cursor() variable
14 cur.execute("select ?", (now,))
15 print(cur.fetchone()[0])
|
| collation_reverse.py | 14 cur = con.cursor() variable
15 cur.execute("create table test(x)")
16 cur.executemany("insert into test(x) values (?)", [("a",), ("b",)])
17 cur.execute("select x from test order by x collate reverse")
18 for row in cur:
|
| complete_statement.py | 7 cur = con.cursor() variable
22 cur.execute(buffer)
25 print(cur.fetchall())
|
| createdb.py | 13 cur = con.cursor() variable
14 cur.execute("""
22 cur.execute("insert into people (name_last, age) values ('Yeltsin', 72)")
23 cur.execute("insert into people (name_last, age) values ('Putin', 51)")
27 cur.close()
|
| execsql_fetchonerow.py | 5 cur = con.cursor() variable
10 cur.execute(SELECT)
11 for (name_last, age) in cur:
15 cur.execute(SELECT)
16 for row in cur:
|
| execute_1.py | 4 cur = con.cursor() variable
5 cur.execute("create table people (name_last, age)")
11 cur.execute("insert into people values (?, ?)", (who, age))
14 cur.execute("select * from people where name_last=:who and age=:age", {"who": who, "age": age})
16 print(cur.fetchone())
|
