2 # -*- coding: utf-8 -*-
3 # vim: sw=4 ts=4 expandtab ai
14 # add mnemosyne directory to Python path in debug mode
15 if os.path.basename(sys.argv[0]).endswith("debug"):
16 sys.path.insert(0, "../../")
17 sys.path.insert(0, "../")
20 """connect to database"""
22 if os.access(file, os.F_OK|os.R_OK|os.W_OK):
23 conn = sqlite3.connect(file)
25 print "access to database file error"
29 def insRecord(record):
30 """insert record into database"""
34 print "database connect error"
37 c.execute("select max(id) from data")
38 id_record = c.fetchone()[0] + 1
39 for k, v in record.items():
40 #print "key=%s value=%s" % (k, v)
41 c.execute("select id from field where name=?", (k,))
42 id_field = c.fetchone()[0]
45 c.execute("insert into field (name) values (?)", (k,))
46 id_field = c.lastrowid
48 # insert row into data
49 print "id=%s id_field=%s value=%s" % (id_record, id_field, v)
50 c.execute("insert into data (id, id_field, value) values (?, ?, ?)", (id_record, id_field, v))
55 record = {"givenName":"Vasya", "cn":"Pupkin", "mail":"vasya@puplin.com"}