db.sqlite

db.sqlite.create_table_from_data(table_name, data, db_path=':memory:'):

Create a sqlite3 table from a python datastructure

Parameters:
  • table_name (str) – Name of the created table/

  • data (list of dict) – Python list of dictionaries

  • db_path (str, optional) – Path to the sqlite database file, defaults to ‘:memory:’

Returns:

sqlite connection handle

Return type:

sqlite3.Connection