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)
