将SALT_STACK的JOB-CACHE放到数据库中，而建库用DJANGO的ORM完成-白红宇

将SALT_STACK的JOB-CACHE放到数据库中，而建库用DJANGO的ORM完成

阅读量：7176 次

发布时间：2019-06-29

本文共 2854 字，大约阅读时间需要 9 分钟。

下面包括了SALT_MASTER的配置，及DJANGO的ORM里更改默认表名称，更改默认字段名称（里面有个RETURN），更改默认ID索引。。。

一个下午有和它磨来磨去。。。

感谢鹏龙，感谢高远。。：）

参考：

http://docs.saltstack.com/en/latest/ref/returners/all/salt.returners.mysql.html#module-salt.returners.mysql

原表SQL语句：

CREATE DATABASE  `salt`  DEFAULT CHARACTER SET utf8  DEFAULT COLLATE utf8_general_ci;USE `salt`;---- Table structure for table `jids`--DROP TABLE IF EXISTS `jids`;CREATE TABLE `jids` (  `jid` varchar(255) NOT NULL,  `load` mediumtext NOT NULL,  UNIQUE KEY `jid` (`jid`)) ENGINE=InnoDB DEFAULT CHARSET=utf8;---- Table structure for table `salt_returns`--DROP TABLE IF EXISTS `salt_returns`;CREATE TABLE `salt_returns` (  `fun` varchar(50) NOT NULL,  `jid` varchar(255) NOT NULL,  `return` mediumtext NOT NULL,  `id` varchar(255) NOT NULL,  `success` varchar(10) NOT NULL,  `full_ret` mediumtext NOT NULL,  `alter_time` TIMESTAMP DEFAULT CURRENT_TIMESTAMP,  KEY `id` (`id`),  KEY `jid` (`jid`),  KEY `fun` (`fun`)) ENGINE=InnoDB DEFAULT CHARSET=utf8;---- Table structure for table `salt_events`--DROP TABLE IF EXISTS `salt_events`;CREATE TABLE `salt_events` (`id` BIGINT NOT NULL AUTO_INCREMENT,`tag` varchar(255) NOT NULL,`data` varchar(1024) NOT NULL,`alter_time` TIMESTAMP DEFAULT CURRENT_TIMESTAMP,`master_id` varchar(255) NOT NULL,PRIMARY KEY (`id`),KEY `tag` (`tag`)) ENGINE=InnoDB DEFAULT CHARSET=utf8;

DJANGO的ORM的样子：

from django.db import models # Create your models here. class jids(models.Model):     jid = models.CharField(max_length=255, unique=True)     load = models.TextField(max_length=1024)     def __unicode__(self):         return self.jid     class Meta:  db_table = 'jids'         ordering = ('-jid',) class salt_events(models.Model):     tag = models.CharField(max_length=255)     data = models.CharField(max_length=1024) alter_time = models.DateTimeField(auto_now_add=True)     master_id = models.CharField(max_length=255)     def __unicode__(self):         return self.id     class Meta:         db_table = 'salt_events'         ordering = ('-id',) class salt_returns(models.Model): custom_id = models.AutoField(primary_key=True)     fun = models.CharField(max_length=50)     jid = models.CharField(max_length=255) return_char = models.TextField(max_length=1024, db_column='return')     id = models.CharField(max_length=50)     success = models.CharField(max_length=10)     full_ret = models.TextField(max_length=1024)     alter_time = models.DateTimeField(auto_now_add=True)     def __unicode__(self):         return self.custom_id     class Meta:         db_table = 'salt_returns'         ordering = ('-custom_id',)

SALT_MASTER配置更改：

#add by chengang#2015-08-24##event_return: mysqlmaster_job_cache: mysqlmysql.host: '1.1.1.1'mysql.user: 'xxx'mysql.pass: 'yyyy'mysql.db: 'AAAA'mysql.port: 3306

DJANGO更新ORM的语句：

python manage.py makemigrations

#python manage.py syncdb(听说快放弃不用)

python manage.py migrate

测试效果：