class Experiment(db.Model): __tablename__ = 'experiments' name = db.Column(db.String(255), unique=False, nullable=False) uuid = db.Column(db.String(255), unique=True, nullable=False, primary_key=True) pipeline_uuid = db.Column(db.String(255), unique=False, nullable=False) pipeline_name = db.Column(db.String(255), unique=False, nullable=False) created = db.Column(db.DateTime, nullable=False, default=datetime.datetime.utcnow) strategy_json = db.Column(db.Text, nullable=False) draft = db.Column(db.Boolean())
class Job(db.Model): __tablename__ = "jobs" name = db.Column(db.String(255), unique=False, nullable=False) uuid = db.Column(db.String(255), unique=True, nullable=False, primary_key=True) pipeline_uuid = db.Column(db.String(255), unique=False, nullable=False) project_uuid = db.Column( db.ForeignKey("project.uuid", ondelete="CASCADE"), unique=False, nullable=False ) pipeline_name = db.Column(db.String(255), unique=False, nullable=False) pipeline_path = db.Column(db.String(255), unique=False, nullable=False) created = db.Column( db.DateTime, nullable=False, server_default=text("timezone('utc', now())") ) strategy_json = db.Column(db.Text, nullable=False) draft = db.Column(db.Boolean()) pipeline_runs = db.relationship( "PipelineRun", lazy="joined", passive_deletes=False, cascade="all, delete" )