Python 操作sqllite
共有5个字段，实现增、查、改功能
import sqlite3
import threading
import functoolsPATH_DATABASE = 'threelang.db'def synchronized(func):@functools.wraps(func)def wrapper(self, *args, **kwargs):with self.lock:return func(self, *args, **kwargs)return wrapper
class Authorize_Tb:def __init__(self) -> None:self.lock = threading.Lock()#初始化def init_tb(self):conn = sqlite3.connect(PATH_DATABASE)c = conn.cursor()try:c.execute('SELECT * FROM T_ThreeLang')except sqlite3.OperationalError:c.execute('''CREATE TABLE T_ThreeLang(id INTEGER PRIMARY KEY autoincrement,chinese TEXT,thai TEXT,english TEXT,act TEXT,times Int);''')conn.commit()finally:conn.close()#添加@synchronizeddef add(self,chinese,thai,english,act,times=0):conn = sqlite3.connect(PATH_DATABASE)cur = conn.cursor()cur.execute("insert into T_ThreeLang (chinese,thai,english,act,times) values (?,?,?,?,?)",(chinese,thai,english,act,times))conn.commit()conn.close()return cur.lastrowid #查询 ('你好', 'สวัสดี', 'Hello', 'act',0) None@synchronizeddef find_by_chinese(self,chinese):conn = sqlite3.connect(PATH_DATABASE)cur = conn.cursor()cur.execute("select id,chinese,thai,english,act,times from T_ThreeLang where chinese = ? order by id desc limit 1",(chinese,))info = cur.fetchone()conn.close()return info#查询@synchronizeddef find_by_id(self,id):conn = sqlite3.connect(PATH_DATABASE)cur = conn.cursor()cur.execute("select id,chinese,thai,english,act,times from T_ThreeLang where id = ? order by id desc limit 1",(id,))info = cur.fetchone()conn.close()return info# 更新@synchronizeddef update_by_id(self, id,thai,english,act,times):conn = sqlite3.connect(PATH_DATABASE)cur = conn.cursor()cur.execute("UPDATE T_ThreeLang SET thai = ?, english = ?, act = ?, times = ? WHERE id = ?", (thai, english, act, times, id))conn.commit()conn.close()# 更新@synchronizeddef update_by_chinese(self, chinese,thai,english,act,times):conn = sqlite3.connect(PATH_DATABASE)cur = conn.cursor()cur.execute("UPDATE T_ThreeLang SET thai = ?, english = ?, act = ?, times = ? WHERE chinese = ?", (thai, english, act, times, chinese))conn.commit()conn.close()# Count@synchronizeddef count(self):conn = sqlite3.connect(PATH_DATABASE)cur = conn.cursor()cur.execute("select count(*) as number from T_ThreeLang")info = cur.fetchone()conn.close()return infoif __name__ == '__main__':db = Authorize_Tb()#db.init_tb()info = db.find_by_chinese('你好')if not info:id = db.add('你好','สวัสดี','Hello', 'act',0)print(id)