diff options
| author | 韩丁康 <[email protected]> | 2024-05-20 13:43:33 +0000 |
|---|---|---|
| committer | 韩丁康 <[email protected]> | 2024-05-20 13:43:33 +0000 |
| commit | 8c67435320d34ea3ef941e435194e9a794bcce59 (patch) | |
| tree | 60e1238c1e291e2b6f527353f0f7f04baa86727f | |
| parent | 65a2b2d34ce6a7337715a27391753ef6c6ab3537 (diff) | |
废除task表指向taskpolicy的外键创建
| -rw-r--r-- | server/apps/util.py | 8 |
1 files changed, 1 insertions, 7 deletions
diff --git a/server/apps/util.py b/server/apps/util.py index ad5bec2..9ea099d 100644 --- a/server/apps/util.py +++ b/server/apps/util.py @@ -135,11 +135,6 @@ class DataHandler: `USER_PWD_HASH` varchar(255), `USER_GROUP` varchar(255)) ENGINE=innodb DEFAULT CHARSET=utf8;""" % 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) # 执行sql语句 try: @@ -159,8 +154,7 @@ class DataHandler: self.cursor.execute(tasklogsql) self.conn.commit() - # 创建外键 - self.cursor.execute(fkey) + except Exception as e: # 重复外键 if str(e).find("(1826"): |