From 08cce3334a2dc81d690b518136b0aaea64e48b0b Mon Sep 17 00:00:00 2001
From: king <18310653075@163.com>
Date: 星期三, 14 六月 2023 09:55:50 +0800
Subject: [PATCH] 2023-06-14
---
src/views/interface/api/index.js | 116 +++++++++++++++++++++++----------------------------------
1 files changed, 47 insertions(+), 69 deletions(-)
diff --git a/src/views/interface/api/index.js b/src/views/interface/api/index.js
index 59f4941..37b374b 100644
--- a/src/views/interface/api/index.js
+++ b/src/views/interface/api/index.js
@@ -1,25 +1,30 @@
import axios from 'axios'
import md5 from 'md5'
import jsSHA from 'jssha'
-import { notification } from 'antd'
-window.GLOB.WebSql = null
+window.GLOB.IndexDB = null
-if (window.openDatabase) {
- let service = window.GLOB.service ? '-' + window.GLOB.service.replace('/', '') : ''
+let service = window.GLOB.service ? '-' + window.GLOB.service.replace('/', '') : ''
+let db = `mk_inter${service}`
+
+if (window.indexedDB) {
try {
- window.GLOB.WebSql = openDatabase(`mkdb${service}`, '1', 'mk-pc-database', 50 * 1024 * 1024)
- window.GLOB.WebSql.transaction(tx => {
- tx.executeSql('CREATE TABLE IF NOT EXISTS INTERFACES (uuid varchar(50), createDate varchar(50), method varchar(50), interface text, params text, headers text, active varchar(50), raw text, formData text, CDefine1 varchar(50), CDefine2 varchar(50), CDefine3 varchar(50), CDefine4 varchar(50), CDefine5 text)', [], () => {
-
- }, () => {
- // eslint-disable-next-line
- throw 'CREATE TABLE ERROR'
- })
- })
+ let request = window.indexedDB.open(db, 1)
+ request.onerror = () => {
+ console.warn('IndexedDB 鍒濆鍖栧け璐ワ紒')
+ }
+ request.onsuccess = () => {
+ window.GLOB.IndexDB = request.result
+ }
+ request.onupgradeneeded = (event) => {
+ window.GLOB.IndexDB = event.target.result
+ if (!window.GLOB.IndexDB.objectStoreNames.contains('interfaces')) {
+ window.GLOB.IndexDB.createObjectStore('interfaces', { keyPath: 'id' })
+ }
+ }
} catch (e) {
- console.warn('WebSql 鍒濆鍖栧け璐ワ紒')
- window.GLOB.WebSql = null
+ console.warn('IndexedDB 鍒濆鍖栧け璐ワ紝鍘嗗彶璁板綍灏嗘棤娉曟煡璇㈡垨淇敼锛�')
+ window.GLOB.IndexDB = null
}
}
@@ -102,73 +107,46 @@
return axios(config)
}
- writeInWebSql (data) {
- if (!window.GLOB.WebSql) {
- notification.warning({ top: 92, message: 'WebSql寮�鍚け璐ワ紒', duration: 5 })
- return
- }
- return new Promise((resolve, reject) => {
- window.GLOB.WebSql.transaction(tx => {
- tx.executeSql(`INSERT INTO INTERFACES (uuid, createDate, method, interface, params, headers, active, raw, formData) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)`, data, (tx, results) => {
- resolve(results)
- }, () => {
- resolve()
- })
- })
- })
+ writeInIndexDB (data) {
+ if (!window.GLOB.IndexDB) return
+
+ window.GLOB.IndexDB.transaction(['interfaces'], 'readwrite').objectStore('interfaces').add(data)
}
getInterfaces () {
- if (!window.GLOB.WebSql) {
- notification.warning({ top: 92, message: 'WebSql寮�鍚け璐ワ紒', duration: 5 })
- return
- }
+ if (!window.GLOB.IndexDB) return Promise.resolve()
+
return new Promise((resolve, reject) => {
- window.GLOB.WebSql.transaction(tx => {
- tx.executeSql(`SELECT * FROM INTERFACES`, [], (tx, results) => {
- // let paramItem = results.rows[0]
- resolve(results)
- }, () => {
- window.GLOB.WebSql = null
- reject()
- })
- })
+ let request = window.GLOB.IndexDB.transaction(['interfaces']).objectStore('interfaces').openCursor()
+ let list = []
+
+ request.onsuccess = (e) => {
+ let cursor = e.target.result
+ if (cursor) {
+ if (cursor.value) {
+ list.push(cursor.value)
+ }
+ cursor.continue()
+ } else {
+ resolve(list)
+ }
+ }
})
}
- delInterface (uuid) {
- if (!window.GLOB.WebSql) {
- notification.warning({ top: 92, message: 'WebSql寮�鍚け璐ワ紒', duration: 5 })
- return
- }
- return new Promise((resolve, reject) => {
- window.GLOB.WebSql.transaction(tx => {
- tx.executeSql(`DELETE FROM INTERFACES where uuid = '${uuid}'`, [], (tx, results) => {
- resolve(results)
- }, () => {
- resolve()
- })
- })
- })
+ delInterface (id) {
+ if (!window.GLOB.IndexDB) return
+
+ window.GLOB.IndexDB.transaction(['interfaces'], 'readwrite').objectStore('interfaces').delete(id)
}
/**
* @description 娓呯┖鎺ュ彛璋冪敤璁板綍
*/
clearInterfaces () {
- if (!window.GLOB.WebSql) {
- notification.warning({ top: 92, message: 'WebSql寮�鍚け璐ワ紒', duration: 5 })
- return
- }
- return new Promise((resolve, reject) => {
- window.GLOB.WebSql.transaction(tx => {
- tx.executeSql(`DELETE FROM INTERFACES`, [], (tx, results) => {
- resolve(results)
- }, () => {
- resolve()
- })
- })
- })
+ if (!window.GLOB.IndexDB) return
+
+ window.GLOB.IndexDB.transaction(['interfaces'], 'readwrite').objectStore('interfaces').clear()
}
}
--
Gitblit v1.8.0