Base = declarative_base()


class Lineup(Base):
    __tablename__ = "Lineup"
    id = Column(Integer, primary_key=True)
    name = Column(String)


class Address(Base):
    __tablename__ = "Address"
    id = Column(Integer, primary_key=True)
    email = Column(String)
    home_lineup_id = Column(Integer, ForeignKey("Lineup.id"))
    home_lineup = relationship(
        "Lineup",
        foreign_keys=[home_lineup_id],
        cascade="all, delete-orphan",
        single_parent=True,
    )
    guest_lineup_id = Column(Integer, ForeignKey("Lineup.id"))
    guest_lineup = relationship(
        "Lineup",
        foreign_keys=[guest_lineup_id],
        cascade="all, delete-orphan",
        single_parent=True,
    )


Base.metadata.drop_all(engine)
Base.metadata.create_all(engine)

with Session(engine) as session:
    addr_1 = Address(
        email="addr_1",
        home_lineup=Lineup(name="lu_1"),
        guest_lineup=Lineup(name="lu_2"),
    )
    session.add(addr_1)
    session.commit()

    session.delete(addr_1)
    session.commit()

"""SQL emitted:
DELETE FROM "Address" WHERE "Address".id = %(id)s
[generated in 0.00165s] {'id': 1}
DELETE FROM "Lineup" WHERE "Lineup".id = %(id)s
[generated in 0.00069s] ({'id': 1}, {'id': 2})
"""