import time
from flask import Blueprint, request
from db import cursor, connection
from socket_io import io
from randid import new_uuid
from game.socket import games, game
from hierarchy import auth_required

def create_game(user_1_id, private = False, user_2_id = None):
    timestamp = int( time.time() * 1000 )

    game_id = new_uuid("games")

    cursor.execute("insert into games values (?, NULL, \"\", ?, ?, NULL, ?, NULL, ?, NULL, NULL, NULL, \"wait_for_opponent\", \"default\", ?, FALSE) ", (game_id, user_1_id, user_2_id, timestamp, timestamp, private))
    connection.commit()

    return game_id

def start_game(game_id, user_2_id):
    timestamp = int( time.time() * 1000 )

    db_game = cursor.execute("select player_2_id, status, private from games where game_id = ?", [game_id]).fetchone()
    if db_game[1] != "wait_for_opponent": return False

    if db_game[0] == None: cursor.execute("update games set player_2_id = ? where game_id = ?", (user_2_id, game_id))
    cursor.execute("update games set status = \"in_progress\", started = ?, last_activity = ? where game_id = ?", (timestamp, timestamp, game_id))
    connection.commit()

    players = cursor.execute("select player_1_id, player_2_id from games where game_id = ?", [game_id]).fetchone()
    games[game_id] = game(game_id, io, players[0], players[1])

    io.emit("gameStart", room=games[game_id].room)

new_game = Blueprint('new_game', __name__)

@new_game.route('/new', methods = ["GET", "POST"])
@auth_required("user")
def index(user_id):
    # create a new private game (join by link)
    #TODO: friend invites + notifications
    game_id = create_game(user_id, True)
    return { "id": game_id }, 200

dynamic_route = ["/game", new_game]