changeset 1 | 2fb8b9db1c86 |
0:ffa851df0825 | 1:2fb8b9db1c86 |
---|---|
1 import sqlite3 |
|
2 |
|
3 class Point(object): |
|
4 def __init__(self, x, y): |
|
5 self.x, self.y = x, y |
|
6 |
|
7 def adapt_point(point): |
|
8 return "%f;%f" % (point.x, point.y) |
|
9 |
|
10 sqlite3.register_adapter(Point, adapt_point) |
|
11 |
|
12 con = sqlite3.connect(":memory:") |
|
13 cur = con.cursor() |
|
14 |
|
15 p = Point(4.0, -3.2) |
|
16 cur.execute("select ?", (p,)) |
|
17 print cur.fetchone()[0] |