def do_GET(self):
"""
handle GET requests
"""
crud = CRUD()
print(self.requestline)
#urls params
requestline = self.requestline
resp = ''
# handle update_terminal
if (requestline.find("update_terminal")>=0):
used = self.get(requestline, "used")
game = self.get(requestline, "game")
id = self.get(requestline, "id")
crud.updateTerminal(id,used, game)
# handle post_score
# new score to save in the db
if (requestline.find("post_score")>=0):
game = self.get(requestline, "game")
user = self.get(requestline, 'user')
score = self.get(requestline, 'score')
crud.insertScore(score, game, user)
# handle get_score
if (requestline.find("get_score")>=0):
game = self.get(requestline, "game")
resp = crud.getScore(game)
# handle get_terminal
# check the status of a terminal
if (requestline.find("get_terminal")>=0):
#check if a terminal is available
terminal_id = self.get(requestline,'id')
resp = crud.isTerminalAvailable(terminal_id)
# handle get_games
if(requestline.find("get_games")>=0):
resp = crud.getAllGames()
#handle get_users
if(requestline.find("get_users")>=0):
#get all users
resp = crud.getAllUsers()
#http response header
self.send_response(200)
self.send_header('Content-type','text/html')
self.end_headers()
#response data
#print(resp)
self.wfile.write(json.dumps(resp).encode("utf-8"))
def connect(userid,password):
global client#we need to define client to global
client=SpreadsheetsService()
client.email=userid
client.password=password
client.source = 'Spreadsheets GData Sample'
client.ProgrammaticLogin()
def clientConnect():
userCredentials()
if "@" not in _id:
print"----RUN AS: python spreadsheets_connect.py --user [username] and enter valid username"
sys.exit()
else:
promptForPassword()
connect(_id,_password)
print "----connection established------"
return client
if __name__=="__main__":
a=clientConnect()
mycrud=CRUD(a)
mycrud.run()
def test_crud_remove_user_5(self):
crud = CRUD(False)
crud.remove_user(1)
crud.update_users('1', 'Trust', 15)
crud.add_new_user('*****@*****.**', '2020-11-16')
crud.remove_user_group('1', 'default')
expected_user = self.user_2
expected_user['Groups'].remove('default')
self.assertEqual(crud.read_users_file(), {'1': expected_user})
def test_crud_remove_user_6(self):
crud = CRUD(False)
crud.remove_user(1)
crud.update_users('1', 'Trust', 30)
crud.remove_user_group('1', 'default')
crud.add_new_user('*****@*****.**', '2020-11-16')
self.assertEqual(crud.read_users_file(), {'1': self.user_2})
def test_crud_remove_user_1(self):
crud = CRUD(False)
crud.remove_user(1)
crud.add_new_user("*****@*****.**", "2020-11-16")
crud.update_users('1', 'SpamN', 25)
crud.remove_user_group('1', 'default')
expected_user = self.user_2
expected_user['SpamN'] = 25
expected_user['Groups'].remove('default')
self.assertEqual(crud.read_users_file(), {'1': expected_user})
def test_crud_remove_user_group_6(self):
crud = CRUD(False)
crud.remove_user_group('1', 'colleague')
crud.update_users('1', 'HamN', 5)
crud.remove_user(1)
crud.add_new_user('*****@*****.**', "2020-11-16")
self.assertEqual(crud.read_users_file(), {'1': self.user_2})
def test_crud_remove_user_group_4(self):
crud = CRUD(False)
crud.remove_user_group('1', 'colleagues')
crud.remove_user(1)
crud.update_users('1', 'Trust', 10)
crud.add_new_user("*****@*****.**", "2020-11-16")
expected_user = self.user_2
self.assertEqual(crud.read_users_file(), {'1': expected_user})
def test_crud_add_new_user_6(self):
crud = CRUD(False)
crud.add_new_user("*****@*****.**", "2020-11-16")
crud.remove_user_group('1', 'colleagues')
crud.remove_user(2)
crud.update_users('1', 'Trust', 40)
expected_user = self.user
expected_user["Trust"] = 40
expected_user["Groups"].remove('colleagues')
self.assertEqual(crud.read_users_file(), {'1': expected_user})
def test_crud_add_new_user_5(self):
crud = CRUD(False)
crud.add_new_user("*****@*****.**", "2020-11-16")
crud.remove_user_group('1', 'default')
crud.update_users('2', 'SpamN', 1)
crud.remove_user(1)
expected_user = self.user_2
expected_user["SpamN"] = 1
self.assertEqual(crud.read_users_file(), {'2': expected_user})
