class ParticipantSignupOption(Base): __tablename__ = 'participant_signup_option' id = Column(Integer, primary_key=True) name = Column(String(255)) #metadata_fields metadata_created = Column(DateTime(), nullable=False, default=datetime.now) metadata_creator = Column(Integer(), default=getCurrentUserId) metadata_modified = Column(DateTime(), default=datetime.now, onupdate=datetime.now) metadata_modifier = Column(Integer(), onupdate=getCurrentUserId) metadata_revision = Column(Integer(), default=1, onupdate=expression_column('metadata_revision')+1) assoc_participantwishes_participantsignupoption = Table("assoc_participantwishes_participantsignupoption", Base.metadata, foreign_key_column("participantwishes_id", Integer, "participant_wishes.id"), foreign_key_column("participantsignupoption_id", Integer, "participant_signup_option.id")) class ParticipantMedical(Base): __tablename__ = 'participant_medicals' id = Column(Integer, primary_key=True) participant_id = Column(Integer, ForeignKey('participants.id'), nullable=False, index=True) #diet = Column(Text) # Erityisruokavaliot diets = relationship("ParticipantMedicalDiet", secondary="assoc_participantmedical_medicaldiets") #food_allergy = Column(Text) # Ruoka-aineallergiat food_allergies = relationship("ParticipantMedicalFoodAllergy", secondary="assoc_participantmedical_medicalfoodallergies") additional_food = Column(Text) # Lisatiedot, ruoka drugs_help = Column(Integer, nullable=False, default=0) # Apua laakityksen ottamiseen illnesses = Column(Text) # Sairaudet #allergies = Column(Text) # Allergiat allergies = relationship("ParticipantMedicalAllergy", secondary="assoc_participantmedical_medicalallergies") additional_health = Column(Text) # Terveydentilan lisatiedot
__tablename__ = 'village_kitchens' id = Column(Integer, primary_key=True, index=True) name = Column(String(255), unique=True, index=True) short_name = Column(String(255), index=True) subcamp_id = Column(String(255), index=True) villages = relationship("Village", secondary="assoc_villagekitchens_villages") leader_id = Column(Integer, index=True) #metadata_fields metadata_created = Column(DateTime(), nullable=False, default=datetime.now) metadata_creator = Column(Integer(), default=getCurrentUserId) metadata_modified = Column(DateTime(), default=datetime.now, onupdate=datetime.now) metadata_modifier = Column(Integer(), onupdate=getCurrentUserId) metadata_revision = Column(Integer(), default=1, onupdate=expression_column('metadata_revision')+1) assoc_villagekitchens_villages = Table("assoc_villagekitchens_villages", Base.metadata, foreign_key_column("village_kitchens_id", Integer, "village_kitchens.id"), foreign_key_column("villages_id", Integer, "villages.id")) class Subcamp(Base): __tablename__ = 'subcamps' id = Column(Integer, primary_key=True, index=True) name = Column(String(255), unique=True, index=True) short_name = Column(String(255), index=True) leader_id = Column(Integer, index=True) #metadata_fields metadata_created = Column(DateTime(), nullable=False, default=datetime.now) metadata_creator = Column(Integer(), default=getCurrentUserId) metadata_modified = Column(DateTime(), default=datetime.now, onupdate=datetime.now) metadata_modifier = Column(Integer(), onupdate=getCurrentUserId) metadata_revision = Column(Integer(), default=1, onupdate=expression_column('metadata_revision')+1)
self.name = name def set_leader_id(self, leader_id): self.leader_id = leader_id class Privilege(Base): __tablename__ = "privileges" id = Column(Integer, primary_key=True) name = Column(String(255), unique=True, nullable=False) def __init__(self, name): self.name = name # metadata_fields metadata_created = Column(DateTime(), nullable=False, default=datetime.now) metadata_creator = Column(Integer(), default=getCurrentUserId) metadata_modified = Column(DateTime(), default=datetime.now, onupdate=datetime.now) metadata_modifier = Column(Integer(), onupdate=getCurrentUserId) metadata_revision = Column(Integer(), default=1, onupdate=expression_column("metadata_revision") + 1) assoc_users_groups = Table( "assoc_users_groups", Base.metadata, foreign_key_column("user_id", Integer, "users.id"), foreign_key_column("group_id", Integer, "groups.id"), ) # assoc_users_privileges = Table("assoc_users_privileges", Base.metadata, foreign_key_column("user_id", Integer, "users.id"), foreign_key_column("privilege_id", Integer, "privileges.id")) # assoc_groups_privileges = Table("assoc_groups_privileges", Base.metadata, foreign_key_column("group_id", Integer, "groups.id"), foreign_key_column("privilege_id", Integer, "privileges.id"))