python sqlite OOP class
Project description
sqlite oop
sqlite Object Oriented
from sqliteoop import sqlite
db = sqlite("./demo.db")
# create table
createtable = db.table("user_name").create_table({
"id":"INTEGER PRIMARY KEY AUTOINCREMENT",
"name":"VARCHAR(80) NOT NULL"
})
print(createtable)
# create datas
insert = db.table("user_name").insert([{"name": "davie"}, {"name": "johan"}])
# create data
insert = db.table("user_name").create({"name": "davie"})
# delete
db.table("user_name").where("id",1).delete()
db.table("user_name").where("name","davie").delete()
# update
db.table("user_name").where("name","davie").updata({"name":"lisa"})
# select
db.table("user_name").where("name","<>","davie").limit(5).select("*")
# find
db.table("user_name").where("name","johan").find("*")
Project details
Release history Release notifications | RSS feed
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distribution
sqlite-oop-0.0.2.tar.gz
(5.2 kB
view hashes)
Built Distribution
Close
Hashes for sqlite_oop-0.0.2-py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 639d798ea77a7e9a6d9394d7e05d4bff7a235e79ae7d1b00777a3e880930196d |
|
MD5 | 6e6fb38c3d19aa9709296fdff05093c2 |
|
BLAKE2b-256 | 87e0bc9335ea43f7b1cb945f709f3f15c7f105a1baaac2a86745492aff483c8b |