IDSIA / sacred

            return {'_id': self.artifact_id,

                    'filename': self.filename}

    class Resource(Base):

        __tablename__ = 'resource'

        @classmethod

        def get_or_create(cls, filename, session):

            md5sum = get_digest(filename)

            instance = session.query(cls).filter_by(filename=filename,

                                                    md5sum=md5sum).first()

            if instance:

                return instance

            with open(filename, 'rb') as f:

                return cls(filename=filename, md5sum=md5sum, content=f.read())

        resource_id = sa.Column(sa.Integer, primary_key=True)

        filename = sa.Column(sa.String(256))

        md5sum = sa.Column(sa.String(32))

        content = sa.Column(sa.LargeBinary)

        def to_json(self):

            return {'filename': self.filename,

                    'md5sum': self.md5sum}

    class Host(Base):

        __tablename__ = 'host'

        def to_json(self):

            return "{}=={}".format(self.name, self.version)

    class Artifact(Base):

        __tablename__ = 'artifact'

        @classmethod

        def create(cls, name, filename):

            with open(filename, 'rb') as f:

                return cls(filename=name, content=f.read())

        artifact_id = sa.Column(sa.Integer, primary_key=True)

        filename = sa.Column(sa.String(64))

        content = sa.Column(sa.LargeBinary)

        run_id = sa.Column(sa.String(24), sa.ForeignKey('run.run_id'))

        run = sa.orm.relationship("Run", backref=sa.orm.backref('artifacts'))

        def to_json(self):

            return {'_id': self.artifact_id,

                    'filename': self.filename}

    class Resource(Base):

        __tablename__ = 'resource'