def test_change_game(self): """ Ensure we can change 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() # DEFINE NEW PROPERTIES FOR GAME data = { "gameTypeId": 1, "description": "difficult game", "title": "Sorry", "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["description"], "difficult game") 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_id = 1 game.title = "Monopoly" game.description = "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["description"], "Milton Bradley") self.assertEqual(json_response["gamer"]["id"], 1) self.assertEqual(json_response["game_type"]["id"], 1) self.assertEqual(json_response["number_of_players"], 4)
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_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 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 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 test_delete_game(self): """ Ensure we can delete an existing game. """ game = Game() game.game_type_id = 1 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 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!!" } #game, schedular, gametype # 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 = Game_Type() gametype.label = "Board game" gametype.save() game = Game() game.game_type_id = 1 game.title = "Sorry" game.gamer_id = 1 game.number_of_players = 4 game.description = "fun" game.save()
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 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 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.game_type_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, # "game_type_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.game_type_id = row["game_type_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)