sqlite3-api

API for sqlite3


Keywords
database, easy, oop, sqlite3
License
MIT
Install
pip install sqlite3-api==2.0.4

Documentation

Sqlite3 API Downloads PyPi version License: MIT

Documentation site

Installation

Install from PyPi

pip install sqlite3-api

Install from GitHub

git clone https://github.com/AlexDev-py/sqlite3_api.git

Create table classes

from sqlite3_api.Table import Table

class MyTable(Table):
    my_first_field: str
    my_second_field: int

In file example/my_tables.py, there is an instruction to create classes(in Russian language)

Using

Initiate the database:

from my_tables import MyTable 
my_table = MyTable('MyDataBase.sqlite')

Create tables:

my_table.create_table()

Inserting data:

my_table.insert(
    my_first_field='first',
    my_second_field='second',
)

Getting data:

data = my_table.filter()

Sorting data:

data = my_table.filter(my_field='value')

More information in the example folder

VK: AlexDev