from app.main.data_model.games.leadedge.le_company import LECompany
from app.main.data_model.games.leadedge.le_player import LEPlayer


class LEPlayerRepository:

    def __init__(self, session):
        self.session = session

    def delete_players(self, players_ids):
        self.session.query(LEPlayer).filter(
            LEPlayer.id.in_(players_ids)
        ).delete()
        self.session.flush()

    def get_player_by_participant_id_and_game_session_id(self, user_id, game_session_id):
        return self.session.query(LEPlayer).filter(
            LEPlayer.player_user_id == user_id,
            LECompany.game_session_id == game_session_id,
            LEPlayer.le_company_id == LECompany.id
        ).first()