execute = self.conn.execute
- if not 'uid' in entry or not 'o' in entry:
- return
-
try:
_id = execute("SELECT MAX(id) FROM data").fetchone()[0] \
+ 1
# update DATA table
for value in values:
- execute("INSERT INTO data values(?,?,?)", (_id, field_id, value))
+ execute("INSERT INTO data values(?,?,?)", \
+ (_id, field_id, value))
# update STRUCT table
name = entry[TOPLEVEL_FIELD][0]
return {}
else:
return dict(sql_res.fetchall())
-
- def get_all_entries(self):
- """Returns list of all entries."""
-
- ids = [item[0] for item in self.conn.execute("""SELECT DISTINCT id \
- FROM data""").fetchall()]
- return [self.get_entry_by_id(_id) for _id in ids]
-
-
-
-
-if __name__ == "__main__":
- db = SQLite('/tmp/')
- #db.update_field('test')
- #print db.get_field_id_by_name('fax')
- #print db.get_entry_by_id(1)
- #print db.get_all_entries()
- db.close()
-
-