Python in-memory ORM database
Project description
littletable - a Python module to give ORM-like access to a collection of objects
The littletable module provides a low-overhead, schema-less, in-memory database access to a collection
of user objects. littletable provides a DataObject class for ad hoc creation of semi-immutable objects
that can be stored in a littletable Table. Tables can also contain user-defined objects, using those
objects' __dict__, __slots__, or _fields mappings to access object attributes.
In addition to basic ORM-style insert/remove/query/delete access to the contents of a Table, littletable offers:
- simple indexing for improved retrieval performance, and optional enforcing key uniqueness
- access to objects using indexed attributes
- simplified joins using '+' operator syntax between annotated Tables
- the result of any query or join is a new first-class littletable Table
littletable Tables do not require an upfront schema definition, but simply work off of the attributes in the stored values, and those referenced in any query parameters.
Here is a simple littletable data storage/retrieval example:
from littletable import Table, DataObject
customers = Table('customers')
customers.create_index("id", unique=True)
customers.insert(DataObject(id="0010", name="George Jetson"))
customers.insert(DataObject(id="0020", name="Wile E. Coyote"))
customers.insert(DataObject(id="0030", name="Jonny Quest"))
catalog = Table('catalog')
catalog.create_index("sku", unique=True)
catalog.insert(DataObject(sku="ANVIL-001", descr="1000lb anvil", unitofmeas="EA",unitprice=100))
catalog.insert(DataObject(sku="BRDSD-001", descr="Bird seed", unitofmeas="LB",unitprice=3))
catalog.insert(DataObject(sku="MAGNT-001", descr="Magnet", unitofmeas="EA",unitprice=8))
catalog.insert(DataObject(sku="MAGLS-001", descr="Magnifying glass", unitofmeas="EA",unitprice=12))
wishitems = Table('wishitems')
wishitems.create_index("custid")
wishitems.create_index("sku")
# easy to import CSV data from a string or file
wishitems.csv_import("""\
custid,sku
0020,ANVIL-001
0020,BRDSD-001
0020,MAGNT-001
0030,MAGNT-001
0030,MAGLS-001
""")
# print a particular customer name
# (unique indexes will return a single item; non-unique
# indexes will return a list of all matching items)
print(customers.by.id["0030"].name)
# see all customer names
for name in customers.all.name:
print(name)
# print all items sold by the pound
for item in catalog.where(unitofmeas="LB"):
print(item.sku, item.descr)
# print all items that cost more than 10
for item in catalog.where(lambda o: o.unitprice>10):
print(item.sku, item.descr, item.unitprice)
# join tables to create queryable wishlists collection
wishlists = customers.join_on("id") + wishitems.join_on("custid") + catalog.join_on("sku")
# print all wishlist items with price > 10 (can use Table.gt comparator instead of lambda)
bigticketitems = wishlists().where(unitprice=Table.gt(10))
for item in bigticketitems:
print(item)
# list all wishlist items in descending order by price
for item in wishlists().sort("unitprice desc"):
print(item)
Release history Release notifications | RSS feed
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distribution
Built Distribution
File details
Details for the file littletable-1.0.1.tar.gz.
File metadata
- Download URL: littletable-1.0.1.tar.gz
- Upload date:
- Size: 39.4 kB
- Tags: Source
- Uploaded using Trusted Publishing? No
- Uploaded via: twine/3.1.1 pkginfo/1.5.0.1 requests/2.22.0 setuptools/41.6.0 requests-toolbelt/0.9.1 tqdm/4.38.0 CPython/3.8.0
File hashes
| Algorithm | Hash digest | |
|---|---|---|
| SHA256 | fcb5df8ddd7a00b6b0f85a4fe57d1b68be36666fd4a9aa56da02c15e8c31c064 |
|
| MD5 | 2653b0db2a2e17f016937b9892b6be50 |
|
| BLAKE2b-256 | 8fa277f3daebce42d90fbb952bc7bd9f8b5038d8ce80fb46f8bb194ef13c85ce |
File details
Details for the file littletable-1.0.1-py2.py3-none-any.whl.
File metadata
- Download URL: littletable-1.0.1-py2.py3-none-any.whl
- Upload date:
- Size: 24.2 kB
- Tags: Python 2, Python 3
- Uploaded using Trusted Publishing? No
- Uploaded via: twine/3.1.1 pkginfo/1.5.0.1 requests/2.22.0 setuptools/41.6.0 requests-toolbelt/0.9.1 tqdm/4.38.0 CPython/3.8.0
File hashes
| Algorithm | Hash digest | |
|---|---|---|
| SHA256 | 3887d8adf2dab6da4b1d03277549196b586ef8a0bb6ab94acf85b4a4cb42660a |
|
| MD5 | 9780f04930a65dadd9353ef7bfee0787 |
|
| BLAKE2b-256 | 490235daba75048d61973223ff465b0fcf026a83c7743eba9fcd21f0806aca77 |
