def load_tables_from_files(db_connection):
    """ Looks in the current working directory for all required tables. """

    _log.info('Loading tables from disk to DB.')

    sde_dir_path = os.path.join(os.path.dirname(os.path.realpath(__file__)), 'sde')

    for sde_file_name in os.listdir(sde_dir_path):
        _log.info('Loading the following table: {}'.format(sde_file_name))

        sde_file_path = os.path.join(sde_dir_path, sde_file_name)

        with open(sde_file_path, 'r') as sde_file:
            sql = sde_file.read()
            execute_sql(sql, db_connection)

    _log.info('Finished loading all requested tables.')
Looks in the current working directory for all required tables.