Class Image

shared/database/image.py:3–106

from shared.database.common import *

class Image(Base):
    __tablename__ = 'image'

    id = Column(BIGINT, primary_key = True)

    original_filename = Column(String(250))
    description = Column(String(250))
    width = Column(Integer)
    height = Column(Integer)
    rotation_degrees = Column(Integer, default = 0)
    soft_delete = Column(Boolean, default = False)

    mask_joint_url = Column(String())
    mask_joint_blob_name = Column(String())

    is_inference = Column(Boolean, default = False)

    file_list = relationship("File", back_populates="image")

    annotation_status = Column(String())  # "complete" "init" "in_progress" ?

    is_annotation_example = Column(Boolean, default = False)
    url_annotation_example = Column(String())
    url_annotation_example_thumb = Column(String())

    url_public = Column(String())
    url_public_thumb = Column(String())

    url_signed = Column(String())
    url_signed_blob_path = Column(String())

    error = Column(String())

    # key assumption is that
    # rebuild_secure_urls_image() handles BOTH regular images
    # and thumbnail images...
    url_signed_thumb = Column(String())
    url_signed_thumb_blob_path = Column(String())

    url_signed_expiry = Column(Integer)

    url_signed_expiry_force_refresh = Column(Integer)
    time_created = Column(DateTime, default = datetime.datetime.utcnow)
    time_updated = Column(DateTime, onupdate = datetime.datetime.utcnow)

    def get_by_id(session, id):
        return session.query(Image).filter(Image.id == id).first()

    # For annotation assignments
    def serialize_for_example(self):
        image = {
            'width': self.width,
            'height': self.height,
            'rotation_degrees': self.rotation_degrees,
            'is_annotation_example': self.is_annotation_example,
            'url_annotation_example': self.url_annotation_example,
            'url_annotation_example_thumb': self.url_annotation_example_thumb
        }