SQLAZO
pip install sqlazo
It 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.
Initialisation
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')
Available Methods
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.
Private Methods 🔏
__connect: Establishes connection to the database.__commit: "Refreshes" changes to the database.__cursor: Creates a cursor on the database connection, allowing "query execution".
Version History:
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
If you wish to learn more, visit:
Metadata
Release files for sqlazo 0.2.0
For a detailed explanation of source distributions (sdists) and built distributions (wheels), please see the package formats documentation.
Source distribution (sdist)
| File | Size | Uploaded | Provenance | Actions |
|---|---|---|---|---|
| sqlazo-0.2.0.tar.gz | 6.1 kB | Without provenance | Details for sqlazo-0.2.0.tar.gz |
Built distribution (wheel)
| File | Interpreter | ABI | Platform | Actions Reset |
|---|---|---|---|---|
| sqlazo-0.2.0-py3-none-any.whl | Python 3 | none | any | Details for sqlazo-0.2.0-py3-none-any.whl |
Total release size: 12.3 kB
Release files / sqlazo-0.2.0.tar.gz
| Download URL | sqlazo-0.2.0.tar.gz |
|---|---|
| Size | 6.1 kB |
| Tags | Source |
|
SHA-256 checksum How to use checksums |
cbaba8ee5a11cc3fcb8113aa25eff7bc71d7b96a7e5fa55bfecdeb1d5e24c786
|
|
BLAKE2b-256 checksum How to use checksums |
15eeac6af2d269abc428cb009932b9f3251c14cc7bc346e4ba933003a44c7855
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
No |
| Uploaded via |
twine/6.1.0 CPython/3.12.8
|
Release files / sqlazo-0.2.0-py3-none-any.whl
| Download URL | sqlazo-0.2.0-py3-none-any.whl |
|---|---|
| Size | 6.3 kB |
| Tags | Python 3 |
|
SHA-256 checksum How to use checksums |
f3e601b52342ed138e5c2de0b792046df76cefacffaa3351fcc31c768e8ec2e2
|
|
BLAKE2b-256 checksum How to use checksums |
988782f112cef743af43aa02625835a5fb099b2395e75e436ad81948d77ca27d
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
No |
| Uploaded via |
twine/6.1.0 CPython/3.12.8
|
Security for sqlazo 0.2.0
Provenance
Provenance describes where a file came from. On PyPI, provenance is shared via attestations, which provide a verifiable record of the build or publishing details. View details, limitations and caveats.
No provenance found
None of the files in this release were uploaded with provenance metadata.
A note on package security
PyPI is a repository for distributing packages, not a service for auditing them. While third-party security researchers and our staff do their best to detect and remove malicious packages, PyPI cannot guarantee the quality, security or suitability of any given package.
To learn more about protecting yourself from malicious actors, visit our package security documentation.