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})