|
|
|
import json
|
|
|
|
|
|
|
|
from sqlalchemy.ext.associationproxy import association_proxy
|
|
|
|
from sqlalchemy.schema import UniqueConstraint
|
|
|
|
|
|
|
|
from app import db
|
|
|
|
from .role import Role
|
|
|
|
from .notification_player import NotificationPlayer
|
|
|
|
from .player_found_objective import PlayerFoundObjective
|
|
|
|
from .review import Review
|
|
|
|
|
|
|
|
class GamePlayer(db.Model):
|
|
|
|
__tablename__ = 'game_player'
|
|
|
|
id = db.Column(db.Integer, primary_key=True)
|
|
|
|
game_id = db.Column(db.Integer, db.ForeignKey('game.id'), nullable=False)
|
|
|
|
user_id = db.Column(db.Integer, db.ForeignKey('user.id'), nullable=False)
|
|
|
|
role = db.Column(db.Enum(Role), server_default=Role(0).name, nullable=False)
|
|
|
|
game = db.relationship('Game', back_populates='players')
|
|
|
|
user = db.relationship('User', back_populates='user_games')
|
|
|
|
__table_args__ = (UniqueConstraint('game_id', 'user_id', name='_game_user_uc'),
|
|
|
|
)
|
|
|
|
|
|
|
|
player_notifications = db.relationship(
|
|
|
|
'NotificationPlayer',
|
|
|
|
back_populates='recipient',
|
|
|
|
cascade='save-update, merge, delete, delete-orphan')
|
|
|
|
notifications = association_proxy('player_notifications', 'notification',
|
|
|
|
creator=lambda notification: NotificationPlayer(notification=notification))
|
|
|
|
|
|
|
|
player_found_objectives = db.relationship(
|
|
|
|
'PlayerFoundObjective',
|
|
|
|
back_populates='game_player',
|
|
|
|
cascade='save-update, merge, delete, delete-orphan')
|
|
|
|
found_objectives = association_proxy('player_found_objectives', 'objective',
|
|
|
|
creator=lambda objective: PlayerFoundObjective(objective=objective))
|
|
|
|
|
|
|
|
caught_by_players = association_proxy('player_caught_by_players', 'catching_player')
|
|
|
|
caught_players = association_proxy('player_caught_players', 'caught_player')
|
|
|
|
|
|
|
|
def last_location(self, offset=None):
|
|
|
|
'''
|
|
|
|
Returns game_player's last recorded location within game start- and end time.
|
|
|
|
|
|
|
|
Parameters:
|
|
|
|
offset (int): Offset in minutes. Only locations older than this amount of minutes will be returned.
|
|
|
|
'''
|
|
|
|
# pylint: disable=no-member
|
|
|
|
return self.user.last_location(self.game, offset)
|
|
|
|
|
|
|
|
def locations_during_game(self):
|
|
|
|
# pylint: disable=no-member
|
|
|
|
return self.user.locations_during_game(self.game)
|
|
|
|
|
|
|
|
def encode_objectives(self):
|
|
|
|
# pylint: disable=no-member
|
|
|
|
objectives = ['[']
|
|
|
|
for objective in self.game.objectives:
|
|
|
|
obj = {
|
|
|
|
'name' : objective.name,
|
|
|
|
'longitude' : objective.longitude,
|
|
|
|
'latitude' : objective.latitude,
|
|
|
|
'found' : objective in self.found_objectives}
|
|
|
|
objectives.append(json.dumps(obj))
|
|
|
|
objectives.append(',')
|
|
|
|
return ''.join(objectives)[:-1] + ']'
|
|
|
|
|
|
|
|
def accepted_caught_players(self):
|
|
|
|
return [pcp.caught_player
|
|
|
|
for pcp in self.player_caught_players
|
|
|
|
if pcp.review == Review.accepted]
|
|
|
|
|
|
|
|
def accepted_caught_by_players(self):
|
|
|
|
return [pcp.catching_player
|
|
|
|
for pcp in self.player_caught_by_players
|
|
|
|
if pcp.review == Review.accepted]
|