tortoise

tortoise

异步ORM（对象关系映射）框架， 类似的有 sqlalchemy，flask-sqlalchemy，alembic

Usage

from tortoise.models import Model
from tortoise import fields
from tortoise import Tortoise

class User(Model):
    id = fields.IntField(pk=True)
    username = fields.CharField(max_length=50)
    email = fields.CharField(max_length=50)

    class Meta:
        table = "users"

async def run():
    # 初始化Tortoise
    await Tortoise.init(
        db_url='sqlite://db.sqlite3',
        modules={'models': ['__main__']}
    )
    # 创建数据库表
    await Tortoise.generate_schemas()

    # 创建一个新的用户
    user = await User.create(username='testuser', email='test@example.com')

    # 查询用户
    user = await User.get(username='testuser')
    print(user.id, user.username, user.email)

# 运行异步函数
import asyncio
asyncio.run(run())