Coverage for docs_src/advanced/decimal/tutorial001.py: 100%
38 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
1from decimal import Decimal 1nopqrstuvwxyz
3from sqlmodel import Field, Session, SQLModel, create_engine, select 1nopqrstuvwxyz
6class Hero(SQLModel, table=True): 1nopqrstuvwxyz
7 id: int | None = Field(default=None, primary_key=True) 1nopqrstuvwxyz
8 name: str = Field(index=True) 1nopqrstuvwxyz
9 secret_name: str 1nopqrstuvwxyz
10 age: int | None = Field(default=None, index=True) 1nopqrstuvwxyz
11 money: Decimal = Field(default=0, max_digits=5, decimal_places=3) 1nopqrstuvwxyz
14sqlite_file_name = "database.db" 1nopqrstuvwxyz
15sqlite_url = f"sqlite:///{sqlite_file_name}" 1nopqrstuvwxyz
17engine = create_engine(sqlite_url, echo=True) 1nopqrstuvwxyz
20def create_db_and_tables(): 1nopqrstuvwxyz
21 SQLModel.metadata.create_all(engine) 1abcdefghijklm
24def create_heroes(): 1nopqrstuvwxyz
25 hero_1 = Hero(name="Deadpond", secret_name="Dive Wilson", money=1.1) 1abcdefghijklm
26 hero_2 = Hero(name="Spider-Boy", secret_name="Pedro Parqueador", money=0.001) 1abcdefghijklm
27 hero_3 = Hero(name="Rusty-Man", secret_name="Tommy Sharp", age=48, money=2.2) 1abcdefghijklm
29 with Session(engine) as session: 1abcdefghijklm
30 session.add(hero_1) 1abcdefghijklm
31 session.add(hero_2) 1abcdefghijklm
32 session.add(hero_3) 1abcdefghijklm
34 session.commit() 1abcdefghijklm
37def select_heroes(): 1nopqrstuvwxyz
38 with Session(engine) as session: 1abcdefghijklm
39 statement = select(Hero).where(Hero.name == "Deadpond") 1abcdefghijklm
40 results = session.exec(statement) 1abcdefghijklm
41 hero_1 = results.one() 1abcdefghijklm
42 print("Hero 1:", hero_1) 1abcdefghijklm
44 statement = select(Hero).where(Hero.name == "Rusty-Man") 1abcdefghijklm
45 results = session.exec(statement) 1abcdefghijklm
46 hero_2 = results.one() 1abcdefghijklm
47 print("Hero 2:", hero_2) 1abcdefghijklm
49 total_money = hero_1.money + hero_2.money 1abcdefghijklm
50 print(f"Total money: {total_money}") 1abcdefghijklm
53def main(): 1nopqrstuvwxyz
54 create_db_and_tables() 1abcdefghijklm
55 create_heroes() 1abcdefghijklm
56 select_heroes() 1abcdefghijklm
59if __name__ == "__main__": 1nopqrstuvwxyz
60 main()