sqlite3py 2.0.5

Module sqlite3py provides you very easy smart requests for sqlite database by Xpos587

sqlite3py

Module sqlite3py provides you very easy smart requests for sqlite database.

Read on GitHub
Examples folder

Methods:

• 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.)

Example

'''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',
# }}]

Requirements Packages

• sqlite3 (Already set by default)