import pandas as pd
from sqlalchemy import create_engine

df = pd.read_csv("data/new/transformed.csv")

engine = create_engine(
    "postgresql+psycopg2://postgres:Krasava10&@localhost:5432/cars_data"
)

df.to_sql(
    "cars_data",
    engine,
    if_exists="replace",
    index=False
)

print("✔ DataFrame успешно загружен в PostgreSQL!")
