Class File

shared/database/source_control/file.py:33–1296

A file is raw data relation + annotation instances eg File.image File.video A file represents the lowest unit of source control data

class File(Base, Caching):
    """
    A file is raw data relation + annotation instances
        eg
        File.image
        File.video

    A file represents the lowest unit of source control data
    """

    __tablename__ = 'file'

    __table_args__ = (
        Index('index__video_parent_file_id__and__frame_number',
              "video_parent_file_id",
              "frame_number"),
    )

    id = Column(BIGINT, primary_key = True)
    created_time = Column(DateTime, default = datetime.datetime.utcnow)
    time_last_updated = Column(DateTime, onupdate = datetime.datetime.utcnow)

    count_instances_changed = Column(Integer)

    # Number of instances (Of all types) in the file.
    count_instances = Column(Integer, default = None, nullable = True)

    created_by_kind = Column(String)  # 'human', 'api'

    time_committed = Column(DateTime)

    job_id = Column(Integer, ForeignKey('job.id'))
    job = relationship("Job")

    # Context of say wanting to check if a file is done processing. ie for video job.
    # Also could be useful in future to be able to "trace back" a file more easily
    # Instead of having to do reverse
    # I guess could just do query input id where file_id = file but just feels funny
    input_id = Column(Integer, ForeignKey('input.id'))

    member_created_id = Column(Integer, ForeignKey('member.id'))
    member_created = relationship("Member", foreign_keys = [member_created_id])

    member_updated_id = Column(Integer, ForeignKey('member.id'))
    member_updated = relationship("Member", foreign_keys = [member_updated_id])

    # "added", "removed", "changed"
    state = Column(String())  # for source control

    committed = Column(Boolean)

    # image, frame, video, label, compound
    type = Column(String())

    # hash_data = [image_id, [instance-list], [n list]]
    hash = Column(String())

    # ann == annotation