Poka数据库接口
poka的Python项目详细描述
Poka数据库接口
mysql连接器上的接口构建
设置
pip install -r req.txt
使用
创建Poka实例
^{pr2}$选择表格
from poka_constructor import Poka
cfg = database config
poka_instance_1 = Poka(cfg) # Set database config
poka_instance_1.table("users") # Set table
从表中选择
from poka_constructor import Poka
cfg = database config
poka_instance_1 = Poka(cfg) # Set database config
poka_instance_1.table("users") # Set table
poka_instance_1.where("column", "=", value) # Set where instruction
poka_instance_1.whereNotNull("column", "=", value) # Set is not null check
poka_instance_1.whereIn("column", "args") # Set where in instruction
poka_instance_1.get() # Fetch records from table
插入数据库
from poka_constructor import Poka
cfg = database config
poka_instance_1 = Poka(cfg) # Set database config
poka_instance_1.table("users") # Set table
poka_instance_1.insert({"colum_name": "value", "column_name2": "value"}) # Set insert data
更新记录
from poka_constructor import Poka
cfg = database config
poka_instance_1 = Poka(cfg) # Set database config
poka_instance_1.table("users") # Set table
poka_instance_1.update({"colum_name": "value", "column_name2": "value"}) # Set update data
限制
from poka_constructor import Poka
cfg = database config
poka_instance_1 = Poka(cfg) # Set database config
poka_instance_1.table("users") # Set table
poka_instance_1.where("column", "=", value) # Set where instruction
poka_instance_1.take(5) # Set count of fetching records
poka_instance_1.get() # Fetch records from table
按ASC |说明订购
from poka_constructor import Poka
cfg = database config
poka_instance_1 = Poka(cfg) # Set database config
poka_instance_1.table("users") # Set table
poka_instance_1.where("column", "=", value) # Set where instruction
poka_instance_1.take(5) # Set count of fetching records
poka_instance_1.orderBy("column", "ASC") # Set order by instruction
poka_instance_1.get() # Fetch records from table
单行请求
例如:从表中选择
from poka_constructor import Poka
cfg = database config
poka_instance_1 = Poka(cfg)
.table("users")
.where("column", "=", value)
.whereNotNull("column", "=", value)
.whereIn("column", "args")
.get()
其他功能也一样。在
- 项目
标签: