pip install sqlazoIt is a module for managing SQLITE databases. It provides access to methods that perform transactions with the database of your choice, as long as it is a SQLITE database.
To begin using it, create an instance of the Database class, which accepts the following parameters:
name: str: Name of the database (e.g. 'test.db').
check_thread: boolean: Check for multithreaded executions.
# Initialisation example
from sqlazo import Database
# Will create a test.db file ready to use
# check threads is False by default
db = Database('test.db')create_table: Allows you to create a table in the connected database.table_exists: Allows you to check if a table exists in the database.insert_data: Executes the insertion "query" in the database (adds data).get_data_all: Executes the "query" to retrieve all records from the database.get_data_where: Executes the "query" to retrieve records using a "custom query".delete_data: Deletes records from the database.
__connect: Establishes connection to the database.__commit: "Refreshes" changes to the database.__cursor: Creates a cursor on the database connection, allowing "query execution".
0.2.0: A new method was added to correctly check whether a table exists or not, and the code was modified to try to be compatible with older versions of Python and:Fix: issue #1Update: Links and e-mail supportFeat: Added new methodtable_exists
0.1.5: Updated dependencies and links0.1.4: Updated dependencies and links0.1.3: Updated dependency versions0.1.2: Updated dependency versions0.1.1: Added dependency handling in the build file (.toml)0.1.0: Initial release