class Groups(Model):
id = PrimaryKey()
uid = Field() # 用户id
name = Field() # 分类名
class Ngroups(Model):
uid = Field() # 用户id
name = Field() # 分组名
count = Field() # 分组好友数量
if __name__ == "__main__":
import sqlite3
import os
from skylark import Database
Database.set_dbapi(sqlite3)
Database.set_autocommit(True)
Database.config(db = os.path.abspath("../../data/data.db"))
r = Groups.where(Groups.id == "1", Groups.uid == 1).update(name = "bbbdfdfdfb").execute()
print(r)
r = Ngroups.select()
for i in r:
print(i.data)
groups = Ngroups.where(Ngroups.uid == 1).select()
for g in groups:
print(g)
print([group.data for group in groups])
def initdb(path = None):
Database.set_dbapi(sqlite3)
Database.set_autocommit(True)
Database.config(db = path if path else lib.DBPATH, check_same_thread = False)
