for field, values in entry.items():
# update FIELDS table
- field_id = execute("SELECT id, name FROM fields WHERE name=?", \
+ field_id = execute("SELECT id FROM fields WHERE name=?", \
(field,)).fetchone()
if field_id is None:
execute("INSERT INTO fields values(NULL, ?)", (field,))
(field_id,)).fetchone()[0]
entry_dict[field_name] = value
return entry_dict
-
-
-
-# test perfomance
-if __name__ == "__main__":
- import profile
- database = SQLite('/tmp/')
- print database.get_entry(8)
- database.close()
-