def execute_sql_folder(path, processes): sql_dir = get_full_path(path) if not sql_dir.endswith('/'): sql_dir += '/' paths = sorted(glob.glob(sql_dir + '*.sql')) if processes > 1: pool = multiprocessing.Pool(processes=processes) pool.map(execute_sql_file, sorted(paths)) else: for path in paths: execute_sql_file(path)
def refresh_db(): 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) print("Finished DB refresh.")
def refresh_db(): 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) print "Finished DB refresh."
def execute_sql_folder(path, processes): sql_dir = get_full_path(path) paths = glob.glob(sql_dir + '*.sql') pool = multiprocessing.Pool(processes=processes) pool.map(execute_sql_file, paths)