summaryrefslogtreecommitdiff
path: root/doc/includes/sqlite3/adapter_point_1.py
blob: d9acb8d106479d99e981f5539c01891dd1f70689 (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
from pysqlite2 import dbapi2 as sqlite3

class Point(object):
    def __init__(self, x, y):
        self.x, self.y = x, y

    def __conform__(self, protocol):
        if protocol is sqlite3.PrepareProtocol:
            return "%f;%f" % (self.x, self.y)

con = sqlite3.connect(":memory:")
cur = con.cursor()

p = Point(4.0, -3.2)
cur.execute("select ?", (p,))
print cur.fetchone()[0]