output = []

for rule in app.url_map.iter_rules():

options = {}

for arg in rule.arguments:

options[arg] = "[{0}]".format(arg)

methods = ','.join(rule.methods)

url = url_for(rule.endpoint, **options)

line = urllib.parse.unquote("{:50s} {:20s} {}".format(rule.endpoint, methods, url))

output.append(line)

for line in sorted(output):

print("Starting DB refresh...")

sql_dir = get_full_path('data/sql_updates/')

files = glob.glob(sql_dir + '*.sql')

for sql_file in files:

print(("Running {}".format(sql_file)))

with open(sql_file, 'r') as sql_fh:

sql = '\n'.join(sql_fh.readlines())

db.engine.execute(sql)