Import into postgres -specific schema about dbfread HOT 1 OPEN

from sqlalchemy import create_engine
#  etc....

def get_engine(db_name):
    # Create the connection to the database
    engine = create_engine(f'postgresql://postgres:postgres@db:5432/{db_name}')
    return engine

def import_table(dbf_file, table_name, db_name):
    try:
        # Attempt to read the dbf file with utf-8 encoding
        table = DBF(dbf_file, load=True)

        df = pd.DataFrame(iter(table))
        # # Print a preview of the dataframe
        logging.info(f"Preview of '{table_name}':\n{df.head()}")
        # # Convert DataFrame to SQL
        engine = get_engine(db_name)
        df.to_sql(table_name, con=engine, schema='import', if_exists='replace', index=False)
# --------------------------------------^^^^^^^^^^^^^--------------
    except Exception as e:
        # Broad exception handling to catch any other unexpected errors
        logging.error(f"Unexpected error during import of file {dbf_file}: {e}. Investigation needed.")