def main(): ctrl = True # 标记是否退出系统 while (ctrl): menu.menu() option = input("请选择:") option_str = re.sub('\D', '', option) # 提取数字 if option_str in ['0', '1', '2', '3', '4', '5', '6', '7']: option_int = int(option_str) if option_int == 0: print("您已退出学生管理系统!") ctrl = False elif option_int == 1: insert.insert() elif option_int == 2: search.search() elif option_int == 3: delete.delete() elif option_int == 4: modify.modify() elif option_int == 5: sort.sort() elif option_int == 6: total.total() elif option_int == 7: show.show()
def fetch_and_update(matches, teams, comp, standings): cursor = db.cursor() # call function to fill in data for matches get_season_data(matches, standings) # set up data frame object df = pd.DataFrame(standings) df = df.transpose() df.sort_values(by=['pts', 'gd', 'gs', 'ga'], ascending=[0, 0, 0, 1], inplace=True) df = df[[ 'gp', 'pts', 'gs', 'ga', 'gd', 'lead_time', 'trail_time', 'competition' ]] df = df.reset_index() df['lead_time_p90'] = df['lead_time'] / df['gp'] df['trail_time_p90'] = df['trail_time'] / df['gp'] df.columns = [ 'team', 'gp', 'pts', 'gs', 'ga', 'gd', 'lead_time', 'trail_time', 'competition', 'lead_time_p90', 'trail_time_p90' ] df['pos'] = df.index + 1 # create numpy array of data for the model X = np.asarray(df[['lead_time_p90', 'trail_time_p90', 'gs', 'ga']]) df['top_four'] = model.top_four(comp, X) df['top_six'] = model.top_six(comp, X) df['relegation'] = model.relegation(comp, X) print(df) # convert df to dictionary and insert them into sql database data_dict = df.to_dict('records') for entry in data_dict: insert.insert(cursor, db, 'Competition_Summary', **entry)
def create_lead(cursor, db, match_id): cursor.execute("select minute, home_score, away_score \ from scores where match_id = %s \ order by minute;" % match_id) score_data = cursor.fetchall() insert_dict = {'match_id': match_id} for i in range(-1, len(score_data)): if i == -1: start = 0 end = score_data[i + 1][0] hg = 0 ag = 0 elif score_data[i] is score_data[-1]: start = score_data[i][0] end = 91 if score_data[i][0] < 90 else score_data[i][0] + 2 hg = score_data[i][1] ag = score_data[i][2] else: start = score_data[i][0] end = score_data[i + 1][0] hg = score_data[i][1] ag = score_data[i][2] for time in range(start, end): insert_dict['minute'] = time insert_dict['home_score'] = hg insert_dict['away_score'] = ag insert.insert(cursor, db, 'extended_scores', **insert_dict)
def update_metadata(match_id, cursor, db): """ update weird metadata """ session = HTMLSession() url = 'http://www.football-lineups.com/match/%s' % match_id r = session.get(url) r.html.encoding = 'ISO-8859-1' # HEIGHT # trs = r.html.find('tr') trs = [ tr for tr in trs if 'align' in tr.attrs.keys() and tr.attrs['align'] == 'center' ] for i, tr in enumerate(trs): if 'Height Avg' in tr.text: home_height = tr.find('td')[0].text[:4] away_height = tr.find('td')[2].text[:4] break print(match_id, home_height, away_height) # INSERT # data_dict = { 'match_id': match_id, 'home_height': home_height, 'away_height': away_height } insert.insert(cursor, db, 'match_metadata', **data_dict)
def insert_league_records(self): lodicts = [] data_dict = self.league_records for i, team in data_dict.items(): for md in team['history']: lodicts.append(md) insert.insert('league_records', lodicts)
def insert_player_data(self): lodicts = [] data_dict = self.players for player in data_dict: player['competition'] = self.competition player['season'] = self.year lodicts.append(player) insert.insert('player_data', lodicts)
def insert_rosters(self): lodicts = [] for k, team in self.rosters.items(): for j, player in team.items(): player['competition'] = self.match_info['league'] player['season'] = self.match_info['season'] player['position_order'] = player.pop('positionOrder') player['match_id'] = self.match_info['id'] lodicts.append(player) insert.insert('roster_data', lodicts)
def insert_shot_data(self): lodicts = [] for k, team in self.shot_data.items(): for shot in team: shot['last_action'] = shot.pop('lastAction') shot['shot_type'] = shot.pop('shotType') shot['team'] = shot['h_team'] if shot['h_a'] == 'h' else \ shot['a_team'] shot['competition'] = self.match_info['league'] lodicts.append(shot) insert.insert('shot_data', lodicts)
def insert_team_data(self): # changing so i can edit stuff data_dict = self.team_data for category, v in data_dict.items(): lodicts = [] for meta_category, vi in v.items(): vi['category'] = category vi['meta_category'] = meta_category vi['team'] = ' '.join(self.name.split('_')) vi['competition'] = self.competition vi['season'] = self.year lodicts.append(vi) insert.insert('team_data', lodicts)
def newUser(msg=[]): print(msg) db = pymysql.connect('localhost', 'server', '[removed for security]', 'thegrind') cursor = db.cursor() sql = "SELECT * FROM userinfo" try: cursor.execute(sql) results = cursor.fetchall() print(results) idnum = 0 uname = 1 email = 2 pw = 3 achiev = '00000000' users = [] emails = [] pws = [] for idx in results: print(idx[idnum]) for idx in results: users.append(idx[uname]) for idx in results: emails.append(idx[email]) for idx in results: pws.append(idx[pw]) print(users, '\n', emails, '\n', pws) if msg[0] != msg[1]: #if uname and confirmUname dont match print('Uname error') return 1 if msg[2] != msg[3]: #if emails dont match print('Email error') return 2 if msg[4] != msg[5]: #is passwords dont match print('Password error') return 3 if msg[0] in users: #if user in table print('Invalid Uname') return 4 if msg[2] in emails: #if email in table print('Invalid Email') return 5 if msg[4] in pws: #if password in table print('Invalid Pass') return 6 insert.insert(msg[0], msg[2], msg[4], achiev) except: pass db.close() return 0 #successful entry into table
def menu(self): while self.dato: selection = input( '\nSelect 1 to insert, 2 to update, 3 to read, 4 to delete \n') if selection == '1': insert.insert() elif selection == '2': update.update() elif selection == '3': read.read() elif selection == '4': delete.delete() else: print('\n Invalid selection \n')
def menu(self): while self.dato: selecction = input("\n Selecciona una de las opciones del menu \n 1.- Insertar \n 2.- Leer \n 3.-Actualizar \n 4.-Borrar \n\n") if selecction=='1': insert.insert() elif selecction=='2': read.read() elif selecction=='3': update.update() elif selecction=='4': delete.delete() else: print("Instruccion invalida")
def upload(data): counter = 0 while counter < 5: try: insert(data) counter += 6 except RuntimeError as error: print(error.args[0]) time.sleep(2.0) counter += 1
def upload(data): counter = 0 while counter < 5: try: insert(data) counter += 6 except RuntimeError as error: print(error.args[0]) logging.error('RuntimeError@upload:', exc_info=error) time.sleep(2.0) counter += 1
def menu(self): while self.dato: selection = input( '\nSelecciona 1 para insertar, 2 para actualizar, 3 para leer, 4 para borrar.\n' ) if selection == '1': insert.insert() elif selection == '2': update.update() elif selection == '3': read.read() elif selection == '4': delete.delete() else: print('\nSelección inválida.')
def store_metrics(request): if 'metric' in request.params and 'value' in request.params and 'ID' in request.params: print request.params['metric'] print request.params['value'] print request.params['ID'] metric = request.params['metric'] value = int(request.params['value']) ID = int(request.params['ID']) insert.insert(value, metric, ID) return Response(body="Stored to database", content_type=CONTENT_TYPE_LATEST) else: print "NO" return Response(body="Not stored to database") return Response(status="OK")
def saving(): jsonData = request.get_json(cache=False) user=jsonData["userName"] type = "Goal" if request.method =='GET': getData = access(graph, type, user, user) elif request.method=='POST': postData = [jsonData["userName"], jsonData["savingsName"], jsonData["amount"], jsonData["downpay"],jsonData["term"],jsonData["description"]] insert(graph,type,postData) elif request.method=='PUT': current=["currentItem"] mod = jsonData["modItem"] modify(graph,type,user,current,mod) elif request.method=='DELETE': delItem=jsonData["delItem"] delete(graph,type,user,delItem)
def transaction(): jsonData = request.get_json(cache=False) user=jsonData["userName"] type = "Transaction" if request.method =='GET': getData = access(graph, type, user, user) elif request.method=='POST': postData = [jsonData["userName"], jsonData["transName"], jsonData["transDate"], jsonData["transLocation"],jsonData["transAmount"]] insert(graph,type,postData) elif request.method=='PUT': current=["currentItem"] mod = jsonData["modItem"] modify(graph,type,user,current,mod) elif request.method=='DELETE': delItem=jsonData["delItem"] delete(graph,type,user,delItem)
def menuLista(): global listaPila while True: print("Seleccione una opción:\n") print("1)Insert") print("2)Delete") print("3)Salir") opc = int(input()) if opc == 3: break else: if opc == 1: insert.insert(lista) elif opc == 2: datoBorrado = (lista) mostrarLista.mostrarLista(lista)
def menu(self): while self.dato: # chossing option to do CRUD operations selection = input( '\nSelect 1 to insert, 2 to update, 3 to read, 4 to delete\n') if selection == '1': insert.insert() elif selection == '2': update.update() elif selection == '3': read.read() elif selection == '4': delete.delete() else: print('\n INVALID SELECTION \n')
def main(): parser = argparse.ArgumentParser() parser.add_argument("-e", "--env", help="get db.conf") args = parser.parse_args() if len(sys.argv) == 1: get.get_pdf() v1 = parse01.parse_pdf01("./pdf/") v2 = parse02.parse_pdf02("./pdf/") insert.insert(v1, v2, 'test') elif len(sys.argv) == 3: get.get_pdf() v1 = parse01.parse_pdf01("./pdf/") v2 = parse02.parse_pdf02("./pdf/") insert.insert(v1, v2, args.env) else: print("error param!") sys.exit(1)
def switch(cursor, mysqldb, option, table_name): switchDic = { "1": sel.mysqlsel(cursor, mysqldb, table_name), "2": ins.insert(cursor, mysqldb, table_name), "3": up.update(cursor, mysqldb, table_name), "4": de.delete(cursor, mysqldb, table_name) } return switchDic.get(option, switchDefault())
def menu(self): while self.dato: print('\nSelect: ') print('\n 1 to Insert ') print('\n 2 to Update ') print('\n 3 to Read ') print('\n 4 to Delete ') selection = input('\nChoose your option: ') if selection == '1': insert.insert() elif selection == '2': update.update() elif selection == '3': read.read() elif selection == '4': delete.delete() else: print('\n INVALID SELECTION \n')
def main(): quit = "y" while (quit == 'y' or quit == 'Y'): x = PrettyTable(["A R A B I D O P S I S T H A L I A N A D A T A B A S E"]) x.align["A R A B I D O P S I S T H A L I A N A D A T A B A S E"] = "l" x.padding_width = 1 x.add_row(["1. Create the Genes table"]) x.add_row(["2. Display the Genes"]) x.add_row(["3. Insert a new Gene"]) x.add_row(["4. Delete a Gene"]) x.add_row(["5. Blast a Gene"]) print x ## Get input ### choice = raw_input('Enter your choice [1-5] : ') ### Convert string to int type ## choice = int(choice) ### Take action as per selected menu-option ### if choice == 1: create.create() #this will create the tables and popululate the data elif choice == 2: display.display() # display both the tables from the database elif choice == 3: insert.insert() # insert a new gene record in the database elif choice == 4: delete.delete() # delete a gene record from the database elif choice == 5: name = raw_input("Please enter the name of the gene to perform blast: ") Blast.fn(name) # Calls the BLAST module Blast.show() # Calls the module that prints image downloaded from Google Search else: ## default ## print ("Invalid input. Please enter the correct input...") quit = raw_input('Do you wanna Continue : ')
def check_sort(): result = { 'insert': {}, 'select': {}, 'bubble': {}, } array_insert = get_array('up') array_select = array_insert.copy() array_bubble = array_insert.copy() result['insert']['up'] = insert(array_insert, len(array_insert)) result['select']['up'] = select(array_select) result['bubble']['up'] = bubble(array_bubble) array_insert = get_array('down') array_select = array_insert.copy() array_bubble = array_insert.copy() result['insert']['down'] = insert(array_insert, len(array_insert)) result['select']['down'] = select(array_select) result['bubble']['down'] = bubble(array_bubble) avg = {'insert': [0, 0], 'select': [0, 0], 'bubble': [0, 0]} for i in range(400): array_insert = get_array('rand') array_select = array_insert.copy() array_bubble = array_insert.copy() sort_result = insert(array_insert, len(array_insert)) avg['insert'][0] += sort_result[0] avg['insert'][1] += sort_result[1] sort_result = select(array_select) avg['select'][0] += sort_result[0] avg['select'][1] += sort_result[1] sort_result = bubble(array_bubble) avg['bubble'][0] += sort_result[0] avg['bubble'][1] += sort_result[1] result['insert']['rand'] = [avg['insert'][0] / 400, avg['insert'][1] / 400] result['select']['rand'] = [avg['select'][0] / 400, avg['select'][1] / 400] result['bubble']['rand'] = [avg['bubble'][0] / 400, avg['bubble'][1] / 400] return result
def parse_html(html): soup = bs4.BeautifulSoup(html, 'html.parser') trs = soup.select('tr') for tr in trs[3:]: a = tr.contents[3].contents[1].attrs['href'] id = a[23:47] href = a[50:-3] url1 = 'http://tzxm.hbzwfw.gov.cn/sbglweb/xminfo?xmdm='+id+'&sxid='+href+'&xzqh=130000' html1 = requests.get(url1, headers=headers1,proxies={"http": "http://{}".format(proxy)}, timeout=50) if html1.status_code == 200: # print('点击页面获取成功') html1 = html1.text soup1 = bs4.BeautifulSoup(html1, 'html.parser') tables = soup1.select('td') j = 3 k = 3 sql = '' sql1 = '' sql2 = '' for table in tables[3:]: if j%2 ==1 and j<10 : # print(table.text) sql = sql + "N'"+table.text.replace("\r\n",'').replace("\t",'').replace(u'\xa0','')+"'," if j > 16 and j <22: # print(table.text) sql1 = sql1 + "N'"+table.text.replace("\r\n",'').replace("\t",'').replace(u'\xa0','')+"'," if k == 21: fullsql = " insert into [dbo].[邯郸投资平台数据_Crawler] VALUES ("+sql+sql1[:-1]+');commit;' insert(fullsql) if j > 28: # print(table.text) sql2 = sql2 + "N'" + table.text.replace("\r\n",'').replace("\t",'').replace(u'\xa0','') + "'," if k==33 or k==38 or k==43 or k==48 or k==53 or k==58 or k==63 or k==68 or k==73 or k==78 or k==83 or k==88 or k==93: fullsql1 = " insert into [dbo].[邯郸投资平台数据_Crawler] VALUES (" + sql + sql2[:-1] + ');commit;' insert(fullsql1) sql2 = '' j+=1 k+=1 else: print('ERROR', html.status_code) html.close()
def menu(self): while self.dato: menu = ''' 1._Insertar 2._Actualizar 3._Eliminar 4._Consultar 5._ Salir''' print(menu) selection = input("Ingrese Opcion : ") if selection == '1': insert.insert() elif selection == '2': update.update() elif selection == '3': delete.delete() elif selection == '4': read.read() elif selection == '5': exit() else: print("Opcion Invalida")
def recon_f(sinogram, thetas): n0, n1 = sinogram.shape x, y = np.mgrid[0:n0, 0:n0] x -= n0 // 2 y -= n1 // 2 r = np.sqrt(x * x + y * y) fil = np.fft.ifftshift(np.where(r < n0 / 3, 1, 0)) # fil = 1 #np.abs(np.fft.fftfreq(n0)).reshape((-1, 1)) ft_sino = np.fft.fftshift(np.fft.fft(sinogram, axis=0), axes=0) slices_real = np.real(ft_sino).T slices_imag = np.imag(ft_sino).T model_real = insert(slices_real, thetas) model_imag = insert(slices_imag, thetas) model = model_real + 1j * model_imag # model *= fil recon = np.fft.ifft2(np.fft.ifftshift(model)).real return model, recon
def word_combi(word): split_set = [(word[:letter], word[letter:]) for letter in range(len(word) + 1)] subset_of_delete = [ leftside_set + rightside_set[1:] for leftside_set, rightside_set in split_set if rightside_set ] transposes = [ leftside_set + rightside_set[1] + rightside_set[0] + rightside_set[2:] for leftside_set, rightside_set in split_set if len(rightside_set) > 1 ] replaces = replace.replace(word) inserts = insert.insert(word) return list(set(subset_of_delete + transposes + replaces + inserts))
def traverse_tree(node, point, max_nodes_per_quad): if node.TopLeftChild is None and node.TopRightChild is None and node.BottomLeftChild is None and node.BottomRightChild is None: # Is leaf node node.points.append(point) if len( node.points ) > max_nodes_per_quad: # Spilt child if points are hight that max point per quad print(node.points) return insert.insert(node, max_nodes_per_quad) cross_x = node.x cross_y = node.y # Check for the suitable child if point[0] <= cross_x and point[1] >= cross_y: traverse_tree(node.TopLeftChild, point, max_nodes_per_quad) else: if cross_x <= point[0] and point[1] <= cross_y: traverse_tree(node.BottomRightChild, point, max_nodes_per_quad) if cross_x < point[0] and point[1] > cross_y: traverse_tree(node.TopRightChild, point, max_nodes_per_quad) if point[0] < cross_x and point[1] < cross_y: traverse_tree(node.BottomLeftChild, point, max_nodes_per_quad)
def run(): # Login and save the html file to gen logging.info('Login and saving notice board html to gen') tpo = TpoSession() tpo.login() # From the html file, extract and save the notices logging.info('Extracting notice from notice board html.') num = insert.insert() if num is None: logging.error("Error encountered during extraction. Exiting.") exit() logging.info("Inserted %d notices.", num) # Update the json files to include the notice details and attachments logging.info('Updating json files') update.update() # Send the unsent notices logging.info('Sending unsent notices.') send.send_unsent() logging.info("Finished running script.")
root = os.path.abspath(os.path.dirname(__file__)) path = root + "/gen" if os.path.isdir(path): logging.info("Found gen folder. Cleaning it up.") shutil.rmtree(path) # Login and save the html file to gen logging.info('Login and save html file to gen') tpo = TpoSession() tpo.login() # From the html file, extract and save the notices logging.info('From the html file, extract and save the notices') num = insert.insert() if num is None: logging.error("Error encountered during extraction. Exiting.") exit() logging.info("Inserted %d notices.", num) # Update the json files to include the notice details and attachments logging.info('Updating the json files.') update.update() # Do not send redundant pushes on first run logging.info('Setting the sent property to false.') sent_false() # Finally, insert the cron jobs to enable automatic updates #logging.info('Inserting cron jobs.')
cns.constants("quests_merge", "tables/quests_constants.j", "quest_struct", ["header", "insert", "msg"]) #creates library for reward constants--integer to integer cns.constants("reward_merge", "tables/reward_constants.j", "reward_struct", ["header", "insert"], "", "_REWARD") #creates library for story constants--integer to integer cns.constants("story_merge", "tables/story_constants.j", "jass", ["header", "insert", "msg"], "", "") #creates library for story constants--integer to integer cns.constants("events_merge", "tables/events_constants.j", "event_struct", ["header", "insert", "msg"], "", "") #insert scripts #creates lua/jass files that allow "global" values #creates lua file for villagers ins.insert("villagers_header.j", "villagers", "villagers_insert.j", "lua", "//insert", ["decrep", "header", "insert"]) #creates lua file for npcs #ins.insert("npcs_header.j", "npcs", "npcs_insert.j", "lua", "//insert", ["decrep", "header", "insert"]) #replacement for npc calls ins.insert("npc_units_header.j", "npc_units", "npc_units_insert.j", "npc_units", "//insert", ["decrep", "header", "insert"], True) ins.insert("npc_heroes_header.j", "npc_heroes", "npc_heroes_insert.j", "npc_heroes", "//insert", ["decrep", "header", "insert"], True) #creates lua file for monsters ins.insert("monsters_header.j", "monsters", "monsters_insert.j", "lua", "//insert", ["decrep", "header", "insert"]) #creates lua file for warps #ins.insert("warps_header.j", "warps", "warps_insert.j", "lua", "//insert", ["decrep", "header", "insert"]) ins.insert("warps_header.j", "warps_merge", "warps_insert.j", "warps", "//insert", ["decrep", "header", "insert"], True)
# file_path = "chain" block_head_format = struct.Struct('20s d 16s I 11s I') block_head = namedtuple('Block_Head', 'hash timestamp case_id item_id state length') block_data = namedtuple('Block_Data', 'data') prev_hash = b'' # Initialise necessary arguements if action not in ["init", "verify"]: if action == "add": arguements["case_id"] = args.c arguements["item_id"] = args.i if arguements["case_id"] and arguements["item_id"]: insert(arguements["case_id"], arguements["item_id"], file_path) else: Arguement_Error() elif action == "checkout" or action == "checkin": arguements["item_id"] = args.i if action == "checkout": checkout(arguements["item_id"], file_path) else: checkin(arguements["item_id"], file_path) elif action == "log": arguements["reverse"] = args.reverse arguements["number"] = args.n arguements["case_id"] = args.c arguements["item_id"] = args.i log(arguements["reverse"], arguements["number"], arguements["case_id"], arguements["item_id"], file_path)