owl 🟨⬜️🟪⬛️ devops • birds • full stack • nature • video game history • pixel art • digital archival • chiptune • historical linguistics • ROM hacking • internet and furry culture 🌐 https://sanqui.net 🟢 SFW account 🟢
![Screenshot of Python source code:
```
from datetime import datetime
from sqlalchemy import ForeignKey
from sqlalchemy.orm import Mapped, mapped_column, relationship
from database import Model
from reg.models import Event, Registration, db
from reg.villa_raffle.query import is_registration_entered_for_villa_raffle
from reg.villa_raffle.end import VillaRaffleEnded
from reg.villa_raffle.start import VillaRaffleStarted
from user.models import User
from furryest.utils import Failure
class VillaRaffleEntered(Model):
event_id: Mapped[int] = mapped_column(ForeignKey(Event.id), nullable=False)
registration_id: Mapped[int] = mapped_column(ForeignKey(Registration.id), nullable=False)
entered_at: Mapped[datetime] = mapped_column(nullable=False, defalt=datetime.now)
event: Mapped[Event] = relationship()
registration: Mapped[Registration] = relationship()
def enter_villa_raffle(user: User, registration: Registration, event: Event) -> VillaRaffleEntered | Failure:
if not db.session.query(VillaRaffleStarted).filter_by(event_id=event.id).first():
return Failure("Villa raffle has not been started for this event.")
elif db.session.query(VillaRaffleEnded).filter_by(event_id=event.id).first():
return Failure("Villa raffle has already ended for this event.")
elif registration.event_id != event.id:
return Failure("Registration does not belong to the given event.")
elif registration.user_id != user.id:
return Failure("Registration does not belong to the given user.")
elif is_registration_entered_for_villa_raffle(registration=registration, event=event):
return Failure("This registration has already entered the villa raffle.")
villa_raffle_entered = VillaRaffleEntered(
event_id=event.id,
registration_id=registration.id
)
villa_raffle_entered.save()
return villa_raffle_entered
```](https://cdn.bsky.app/img/feed_thumbnail/plain/did:plc:l62vabhiophfeg3xbwm5jeku/bafkreibegqxosceazkyd2eequgasnfd65nvem3tp2crvel3zla77agqrmy)
owl 🟨⬜️🟪⬛️ devops • birds • full stack • nature • video game history • pixel art • digital archival • chiptune • historical linguistics • ROM hacking • internet and furry culture 🌐 https://sanqui.net 🟢 SFW account 🟢