Coverage for docs_src/tutorial/relationship_attributes/back_populates/tutorial003.py: 100%
32 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, SQLModel, create_engine 1abcdefghijklm
4class Weapon(SQLModel, table=True): 1abcdefghijklm
5 id: int | None = Field(default=None, primary_key=True) 1abcdefghijklm
6 name: str = Field(index=True) 1abcdefghijklm
8 hero: "Hero" = Relationship(back_populates="weapon") 1abcdefghijklm
11class Power(SQLModel, table=True): 1abcdefghijklm
12 id: int | None = Field(default=None, primary_key=True) 1abcdefghijklm
13 name: str = Field(index=True) 1abcdefghijklm
15 hero_id: int = Field(foreign_key="hero.id") 1abcdefghijklm
16 hero: "Hero" = Relationship(back_populates="powers") 1abcdefghijklm
19class Team(SQLModel, table=True): 1abcdefghijklm
20 id: int | None = Field(default=None, primary_key=True) 1abcdefghijklm
21 name: str = Field(index=True) 1abcdefghijklm
22 headquarters: str 1abcdefghijklm
24 heroes: list["Hero"] = Relationship(back_populates="team") 1abcdefghijklm
27class Hero(SQLModel, table=True): 1abcdefghijklm
28 id: int | None = Field(default=None, primary_key=True) 1abcdefghijklm
29 name: str = Field(index=True) 1abcdefghijklm
30 secret_name: str 1abcdefghijklm
31 age: int | None = Field(default=None, index=True) 1abcdefghijklm
33 team_id: int | None = Field(default=None, foreign_key="team.id") 1abcdefghijklm
34 team: Team | None = Relationship(back_populates="heroes") 1abcdefghijklm
36 weapon_id: int | None = Field(default=None, foreign_key="weapon.id") 1abcdefghijklm
37 weapon: Weapon | None = Relationship(back_populates="hero") 1abcdefghijklm
39 powers: list[Power] = Relationship(back_populates="hero") 1abcdefghijklm
42sqlite_file_name = "database.db" 1abcdefghijklm
43sqlite_url = f"sqlite:///{sqlite_file_name}" 1abcdefghijklm
45engine = create_engine(sqlite_url, echo=True) 1abcdefghijklm
48def create_db_and_tables(): 1abcdefghijklm
49 SQLModel.metadata.create_all(engine) 1nopqrstuvwxyz
52def main(): 1abcdefghijklm
53 create_db_and_tables() 1nopqrstuvwxyz
56if __name__ == "__main__": 1abcdefghijklm
57 main()