Would you like to read an account of ZX Spectrum indie game development in late 1980s Czechoslovakia? Colleagues at @hernihistorie.cz conducted this interview with Petr Tuček while I did the web conversion!
Read the questionnaire and download the games: herniarchiv.cz/en/interview...
![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)
