Coverage for docs_src/tutorial/many_to_many/tutorial001.py: 100%
43 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 sqlmodel import Field, Relationship, Session, SQLModel, create_engine 1abcdefghijklm
4class HeroTeamLink(SQLModel, table=True): 1abcdefghijklm
5 team_id: int | None = Field(default=None, foreign_key="team.id", primary_key=True) 1abcdefghijklm
6 hero_id: int | None = Field(default=None, foreign_key="hero.id", primary_key=True) 1abcdefghijklm
9class Team(SQLModel, table=True): 1abcdefghijklm
10 id: int | None = Field(default=None, primary_key=True) 1abcdefghijklm
11 name: str = Field(index=True) 1abcdefghijklm
12 headquarters: str 1abcdefghijklm
14 heroes: list["Hero"] = Relationship(back_populates="teams", link_model=HeroTeamLink) 1abcdefghijklm
17class Hero(SQLModel, table=True): 1abcdefghijklm
18 id: int | None = Field(default=None, primary_key=True) 1abcdefghijklm
19 name: str = Field(index=True) 1abcdefghijklm
20 secret_name: str 1abcdefghijklm
21 age: int | None = Field(default=None, index=True) 1abcdefghijklm
23 teams: list[Team] = Relationship(back_populates="heroes", link_model=HeroTeamLink) 1abcdefghijklm
26sqlite_file_name = "database.db" 1abcdefghijklm
27sqlite_url = f"sqlite:///{sqlite_file_name}" 1abcdefghijklm
29engine = create_engine(sqlite_url, echo=True) 1abcdefghijklm
32def create_db_and_tables(): 1abcdefghijklm
33 SQLModel.metadata.create_all(engine) 1nopqrstuvwxyz
36def create_heroes(): 1abcdefghijklm
37 with Session(engine) as session: 1nopqrstuvwxyz
38 team_preventers = Team(name="Preventers", headquarters="Sharp Tower") 1nopqrstuvwxyz
39 team_z_force = Team(name="Z-Force", headquarters="Sister Margaret's Bar") 1nopqrstuvwxyz
41 hero_deadpond = Hero( 1nopqrstuvwxyz
42 name="Deadpond",
43 secret_name="Dive Wilson",
44 teams=[team_z_force, team_preventers],
45 )
46 hero_rusty_man = Hero( 1nopqrstuvwxyz
47 name="Rusty-Man",
48 secret_name="Tommy Sharp",
49 age=48,
50 teams=[team_preventers],
51 )
52 hero_spider_boy = Hero( 1nopqrstuvwxyz
53 name="Spider-Boy", secret_name="Pedro Parqueador", teams=[team_preventers]
54 )
55 session.add(hero_deadpond) 1nopqrstuvwxyz
56 session.add(hero_rusty_man) 1nopqrstuvwxyz
57 session.add(hero_spider_boy) 1nopqrstuvwxyz
58 session.commit() 1nopqrstuvwxyz
60 session.refresh(hero_deadpond) 1nopqrstuvwxyz
61 session.refresh(hero_rusty_man) 1nopqrstuvwxyz
62 session.refresh(hero_spider_boy) 1nopqrstuvwxyz
64 print("Deadpond:", hero_deadpond) 1nopqrstuvwxyz
65 print("Deadpond teams:", hero_deadpond.teams) 1nopqrstuvwxyz
66 print("Rusty-Man:", hero_rusty_man) 1nopqrstuvwxyz
67 print("Rusty-Man Teams:", hero_rusty_man.teams) 1nopqrstuvwxyz
68 print("Spider-Boy:", hero_spider_boy) 1nopqrstuvwxyz
69 print("Spider-Boy Teams:", hero_spider_boy.teams) 1nopqrstuvwxyz
72def main(): 1abcdefghijklm
73 create_db_and_tables() 1nopqrstuvwxyz
74 create_heroes() 1nopqrstuvwxyz
77if __name__ == "__main__": 1abcdefghijklm
78 main()