-# add mnemosyne directory to Python path in debug mode
-if os.path.basename(sys.argv[0]).endswith("debug"):
- sys.path.insert(0, "../../")
- sys.path.insert(0, "../")
-
-def connect():
- """connect to database"""
- file = "meabookdb";
- if os.access(file, os.F_OK|os.R_OK|os.W_OK):
- conn = sqlite3.connect(file)
- else:
- print "access to database file error"
- conn = None
- return conn
-
-def insRecord(record):
- """insert record into database"""
- #get id new record
- conn = connect()
- if conn is None:
- print "database connect error"
- return None
- c = conn.cursor()
- c.execute("select max(id) from data")
- id_record = c.fetchone()[0] + 1
- for k, v in record.items():
- #print "key=%s value=%s" % (k, v)
- c.execute("select id from field where name=?", (k,))
- id_field = c.fetchone()[0]
- if id_field is None:
- #write new field ваы
- c.execute("insert into field (name) values (?)", (k,))
- id_field = c.lastrowid
+class DbSqlite:
+
+ """class for work with database"""
+ def connect(self):
+
+ """connect to database"""
+ dbname = "meabookdb"
+ if os.access(dbname, os.F_OK|os.R_OK|os.W_OK):
+ conn = sqlite3.connect(dbname)
+ else:
+ print "access to database file error"
+ conn = None
+ return conn
+
+ def ins_record(self, rec):
+
+ """insert record into database"""
+ #get id new record
+ conn = self.connect()
+ if conn is None:
+ print "database connect error"
+ return None
+ cur = conn.cursor()
+ cur.execute("select max(id) from data")
+ id_record = cur.fetchone()[0]
+ if id_record is None:
+ id_record = 1
+ else:
+ id_record = id_record + 1
+ print "id_record=%s" % (id_record,)