diff options
Diffstat (limited to 'server/apps/util.py')
| -rw-r--r-- | server/apps/util.py | 48 |
1 files changed, 0 insertions, 48 deletions
diff --git a/server/apps/util.py b/server/apps/util.py index 3ef9063..67227e4 100644 --- a/server/apps/util.py +++ b/server/apps/util.py @@ -154,52 +154,12 @@ class DataHandler: `USER_PWD_HASH` varchar(255), `USER_GROUP` varchar(255)) ENGINE=innodb DEFAULT CHARSET=utf8;""" % MYSQL_TAB_USER - # 外键，考虑重复外键的处理 - # fkey1 = """ - # ALTER TABLE %s DROP FOREIGN KEY IF EXISTS `fk_SYSLOG_USER_1`; - # ALTER TABLE %s ADD CONSTRAINT `fk_SYSLOG_USER_1` - # FOREIGN KEY(`USER_ID`) REFERENCES %s(`USER_ID`);""" % (MYSQL_TAB_SYSLOG, MYSQL_TAB_SYSLOG, MYSQL_TAB_USER) - - # fkey2 = """ - # ALTER TABLE %s DROP FOREIGN KEY IF EXISTS `fk_TASK_AGENT_1`; - # ALTER TABLE %s ADD CONSTRAINT `fk_TASK_AGENT_1` - # FOREIGN KEY(`AGENT_ID`) REFERENCES %s(`AGENT_ID`);""" % (MYSQL_TAB_TASK, MYSQL_TAB_TASK, MYSQL_TAB_AGENT) - - # fkey3 = """ - # ALTER TABLE %s DROP FOREIGN KEY IF EXISTS `fk_TASK_USER_1`; - # ALTER TABLE %s ADD CONSTRAINT `fk_TASK_USER_1` - # FOREIGN KEY(`CREATED_BY`) REFERENCES %s(`USER_ID`);""" % (MYSQL_TAB_TASK, MYSQL_TAB_TASK, MYSQL_TAB_USER) - # 和task_policysql存在双向外键引用的问题，需要额外定义 fkey = """ ALTER TABLE %s ADD CONSTRAINT `fk_TASK_TASK_POLICY_1` FOREIGN KEY(`POLICY`) REFERENCES %s(`TP_ID`)""" % ( MYSQL_TAB_TASK, MYSQL_TAB_TASKPOLICY) - # fkey5 = """ - # ALTER TABLE %s DROP FOREIGN KEY IF EXISTS `fk_TASK_LOG_AGENT_1`; - # ALTER TABLE %s ADD CONSTRAINT `fk_TASK_LOG_AGENT_1` - # FOREIGN KEY(`CREATED_BY_AGENT`) REFERENCES %s(`AGENT_ID`);""" % ( - # MYSQL_TAB_TASK_LOG, MYSQL_TAB_TASK_LOG, MYSQL_TAB_AGENT) - - # fkey6 = """ - # ALTER TABLE %s DROP FOREIGN KEY IF EXISTS `fk_TASK_LOG_TASK_POLICY_1`; - # ALTER TABLE %s ADD CONSTRAINT `fk_TASK_LOG_TASK_POLICY_1` - # FOREIGN KEY(`TLOG_TP`) REFERENCES %s(`TP_ID`);""" % ( - # MYSQL_TAB_TASK_LOG, MYSQL_TAB_TASK_LOG, MYSQL_TAB_TASKPOLICY) - - # fkey7 = """ - # ALTER TABLE %s DROP FOREIGN KEY IF EXISTS `fk_TASK_POLICY_POLICY_1`; - # ALTER TABLE %s ADD CONSTRAINT `fk_TASK_POLICY_POLICY_1` - # FOREIGN KEY(`POLICY`) REFERENCES %s(`P_ID`);""" % ( - # MYSQL_TAB_TASKPOLICY, MYSQL_TAB_TASKPOLICY, MYSQL_TAB_POLICY) - - # fkey8 = """ - # ALTER TABLE %s DROP FOREIGN KEY IF EXISTS `fk_TASK_POLICY_TASK_1`; - # ALTER TABLE %s ADD CONSTRAINT `fk_TASK_POLICY_TASK_1` - # FOREIGN KEY(`FOR_TASK`) REFERENCES %s(`TASK_ID`);""" % ( - # MYSQL_TAB_TASKPOLICY, MYSQL_TAB_TASKPOLICY, MYSQL_TAB_TASK) - # 执行sql语句 try: # 创建数据库 @@ -220,14 +180,6 @@ class DataHandler: # 创建外键 self.cursor.execute(fkey) - # self.cursor.execute(fkey2) - # self.cursor.execute(fkey3) - # self.cursor.execute(fkey4) - # self.cursor.execute(fkey5) - # self.cursor.execute(fkey6) - # self.cursor.execute(fkey7) - # self.cursor.execute(fkey8) - # self.conn.commit() except Exception as e: # 重复外键 if str(e).find("(1826"): |