models.py

# lib/models.py
from sqlalchemy import Column, Integer, String, ForeignKey
from sqlalchemy.orm import relationship, declarative_base

Base = declarative_base()

class Dev(Base):
    __tablename__ = 'devs'
    id = Column(Integer, primary_key=True)
    name = Column(String)

    freebies = relationship("Freebie", back_populates="dev", overlaps="companies,freebies")
    companies = relationship("Company", secondary="freebies", back_populates="devs", overlaps="freebies,devs")

class Company(Base):
    __tablename__ = 'companies'
    id = Column(Integer, primary_key=True)
    name = Column(String)
    founding_year = Column(Integer)

    freebies = relationship("Freebie", back_populates="company", overlaps="companies,devs")
    devs = relationship("Dev", secondary="freebies", back_populates="companies", overlaps="freebies,companies")

class Freebie(Base):
    __tablename__ = 'freebies'
    id = Column(Integer, primary_key=True)
    item_name = Column(String)
    value = Column(Integer)
    dev_id = Column(Integer, ForeignKey('devs.id'))
    company_id = Column(Integer, ForeignKey('companies.id'))

    dev = relationship("Dev", back_populates="freebies", overlaps="companies,devs")
    company = relationship("Company", back_populates="freebies", overlaps="companies,devs")



# from sqlalchemy import Column, Integer, String, ForeignKey
# from sqlalchemy.orm import relationship
# from database import Base, session  # Adjust import as per your setup

# # class Dev(Base):
# #     __tablename__ = 'devs'
# #     id = Column(Integer, primary_key=True)
# #     name = Column(String)
# #     freebies = relationship("Freebie", back_populates="dev")
# #     companies = relationship("Company", secondary="freebies", back_populates="devs")

# class Company(Base):
#     __tablename__ = 'companies'

#     id = Column(Integer, primary_key=True)
#     name = Column(String)
#     founding_year = Column(Integer)

#     freebies = relationship('Freebie', back_populates='company', cascade='all, delete-orphan')
#     devs = relationship('Dev', secondary='freebies', back_populates='companies')

#     def give_freebie(self, dev, item_name, value):
#         freebie = Freebie(item_name=item_name, value=value, dev=dev, company=self)
#         session.add(freebie)
#         session.commit()
#         return freebie

#     @classmethod
#     def oldest_company(cls, session):
#         return session.query(cls).order_by(cls.founding_year).first()

# class Dev(Base):
#     __tablename__ = 'devs'

#     id = Column(Integer, primary_key=True)
#     name = Column(String)

#     freebies = relationship('Freebie', back_populates='dev', cascade='all, delete-orphan')
#     companies = relationship('Company', secondary='freebies', back_populates='devs')

#     def received_one(self, item_name):
#         return any(freebie.item_name == item_name for freebie in self.freebies)

#     def give_away(self, new_dev, freebie):
#         if freebie in self.freebies:
#             freebie.dev = new_dev
#             session.commit()
#             return True
#         return False

# class Freebie(Base):
#     __tablename__ = 'freebies'

#     id = Column(Integer, primary_key=True)
#     item_name = Column(String)
#     value = Column(Integer)
#     dev_id = Column(Integer, ForeignKey('devs.id'))
#     company_id = Column(Integer, ForeignKey('companies.id'))

#     dev = relationship('Dev', back_populates='freebies')
#     company = relationship('Company', back_populates='freebies')

#     def print_details(self):
#         return f"{self.dev.name} owns a {self.item_name} from {self.company.name}."


# from sqlalchemy import Column, Integer, String, ForeignKey, MetaData
# from sqlalchemy.orm import relationship, backref
# from sqlalchemy.ext.declarative import declarative_base
# from sqlalchemy.ext.associationproxy import association_proxy

# # Custom metadata naming convention
# metadata = MetaData(naming_convention={
#     "fk": "fk_%(table_name)s_%(column_0_name)s_%(referred_table_name)s"
# })

# Base = declarative_base(metadata=metadata)

# class Company(Base):
#     __tablename__ = 'companies'

#     id = Column(Integer, primary_key=True)
#     name = Column(String)
#     founding_year = Column(Integer)

#     # Each company can hand out many freebies
#     freebies = relationship('Freebie', backref='company', cascade="all, delete-orphan")
#     devs = association_proxy('freebies', 'dev')  # Developers who got freebies from this company

#     def __repr__(self):
#         return f"<Company name='{self.name}'>"

#     def give_freebie(self, dev, item_name, value):
#         """Hand a freebie to a developer."""
#         return Freebie(item_name=item_name, value=value, dev=dev, company=self)

#     @classmethod
#     def oldest_company(cls, session):
#         """Return the company founded first."""
#         return session.query(cls).order_by(cls.founding_year).first()


# class Dev(Base):
#     __tablename__ = 'devs'

#     id = Column(Integer, primary_key=True)
#     name = Column(String)

#     # One dev can receive multiple freebies
#     freebies = relationship('Freebie', backref='dev', cascade="all, delete-orphan")
#     companies = association_proxy('freebies', 'company')

#     def __repr__(self):
#         return f"<Dev name='{self.name}'>"

#     def received_one(self, item_name):
#         """Check if the dev has received a specific item."""
#         return any(f.item_name == item_name for f in self.freebies)

#     def give_away(self, other_dev, freebie):
#         """Give a freebie to another dev if this dev owns it."""
#         if freebie in self.freebies:
#             freebie.dev = other_dev


# class Freebie(Base):
#     __tablename__ = 'freebies'

#     id = Column(Integer, primary_key=True)
#     item_name = Column(String)
#     value = Column(Integer)

#     dev_id = Column(Integer, ForeignKey('devs.id'))
#     company_id = Column(Integer, ForeignKey('companies.id'))

#     def __repr__(self):
#         return f"<Freebie '{self.item_name}' (worth ${self.value})>"

#     def print_details(self):
#         """Nicely formatted description of who owns what."""
#         dev_name = self.dev.name if self.dev else "Unknown Dev"
#         company_name = self.company.name if self.company else "Unknown Company"
#         return f"{dev_name} owns a {self.item_name} from {company_name}"

# Base = Base