From 6b680ace26dc95031a1b7a3e33f8785c112f787d Mon Sep 17 00:00:00 2001
From: king <18310653075@163.com>
Date: 星期一, 20 四月 2020 18:32:01 +0800
Subject: [PATCH] 2020-04-20
---
src/utils/utils.js | 28 ++++++++++++++--------------
1 files changed, 14 insertions(+), 14 deletions(-)
diff --git a/src/utils/utils.js b/src/utils/utils.js
index a3f9b02..2a4bd06 100644
--- a/src/utils/utils.js
+++ b/src/utils/utils.js
@@ -58,19 +58,19 @@
static verifySql (sql, type) {
if (!sql) return ''
let chars = [
- {key: 'create', reg: '(^|\\s)create\\s'},
- {key: 'insert', reg: '(^|\\s)insert\\s'},
- {key: 'delete', reg: '(^|\\s)delete\\s'},
- {key: 'update', reg: '(^|\\s)update\\s'},
- {key: 'set', reg: '(^|\\s)set\\s'},
- {key: 'drop', reg: '(^|\\s)drop\\s'},
- {key: 'alter', reg: '(^|\\s)alter\\s'},
- {key: 'truncate', reg: '(^|\\s)truncate\\s'},
- {key: 'if', reg: '(^|\\s)if\\s'},
- {key: 'exec', reg: 'exec'},
- {key: 'OBJECT', reg: 'OBJECT'},
- {key: 'sys.', reg: 'sys.'},
- {key: 'kill', reg: 'kill'},
+ {key: 'create', reg: /(^|\s)create\s/ig},
+ {key: 'insert', reg: /(^|\s)insert\s/ig},
+ {key: 'delete', reg: /(^|\s)delete\s/ig},
+ {key: 'update', reg: /(^|\s)update\s/ig},
+ {key: 'set', reg: /(^|\s)set\s/ig},
+ {key: 'drop', reg: /(^|\s)drop\s/ig},
+ {key: 'alter', reg: /(^|\s)alter\s/ig},
+ {key: 'truncate', reg: /(^|\s)truncate\s/ig},
+ {key: 'if', reg: /(^|\s)if\s/ig},
+ {key: 'exec', reg: /exec/ig},
+ {key: 'OBJECT', reg: /object/ig},
+ {key: 'sys.', reg: /sys\./ig},
+ {key: 'kill', reg: /kill/ig}
]
if (type === 'customscript') {
@@ -79,7 +79,7 @@
let error = ''
chars.forEach(char => {
- if (!error && new RegExp(char.reg, 'ig').test(sql)) {
+ if (!error && char.reg.test(sql)) {
error = char.key
}
})
--
Gitblit v1.8.0