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_get_game(self): """ Ensure we can get an existing game. """ # Seed the database with a game game = Game() game.gametype = GameType.objects.get(pk=1) game.skill_level = 5 game.title = "Monopoly" game.maker = "Milton Bradley" game.number_of_players = 4 game.gamer = Gamer.objects.get(pk=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 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 = GameType.objects.get(pk=1) game.skill_level = 5 game.title = "Sorry" game.maker = "Milton Bradley" game.number_of_players = 4 game.gamer = Gamer.objects.get(pk=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.gametype = 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_404_BAD_REQUEST)
def test_change_game(self): """ Ensure we can change an existing game. """ game = Game() game.gametype = GameType.objects.get(pk=1) game.skill_level = 5 game.title = "Sorry" game.maker = "Milton Bradley" game.number_of_players = 4 game.gamer = Gamer.objects.get(pk=1) game.save() # DEFINE NEW PROPERTIES FOR GAME data = { "gametype": 1, "skill_level": 2, "title": "Sorry", "maker": "Hasbro", "number_of_players": 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["maker"], "Hasbro") self.assertEqual(json_response["skill_level"], 2) self.assertEqual(json_response["number_of_players"], 4)
def usergame_list(request): """Function to build an HTML report of games by user""" if request.method == 'GET': # Connect to project database with sqlite3.connect(Connection.db_path) as conn: conn.row_factory = sqlite3.Row db_cursor = conn.cursor() # Query for all games, with related user info. 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() # Take the flat data from the database, and build the # following data structure for each gamer. # # { # 1: { # "id": 1, # "full_name": "Admina Straytor", # "games": [ # { # "id": 1, # "title": "Foo", # "maker": "Bar Games", # "skill_level": 3, # "number_of_players": 4, # "gametype_id": 2 # } # ] # } # } games_by_user = {} for row in dataset: # Crete a Game instance and set its properties 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 = GameType.objects.get(pk=row["gametype_id"]) # Store the user's id uid = row["user_id"] # If the user's id is already a key in the dictionary... if uid in games_by_user: # Add the current game to the `games` list for it games_by_user[uid]['games'].append(game) else: # Otherwise, create the key and dictionary value 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] # Get only the values from the dictionary and create a list from them list_of_users_with_games = games_by_user.values() # Specify the Django template and provide data context template = 'users/list_with_games.html' context = {'usergame_list': list_of_users_with_games} return render(request, template, context)