qinglong/back/data/runningInstance.ts

import { sequelize } from '.';
import { DataTypes, Model } from 'sequelize';

export enum InstanceStatus {
  'running' = 0,
  'finished' = 1,
  'stopped' = 2,
  'error' = 3,
}

export interface RunningInstanceAttributes {
  id?: number;
  cron_id: number;
  run_id?: string | null;
  attempt_id?: string | null;
  pid?: number;
  log_path?: string;
  started_at: number;
  finished_at?: number;
  status: InstanceStatus;
  exit_code?: number;
}

export class RunningInstance {
  id?: number;
  cron_id!: number;
  run_id?: string | null;
  attempt_id?: string | null;
  pid?: number;
  log_path?: string;
  started_at!: number;
  finished_at?: number;
  status!: InstanceStatus;
  exit_code?: number;

  constructor(options: RunningInstanceAttributes) {
    this.id = options.id;
    this.cron_id = options.cron_id;
    this.run_id = options.run_id;
    this.attempt_id = options.attempt_id;
    this.pid = options.pid;
    this.log_path = options.log_path;
    this.started_at = options.started_at;
    this.finished_at = options.finished_at;
    this.status = options.status;
    this.exit_code = options.exit_code;
  }
}

export interface RunningInstanceModel
  extends Model<RunningInstanceAttributes, RunningInstanceAttributes>,
    RunningInstanceAttributes {}

export const RunningInstanceModel = sequelize.define<RunningInstanceModel>(
  'RunningInstance',
  {
    cron_id: {
      type: DataTypes.NUMBER,
      allowNull: false,
    },
    run_id: {
      type: DataTypes.STRING(36),
      allowNull: true,
    },
    attempt_id: {
      type: DataTypes.STRING(36),
      allowNull: true,
      unique: 'running_instances_attempt_uidx',
    },
    pid: {
      type: DataTypes.NUMBER,
      allowNull: true,
    },
    log_path: {
      type: DataTypes.STRING,
      allowNull: true,
    },
    started_at: {
      type: DataTypes.NUMBER,
      allowNull: false,
    },
    finished_at: {
      type: DataTypes.NUMBER,
      allowNull: true,
    },
    status: {
      type: DataTypes.NUMBER,
      allowNull: false,
      defaultValue: InstanceStatus.running,
    },
    exit_code: {
      type: DataTypes.NUMBER,
      allowNull: true,
    },
  },
);