sqlitetable

SqliteTable

Use sqlite just like classes!

Create Table

from sqlitetable import SqliteTable
class Student(SqliteTable):
    uid:int
    name:str
Student.create_table('test.db')

The above code creates the following table

CREATE TABLE "student"(
    "uid" INTEGER,
    "name" TEXT
);

Simple Insert

s = Student()
s.uid = 10001
s.name = 'Hu Tao'
s.sqlite_insert()

The above code runs

INSERT INTO "student" ("uid", "name") VALUES (10001, 'Hu Tao');

Simple Select

s = Student()
s.name = 'Hu Tao'
for e in s.sqlite_select():
    print(e, e.uid, e.name)

The above code runs

SELECT "uid" FROM "student" WHERE "name"='Hu Tao';