コード例 #1
0
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)
コード例 #2
0
ファイル: manage.py プロジェクト: srinivasmalladi/openFEC
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)
コード例 #3
0
ファイル: manage.py プロジェクト: LindsayYoung/openFEC
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.")
コード例 #4
0
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."
コード例 #5
0
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)
コード例 #6
0
ファイル: manage.py プロジェクト: LetsUnlockiPhone/openFEC
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)