def sign_up(): # on récupère le json envoyé par le client formulaire_inscription = (request.get_json()) # on récupère l'email email = formulaire_inscription["email"] # on check si l'email existe, si oui on envoie une erreur sql_request = f'''SELECT * FROM players WHERE players_email = "{email}"''' players_avec_cette_email = sql_select(sql_request) if len(players_avec_cette_email) > 0: return "Email déjà existant", 503 # on ajoute le joueur sql_request = f'''INSERT INTO players(players_pseudo, players_email, players_password) VALUES("{formulaire_inscription["pseudo"]}", "{formulaire_inscription["email"]}", "{formulaire_inscription["password"]}")''' players_id = sql_insert(sql_request) add_room(players_id, 0, 0, formulaire_inscription["seed"]) return "OK", 200
def add_room(players_id, pos_x, pos_y, seed): request_sql = f'''SELECT * FROM rooms WHERE rooms.players_id = {players_id} AND rooms.rooms_position_x = {pos_x} AND rooms.rooms_position_y = {pos_y}''' checkroom = sql_select(request_sql) if len(checkroom) > 0: return "Il y a deja une salle à cet endroit", 404 else: request_sql = f'''INSERT INTO rooms(players_id, rooms_position_x, rooms_position_y, rooms_seed) VALUES ('{players_id}', '{pos_x}', '{pos_y}', '{seed}')''' room_build = sql_insert(request_sql) return jsonify({"id": room_build})
def add_room(players_id, pos_x, pos_y, seed): sql_request = f'''SELECT * FROM rooms WHERE players_id = "{players_id}" AND rooms_position_x = "{pos_x}" AND rooms_position_x = "{pos_y}"''' player_rooms_info = sql_select(sql_request) if len(player_rooms_info) > 0: return "Il y a déjà une room ici", 403 else: sql_request = f'''INSERT INTO rooms (rooms_position_x, rooms_position_y, rooms_seed, players_id) VALUES("{pos_x}", "{pos_y}", "{seed}", "{players_id}")''' execute = sql_insert(sql_request) return {"id": execute}, 200
def add_room(players_id, pos_x, pos_y, seed): sql_request = f'''SELECT * FROM rooms WHERE rooms.players_id = "{players_id}" AND rooms.rooms_position_x = "{pos_x}" AND rooms.rooms_position_y = "{pos_y}"''' checkroom = sql_select(sql_request) if len(checkroom) > 0: return "il y a deja une room ici", 404 else: sql_request = f'''INSERT INTO rooms (players_id, rooms_position_x, rooms_position_y, rooms_seed) VALUES("{players_id}", "{pos_x}", "{pos_y}", "{seed}")''' room_build = sql_insert(sql_request) return jsonify({"id": room_build}), 200
def add_room(players_id, pos_x, pos_y, seed): # Requête pour créer une nouvelle ligne dans la table rooms sql_request = f'''INSERT INTO `rooms` (`rooms_id`, `rooms_position_x`, `rooms_position_y`, `rooms_seed`, `players_id`) VALUES (NULL, '{pos_x}', '{pos_y}', '{seed}', '{players_id}');''' # On check s'il existe déjà une salle à l'endroit désiré sql_request2 = f'''SELECT rooms_position_x,rooms_position_y FROM `rooms` WHERE players_id = {players_id}''' rooms_positions = sql_select(sql_request2) for rooms in rooms_positions: if pos_x == rooms["rooms_position_x"] and pos_y == rooms["rooms_position_y"]: return "Il y a déjà une salle à cette position", 403 # On insert la nouvelle salle dans la BDD et on renvoit l"id de la salle. new_room = sql_insert(sql_request) new_room_dico = {"id": new_room} return jsonify(new_room_dico), 200
def add_room(players_id, pos_x, pos_y, seed): #check si une room existe déja a cette position sql_request = f'''SELECT * FROM rooms WHERE player_id = "{players_id}" AND rooms_position_x = "{pos_x}" AND rooms_position_y = "{pos_y}"''' player_rooms_info = sql_select(sql_request) if len(player_rooms_info) > 0 return "une room éxiste déja ici", 403 else: sql_request = f'''INSERT INTO rooms(rooms_position_y, rooms_seed, player_id) VALUES("{pos_x}", "{pos_y}", "{seed}", "{players_id}")''' execute = sql_insert(sql_request) return {"id": execute}, 200
def add_room(players_id, pos_x, pos_y, seed): sql_request = f'''SELECT * FROM rooms WHERE players_id = {players_id} AND rooms_position_x ={pos_x} AND rooms_position_y ={pos_y} ''' player_rooms_info = sql_select(sql_request) if len(player_rooms_info) > 0: return "Une Salle existe deja à ces coordonnées", 501 else: sql_request = f'''INSERT INTO rooms(rooms_position_x, rooms_position_y, rooms_seed, players_id) VALUES({pos_x}, {pos_y}, {seed}, {players_id})''' add = sql_insert(sql_request) return {"id": add}, 200