sqladaptor 0.1.0

Starting adaptor for JSON/Pandas to SQL db

sqladaptor

Transferring data, stored as JSON or Pandas, into an SQL database and back again.

Why?

Building webserver protoytpes, you will often save your data as JSON or Pandas files. At some point though, you will want to transition to a database where updating/inserting data to disk is more efficient.

SqlAdaptor allows an easy transition to such a database. This includes methods to search using dicts, and to return rows as dicts for web-servers.

This is possible because there is an equivalence between lists of JSON dicts, Pandas DataFrames and SQl tables - they are all tabular arrangements of columnar data.

Installation

pip install sqladaptor

Basic Usage

from sqladaptor.sqlite import SqliteAdaptor
import pandas

entries = [
    {"description": "this", "value": 1},
    {"description": "that", "value": 2}
]

db = SqliteAdaptor('db.sqlite')
db.set_from_df('data1', pandas.DataFrame(entries))

entries = db.get_dict_list('data1')
# [{'description': 'this', 'value': 1}, {'description': 'that', 'value': 2}]

entries = db.get_dict_list('data1', {"description": "this"})
# [{'description': 'this', 'value': 1}]

df = db.get_df("data1", {"value": 2})
#   description  value
# 0        that      2

db.update("data1", {"value": 2}, {"description": "altered"})
entries = db.get_dict_list('data1', {"value": 2})
[{'description': 'altered', 'value': 2}]