debug.py

import ipdb
from models import Base, Company, Dev, Freebie
from sqlalchemy import create_engine
from sqlalchemy.orm import sessionmaker

# Setup database connection
engine = create_engine('sqlite:///freebies.db') 
Session = sessionmaker(bind=engine)
session = Session()

#Some data for testing
ava = session.query(Dev).filter_by(name="Ava Sinclair").first()
quantum_soft = session.query(Company).filter_by(name="QuantumSoft").first()
nebula_tshirt = session.query(Freebie).filter_by(item_name="Nebula T-Shirt").first()

#Debugging breakpoint
ipdb.set_trace()

#session.close()

##Commands to run
#session.query(Company).all() #Gets all companies
#session.query(Dev).all() #Gets all the devs
#session.query(Freebie).all() #Gets all the Freebies

#p ava.received_one("Nebula T-shirt") #Checks if a dev recieved a freebie
#p ava.freebies #Checks all freebies a dev received
#for freebie in ava.freebies: print (freebie.print_details()) ##Checks the details of a freebie
#p session.query(Company).order_by(Company.name).all() #Checks all companies in alphabetical order
#p Company.oldest_company(session) #Checks the oldest company
#p len(ava.freebies) #checks how many freebies a dev has
#p session.query(Dev).join(Freebie).filter(Freebie.item_name == "Nebula T-Shirt").all() #checks which dev owns a specific freebie