def answer():
if request.method == 'GET':
return render_template('game.j2')
if 'game_id' not in session and 'user_name' in session:
filde = {'user_name': session['user_name']}
game_play = Games(**filde)
game_play.save()
game_id = Games.select().order_by(Games.game_id.desc()).get()
game_id = model_to_dict(game_id)['game_id']
session['game_id'] = game_id
answer = str(request.form['answer'])
if 'riddle' in session:
if answer.lower() == session['riddle']['answer'].lower():
fields = {
'game_result': True,
'riddle': session['riddle']['id'],
'game': session['game_id']
}
GameResulte(**fields).save()
session.pop('riddle', None)
return redirect(url_for('game'))
else:
resulte = 0
resulte = GameResulte.select().where(
GameResulte.game == session['game_id']).count()
if not resulte:
resulte = 'game over'
session.pop('game_id', None)
session.pop('riddle', None)
session['resulte'] = resulte
return redirect(url_for('index'))
return render_template('game.j2')
def _create_game(self, players, columns, rows):
error = Validators()._validate_board(players, columns, rows)
if error:
return error
# This step is currently not needed. The players table is not used.
# TODO: replace all player_name references with foreign_key on
# primary_key
player_ids = []
for player in players:
player_row = Players.query.filter_by(player_name=player).first()
if player_row is None:
new_player = Players(player_name=player)
db.session.add(new_player)
db.session.commit()
player_row = Players.query.filter_by(
player_name=player).first()
player_ids.append(player_row.player_name)
player_ids = ','.join(map(str, player_ids))
new_game = Games(players=str(player_ids),
game_columns=columns,
game_rows=rows,
game_state="IN_PROGRESS")
db.session.add(new_game)
db.session.commit()
game_id = new_game.game_id
return jsonify({"gameId": str(game_id)})
def add_game():
camilo = request.get_json()
game = Games(
name=camilo["name"],
category=camilo["category"],
)
db.session.add(game)
db.session.commit()
return jsonify(game.to_dict())
def AddNewGame(self):
game_new = Games(HomeTeamId=self.HomeTeamId,
HomeTeamScore=self.HomeTeamScore,
AwayTeamId=self.AwayTeamId,
AwayTeamScore=self.AwayTeamScore,
GameStatusId=self.GameStatusId,
GameTypeId=self.GameTypeId,
GameDate=self.GameDate,
GameLink=self.GameLink)
self.game_new = game_new
def add_title(request):
newtitle = request.GET['title']
if newtitle != '':
try:
existingGame = Games.objects.get(title=newtitle)
return render_to_response('gameexist.html')
except:
newgame = Games()
newgame.title = newtitle
newgame.save()
us = User.objects.get(username__exact=request.user.username)
us.employee.lastVoted = datetime.date.today()
us.employee.save()
us.save()
gv = GameVote()
gv.game_id = newgame
gv.save()
return HttpResponseRedirect('/home/')
def createNewGame(user_id):
"""instantiates a new game and adds a player to the game"""
#first check if user is already playing a game
u = Users.query.get(user_id)
if u.game_id:
return [Games.query.get(u.game_id), 'user already playing game']
while True:
rand_code = random.randrange(10000, 99999)
existing_code = Games.query.filter_by(code=rand_code).first()
if not existing_code:
g = Games(code=rand_code)
db.session.add(g)
db.session.commit()
u.game_id = g.id
u.isAdmin = True
db.session.commit()
return [g, 'created new game']
def create_game_route():
content = request.json
game_types = [
'basic_addition',
'advanced_addition',
'basic_subtraction' ,
'advanced_subtraction',
'basic_multiplication',
'advanced_multiplication',
'basic_division',
'advanced_division',
'basic_mixed',
'advanced_mixed',
'add_fractions',
'subtract_fractions',
'multiply_fractions',
'divide_fractions',
'simplify_fractions',
'angles',
'perimeter',
'area',
'pythagorean',
'average',
'median',
'range',
'dollars_and_cents',
'exponents_and_powers',
'square_roots'
]
if content['game_type'] not in game_types:
return jsonify({
'status' : 'error',
'message' : 'Invalid game type.'
})
number_of_questions = int(content['number_of_questions'])
#MAKE TEMPORARY UNIQUE JOIN CODE
found_join_code = False
join_code = ""
while found_join_code == False:
join_code = generate_short_code()
query = Games.query.filter_by(live_game = 1).filter_by(join_code = join_code).first()
if query == None:
found_join_code = True
#CREATE GAME HERE
game_id = generate_random_string(10,20)
new_game = Games(
game_id,
"public",
content['game_type'],
number_of_questions,
1,
join_code
)
db.session.add(new_game)
#CREATE QUESTIONS
for x in range(number_of_questions):
question_data = create_question(content['game_type'])
new_question = Questions(
generate_random_string(10,200),
game_id,
x + 1,
question_data['question_text'],
question_data['answer']
)
db.session.add(new_question)
db.session.commit()
return jsonify({
'status' : 'success',
'game_id' : game_id
})
for event in events:
rot_away = event.rotation_away
rot_home = event.rotation_home
# We need to see if we have already stored this game
result_count = Games.query.filter_by(game_id=event.rundown_id).count()
if result_count > 0:
print('Game already exists in DB. Skipping.')
elif event.event_status == 'STATUS_CANCELED':
print('Game cancelled. Skipping')
else:
game = Games()
game.game_date = event.datetime
game.game_id = event.rundown_id
game.team_away_name = event.team_away_name
game.team_home_name = event.team_home_name
game.rotation_away = event.rotation_away
game.rotation_home = event.rotation_home
game.event_status = event.event_status
game.score_away = event.score_away
game.score_home = event.score_home
game.winner_away = event.winner_away
game.winner_home = event.winner_home
games_added.append(game)
db.session.add_all(games_added)
db.session.commit()
def createGame(self, request):
user = endpoints.get_current_user()
if not user:
raise endpoints.UnauthorizedException('Authorization required')
return newGameMSGout(msg='Not Logged In!',
uv='',
game_id=0,
hint_one='',
hint_two='',
hint_three='')
email = user.email()
user2 = Users.query(Users.email == email).get()
# print user2
if not user2:
msg = 'Email Does Not Exist In App. Please Create Account.'
return newGameMSGout(msg=msg,
uv='',
game_id=0,
hint_one='',
hint_two='',
hint_three='')
user_id = user2.key.id()
checkGame = Games \
.query(ndb.AND(Games.user_id == user_id, Games.active == True)).get()
if checkGame:
msg = ''' You already have an active game. That game must be
finished before starting a new one.
You Guessed %s Times.''' % checkGame.tries
return newGameMSGout(msg=msg,
uv='',
game_id=0,
hint_one='',
hint_two='',
hint_three='')
game = random.choice(options)
uv = randomVal()
newGame = Games(user_id=user_id,
uv=uv,
answer=game['answer'],
hint_one=game['hintONE'],
hint_two=game['hintTWO'],
hint_three=game['hintTHREE'])
ng = newGame.put()
# print ng
ng = ng.id()
user2.current_game_id = ng
user2.put()
taskqueue.add(params={
'email':
email,
'gameInfo':
'New Game!!! https://gamewai-142922.appspot.com/'
},
url='/tasks/send_newgame_email')
return newGameMSGout(msg='New Game Created! Guess Who It Is...',
uv=newGame.uv,
game_id=ng,
hint_one=newGame.hint_one,
hint_two=newGame.hint_two,
hint_three=newGame.hint_three)
def get_form_kwargs(self):
kwargs = super(SubmitGame, self).get_form_kwargs()
kwargs['instance'] = Games()
if self.request.user.is_authenticated():
kwargs['instance'].name = self.request.user
return kwargs
