sqlite3dict
Wrapper around sqlite3 which allows working simply with python dictionaries as well as combining it with sql syntax.
Installation
Use the package manager pip to install sqlite3dict.
pip install sqlite3dict
Usage
from sqlite3dict import Storage
from datetime import datetime
with Storage("test.sqlite") as store:
definitions = {
"name": "TEXT",
"age": "INTEGER",
"amount": "DOUBLE",
"createdate": "DATETIME",
"resident": "BOOLEAN"
}
collection = store.init_collection("test", definitions)
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
})
collection.update().data({
"createdate": datetime.now(),
"age": 15,
"amount": 99.38,
"resident": False
}).where("age = 25").execute()
list = collection.query().where("age = 15").limit(10).offset(0).order("createdate", "ASC").order("ID").execute()
for item in list:
print("item:", item)
collection.delete().where("age = 15").execute()
items = store.query_native("select * from test")
for item in items:
print("native item:", item)
store.delete_collection("test")
Contributing
Pull requests are welcome. For major changes, please open an issue first to discuss what you would like to change.
License
MIT