Module sqlite3py provides you smart requests for sqlite database by Xpos587
Project description
sqlite3py
Module sqlite3py provides you smart requests for sqlite database.
Methods:
- createTable (Create table for your database.)
- removeTable (Remove table from your database.)
- insert (Insert data for selected table and row(s).)
- get (Return data from selected table and row.)
- delete (Delete data from selected table and row.)
- set (Update (Set) data for selected table and row(s).)
- request (Send your SQL request to database.)
Example
## before:
import sqlite3
connection = sqlite3.connect('database.sqlite3', check_same_thread = False)
cursor = connection.cursor()
cursor.execute('''CREATE TABLE IF NOT EXISTS files(uuid TEXT NOT NULL, name TEXT NOT NULL, extension TEXT NOT NULL, description TEXT NOT NULL)''')
description = cursor.execute('''SELECT description FROM files where uuid = ?''', (file,)).fetchone()[0]
cursor.execute('''INSERT INTO files(uuid, name, extension, description) VALUES(?, ?, ?, ?)''', (fileUuid, fileName, fileExtension, fileDescription))
connection.commit()
## after:
import sqlite3py
database = Database()
database.createTable('files', 'uuid TEXT NOT NULL, name TEXT NOT NULL, extension TEXT NOT NULL, description TEXT NOT NULL')
database.get('files', 'description', f'WHERE uuid = "{file}"').fetchone()[0]
database.insert('files', 'uuid, name, extension, description', f'"{fileUuid}", "{fileName}", "{fileExtension}", "{fileDescription}"')
Requirements Packages
- sqlite3 (Already set by default)
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
sqlite3py-1.0.2.1.tar.gz
(3.8 kB
view hashes)