def upgrade(): op.create_table( 'decks', sa.Column('id', sa.Integer, primary_key=True, autoincrement=True), sa.Column('face_down_cards', sau.ScalarListType(), default=[]), sa.Column('dealt_cards', sau.ScalarListType(), default=[]), )
def upgrade(): op.create_table( 'games', sa.Column('id', sa.Integer, primary_key=True, autoincrement=True), sa.Column('deck_id', sa.Integer), sa.Column('player_id', sa.Integer), sa.Column('player_hand', sau.ScalarListType(), default=[]), sa.Column('player_score', sa.Integer, default=0), sa.Column('player_ace_high', sa.Boolean, default=False), sa.Column('dealer_hand', sau.ScalarListType(), default=[]), sa.Column('dealer_hand_hidden', sau.ScalarListType(), default=[]), sa.Column('dealer_score', sa.Integer, default=0), sa.Column('dealer_ace_high', sa.Boolean, default=False), sa.Column('dealer_ace_high_hidden', sa.Boolean, default=False), sa.Column('status', sa.Integer, default=0), )
class AgentSkill(db.Model): __tablename__ = 'agent_skills' domain_name = db.Column(db.String, primary_key=True) agent_name = db.Column(db.String, primary_key=True) skill_name = db.Column(db.String, primary_key=True) elementary = db.Column(db.Boolean, nullable=False) sub_skills = db.relationship( 'AgentSkill', secondary=SubSkill.__table__, primaryjoin=db.and_(domain_name == SubSkill.domain_name, agent_name == SubSkill.agent_name, skill_name == SubSkill.skill_name), secondaryjoin=db.and_(domain_name == SubSkill.domain_name, agent_name == SubSkill.agent_name, skill_name == SubSkill.sub_skill_name), order_by=SubSkill.sub_skill_index) min_valid_data = db.Column(db.Integer, nullable=False) sub_arg_accuracy = db.Column(sau.ScalarListType(float), nullable=False) validated = db.Column(db.Boolean) data = db.Column(db.PickleType) skill_model_id = db.Column(db.Integer, db.ForeignKey('skill_models.id')) skill_model = db.relationship( 'SkillModel', primaryjoin='AgentSkill.skill_model_id == SkillModel.id', backref='agent_skills') def as_dict(self): return {c.name: getattr(self, c.name) for c in self.__table__.columns}
class KarmaChange(Base): __tablename__ = "karma_changes" karma_id = sa.Column(sa.Integer, sa.ForeignKey("karma.id"), primary_key=True, nullable=False) user_id = sa.Column(sa.Integer, sa.ForeignKey("users.id"), primary_key=True, nullable=False) message_id = sa.Column(sa.Integer, sa.ForeignKey("messages.id"), primary_key=True, nullable=False) created_at = sa.Column(sa.DateTime, nullable=False) reasons = sa.Column( sau.EncryptedType(type_in=sau.ScalarListType(str), key=secret_key), nullable=True, ) reasons_new = sa.Column(sau.ScalarListType(str, separator=";"), nullable=True)
def upgrade(): op.create_table( 'tbl_clinics', sa.Column('id', sa.Integer(), nullable=False), sa.Column('name', sa.Unicode(128), nullable=False), sa.Column('canonical_id', sa.Integer(), nullable=True), sa.Column('is_active', sa.Boolean(), nullable=False), sa.ForeignKeyConstraint( ['canonical_id'], ['tbl_clinics.id'], ), sa.PrimaryKeyConstraint('id'), sa.UniqueConstraint('name')) op.create_index(op.f('ix_tbl_clinics_canonical_id'), 'tbl_clinics', ['canonical_id'], unique=False) op.create_table( 'tbl_patients', sa.Column('ptnum', sa.Integer(), nullable=False), sa.Column('lastname', sa.Unicode(128), nullable=False), sa.Column('firstname', sa.Unicode(128), nullable=False), sa.Column('birthday', sa.Date(), nullable=True), sa.Column('hivdb_ptid', sa.Integer(), nullable=True), sa.Column('created_at', sa.DateTime(timezone=True), nullable=False), sa.PrimaryKeyConstraint('ptnum')) op.create_index(op.f('ix_tbl_patients_created_at'), 'tbl_patients', ['created_at'], unique=False) op.create_index(op.f('ix_tbl_patients_firstname'), 'tbl_patients', ['firstname'], unique=False) op.create_index(op.f('ix_tbl_patients_hivdb_ptid'), 'tbl_patients', ['hivdb_ptid'], unique=False) op.create_index('patient_name_index', 'tbl_patients', ['lastname', 'firstname'], unique=False) op.create_table('tbl_physicians', sa.Column('id', sa.Integer(), nullable=False), sa.Column('lastname', sa.Unicode(128), nullable=False), sa.Column('firstname', sa.Unicode(128), nullable=False), sa.PrimaryKeyConstraint('id'), sa.UniqueConstraint('lastname', 'firstname')) op.create_index(op.f('ix_tbl_physicians_firstname'), 'tbl_physicians', ['firstname'], unique=False) op.create_index(op.f('ix_tbl_physicians_lastname'), 'tbl_physicians', ['lastname'], unique=False) op.create_table( 'tbl_reports', sa.Column('id', sa.Integer(), nullable=False), sa.Column('content', UploadedFileField(), nullable=True), sa.Column('content_type', sa.Unicode(16), nullable=True), sa.Column('status', sa.Unicode(32), nullable=True), sa.Column('created_at', sa.DateTime(timezone=True), nullable=True), sa.PrimaryKeyConstraint('id')) op.create_table('tbl_sequences', sa.Column('id', sa.Integer(), nullable=False), sa.Column('naseq', sa.Text(), nullable=False), sa.Column('subtype', sa.Unicode(64), nullable=False), sa.Column('genes', sau.ScalarListType(), nullable=False), sa.Column('filename', sa.Unicode(256), nullable=True), sa.PrimaryKeyConstraint('id')) op.create_table( 'tbl_users', sa.Column('id', sa.Integer(), nullable=False), sa.Column('email', sau.EmailType(), nullable=False), sa.Column('password', sau.PasswordType(), nullable=False), sa.Column('created_at', sa.DateTime(timezone=True), nullable=False), sa.PrimaryKeyConstraint('id'), sa.UniqueConstraint('email')) op.create_index(op.f('ix_tbl_users_created_at'), 'tbl_users', ['created_at'], unique=False) op.create_table( 'tbl_medical_records', sa.Column('mrid', sa.Unicode(128), nullable=False), sa.Column('ptnum', sa.Integer(), nullable=False), sa.ForeignKeyConstraint( ['ptnum'], ['tbl_patients.ptnum'], ), sa.PrimaryKeyConstraint('mrid', 'ptnum')) op.create_index(op.f('ix_tbl_medical_records_ptnum'), 'tbl_medical_records', ['ptnum'], unique=False) op.create_table( 'tbl_positive_controls', sa.Column('id', sa.Integer(), nullable=False), sa.Column('note', sa.Unicode(128), nullable=False), sa.Column('lot_number', sa.Unicode(64), nullable=True), sa.Column('test_code', sa.Unicode(64), nullable=False), sa.Column('specimen_type', sa.Unicode(32), nullable=False), sa.Column('sequence_id', sa.Integer(), nullable=True), sa.Column('labnotes', sa.UnicodeText(), nullable=True), sa.Column('entered_at', sa.DateTime(timezone=True), nullable=False), sa.ForeignKeyConstraint( ['sequence_id'], ['tbl_sequences.id'], ), sa.PrimaryKeyConstraint('id'), sa.UniqueConstraint('sequence_id')) op.create_index(op.f('ix_tbl_positive_controls_entered_at'), 'tbl_positive_controls', ['entered_at'], unique=False) op.create_table( 'tbl_proficiency_samples', sa.Column('id', sa.Integer(), nullable=False), sa.Column('name', sa.Unicode(128), nullable=False), sa.Column('source', sa.Unicode(64), nullable=False), sa.Column('vnum', sa.Unicode(64), nullable=False), sa.Column('test_code', sa.Unicode(64), nullable=False), sa.Column('sequence_id', sa.Integer(), nullable=True), sa.Column('notes', sa.UnicodeText(), nullable=True), sa.Column('labnotes', sa.UnicodeText(), nullable=True), sa.Column('received_at', sa.Date(), nullable=False), sa.Column('entered_at', sa.DateTime(timezone=True), nullable=False), sa.ForeignKeyConstraint( ['sequence_id'], ['tbl_sequences.id'], ), sa.PrimaryKeyConstraint('id'), sa.UniqueConstraint('sequence_id'), sa.UniqueConstraint('vnum', 'test_code', 'received_at')) op.create_index(op.f('ix_tbl_proficiency_samples_entered_at'), 'tbl_proficiency_samples', ['entered_at'], unique=False) op.create_index(op.f('ix_tbl_proficiency_samples_name'), 'tbl_proficiency_samples', ['name'], unique=False) op.create_index(op.f('ix_tbl_proficiency_samples_received_at'), 'tbl_proficiency_samples', ['received_at'], unique=False) op.create_index(op.f('ix_tbl_proficiency_samples_source'), 'tbl_proficiency_samples', ['source'], unique=False) op.create_index(op.f('ix_tbl_proficiency_samples_vnum'), 'tbl_proficiency_samples', ['vnum'], unique=False) op.create_table( 'tbl_patient_visits', sa.Column('id', sa.Integer(), nullable=False), sa.Column('ptnum', sa.Integer(), nullable=False), sa.Column('mrid', sa.Unicode(128), nullable=True), sa.Column('collected_at', sa.Date(), nullable=False), sa.ForeignKeyConstraint( ['mrid', 'ptnum'], ['tbl_medical_records.mrid', 'tbl_medical_records.ptnum'], ), sa.ForeignKeyConstraint( ['ptnum'], ['tbl_patients.ptnum'], ), sa.PrimaryKeyConstraint('id'), sa.UniqueConstraint('ptnum', 'collected_at')) op.create_index(op.f('ix_tbl_patient_visits_collected_at'), 'tbl_patient_visits', ['collected_at'], unique=False) op.create_table( 'tbl_positive_control_reports', sa.Column('positive_control_id', sa.Integer(), nullable=False), sa.Column('report_id', sa.Integer(), nullable=False), sa.ForeignKeyConstraint( ['positive_control_id'], ['tbl_positive_controls.id'], ), sa.ForeignKeyConstraint( ['report_id'], ['tbl_reports.id'], ), sa.PrimaryKeyConstraint('positive_control_id', 'report_id')) op.create_table( 'tbl_proficiency_sample_reports', sa.Column('proficiency_sample_id', sa.Integer(), nullable=False), sa.Column('report_id', sa.Integer(), nullable=False), sa.ForeignKeyConstraint( ['proficiency_sample_id'], ['tbl_proficiency_samples.id'], ), sa.ForeignKeyConstraint( ['report_id'], ['tbl_reports.id'], ), sa.PrimaryKeyConstraint('proficiency_sample_id', 'report_id')) op.create_table( 'tbl_patient_samples', sa.Column('id', sa.Integer(), nullable=False), sa.Column('vnum', sa.Unicode(64), nullable=False), sa.Column('test_code', sa.Unicode(64), nullable=False), sa.Column('specimen_type', sa.Unicode(32), nullable=False), sa.Column('patient_visit_id', sa.Integer(), nullable=False), sa.Column('sequence_id', sa.Integer(), nullable=True), sa.Column('physician_id', sa.Integer(), nullable=True), sa.Column('clinic_id', sa.Integer(), nullable=True), sa.Column('amplifiable', sa.Boolean(), nullable=True), sa.Column('notes', sa.UnicodeText(), nullable=True), sa.Column('labnotes', sa.UnicodeText(), nullable=True), sa.Column('received_at', sa.Date(), nullable=True), sa.Column('entered_at', sa.DateTime(timezone=True), nullable=False), sa.ForeignKeyConstraint( ['clinic_id'], ['tbl_clinics.id'], ), sa.ForeignKeyConstraint( ['patient_visit_id'], ['tbl_patient_visits.id'], ), sa.ForeignKeyConstraint( ['physician_id'], ['tbl_physicians.id'], ), sa.ForeignKeyConstraint( ['sequence_id'], ['tbl_sequences.id'], ), sa.PrimaryKeyConstraint('id'), sa.UniqueConstraint('sequence_id'), sa.UniqueConstraint('vnum', 'test_code', 'patient_visit_id')) op.create_index(op.f('ix_tbl_patient_samples_clinic_id'), 'tbl_patient_samples', ['clinic_id'], unique=False) op.create_index(op.f('ix_tbl_patient_samples_entered_at'), 'tbl_patient_samples', ['entered_at'], unique=False) op.create_index(op.f('ix_tbl_patient_samples_patient_visit_id'), 'tbl_patient_samples', ['patient_visit_id'], unique=False) op.create_index(op.f('ix_tbl_patient_samples_physician_id'), 'tbl_patient_samples', ['physician_id'], unique=False) op.create_index(op.f('ix_tbl_patient_samples_received_at'), 'tbl_patient_samples', ['received_at'], unique=False) op.create_index(op.f('ix_tbl_patient_samples_vnum'), 'tbl_patient_samples', ['vnum'], unique=False) op.create_table( 'tbl_patient_sample_reports', sa.Column('patient_sample_id', sa.Integer(), nullable=False), sa.Column('report_id', sa.Integer(), nullable=False), sa.ForeignKeyConstraint( ['patient_sample_id'], ['tbl_patient_samples.id'], ), sa.ForeignKeyConstraint( ['report_id'], ['tbl_reports.id'], ), sa.PrimaryKeyConstraint('patient_sample_id', 'report_id'))