tortoise-orm | Familiar asyncio ORM for python , built with relations | Reactive Programming library

async def init():
    await Tortoise.init(
        db_url="sqlite://db.sqlite3",
        modules={"models": ["sanic_security.models", "app.models"]},
    )
    await Tortoise.generate_schemas()

register_tortoise(
    app,
    db_url="sqlite://db.sql  

from sqlitedict import SqliteDict
db = SqliteDict(
  'db.sqlite', 
  tablename='foo', 
  autocommit=True
)

@bot.event
async def on_message(msg):
  if msg.guild:
    guild_db = db.get(msg.guild.id, {})
    user_db =

Recipe.objects.filter(
    ingredients__name='tomato'
).filter(
    ingredients__name='onion'
)

SELECT recipe.id, recipe.description
FROM recipe
INNER JOIN recipe_ingredients ON rec

PPost = pydantic_model_creator(Post)
# used as
return await PPost.from_tortoise_orm(await Post.get_or_none(id=1))

asyncio.create_task(init_tortoise())

asyncio.get_event_loop().run_until_com

from fastapi.testclient import TestClient

app = FastAPI()

# Fixtures
@pytest.fixture
def client():
    with TestClient(app) as tc:
        yield tc

@pytest.fixture
def loop(client):
    yield client.task.get_loop()

await Tortoise.init(db_url="sqlite://:memory:", modules={"models": ["__main__"]})
await Tortoise.generate_schemas()

Event_Pydantic = pydantic_model_creator(Event)

from tortoise import Tortoise

Tortoise.init_mo