def main(args): # Read source if args.source_type == "excel": df = pd.read_excel(open(args.source, 'rb'), sheet_name=args.sheet_name, encoding='utf-8') else: df = pd.read_csv(args.source) UserDB.connect(args.db_path) UserDB.initSchema() # Iterate data users = [] for row in df.values: bibNumber = row[0] firstName = row[3] lastName = row[4] bibName = row[6] telNumber = row[7] raceCategory = row[9] challenge = row[10] try: UserDB.insertUser(firstName, lastName, bibName, challenge, raceCategory, telNumber, bibNumber) except Exception as e: print("Error %s: %s" % (str(e), bibNumber)) UserDB.close()
def main(args): # Read source if args.source_type == "excel": df = pd.read_excel(open(args.source,'rb'), sheet_name=args.sheet_name, encoding='utf-8') else: df = pd.read_csv(args.source) UserDB.connect(args.db_path) UserDB.initSchema() # Iterate data users = [] for row in df.values: firstname = row[3] lastname = row[4] teamName = None distance = row[8] if "10 KM" not in distance: # Skip 5K runner continue first10k_word = row[10] if first10k_word == "เคย": first10k = 0 elif first10k_word == "ไม่เคย": first10k = 1 else: assert(0) user = (firstname, lastname, teamName, first10k) users.append(user) print("Inserting %d users" % (len(users))) UserDB.insertUsers(users) UserDB.close()
def main(): debug_flag = ENV_MODE != 'production' try: app.run(host=BIND_ADDRESS, port=PORT, debug=debug_flag) finally: # Caught an interrupt or some error. UserDB.close()
def main(): global config config = load_json_config(DEFAULT_CONFIG_PATH) server_conf = config["server"] debug_flag = False if "debug" in config["server"]: debug_flag = config["server"]["debug"] try: app.run(host=server_conf["bindAddress"], port=server_conf["port"], debug=debug_flag) finally: # Caught an interrupt or some error. UserDB.close()
def close_connection(exception): UserDB.close()
def testDB_teardown(): # Teardown is called when a method using testDB ends. UserDB.close()