debug.py

#!/usr/bin/env python3


# debug.py

from config import session, engine
from models import Dev, Company, Freebie
from sqlalchemy import create_engine, inspect
def show_tables():
    inspector = inspect(engine)
    tables = inspector.get_table_names()
    print("Tables in the database:", tables)

def add_sample_data():
    print("Adding sample data...")
    dev = Dev(name="Chance")
    company = Company(name="Chancy Founders", founding_year=2024)
    freebie = Freebie(item_name="Milk", value=25, dev=dev, company=company)

    session.add_all([dev, company, freebie])
    session.commit()
    print("Yay!Sample data added!")

def query_data():
    print("--------/n Querying data...--------------------/n")
    devs = session.query(Dev).all()
    companies = session.query(Company).all()
    freebies = session.query(Freebie).all()

    print(f"Devs: {[d.name for d in devs]}")
    print(f"Companies: {[c.name for c in companies]}")
    print(f"Freebies: [{', '.join(f'{f.item_name} (value: {f.value})' for f in freebies)}]")

def main():
    show_tables()
    add_sample_data()
    query_data()

if __name__ == "__main__":
    main()