コード例 #1
0
class Laboratory(Model):
    __tablename__ = 'laboratory'

    id = Column(Integer, primary_key=True)
    name = Column(String())
    created_at = Column(DateTime(), default=func.now())
    updated_at = Column(DateTime(), onupdate=datetime.datetime.now)
    sub_samples = relationship('SubSample', cascade='all,delete-orphan', backref='laboratory')

    def __repr__(self):
        return '<id {}>'.format(self.id)
コード例 #2
0
ファイル: sub_sample.py プロジェクト: jbrr/mosquito_heat_map
class SubSample(Model):
    __tablename__ = 'sub_sample'

    id = Column(Integer, primary_key=True)
    sample_id = Column(Integer, ForeignKey('sample.id'), nullable=False)
    identified_by = Column(Integer, ForeignKey('scientist.id'))
    identified_by_lab = Column(Integer, ForeignKey('laboratory.id'))
    individual_count = Column(Integer)
    specimen_id = Column(Integer, ForeignKey('specimen.id'))
    created_at = Column(DateTime(), default=func.now())
    updated_at = Column(DateTime(), onupdate=datetime.datetime.now)

    def __repr__(self):
        return '<id {}>'.format(self.id)
コード例 #3
0
ファイル: sample.py プロジェクト: jbrr/mosquito_heat_map
class Sample(Model):
    __tablename__ = 'sample'

    id = Column(Integer, primary_key=True)
    set_date = Column(DateTime())
    collect_date = Column(DateTime())
    location_id = Column(Integer, ForeignKey('location.id'))
    sub_samples = relationship('SubSample',
                               cascade='all,delete-orphan',
                               backref='sample')
    created_at = Column(DateTime(), default=func.now())
    updated_at = Column(DateTime(), onupdate=datetime.datetime.now)

    def __repr__(self):
        return '<id {}>'.format(self.id)
コード例 #4
0
ファイル: location.py プロジェクト: jbrr/mosquito_heat_map
class Location(Model):
    __tablename__ = 'location'

    id = Column(Integer, primary_key=True)
    site_id = Column(String())
    domain = Column(String())
    named_location = Column(String(), unique=True)
    elevation = Column(Float)
    point = Column(Geometry('POINT', srid=4326))
    nlcd_class_id = Column(ForeignKey('nlcd_class.id'))
    county = Column(String())
    state = Column(String())
    country = Column(String())
    created_at = Column(DateTime(), default=func.now())
    updated_at = Column(DateTime(), onupdate=datetime.datetime.now)
    samples = relationship('Sample',
                           cascade='all,delete-orphan',
                           backref='location')

    def __repr__(self):
        return '<id {}>'.format(self.id)
コード例 #5
0
class Specimen(Model):
    __tablename__ = 'specimen'

    id = Column(Integer, primary_key=True)
    kingdom = Column(String())
    phylum = Column(String())
    # class is a reserved keyword
    tax_class = Column('class', String())
    order = Column(String())
    family = Column(String())
    subfamily = Column(String())
    tribe = Column(String())
    genus = Column(String())
    subgenus = Column(String())
    species = Column(String())
    sub_samples = relationship('SubSample', cascade='all,delete-orphan', backref='specimen')
    created_at = Column(DateTime(), default=func.now())
    updated_at = Column(DateTime(), onupdate=datetime.datetime.now)

    def __repr__(self):
        return '<id {}>'.format(self.id)