Wrapper around sqlite3 to work with dictionaries
Project description
Wrapper around sqlite3 which allows working simply with python dictionaries as well as combining it with sql syntax.
Main scope of this project:
- Simple store for json documents combined with fast searching capabilities of Sqlite3
- Support big volumes of data (millions of records)
- Combine best features of NOSQL and SQL
- Elimintate the need to work with SQL DDL
Sample code:
from sqlite3dict import Storage
from datetime import datetime
# ******************************************************************************
# * Test
# ******************************************************************************
with Storage("test.sqlite") as store:
definitions = {
"name": "TEXT",
"age": "INTEGER",
"amount": "DOUBLE",
"createdate": "DATETIME",
"resident": "BOOLEAN"
}
# This creates the table (collection) only if it does not exist already
collection = store.init_collection("test", definitions)
# Insert data
collection.insert({
"name": "John Doe",
"age": 25,
"amount": 100.23,
"createdate": datetime.now(),
"resident": True,
"additional": {
"prop1": 1,
"prop2": 1,
"other": ["A", "B"]
}
})
collection.insert({
"name": "John Doe",
"age": 10,
"amount": 100.00,
"createdate": datetime.now(),
"resident": True
})
# Update inserted data by given criteria
collection.update().data({
"createdate": datetime.now(),
"age": 15,
"amount": 99.38,
"resident": False
}).where("age = 25").execute()
# Simple query for data
list = collection.query().where("age = 15").limit(10).offset(0).order("createdate", "ASC").order("ID").execute()
for item in list:
print("item:", item)
# Delete data by given criteria
collection.delete().where("age = 15").execute()
# Native SQL query in case you still need it
items = store.query_native("select * from test")
for item in items:
print("native item:", item)
# Drop table (collection)
store.delete_collection("test")
Project details
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distribution
sqlite3dict-0.0.1.tar.gz
(6.2 kB
view hashes)
Built Distribution
Close
Hashes for sqlite3dict-0.0.1-py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 7de7e062acd28a5087b8721df4de5abf7875a90fd49b674151d37270b1863f36 |
|
MD5 | ffd1d63bf10a7906c4b044325c394c02 |
|
BLAKE2b-256 | 0bf200b71b165c34aaf54c50fa56ea1584e646191e495ebbc41cc34419474703 |