python-p3-freebie-tracker/lib/debug.py at main · ussenuk/python-p3-freebie-tracker · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
#!/usr/bin/env python3

from sqlalchemy import create_engine
from sqlalchemy.orm import sessionmaker

from models import Company, Dev, Freebie

if __name__ == '__main__':
    engine = create_engine('sqlite:///freebies.db')
    Session = sessionmaker(bind=engine)
    session = Session()


    # # Query all companies
    # companies = session.query(Company).all()

    # # For each company, print its name and the names of its devs
    # for company in companies:
    #     print(f'Company: {company.name}')
    #     print('Devs:')
    #     for dev in company.devs:
    #         print(f'- {dev.name}')

    # # Query all devs
    # devs = session.query(Dev).all()

    # # For each dev, print its name and the names of its companies
    # for dev in devs:
    #     print(f'Dev: {dev.name}')
    #     print('Companies:')
    #     for company in dev.companies:
    #         print(f'- {company.name}')


    # # For a particular dev what the freebies collected from different companies
    # dev = session.query(Dev).filter_by(name='Matthew Grant').first()

    # if dev is not None:
    #     print(dev.freebies)
    # else:
    #     print("Developer didn't collect freebies.")


    # # Query all freebies
    # freebies = session.query(Freebie).all()

    # for freebie in freebies:
    #     try:
    #         print(freebie.print_details())
    #     except Exception as e:
    #         print(f"Error printing details for freebie with id {freebie.id}: {e}")

    # # Query all companies
    # companies = session.query(Company).all()

    # for company in companies:
    #     try:
    #         # Test oldest_company method
    #         oldest_company = Company.oldest_company(session)
    #         print(f"Oldest company: {oldest_company}")
    #     except Exception as e:
    #         print(f"Error finding oldest company for company with id {company.id}: {e}")

    # # Query all devs
    # devs = session.query(Dev).all()


   # Query all devs and freebies
    devs = session.query(Dev).all()
    freebies = session.query(Freebie).all()

    # Test give_away method for each dev and freebie
    for dev in devs:
        for freebie in freebies:
            try:
                # Use a known dev for testing
                new_dev = devs[0]  # replace with a valid Dev instance
                result = dev.give_away(new_dev, freebie)
                print(f"Dev {dev.name} gave away {freebie.item_name} to {new_dev.name}: {result}")
            except Exception as e:
                print(f"Error giving away freebie with id {freebie.id} from dev with id {dev.id} to dev with id {new_dev.id}: {e}")

    # print(dev.received_one('Freebie Name'))
    # other_dev = Dev(name='Other Dev')
    # session.add(other_dev)
    # session.commit()
    # print(dev.give_away(other_dev, freebie))

    # print(Company.oldest_company(session))


    import ipdb; ipdb.set_trace()