def evaluate_game(join_code):
#Fetch Game
db = get_db()
result = db.execute(
"SELECT name1, move1, name2, move2 FROM game WHERE joincode = ?",
(join_code, )).fetchone()
move1 = result["move1"]
move2 = result["move2"]
#If both moves are full, emit messages
if (move1 != None and move2 != None):
msg = result["name1"] + " played " + move1 + ", " + result[
"name2"] + " played " + move2 + ". "
if (move1 == move2):
msg += "It's a tie!"
elif ((move1 == "paper" and move2 == "rock")
or (move1 == "scissors" and move2 == "paper")
or (move1 == "rock" and move2 == "scissors")):
msg += result["name1"] + " won!!"
else:
msg += result["name2"] + " won!!"
db.execute(
"UPDATE game set move1 = NULL, move2 = NULL WHERE joincode = (?)",
(join_code, ))
db.commit()
emit("response", {"data": msg, "room": join_code}, broadcast=True)
def test_disconnect():
nickname = session["nickname"]
join_code = session["join_code"]
db = get_db()
# Fetches game row
result = db.execute(
"SELECT name1,move1,name2,move2 FROM game WHERE joincode = ?",
(join_code, )).fetchone()
colname = None
if (result != None):
if (result["name1"] == nickname):
if (result["move1"] == None):
colname = "name1"
elif (result["name2"] == nickname):
if (result["move2"] == None):
colname = "name2"
if (colname != None):
db.execute(
"UPDATE game SET " + colname + " = NULL WHERE joincode = :jc",
{"jc": join_code})
db.commit()
check_empty(join_code)
def check_empty(join_code):
db = get_db()
result = db.execute(
"SELECT name1, move1, name2, move2 FROM game WHERE joincode = ?",
(join_code, )).fetchone()
if (result["name1"] == None or result["name2"] == None):
db.execute("DELETE FROM game WHERE joincode = (?)", (join_code, ))
db.commit()
def move_input(choice):
nickname = session["nickname"]
join_code = session["join_code"]
print("name: " + nickname + " code :" + join_code + " choice: " +
choice["data"])
db = get_db()
# Fetches game row
result = db.execute(
"SELECT name1,move1,name2,move2 FROM game WHERE joincode = ?",
(join_code, )).fetchone()
colname = None
if (result["name1"] == nickname):
if (result["move1"] == None):
colname = "move1"
emit('response', {
'data': nickname + ' made move.',
"room": join_code
},
broadcast=True)
elif (result["name2"] == nickname):
if (result["move2"] == None):
colname = "move2"
emit('response', {
'data': nickname + ' made move.',
"room": join_code
},
broadcast=True)
if (colname != None):
db.execute(
"UPDATE game SET " + colname + " = :choice WHERE joincode = :jc", {
"choice": choice["data"],
"jc": join_code
})
db.commit()
evaluate_game(join_code)
def index():
if request.method == "POST":
nickname = request.form['nickname']
join_code = request.form['join_code']
db = get_db()
game_result = db.execute('SELECT name1,name2,joincode FROM game WHERE joincode = ?', (join_code,)).fetchone()
if game_result is None:
#create new game
db.execute(
'INSERT INTO game (joincode,name1) VALUES (?,?)',(join_code,nickname)
)
db.commit()
session["join_code"] = join_code
session["nickname"] = nickname
print(url_for('game.run_game'))
return redirect(url_for('game.run_game'))
else:
#join exsisting game
if game_result["name2"] != None:
print("SORRY PAL. GAME IS FULL");
else:
db.execute(
'UPDATE game SET name2 = (?) WHERE joincode = (?)',(nickname,join_code)
)
db.commit()
session["join_code"] = game_result["joincode"]
session["nickname"] = nickname
return redirect(url_for('game.run_game'))
return render_template("index.html")