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)