How can I get dict from sqlite query?

by

You could use row_factory, as in the example in the docs:

import sqlite3

def dict_factory(cursor, row):
    d = {}
    for idx, col in enumerate(cursor.description):
        d[col[0]] = row[idx]
    return d

con = sqlite3.connect(":memory:")
con.row_factory = dict_factory
cur = con.cursor()
cur.execute("select 1 as a")
print cur.fetchone()["a"]

or follow the advice that’s given right after this example in the docs:

If returning a tuple doesn’t suffice
and you want name-based access to
columns, you should consider setting
row_factory to the highly-optimized
sqlite3.Row type. Row provides both
index-based and case-insensitive
name-based access to columns with
almost no memory overhead. It will
probably be better than your own
custom dictionary-based approach or
even a db_row based solution.

Here is the code for this second solution:

con = sqlite3.connect(…)
con.row_factory = sqlite3.Row   #   add this row
cursor = con.cursor()

More Related Contents:

  1. Using a WHERE ___ IN ___ statement
  2. How to get a single result from a SQL query in python?
  3. Is this Python code vulnerable to SQL injection? (SQLite3)
  4. pysqlite: Placeholder substitution for column or table names?
  5. What is an efficient way of inserting thousands of records into an SQLite table using Django?
  6. Python SQLite3 SQL Injection Vulnerable Code
  7. Python and SQLite: insert into table
  8. How to check the existence of a row in SQLite with Python?
  9. Adding a element in dictionary which consist of dictionaries.
  10. How to copy a dictionary and only edit the copy
  11. How to keep track of class instances?
  12. How do I format a string using a dictionary in python-3.x?
  13. Thread Safety in Python’s dictionary
  14. python filter list of dictionaries based on key value
  15. String to Dictionary in Python [duplicate]
  16. How to reverse a dictionary that has repeated values
  17. How do I serialize a Python dictionary into a string, and then back to a dictionary?
  18. Get all keys of a nested dictionary [duplicate]
  19. How to create a dictionary of two pandas DataFrame columns
  20. Why do I get an error “‘unicode’ object does not support item deletion” when trying to delete values from a JSON object?
  21. How to split dictionary into multiple dictionaries fast
  22. Using a dict to translate numbers to letters in python
  23. How can I make a dictionary (dict) from separate lists of keys and values?
  24. How to merge dicts, collecting values from matching keys?
  25. Is self.__dict__.update(**kwargs) good or poor style?
  26. How can I avoid “RuntimeError: dictionary changed size during iteration” error?
  27. Why updating “shallow” copy dictionary doesn’t update “original” dictionary? [duplicate]
  28. How to extract all values from a dictionary in Python?
  29. Determine whether a key is present in a dictionary [duplicate]
  30. Comparing 2 lists consisting of dictionaries with unique keys in python

Leave a Comment