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