from pathlib import Path

import pandas as pd
from sqlalchemy import create_engine, text


database = Path("orders.db")
engine = create_engine(f"sqlite:///{database}")

source_orders = pd.DataFrame(
    {
        "order_id": ["A100", "A101", "A102"],
        "customer": ["Ada", "Lin", "Mira"],
        "status": ["open", "closed", "open"],
        "total_usd": [125.50, 88.00, 212.25],
    }
)
source_orders.to_sql("orders", engine, if_exists="replace", index=False)