Module sqlite3py provides you very easy smart requests for sqlite database.
Read on GitHubExamples folder
- set (Update (Set) values for selected row.)
- insert (Insert (Push) row.)
- all (Return all values.)
- get (Return values from selected row.)
- delete (Delete selected row.)
'''After sqlite3py Version 2.0.0'''
from sqlite3py import Database
# Create database
database = Database('./storage.db', check_same_thread = False)
# Create table
files = database.table('files')
# Set values
files.set('Documentation', {
'title': 'Documentation',
'description': 'Some description',
'type': 'pdf',
'uuid': 'a8098c1a-f86e-11da-bd1a-00112444be1e',
})
# Get values
files.get('Documentation')[0]['description']
# Return: 'Some description'
# Get all values
files.all()
# Return: [{'key': 'Documentation', 'value': {
# 'title': 'Documentation',
# 'description': 'Some description',
# 'type': 'pdf',
# 'uuid': 'a8098c1a-f86e-11da-bd1a-00112444be1e',
# }}]
- sqlite3 (Already set by default)