Python execute_file Examples

Example #1

File: EP_Online_load.py Project: dutch-dwellings/dutch-dwelling-database

def add_functions():
    print('Adding functions for energy labels...')
    filename = 'EP_Online_add_functions.sql'
    current_dir = os.path.dirname(os.path.realpath(__file__))
    path = os.path.join(current_dir, filename)

    execute_file(path)

Example #2

File: EP_Online_load.py Project: dutch-dwellings/dutch-dwelling-database

def add_column_epi_imputed():
    print(
        'Adding column with imputed EPI values, this can take a minute or 2...'
    )
    filename = 'EP_Online_add_column_epi_imputed.sql'
    current_dir = os.path.dirname(os.path.realpath(__file__))
    path = os.path.join(current_dir, filename)

    execute_file(path)

Example #3

def main():
    folder = os.path.dirname(os.path.realpath(__file__))
    path = os.path.join(folder, CREATE_TABLE_SQL)
    execute_file(path)