main.py

import pandas as pd
import os
from etl.extract import extract_data
from etl.transfer import transfer_data 
#from etl.load import load_data
from dotenv import load_dotenv
from pathlib import Path
#from config import Config
#import yaml

def main():
    # Load environment variables
    load_dotenv()

    # Load configuration settings
     
    # Define file paths and database URL
    #input_file_path = Path("data/academy.csv")
    #output_file_path = Path("data/output_data.csv")
    #db_url = os.getenv("DATABASE_URL")
    #table_name = "my_table"
    
    #Extract data from CSV file
    df = extract_data()
    
    # Transfer data to a new CSV file
    transferred_df = transfer_data(df)
    
    # Load data into the SQL database
    #load_data(transferred_df, db_url, table_name)

if __name__ == "__main__":
    main()
    print("ETL process completed successfully.")