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)