summaryrefslogtreecommitdiff
path: root/doc/includes/sqlite3/apsw_example.py
blob: bdca0c91e8b28a5626717087a4a533a4198fc72e (plain)
1
2
3
4
5
6
7
8
9
10
11
12
from pysqlite2 import dbapi2 as sqlite3
import apsw

apsw_con = apsw.Connection(":memory:")
apsw_con.createscalarfunction("times_two", lambda x: 2*x, 1)

# Create pysqlite connection from APSW connection
con = sqlite3.connect(apsw_con)
result = con.execute("select times_two(15)").fetchone()[0]
assert result == 30
con.close()