1 import sqlite3

     2 

     3 class Point(object):

     4     def __init__(self, x, y):

     5         self.x, self.y = x, y

     6 

     7     def __repr__(self):

     8         return "(%f;%f)" % (self.x, self.y)

     9 

    10 def adapt_point(point):

    11     return "%f;%f" % (point.x, point.y)

    12 

    13 def convert_point(s):

    14     x, y = map(float, s.split(";"))

    15     return Point(x, y)

    16 

    17 # Register the adapter

    18 sqlite3.register_adapter(Point, adapt_point)

    19 

    20 # Register the converter

    21 sqlite3.register_converter("point", convert_point)

    22 

    23 p = Point(4.0, -3.2)

    24 

    25 #########################

    26 # 1) Using declared types

    27 con = sqlite3.connect(":memory:", detect_types=sqlite3.PARSE_DECLTYPES)

    28 cur = con.cursor()

    29 cur.execute("create table test(p point)")

    30 

    31 cur.execute("insert into test(p) values (?)", (p,))

    32 cur.execute("select p from test")

    33 print "with declared types:", cur.fetchone()[0]

    34 cur.close()

    35 con.close()

    36 

    37 #######################

    38 # 1) Using column names

    39 con = sqlite3.connect(":memory:", detect_types=sqlite3.PARSE_COLNAMES)

    40 cur = con.cursor()

    41 cur.execute("create table test(p)")

    42 

    43 cur.execute("insert into test(p) values (?)", (p,))

    44 cur.execute('select p as "p [point]" from test')

    45 print "with column names:", cur.fetchone()[0]

    46 cur.close()

    47 con.close()