class User(Base): """ 执行用户 """ name = models.CharField(max_length=40) create_user = models.CharField(max_length=40) create_time = models.DateTimeField(auto_now_add=True) project_id = models.IntegerField() class Meta: db_table = "user"
class Procedure(Base): """ 流程 """ name = models.CharField(max_length=200) create_user = models.CharField(max_length=40) create_time = models.DateTimeField(auto_now_add=True) last_user = models.CharField(max_length=40) last_time = models.DateTimeField(auto_now=True) project_id = models.PositiveIntegerField() class Meta: db_table = "procedure"
class HistoryTask(Base): """ 任务历史 """ name = models.CharField(max_length=200) user = models.CharField(max_length=40) status = models.PositiveSmallIntegerField(default=0) #0等待执行 1成功 2失败 10正在执行 type = models.PositiveSmallIntegerField(default=0) #1页面启动 start_time = models.DateTimeField(auto_now_add=True) end_time = models.DateTimeField(null=True) total_time = models.PositiveIntegerField(default=0) project_id = models.PositiveIntegerField() class Meta: db_table = "history_task"
class Script(Base): """ 脚本 """ name = models.CharField(max_length=200) content = models.BinaryField() type = models.IntegerField() create_user = models.CharField(max_length=40) create_time = models.DateTimeField(auto_now_add=True) last_user = models.CharField(max_length=40) last_time = models.DateTimeField(auto_now=True) project_id = models.IntegerField() class Meta: db_table = "script"
class Project(Base): """ 项目 """ name = models.CharField(max_length = 200) class Meta: db_table = "project"
class HistoryScriptServer(Base): """ 服务器历史 """ host = models.CharField(max_length=40) log = models.BinaryField() code = models.IntegerField(null=True) total_time = models.PositiveIntegerField(default=0) node = models.ForeignKey(HistoryScriptNode) class Meta: db_table = "history_script_server"
class HistoryScriptNode(Base): """ 节点历史 """ order = models.CharField(max_length=40) name = models.CharField(max_length=200) content = models.BinaryField() type = models.PositiveSmallIntegerField() args = models.CharField(max_length=200, default="") user = models.CharField(max_length=40) index = models.PositiveIntegerField() status = models.PositiveSmallIntegerField( default=0) #0等待执行 1成功 2失败 3忽略错误 10正在执行 start_time = models.DateTimeField(null=True) end_time = models.DateTimeField(null=True) total_time = models.PositiveIntegerField(default=0) step = models.ForeignKey(HistoryStep) class Meta: db_table = "history_script_node" ordering = ["index"]
class HistoryStep(Base): """ 步骤历史 """ name = models.CharField(max_length=200) index = models.PositiveIntegerField() type = models.PositiveSmallIntegerField() task = models.ForeignKey(HistoryTask) class Meta: db_table = "history_step" ordering = ["index"]
class Step(Base): """ 步骤 """ name = models.CharField(max_length=200) index = models.PositiveIntegerField() type = models.PositiveSmallIntegerField() procedure = models.ForeignKey(Procedure) class Meta: db_table = "step" ordering = ["index"]
class ScriptNode(Base): """ 节点 """ script = models.ForeignKey(Script) user = models.ForeignKey(User) args = models.CharField(default="", max_length=200) index = models.PositiveIntegerField() servers = models.TextField() step = models.ForeignKey(Step) class Meta: db_table = "script_node" ordering = ["index"]