Welcome to TinyDB! — TinyDB 4.5.1 documentation
tinydb:Welcome to TinyDB! — TinyDB 4.5.1 documentation
from tinydb import TinyDB, Query db = TinyDB(r'./db.json') student = db.table("student") student.insert({"name": "Tom", "age": 23}) student.insert_multiple([ {"name": "Jack", "age": 24}, {"name": "mary", "age": 25} ]) print(student.all()) query = Query() result = student.search(query.name == 'Tom') print(result) result = student.search(query.age > 24) print(result) # [{'name': 'mary', 'age': 25}] # 逻辑查询 User = Query() db.search(~ (User.name == 'John')) # Negate db.search((User.name == 'John') & (User.age <= 30)) # And db.search((User.name == 'John') | (User.name == 'Bob')) # Or # 更新 print("update........") student.update({'age': 26}, query.name == "Tom") print(student.search(query.name=="Tom")) # [{'name': 'Tom', 'age': 26}] # 删除 print("delete........") student.remove(query.age < 25) print(student.all()) # [{'name': 'Tom', 'age': 26}, {'name': 'mary', 'age': 25}] # 关闭 db.close()