Python Player.get_or_create Examples

Example #1

File: initialize_db.py Project: goonpug/goonpug-stats

#!/usr/bin/env python

from goonpug import db
from goonpug.models import Player


db.create_all()
bot = Player.get_or_create(0, u'Bot')
bot.nickname = u'Bot'
db.session.commit()

# create the player stats views needed by the plugin
q = '''CREATE OR REPLACE VIEW player_overall_rws AS
SELECT player_id, AVG(rws) AS rws FROM player_round
GROUP BY player_round.player_id
'''
db.session.execute(q)

db.session.commit()

Example #2

File: goonpugd.py Project: goonpug/goonpug-stats

 def handle_enter_game(self, event):
     if self.verbose:
         print unicode(event)
     steam_id = event.player.steam_id.id64()
     Player.get_or_create(steam_id, nickname=event.player.name)
     db.session.commit()