js读取sqlite数据库

var data={total:0,users:0,peruser:0,disks:[]}
	// 读取数据库数据
    axios.get("../data/diskinfo.db",{responseType: 'arraybuffer'}, {headers:{'Access-Control-Allow-Origin': '*'}})
        .then(function (response) {
            let db = new window.SQL.Database(new Uint8Array(response.data));
            // 执行查询
            let r = db.exec("SELECT * FROM sdiskusage where flag=1;");
            // 解析数据
	    let col=r[0].columns;
            let val=r[0].values;
			
	    //console.info(r[0]);
	    for(i = 0,len_i=val.length; i < len_i; i++) {
		tmp={};
		for(j=0,len_j=val[i].length;j<len_j;j++){
		    tmp[col[j]]=val[i][j];
		}
		tmp['name']=tmp['device'];
		tmp['value']=tmp['percent'];
		data.total+=tmp['total'];
		data.users+=tmp['used'];
				
		if(tmp['total']>1){
		    tmp['total']=Math.round(tmp['total'])+"G";
		}
		else{
		    tmp['total']=Math.round(tmp['total']*1024)+"M";
		}
				
		data.disks[i]=tmp;
	    }
	    data.peruser=(data.users/data.total*100).toFixed(2)+"%";
	    if(data.total>1){
	        data.total=Math.round(data.total)+"G";
	    }
	    else{
	        data.total=Math.round(data.total*1024)+"M";
            }
	    if(data.users>1){
	        data.users=Math.round(data.users)+"G";
	    }
	    else{
	        data.users=Math.round(data.users*1024)+"M";
	    }
	    console.info(data);
	})
        .catch(function (error) {
            console.info(error);
        });