TinyDB 是一个轻量级的文档数据库,操作类似MongoBD,其存储方式为Json
文档:https://tinydb.readthedocs.io/en/latest/index.html github:https://github.com/msiemens/tinydb
代码示例
# -*- coding: utf-8 -*-
from tinydb import TinyDB, Query
db = TinyDB('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())
[
{'name': 'Tom', 'age': 23},
{'name': 'Jack', 'age': 24},
{'name': 'mary', 'age': 25}
]
# 查询部分
query = Query()
result = student.search(query.name == 'Tom')
print(result)
# [{'name': 'Tom', 'age': 23}]
result = student.search(query.age > 24)
print(result)
# [{'name': 'mary', 'age': 25}]
# 逻辑查询
db.search(~ (User.name == 'John')) # Negate
db.search((User.name == 'John') & (User.age
关注
打赏