def test_get_game(self): """ Ensure we can get an existing game. """ event = Event() event.event_day = "1820-10-25" event.event_time = "14:39" event.game_id = 1 event.location = "Tom's" event.gamer_id = 1 event.save() # Make sure request is authenticated self.client.credentials(HTTP_AUTHORIZATION='Token ' + self.token) # Initiate request and store response response = self.client.get(f"/events/{event.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["event_day"], "1820-10-25") self.assertEqual(json_response["event_time"], "14:39:00") self.assertEqual(json_response["location"], "Tom's")
def test_get_event(self): """ Ensure we can get an existing event. """ # Seed the database with a event event = Event() event.time = "19:30:00" event.date = "2021-08-14" event.game_id = 1 event.description = "We all live in a yellow submarine" event.organizer_id = 1 event.save() # Make sure request is authenticated self.client.credentials(HTTP_AUTHORIZATION='Token ' + self.token) # Initiate request and store response response = self.client.get(f"/events/{event.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["time"], "19:30:00") self.assertEqual(json_response["date"], "2021-08-14") self.assertEqual(json_response["description"], "We all live in a yellow submarine")
def test_get_event(self): """ Ensure we can get an existing game. """ # Seed the database with a game event = Event() event.game_id = 1 event.organizer_id = 1 event.time = "11:45:00" event.date = "2021-05-19" event.description = "budding software developer" event.save() # Make sure request is authenticated self.client.credentials(HTTP_AUTHORIZATION='Token ' + self.token) # Initiate request and store response response = self.client.get(f"/events/{event.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["organizer"]["id"], "Monopoly") self.assertEqual(json_response["description"], "budding software developer") # self.assertEqual(json_response["game"]["id"], 5) self.assertEqual(json_response["time"], "11:45:00") self.assertEqual(json_response["date"], "2021-05-19")
def test_get_event(self): """ Ensure we can get an existing event. """ # Seed the database with an event event = Event() event.event_time = "2020-08-29T13:24:27.172Z" event.game_id = 1 event.location = "Nashville, TN" event.scheduler_id = 1 event.save() # Make sure request is authenticated self.client.credentials(HTTP_AUTHORIZATION='Token ' + self.token) # Initiate request and store response response = self.client.get(f"/events/{event.id}") # Parse the JSON in the response body json_response = json.loads(response.content) # Assert that the event was retrieved self.assertEqual(response.status_code, status.HTTP_200_OK) # Assert that the values are correct self.assertEqual(json_response["event_time"], "2020-08-29T13:24:27.172000Z") self.assertEqual(json_response["game"]["id"], 1) self.assertEqual(json_response["location"], "Nashville, TN") self.assertEqual(json_response["scheduler"]["user"]["id"], 1)
def test_change_event(self): """ Ensure we can change an existing event """ event = Event() event.event_time = "2020-08-29T13:24:27.172Z" event.game_id = 1 event.location = "Nashville, TN" event.scheduler_id = 1 event.save() # Define new properties for game data = { "time": "2020-08-29T13:24:27.172000Z", "gameId": 1, "location": "Columbus, GA", "scheduler": 1 } self.client.credentials(HTTP_AUTHORIZATION='Token ' + self.token) response = self.client.put(f"/events/{event.id}", data, format="json") self.assertEqual(response.status_code, status.HTTP_204_NO_CONTENT) # GET Event again to verify changes response = self.client.get(f"/events/{event.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["event_time"], "2020-08-29T13:24:27.172000Z") self.assertEqual(json_response["game"]["id"], 1) self.assertEqual(json_response["location"], "Columbus, GA") self.assertEqual(json_response["scheduler"]["user"]["id"], 1)
def test_change_event(self): """ Ensure we can change an existing game. """ event = Event() event.game_id = 1 event.organizer_id = 1 event.time = "12:25:00" event.date = "2000-03-29" event.description = "junior software developer" event.save() # DEFINE NEW PROPERTIES FOR GAME data = { "gameId": 1, "description": "Hasbro", "time": "12:25:00", "date": "2000-03-29" } self.client.credentials(HTTP_AUTHORIZATION='Token ' + self.token) response = self.client.put(f"/events/{event.id}", data, format="json") self.assertEqual(response.status_code, status.HTTP_204_NO_CONTENT) # GET EVENT AGAIN TO VERIFY CHANGES response = self.client.get(f"/events/{event.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["gameId"], 1) self.assertEqual(json_response["description"], "Hasbro") self.assertEqual(json_response["time"], "12:25:00") self.assertEqual(json_response["date"], "2000-03-29")
def test_change_event(self): """ Ensure we can get an existing game. """ # Seed the database with a game event = Event() event.event_time = "2020-08-28T14:51:39.989Z" event.location = "Shelbyville" event.game_id = 1 event.gamer_id = 1 event.save() data = { "event_time": "2020-08-28T14:51:39.989Z", "gameId": 1, "gamerId": 1, "location": "Shelbyville" } self.client.credentials(HTTP_AUTHORIZATION='Token ' + self.token) response = self.client.put(f"/events/{event.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"/events/{event.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["event_time"], "2020-08-28T14:51:39.989Z") self.assertEqual(json_response["game"]["id"], 1) self.assertEqual(json_response["gamer"]["id"], 1) self.assertEqual(json_response["location"], "Shelbyville")
def test_get_event(self): """ Ensure we can get an existing game. """ # Seed the database with a game event = Event() event.event_time = "2020-08-28T14:51:39.989Z" event.location = "Shelbyville" event.game_id = 1 event.gamer_id = 1 event.save() # Make sure request is authenticated self.client.credentials(HTTP_AUTHORIZATION='Token ' + self.token) # Initiate request and store response response = self.client.get(f"/events/{event.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["event_time"], "2020-08-28T14:51:39.989Z") self.assertEqual(json_response["game"]["id"], 1) self.assertEqual(json_response["gamer"]["id"], 1) self.assertEqual(json_response["location"], "Shelbyville")
def test_change_event(self): """ Ensure we can change an existing game. """ event = Event() event.event_time = "2021-02-12 12:47:00" event.location = "Sorry" event.scheduler_id = 1 event.game_id = 1 event.save() # DEFINE NEW PROPERTIES FOR GAME data = { "event_time": "2021-03-12 12:47:00", "location": "your moms house", "gameId": 1, "gamerId": 1 } self.client.credentials(HTTP_AUTHORIZATION='Token ' + self.token) response = self.client.put(f"/events/{event.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"/events/{event.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["location"], "your moms house") self.assertEqual(json_response["event_time"], "2021-03-12T12:47:00Z") self.assertEqual(json_response["game"]["id"], 1) self.assertEqual(json_response["scheduler"]["id"], 1)
def test_get_event(self): event = Event() event.game_id = 1 event.scheduler_id = 1 event.location = "The moon" event.event_time = "2021-02-05 17:00:00" event.save() self.client.credentials(HTTP_AUTHORIZATION='Token ' + self.token) response = self.client.get(f"/events/{event.id}") json_response = json.loads(response.content) self.assertEqual(json_response["location"], "The moon")
def test_delete_game(self): """ Ensure we can delete an existing game. """ event = Event() event.event_time = "2020-08-29T13:24:27.172Z" event.game_id = 1 event.location = "Nashville, TN" event.scheduler_id = 1 event.save() self.client.credentials(HTTP_AUTHORIZATION='Token ' + self.token) response = self.client.delete(f"/events/{event.id}") self.assertEqual(response.status_code, status.HTTP_204_NO_CONTENT) # GET again to verify 404 response = self.client.get(f"/events/{event.id}") self.assertEqual(response.status_code, status.HTTP_404_NOT_FOUND)
def test_delete_event(self): """ Ensure we can delete an existing game. """ event = Event() event.event_time = "2020-08-28T14:51:39.989Z" event.location = "Shelbyville" event.game_id = 1 event.gamer_id = 1 event.save() self.client.credentials(HTTP_AUTHORIZATION='Token ' + self.token) response = self.client.delete(f"/events/{event.id}") self.assertEqual(response.status_code, status.HTTP_204_NO_CONTENT) # GET event AGAIN TO VERIFY 404 response response = self.client.get(f"/events/{event.id}") self.assertEqual(response.status_code, status.HTTP_404_NOT_FOUND)
def test_delete_event(self): """ Ensure we can delete an existing event. """ event = Event() event.event_time = "2021-03-02 13:46:38.058841" event.location = "My house" event.game_id = 1 event.scheduler_id = 1 event.save() self.client.credentials(HTTP_AUTHORIZATION='Token ' + self.token) response = self.client.delete(f"/events/{event.id}") self.assertEqual(response.status_code, status.HTTP_204_NO_CONTENT) # GET event AGAIN TO VERIFY 404 response response = self.client.get(f"/events/{event.id}") self.assertEqual(response.status_code, status.HTTP_404_NOT_FOUND)
def test_delete_event(self): """ Ensure we can delete an existing game. """ event = Event() event.game_id = 1 event.organizer_id = 1 event.time = "11:25:00" event.date = "2000-03-17" event.description = "senior software developer" event.save() self.client.credentials(HTTP_AUTHORIZATION='Token ' + self.token) response = self.client.delete(f"/events/{event.id}") self.assertEqual(response.status_code, status.HTTP_204_NO_CONTENT) # GET event AGAIN TO VERIFY 404 response response = self.client.get(f"/events/{event.id}") self.assertEqual(response.status_code, status.HTTP_500_INTERNAL_SERVER_ERROR)
def userevent_list(request): """Function to build an HTML report events 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 e.id, e.description, e.organizer_id, e.game_id, e.date, e.time, u.id user_id, u.first_name || ' ' || u.last_name AS full_name FROM levelupapi_event e JOIN levelupapi_gamer gr ON e.organizer_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 # } # ] # } # } events_by_user = {} for row in dataset: # Crete a Game instance and set its properties event = Event() event.description = row["description"] event.organizer_id = row["organizer_id"] event.game_id = row["game_id"] event.date = row["date"] event.time = row["time"] # Store the user's id uid = row["user_id"] # If the user's id is already a key in the dictionary... if uid in events_by_user: # Add the current game to the `games` list for it events_by_user[uid]['events'].append(event) else: # Otherwise, create the key and dictionary value events_by_user[uid] = {} events_by_user[uid]["id"] = uid events_by_user[uid]["full_name"] = row["full_name"] events_by_user[uid]["events"] = [event] # Get only the values from the dictionary and create a list from them list_of_users_with_events = events_by_user.values() # Specify the Django template and provide data context template = 'users/list_with_events.html' context = {'userevent_list': list_of_users_with_events} return render(request, template, context)