- sql_res = self.conn.execute("SELECT fields.name, data.value AS name \
- FROM data LEFT JOIN fields ON data.field_id=fields.id LEFT JOIN \
- relation ON data.id=relation.data_id WHERE data.id=?", (_id,))
- if sql_res is None:
- return {}
- else:
- return dict(sql_res.fetchall())
+ execute = self.conn.execute
+ entry_dict = {}
+ for field_id, value in execute("SELECT field_id, value FROM data WHERE \
+ id=?", (_id,)).fetchall():
+ field_name = execute("SELECT name FROM fields WHERE id=?", \
+ (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()
+