From 213c70792e6af7f9ccef17d778c5f8806fbd513c Mon Sep 17 00:00:00 2001
From: king <18310653075@163.com>
Date: 星期四, 28 十一月 2019 15:01:24 +0800
Subject: [PATCH] 2019-11-28-01
---
src/utils/utils.js | 130 ++++++++++++++++++++++++++++++++++--------
1 files changed, 104 insertions(+), 26 deletions(-)
diff --git a/src/utils/utils.js b/src/utils/utils.js
index d570d6c..1717dc4 100644
--- a/src/utils/utils.js
+++ b/src/utils/utils.js
@@ -30,54 +30,132 @@
}
/**
- * @description 鏍煎紡鍖栨悳绱㈡潯浠�
+ * @description sql鍔犲瘑
* @return {String} value
*/
static formatOptions (value) {
// 浜х敓涓�涓柊鐨凣UID鍊�
let format = [{
key: 'select',
- value: 'msltk'
+ value: ' msltk '
}, {
key: 'from',
- value: 'mfrmk'
+ value: ' mfrmk '
}, {
key: 'where',
- value: 'mwhrk'
+ value: ' mwhrk '
}, {
key: 'order by',
- value: 'modbk'
+ value: ' modbk '
}, {
key: 'asc',
- value: 'modack'
+ value: ' modack '
}, {
key: 'desc',
- value: 'moddesk'
- }, {
- key: '%',
- value: 'mpercent'
- }, {
- key: '>',
- value: 'greateror'
- }, {
- key: '<',
- value: 'lessor'
- }, {
- key: '=',
- value: 'equal'
+ value: ' moddesk '
}, {
key: 'top',
- value: 'mtpk'
+ value: ' mtpk '
+ }, {
+ key: 'like',
+ value: ' mlkk '
+ }, {
+ key: 'not like',
+ value: ' mnlkk '
+ }, {
+ key: 'between',
+ value: ' mbtnk '
+ }, {
+ key: 'and',
+ value: ' madk '
+ }, {
+ key: 'insert',
+ value: ' mistk '
+ }, {
+ key: 'into',
+ value: ' mitk '
+ }, {
+ key: 'update',
+ value: ' muptk '
+ }, {
+ key: 'delete',
+ value: ' mdelk '
+ }, {
+ key: 'begin',
+ value: ' mbgink '
+ }, {
+ key: 'end',
+ value: ' medk '
+ }, {
+ key: 'if',
+ value: ' mefk '
+ }, {
+ key: 'while',
+ value: ' mwilk '
+ }, {
+ key: 'create',
+ value: ' mcrtk '
+ }, {
+ key: 'alter',
+ value: ' matek '
+ }, {
+ key: 'len',
+ value: ' mlnk '
+ }, {
+ key: 'left',
+ value: ' mlftk '
+ }, {
+ key: 'right',
+ value: ' mritk '
+ }, {
+ key: 'union',
+ value: ' munok '
+ }, {
+ key: 'varchar',
+ value: ' mvcrk '
+ }, {
+ key: 'getdate',
+ value: ' mgtdtk '
+ }, {
+ key: 'TRY',
+ value: ' mtryonek '
+ }, {
+ key: 'TRAN',
+ value: ' mtrnk '
+ }, {
+ key: 'goto',
+ value: ' mgtk '
+ }, {
+ key: 'set',
+ value: ' mstk '
+ }, {
+ key: 'ROLLBACK',
+ value: ' mrlbkk '
}]
-
format.forEach(item => {
- let reg = new RegExp(item.key, 'ig')
+ let reg = new RegExp('(^|\\s)' + item.key + '(\\s|$)', 'ig')
value = value.replace(reg, item.value)
})
-
- value = value.replace(/\*/ig, 'mastrsk')
- value = value.replace(/'/ig, 'mqotek')
- value = value.replace(/\s/ig, 'mspace')
+ value = value.replace(/(^\s|\s$)/ig, '')
+ value = window.btoa(window.encodeURIComponent(value))
+ // let index = Math.floor(Math.random() * value.length)
+ // value = value.slice(0, index) + 'minKe' + value.slice(index)
+ value = 'minKe' + value
+ value = window.btoa(value)
+ // value = value.replace(/%/ig, 'mpercent')
+ // .replace(/>/ig, 'greateror')
+ // .replace(/</ig, 'lessor')
+ // .replace(/!=/ig, 'noequal')
+ // .replace(/=/ig, 'equal')
+ // .replace(/,/ig, 'comma')
+ // .replace(/>=/ig, 'greaterorequal')
+ // .replace(/<=/ig, 'lessorequal')
+ // .replace(/@/ig, 'matk')
+ // .replace(/\(/ig, 'mlbrktsk')
+ // .replace(/\)/ig, 'mrbrktsk')
+ // .replace(/\*/ig, 'mastrsk')
+ // .replace(/'/ig, 'mqotek')
+ // .replace(/\s/ig, 'mspace')
return value
}
--
Gitblit v1.8.0