Пример #1
0
def player_data():
    if not request.json or 'player' not in request.json:
        print(request, request.json)
        abort(400)

    db = get_db()

    player_data = request.json['player']
    friends = player_data['friends']
    puzzle_data = player_data['puzzle_data']
    del player_data['friends']
    del player_data['puzzle_data']

    player = Player.get_or_create(player_data)
    db.session.query(Player).filter(
        Player.social_id == player.social_id).update(player_data)

    for friend_social_id in friends:
        friend = Player.get_or_create({"social_id": friend_social_id})
        player.add_friendship(friend)

    for index, puzzle_id in enumerate(puzzle_data['puzzles']):
        Score.maybe_update_score({
            'player_social_id': player.social_id,
            'puzzle_id': puzzle_id,
            'score': puzzle_data['scores'][index],
            'stars': puzzle_data['stars'][index]})

    db.session.commit()

    return jsonify(
        _assemble_response(player))
Пример #2
0
from sqlalchemy import func
from bootstrap import get_db

db = get_db()

class DnfBase(db.Model):
    __abstract__ = True

    def as_dict(self):
        return {c.name: getattr(self, c.name) for c in self.__table__.columns}

friendships = db.Table("friendships",
                       db.Column('friend_social_id',
                                 db.String(32),
                                 db.ForeignKey('player.social_id'),
                                 primary_key=True),
                       db.Column('friend_of_social_id',
                                 db.String(32),
                                 db.ForeignKey('player.social_id'),
                                 primary_key=True))


class Score(DnfBase):
    player_social_id = db.Column(db.String(32), db.ForeignKey(
        'player.social_id'), primary_key=True)
    puzzle_id = db.Column(db.Integer, primary_key=True)
    score = db.Column(db.Integer, nullable=False)
    stars = db.Column(db.Integer, nullable=False)

    def __init__(self, player_social_id, puzzle_id, score, stars):
        self.player_social_id = player_social_id