pwtools.sql.SQLiteDB.get_dict

SQLiteDB.get_dict(*args, **kwargs)[source]

For the provided select statement, return a dict where each key is the column name and the column is a list. Column names are obtained from the Cursor.description attribute.

Examples

>>> db.get_dict("select foo,bar from calc")
{'foo': [1,2,3],
 'bar': ['x', 'y', 'z']}