Coverage for tests/test_query.py: 100%
21 statements
« prev ^ index » next coverage.py v7.17.2, created at 2026-11-16 00:02 +0000
« prev ^ index » next coverage.py v7.17.2, created at 2026-11-16 00:02 +0000
1import pytest 1nopqrstuvwxyz
2from sqlalchemy import Engine 1nopqrstuvwxyz
3from sqlmodel import Field, Session, SQLModel 1nopqrstuvwxyz
6def test_query(database_engine: Engine): 1nopqrstuvwxyz
7 class Hero(SQLModel, table=True): 1abcdefghijklm
8 id: int | None = Field(default=None, primary_key=True) 1abcdefghijklm
9 name: str 1abcdefghijklm
10 secret_name: str 1abcdefghijklm
11 age: int | None = None 1abcdefghijklm
13 hero_1 = Hero(name="Deadpond", secret_name="Dive Wilson") 1abcdefghijklm
15 engine = database_engine 1abcdefghijklm
17 SQLModel.metadata.create_all(engine) 1abcdefghijklm
18 with Session(engine) as session: 1abcdefghijklm
19 session.add(hero_1) 1abcdefghijklm
20 session.commit() 1abcdefghijklm
21 session.refresh(hero_1) 1abcdefghijklm
23 with Session(engine) as session: 1abcdefghijklm
24 with pytest.warns(DeprecationWarning): 1abcdefghijklm
25 query_hero = session.query(Hero).first() 1abcdefghijklm
26 assert query_hero 1abcdefghijklm
27 assert query_hero.name == hero_1.name 1abcdefghijklm