def test_change_game(self): """ Ensure we can change an existing game. """ game = Game() game.game_type_id = 1 game.title = "Sorry" game.maker = "Milton Bradley" game.number_of_players = 4 game.gamer_id = 1 game.description = "This is a fun game" game.save() # DEFINE NEW PROPERTIES FOR GAME data = { "gameTypeId": 1, "skillLevel": 2, "title": "Sorry", "numberOfPlayers": 4, "description": "This is a fun game" } self.client.credentials(HTTP_AUTHORIZATION='Token ' + self.token) response = self.client.put(f"/games/{game.id}", data, format="json") self.assertEqual(response.status_code, status.HTTP_204_NO_CONTENT) # GET GAME AGAIN TO VERIFY CHANGES response = self.client.get(f"/games/{game.id}") json_response = json.loads(response.content) self.assertEqual(response.status_code, status.HTTP_200_OK) # Assert that the properties are correct self.assertEqual(json_response["title"], "Sorry") self.assertEqual(json_response["number_of_players"], 4) self.assertEqual(json_response["description"], "This is a fun game")
def create(self, request): """Handle POST operations Returns: Response -- JSON serialized game instance """ gamer = Gamer.objects.get(user=request.auth.user) game = Game() try: game.title = request.data["title"] game.maker = request.data["maker"] game.number_of_players = request.data["numberOfPlayers"] game.skill_level = request.data["skillLevel"] except KeyError as ex: return Response({'message': 'Incorrect key was sent in request'}, status=status.HTTP_400_BAD_REQUEST) game.gamer = gamer try: gametype = GameType.objects.get(pk=request.data["gameTypeId"]) game.gametype = gametype except GameType.DoesNotExist as ex: return Response({'message': 'Game type provided is not valid'}, status=status.HTTP_400_BAD_REQUEST) try: game.save() serializer = GameSerializer(game, context={'request': request}) return Response(serializer.data, status=status.HTTP_201_CREATED) except ValidationError as ex: return Response({"reason": ex.message}, status=status.HTTP_400_BAD_REQUEST)
def test_change_game(self): game = Game() game.game_type_id = 1 game.skill_level = 1 game.title = "Sorry" game.maker = "Milton Bradley" game.number_of_players = 4 game.gamer_id = 1 game.save() # DEFINE NEW PROPERTIES FOR GAME data = { "game_type_id": 1, "title": "Sorry", "skill_level": 1, "maker": "Hasbro", "number_of_players": 4 } self.client.credentials(HTTP_AUTHORIZATION=f'Token {self.token}') response = self.client.put(f"/games/{game.id}", data, format="json") self.assertEqual(response.status_code, status.HTTP_204_NO_CONTENT) # GET GAME AGAIN TO VERIFY CHANGES response = self.client.get(f"/games/{game.id}") json_response = json.loads(response.content) self.assertEqual(response.status_code, status.HTTP_200_OK) # Assert that the properties are correct self.assertEqual(json_response["title"], "Sorry") self.assertEqual(json_response["skill_level"], 1) self.assertEqual(json_response["maker"], "Hasbro") self.assertEqual(json_response["number_of_players"], 4)
def test_get_game(self): """ Ensure we can get an existing game. """ # Seed the database with a game game = Game() game.gametype_id = 1 game.skill_level = 5 game.title = "Monopoly" game.maker = "Milton Bradley" game.number_of_players = 4 game.gamer_id = 1 game.save() # Make sure request is authenticated self.client.credentials(HTTP_AUTHORIZATION='Token ' + self.token) # Initiate request and store response response = self.client.get(f"/games/{game.id}") # Parse the JSON in the response body json_response = json.loads(response.content) # Assert that the game was retrieved self.assertEqual(response.status_code, status.HTTP_200_OK) # Assert that the values are correct self.assertEqual(json_response["title"], "Monopoly") self.assertEqual(json_response["maker"], "Milton Bradley") self.assertEqual(json_response["skill_level"], 5) self.assertEqual(json_response["number_of_players"], 4)
def test_get_game(self): """ Ensure we can get an existing game. """ # Seed the database with a game game = Game() game.game_type = self.gametype game.description = "You move around the game board (a mansion), as of one of the game's six suspects, collecting clues from which to deduce which suspect murdered the game's perpetual victim: Mr. Boddy (Dr. Black, outside of U.S.), and with which weapon and in what room." game.title = "Monopoly" game.number_of_players = 4 game.gamer_id= 1 game.save() # Make sure request is authenticated self.client.credentials(HTTP_AUTHORIZATION='Token ' + self.token) # Initiate request and store response response = self.client.get(f"/games/{game.id}") # Parse the JSON in the response body json_response = json.loads(response.content) # Assert that the game was retrieved self.assertEqual(response.status_code, status.HTTP_200_OK) # Assert that the values are correct self.assertEqual(json_response["title"], "Monopoly") self.assertEqual(json_response["description"], "You move around the game board (a mansion), as of one of the game's six suspects, collecting clues from which to deduce which suspect murdered the game's perpetual victim: Mr. Boddy (Dr. Black, outside of U.S.), and with which weapon and in what room.") self.assertEqual(json_response["number_of_players"], 4) self.assertEqual(json_response["game_type"]["id"], 1) self.assertEqual(json_response["gamer"]["id"], 1)
def test_change_game(self): """ Ensure we can change an existing game. """ game = Game() game.game_type = self.gametype game.description = "Players move their three or four pieces around the board, attempting to get all of their pieces home before any other player" game.title = "Sorry" game.number_of_players = 4 game.gamer_id = 1 game.save() # DEFINE NEW PROPERTIES FOR GAME data = { "gameTypeId": 1, "description": "Players move their three or four pieces around the board, attempting to get all of their pieces home before any other player", "title": "Sorry", "numberOfPlayers": 4 } self.client.credentials(HTTP_AUTHORIZATION='Token ' + self.token) response = self.client.put(f"/games/{game.id}", data, format="json") self.assertEqual(response.status_code, status.HTTP_204_NO_CONTENT) # GET GAME AGAIN TO VERIFY CHANGES response = self.client.get(f"/games/{game.id}") json_response = json.loads(response.content) self.assertEqual(response.status_code, status.HTTP_200_OK) # Assert that the properties are correct self.assertEqual(json_response["title"], "Sorry") self.assertEqual(json_response["description"], "Players move their three or four pieces around the board, attempting to get all of their pieces home before any other player") self.assertEqual(json_response["number_of_players"], 4) self.assertEqual(json_response["game_type"]["id"], 1) self.assertEqual(json_response["gamer"]["id"], 1)
def setUp(self): #create new account and sample category url = '/register' data = { 'username': '******', 'password': '******', 'email': '*****@*****.**', 'address': '100 Infinity Way', 'phone_number': '555-1212', 'first_name': 'Steve', 'last_name': 'Brownlee', 'bio': 'Love those gamez!!' } #initiate request and grab the response response = self.client.post(url, data, format='json') #parse the JSON in the resonse body fuckin_json_response = json.loads(response.content) #store teh AUTH Token self.token = fuckin_json_response['token'] #assert that a user was created self.assertEqual(response.status_code, status.HTTP_201_CREATED) #seed the DB wit one game type so it don't break and there's no URL endpoint for creating GTs gametype = GameType() gametype.label = 'Classic Type' gametype.save() #now make a dummy game and save it game = Game() game.game_type_id = 1 game.title = 'Chess' game.description = 'GOAT Board Game' game.number_of_players = 2 game.gamer_id = 1 game.save()
def test_change_game(self): #test we can update an existing game game = Game() game.game_type_id = 1 game.title = 'Chess' game.description = 'GOAT Board Game' game.number_of_players = 2 game.gamer_id = 1 game.save() #now define NEW properties for this shit data = { 'gameTypeId': 1, 'title': 'Clue', 'description': 'Milton Bradley', 'numberOfPlayers': 6, } self.client.credentials(HTTP_AUTHORIZATION='Token ' + self.token) response = self.client.put(f'/games/{game.id}', data, format='json') self.assertEqual(response.status_code, status.HTTP_204_NO_CONTENT) #verify the changes response = self.client.get(f'/games/{game.id}') json_response = json.loads(response.content) self.assertEqual(response.status_code, status.HTTP_200_OK) #assert that the properties on the this resource are correct self.assertEqual(json_response['title'], 'Clue') self.assertEqual(json_response['description'], 'Milton Bradley') self.assertEqual(json_response['number_of_players'], 6)
def test_get_game(self): """ Ensure we can get an existing game. """ # Seed the database with a game game = Game() game.title = "Checkers" game.gametype_id = 1 game.number_of_players = 2 game.gamer_id = 1 game.description = "Great game" game.save() # Make sure request is authenticated self.client.credentials(HTTP_AUTHORIZATION='Token ' + self.token) # Initiate request and store response response = self.client.get(f"/games/{game.id}") # Parse the JSON in the response body json_response = json.loads(response.content) # Assert that the game was retrieved self.assertEqual(response.status_code, status.HTTP_200_OK) # Assert that the values are correct self.assertEqual(json_response["title"], "Checkers") self.assertEqual(json_response["description"], "Great game")
def setUp(self): """ Create a new account and create sample category """ url = "/register" data = { "username": "******", "password": "******", "email": "*****@*****.**", "address": "100 Infinity Way", "phone_number": "555-1212", "first_name": "Steve", "last_name": "Brownlee", "bio": "Love those eventz!!" } # Initiate request and capture response response = self.client.post(url, data, format='json') # Parse the JSON in the response body json_response = json.loads(response.content) # Store the auth token self.token = json_response["token"] # Assert that a user was created self.assertEqual(response.status_code, status.HTTP_201_CREATED) # SEED DATABASE WITH ONE GAME TYPE # This is needed because the API does not expose a /gametypes # endpoint for creating game types gametype = GameType() gametype.label = "Board game" gametype.save() # SEED DATABASE WITH ONE game # This is needed because the API does not expose a /game # endpoint for creating game game = Game() game.gamer_id = 1 game.gametype_id = gametype.id game.skill_level = 5 game.number_of_players = 3 game.maker = "Wizards of the Coast" game.title = "Dungeons & Dragons" game.save()
def create(self, request): gamer = Gamer.objects.get(user=request.auth.user) game = Game() game.title = request.data["title"] game.maker = request.data["maker"] game.number_of_players = request.data["numberOfPlayers"] game.skill_level = request.data["skillLevel"] game.gamer = gamer gametype = GameType.objects.get(pk=request.data["gameTypeId"]) game.gametype = gametype try: game.save() serializer = GameSerializer(game, context={'request': request}) return Response(serializer.data) except ValidationError as ex: return Response({"reason": ex.message}, status=status.HTTP_400_BAD_REQUEST)
def setUp(self): """ Create a new account and create sample category """ url = "/register" data = { "username": "******", "password": "******", "email": "*****@*****.**", "address": "100 Infinity Way", "phone_number": "555-1212", "first_name": "Jon", "last_name": "Shearon", "bio": "Love those gamez!!" } # Initiate request and capture response response = self.client.post(url, data, format='json') # Parse the JSON in the response body json_response = json.loads(response.content) # Store the auth token self.token = json_response["token"] # Assert that a user was created self.assertEqual(response.status_code, status.HTTP_201_CREATED) # SEED DATABASE WITH ONE GAME TYPE # This is needed because the API does not expose a /gametypes # endpoint for creating game types gametype = GameType() gametype.label = "Board game" gametype.save() game = Game() game.gametype = GameType.objects.get(pk=1) game.skill_level = 5 game.title = "Clue" game.maker = "Milton Bradley" game.number_of_players = 6 game.gamer = Gamer.objects.get(pk=1) game.save()
def test_delete_game(self): """ Ensure we can delete an existing game. """ game = Game() game.gametype_id = 1 game.skill_level = 5 game.title = "Sorry" game.maker = "Milton Bradley" game.number_of_players = 4 game.gamer_id = 1 game.save() self.client.credentials(HTTP_AUTHORIZATION='Token ' + self.token) response = self.client.delete(f"/games/{game.id}") self.assertEqual(response.status_code, status.HTTP_204_NO_CONTENT) # GET GAME AGAIN TO VERIFY 404 response response = self.client.get(f"/games/{game.id}") self.assertEqual(response.status_code, status.HTTP_404_NOT_FOUND)
def test_delete_game(self): #make sure we can delete a game game = Game() game.game_type_id = 1 game.title = 'Chess' game.description = 'GOAT Board Game' game.number_of_players = 2 game.gamer_id = 1 game.save() self.client.credentials(HTTP_AUTHORIZATION='Token ' + self.token) response = self.client.delete(f'/games/{game.id}') self.assertEqual(response.status_code, status.HTTP_204_NO_CONTENT) # GET GAME AGAIN TO VERIFY 404 response response = self.client.get(f'/games/{game.id}') self.assertEqual(response.status_code, status.HTTP_404_NOT_FOUND)
def create(self, request): """Handle POST operations Returns: Response -- JSON serialized game instance """ # Uses the token passed in the `Authorization` header gamer = Gamer.objects.get(user=request.auth.user) # Create a new Python instance of the Game class # and set its properties from what was sent in the # body of the request from the client. game = Game() game.title = request.data["title"] game.maker = request.data["maker"] game.number_of_players = request.data["numberOfPlayers"] game.skill_level = request.data["skillLevel"] game.gamer = gamer # Use the Django ORM to get the record from the database # whose `id` is what the client passed as the # `gameTypeId` in the body of the request. gametype = GameType.objects.get(pk=request.data["gameTypeId"]) game.game_type = gametype # Try to save the new game to the database, then # serialize the game instance as JSON, and send the # JSON as a response to the client request try: game.save() serializer = GameSerializer(game, context={'request': request}) return Response(serializer.data, status=status.HTTP_201_CREATED) # If anything went wrong, catch the exception and # send a response with a 400 status code to tell the # client that something was wrong with its request data except ValidationError as ex: return Response({"reason": ex.message}, status=status.HTTP_400_BAD_REQUEST)
def create(self, request): # use token passed in the 'Authorization' header gamer = Gamer.objects.get(user=request.auth.user) # create a new Python instance of the Game class con properties de REQUEST de client game = Game() game.title = request.data["title"] game.game_type_id = request.data["gameTypeId"] game.number_of_players = request.data["numberOfPlayers"] game.description = request.data["description"] game.gamer = gamer # now use the Djanog ORM to fetch the record from the database whose 'id' is what the client passed as gameTypeId game_type = GameType.objects.get(pk=request.data["gameTypeId"]) game.game_type = game_type # try to save the new game to the db, then serialize it to JSON, then send that JSON back to client try: game.save() serializer = GameSerializer(game, context={'request': request}) return Response(serializer.data, status=status.HTTP_201_CREATED) except ValidationError as ex: return Response({"reason": ex.message}, status=status.HTTP_400_BAD_REQUEST)
def test_delete_game(self): """ Ensure we can delete an existing game. """ game = Game() game.game_type = self.gametype game.description = "Players move their three or four pieces around the board, attempting to get all of their pieces home before any other player" game.title = "Sorry" game.number_of_players = 4 game.gamer_id = 1 game.save() self.client.credentials(HTTP_AUTHORIZATION='Token ' + self.token) response = self.client.delete(f"/games/{game.id}") self.assertEqual(response.status_code, status.HTTP_204_NO_CONTENT) # GET GAME AGAIN TO VERIFY 404 response response = self.client.get(f"/games/{game.id}") self.assertEqual(response.status_code, status.HTTP_404_NOT_FOUND)
def test_delete_game(self): """ Ensure we can delete an existing game. """ game = Game() game.title = "Checkers" game.gametype_id = 1 game.number_of_players = 2 game.gamer_id = 1 game.description = "Great game" game.save() self.client.credentials(HTTP_AUTHORIZATION='Token ' + self.token) response = self.client.delete(f"/games/{game.id}") self.assertEqual(response.status_code, status.HTTP_204_NO_CONTENT) # GET game again to verify 404 response response = self.client.get(f"/games/{game.id}") self.assertEqual(response.status_code, status.HTTP_404_NOT_FOUND)
def create(self, request): gamer = Gamer.objects.get(user=request.auth.user) game = Game() game.title = request.data['title'] game.maker = request.data['maker'] game.number_of_players = request.data['numberOfPlayers'] game.skill_level = request.data['skillLevel'] game.gamer = gamer game_type = GameType.objects.get(pk=request.data['gameTypeId']) # select * # from gametype # where id=request.data['game_type_id'] game.game_type = game_type try: game.save() serializer = GameSerializer(game, context={'request': request}) return Response(serializer.data, status=status.HTTP_201_CREATED) except ValidationError as ex: return Response({'reason': ex.message}, status=status.HTTP_400_BAD_REQUEST)
def usergame_list(request): if request.method == "GET": with sqlite3.connect(Connection.db_path) as conn: conn.row_factory = sqlite3.Row db_cursor = conn.cursor() db_cursor.execute(""" select g.id, g.title, g.maker, g.game_type_id, g.skill_level, g.number_of_players, u.id user_id, u.first_name || ' ' || u.last_name as full_name from levelupapi_game g join levelupapi_gamer gr on g.gamer_id = gr.id join auth_user u on gr.user_id = u.id """) dataset = db_cursor.fetchall() games_by_user = {} for row in dataset: game = Game() game.title = row['title'] game.maker = row['maker'] game.skill_level = row['skill_level'] game.number_of_players = row['number_of_players'] game.game_type_id = row['game_type_id'] uid = row['user_id'] if uid in games_by_user: games_by_user[uid]['games'].append(game) else: games_by_user[uid] = {} games_by_user[uid]['id'] = uid games_by_user[uid]['full_name'] = row['full_name'] games_by_user[uid]['games'] = [game] list_of_users_with_games = games_by_user.values() template = 'users/list_with_games.html' context = { 'usergame_list': list_of_users_with_games, 'title': 'Users with Games' } return render(request, template, context)
def setUp(self): url = "/register" data = { "username": "******", "password": "******", "email": "*****@*****.**", "first_name": "Steve", "last_name": "Brownlee", "bio": "Love those gamez!!" } response = self.client.post(url, data, format='json') json_response = json.loads(response.content) self.token = json_response["token"] self.assertEqual(response.status_code, status.HTTP_201_CREATED) gametype = GameType() gametype.label = "Board game" gametype.save() # url = "/games" # data = { # "gamer": 1, # "game_type": 1, # "title": "Balderdash", # "number_of_players": 2, # "description": "fun" # } # response = self.client.post(url, data, format='json') # json_response = json.loads(response.content) # self.token = json_response["token"] # self.assertEqual(response.status_code, status.HTTP_201_CREATED) game = Game() game.game_type = gametype game.title = "Balderdash" game.number_of_players = 4 game.gamer_id = 1 game.save()
def usergame_list(request): if request.method == 'GET': with sqlite3.connect(Connection.db_path) as conn: conn.row_factory = sqlite3.Row db_cursor = conn.cursor() db_cursor.execute(""" SELECT g.id, g.title, g.maker, g.gametype_id, g.number_of_players, g.skill_level, u.id user_id, u.first_name || ' ' || u.last_name AS full_name FROM levelupapi_game g JOIN levelupapi_gamer gr ON g.gamer_id = gr.id JOIN auth_user u ON gr.user_id = u.id """) dataset = db_cursor.fetchall() gamers_dict = {} for row in dataset: game = Game() game.title = row["title"] game.maker = row["maker"] game.skill_level = row["skill_level"] game.number_of_players = row["number_of_players"] game.gametype_id = row["gametype_id"] uid = row["user_id"] if uid in gamers_dict: gamers_dict[uid]['games'].append(game) else: gamers_dict[uid] = {} gamers_dict[uid]["id"] = uid gamers_dict[uid]["full_name"] = row["full_name"] gamers_dict[uid]["games"] = [game] # Get only the values from the dictionary and create a list from them list_of_user_objects = gamers_dict.values() # Specify the HTML template and provide data context template = 'users/list_with_games.html' context = {'usergame_list': list_of_user_objects} return render(request, template, context)
def test_change_game(self): """ Ensure we can change an existing game. """ game = Game() game.gametype_id = 1 game.skill_level = 5 game.title = "Sorry" game.maker = "Milton Bradley" game.number_of_players = 4 game.gamer_id = 1 game.save() # DEFINE NEW PROPERTIES FOR GAME data = { "gameTypeId": 1, "skillLevel": 2, "title": "Sorry", "maker": "Hasbro", "numberOfPlayers": 4 } # print('GAME ID ' + str(game.id)) self.client.credentials(HTTP_AUTHORIZATION='Token ' + self.token) response = self.client.put(f"/games/{game.id}", data, format='json') self.assertEqual(response.status_code, status.HTTP_204_NO_CONTENT) # get game again to verify changes response = self.client.get(f"/games/{game.id}") json_response = json.loads(response.content) self.assertEqual(response.status_code, status.HTTP_200_OK) # assert that the properties are correct self.assertEqual(json_response["title"], "Sorry") self.assertEqual(json_response["maker"], "Hasbro") self.assertEqual(json_response["skill_level"], 2) self.assertEqual(json_response["number_of_players"], 4)
def test_delete_game(self): """ Ensure we can delete an existing game. """ game = Game() game.game_type_id = 1 game.title = "Monopoly" game.description = "family ending board game" game.number_of_players = 4 game.gamer_id = 1 game.save() self.client.credentials(HTTP_AUTHORIZATION='Token ' + self.token) response = self.client.delete(f"/games/{game.id}") self.assertEqual(response.status_code, status.HTTP_204_NO_CONTENT) # GET GAME AGAIN TO VERIFY 404 response response = self.client.get(f"/games/{game.id}") self.assertEqual(response.status_code, status.HTTP_404_NOT_FOUND)
def test_delete_game(self): """ Ensure we can delete an existing game. """ # Use the ORM to insert some test data into the database game = Game() game.gametype_id = 1 game.skill_level = 5 game.title = "Sorry" game.maker = "Milton Bradley" game.number_of_players = 4 game.gamer_id = 1 game.save() # Authorize the request self.client.credentials(HTTP_AUTHORIZATION='Token ' + self.token) # Use the API to delete the test game response = self.client.delete(f"/games/{game.id}") # GET GAME AGAIN TO VERIFY 404 response response = self.client.get(f"/games/{game.id}") self.assertEqual(response.status_code, status.HTTP_404_NOT_FOUND)
def test_get_game(self): #check to see if we can get an existing game, 1st seed the DB game = Game() game.game_type_id = 1 game.title = 'Chess' game.description = 'GOAT Board Game' game.number_of_players = 2 game.gamer_id = 1 game.save() #make sure request is authenticated self.client.credentials(HTTP_AUTHORIZATION='Token ' + self.token) #initi8ate request and store response response = self.client.get(f'/games/{game.id}') #json rESPONSE JUST F*****G PARSE IT!!! json_response = json.loads(response.content) #assert that the game WAS RETRIEVED SUCCESSFULLY self.assertEqual(response.status_code, status.HTTP_200_OK) #assert that the values are correct self.assertEqual(json_response['title'], 'Chess') self.assertEqual(json_response['description'], 'GOAT Board Game') self.assertEqual(json_response['number_of_players'], 2)
def setUp(self): """ Create a new account and create sample category """ url = "/register" data = { "username": "******", "password": "******", "email": "*****@*****.**", "address": "100 Infinity Way", "phone_number": "555-1212", "first_name": "Steve", "last_name": "Brownlee", "bio": "Love those gamez!!" } # Initiate request and capture response response = self.client.post(url, data, format='json') # Parse the JSON in the response body json_response = json.loads(response.content) # Store the auth token self.token = json_response["token"] # Assert that a user was created self.assertEqual(response.status_code, status.HTTP_201_CREATED) gametype = GameType() gametype.label = "Board game" gametype.save() game = Game() game.title = "title" game.number_of_players = 4 game.description = "This gmae is fun" game.gamer_id = 1 game_type = 1 game.game_type_id = game_type game.save()
def test_change_game(self): """ Ensure we can change an existing game. """ game = Game() game.title = "Sorry" game.gametype_id = 1 game.number_of_players = 4 game.gamer_id = 1 game.description = "Sucks to be you" game.save() # DEFINE NEW PROPERTIES FOR GAME data = { "title": "Sorry", "gameTypeId": 1, "numberOfPlayers": 4, "gamer": 1, "description": "Sorry suckaaa!" } self.client.credentials(HTTP_AUTHORIZATION='Token ' + self.token) response = self.client.put(f"/games/{game.id}", data, format="json") self.assertEqual(response.status_code, status.HTTP_204_NO_CONTENT) # GET GAME AGAIN TO VERIFY CHANGES response = self.client.get(f"/games/{game.id}") json_response = json.loads(response.content) self.assertEqual(response.status_code, status.HTTP_200_OK) # print(f"(Hello){type(json_response)}") # Assert that the properties are correct self.assertEqual(json_response["title"], "Sorry") self.assertEqual(json_response["gametype"]["id"], 1) self.assertEqual(json_response["number_of_players"], 4) self.assertEqual(json_response["gamer"]["id"], 1) self.assertEqual(json_response["description"], "Sorry suckaaa!")
def setUp(self): """ Create a new account and set up a game """ url = "/register" data = { "username": "******", "password": "******", "email": "*****@*****.**", "first_name": "Steve", "last_name": "Brownlee", "bio": "Love those eventz!!" } # Initiate request and capture response response = self.client.post(url, data, format='json') # Parse the JSON in the response body json_response = json.loads(response.content) # Store the auth token self.token = json_response["token"] # Assert that a user was created self.assertEqual(response.status_code, status.HTTP_201_CREATED) # Seed database with one game type gametype = GameType() gametype.label = "Board game" gametype.save() # Seed database with one game game = Game() game.title = "Checkers" game.gametype_id = 1 game.number_of_players = 2 game.gamer_id = 1 game.description = "Great game" game.save()
def usergame_list(request): if request.method == 'GET': with sqlite3.connect(Connection.db_path) as conn: conn.row_factory = sqlite3.Row db_cursor = conn.cursor() db_cursor.execute(""" SELECT id, title, maker, gametype_id, number_of_players, skill_level, user_id, full_name FROM GAMES_BY_USER """) dataset = db_cursor.fetchall() games_by_user = {} for row in dataset: game = Game() game.title = row["title"] game.maker = row["maker"] game.skill_level = row["skill_level"] game.number_of_players = row["number_of_players"] game.gametype_id = row["gametype_id"] uid = row["user_id"] if uid in games_by_user: games_by_user[uid]['games'].append(game) else: games_by_user[uid] = {} games_by_user[uid]["id"] = uid games_by_user[uid]["full_name"] = row["full_name"] games_by_user[uid]["games"] = [game] list_of_users_with_games = games_by_user.values() template = 'users/list_with_games.html' context = { 'usergame_list': list_of_users_with_games } return render(request, template, context)