25 lines
914 B
Python
25 lines
914 B
Python
from sqlalchemy.orm import Mapped, mapped_column, relationship
|
|
from sqlalchemy.schema import ForeignKey
|
|
from sqlalchemy.types import BigInteger, Integer
|
|
import app_db
|
|
|
|
|
|
class PlayerMatch(app_db.BaseModel):
|
|
__tablename__ = "players_matches"
|
|
|
|
player_id: Mapped[int] = mapped_column(ForeignKey("players.steam_id"), primary_key=True)
|
|
match_id: Mapped[int] = mapped_column(ForeignKey("matches.logs_tf_id"), primary_key=True)
|
|
|
|
kills: Mapped[int] = mapped_column(Integer)
|
|
deaths: Mapped[int] = mapped_column(Integer)
|
|
assists: Mapped[int] = mapped_column(Integer)
|
|
damage: Mapped[int] = mapped_column(BigInteger)
|
|
damage_taken: Mapped[int] = mapped_column(BigInteger)
|
|
|
|
player: Mapped["Player"] = relationship("Player", back_populates="matches")
|
|
match: Mapped["Match"] = relationship("Match", back_populates="players")
|
|
|
|
|
|
from models.match import Match
|
|
from models.player import Player
|