• IndexedDB 封装


    class DB{
        /** 构造函数 */
        constructor(dbName){
            this.dbName = dbName;
        }
        
        /**
         * 选择表单
         */
        table(tableName, keys, version){
            version = version || 1;
            this.tableName = tableName;
            this.request = indexedDB.open(this.dbName, version);
            return new Promise((resolve, reject) => {
                this.request.onsuccess = (event) => {
                    this.db = event.target.result;
                    
                    resolve(this);
                }
                
                this.request.onupgradeneeded = (event) => {
                    this.db = event.target.result;
                    var objectStore;
                    
                    // 排列组合组装索引
                    var groups = [];
                    for(let i=0; i< keys.length; i++){
                        var arr = []; 
                        arr.push([keys[i]]);
                        for(let j=0; j< groups.length; j++){
                            arr.push([...groups[j], keys[i]]);
                        }
                        groups = groups.concat(arr);
                    }
                    if(!this.db.objectStoreNames.contains(tableName)){
                        objectStore = this.db.createObjectStore(tableName, {keyPath: 'id'});
                        groups.forEach(item => {
                            var idx = item.join('_');
                            objectStore.createIndex(idx, item, {unique: false});
                        });
                        
                    }
                    else{
                        objectStore = this.request.transaction.objectStore(tableName);
                        
                        var newIndexNames = [];
                        groups.forEach(item => {
                            var idx = item.join('_');
                            newIndexNames.push(idx);
                            if(!objectStore.indexNames.contains(idx)){
                                objectStore.createIndex(idx, item, {unique: false});
                            }
                        });
                        var delIndexNames = [];
                        for(var i=0; i<objectStore.indexNames.length; i++){
                            var item = objectStore.indexNames.item(i);
                            if(!newIndexNames.includes(item)){
                                delIndexNames.push(item);
                            }    
                        }
                        
                        // 删除索引
                        delIndexNames.forEach(item => {
                            console.log('del:' + item);
                            objectStore.deleteIndex(item);
                        });
            
                    }
                    
                }
                
                this.request.onerror = (event) => {
                    reject(event);
                }
            });
        }
        
    
        
        /**
         * 新增数据
         */
        add(item){
            return new Promise((resolve, reject) => {
                var request = this.db.transaction([this.tableName], 'readwrite')
                .objectStore(this.tableName)
                .add(item);
                
                request.onsuccess = (event) => {
                    resolve(event);
                }
                request.onerror = (event) => {
                    reject(event);
                }
                
            });
        }
        
        /**
         * 通过ID获取
         */
        get(id){
            return new Promise((resolve, reject) => {
                var transaction = this.db.transaction([this.tableName]);
                var objectStore = transaction.objectStore(this.tableName);
                var request = objectStore.get(id);
                request.onsuccess = (event) => {
                    resolve(event.target.result);
                }
                request.onerror = (event) => {
                    reject(event);
                }
            });
        }
        
        /** 获取所有 */
        findAll(){
            return new Promise((resolve, reject) => {
                var transaction = this.db.transaction([this.tableName]);
                var objectStore = transaction.objectStore(this.tableName);
                
                var items = [];
                objectStore.openCursor().onsuccess = async (event) => {
                    var cursor = event.target.result;
                    if(cursor){
                        console.log(cursor);
                        items.push(cursor.value);
                        cursor.continue();
                    }
                    else{
                        resolve(items);
                    }
                    
                }
                
            });
        }
        
        /**
         * 查询列表
         */
        findList(filter){
            return new Promise((resolve, reject) => {
                var keys = Object.keys(filter);
                var values = Object.values(filter);
                
                
                var transaction = this.db.transaction([this.tableName]);
                var objectStore = transaction.objectStore(this.tableName);
                var index = objectStore.index(keys.join('_'));
                
                var items = [];
                
                index.openCursor(IDBKeyRange.only(values)).onsuccess = async (event) => {
                    var cursor = event.target.result;
                    if(cursor){
                        items.push(cursor.value);
                        cursor.continue();
                    }
                    else{
                        resolve(items);
                    }
                    
                }
                
            });
        }
    }
    var db = new DB('TTD');
    db.table('person', ['name', 'age'], 11)
    .then(() => {
        //return db.add({id: 6, name: '王五', age: 25, email: 'zhangsan@email.com'})
    })
    .then(()=>{
        return db.get(11);
    }).then(res => {
        console.log(res);
    }).then(() => {
        return db.findAll();
    }).then(res =>{
        console.log(res);
    }).then(() =>{
        return db.findList({age: 25})
    }).then(res =>{
        console.log(res);
    });
  • 相关阅读:
    8.2 TensorFlow实现KNN与TensorFlow中的损失函数,优化函数
    8.3 TensorFlow BP神经网络构建与超参数的选取
    8.3 TensorFlow BP神经网络构建与超参数的选取
    聊一聊深度学习的weight initialization
    聊一聊深度学习的weight initialization
    聊一聊深度学习的activation function
    聊一聊深度学习的activation function
    Hadoop-2.7.4 八节点分布式集群安装
    Hadoop-2.7.4 八节点分布式集群安装
    Vue学习笔记(一) 入门
  • 原文地址:https://www.cnblogs.com/rubekid/p/14679935.html
Copyright © 2020-2023  润新知