array2json

本文介绍了使用jQuery进行类型检测的方法,并提供了toJSON和evalJSON两个实用函数的实现,用于处理JSON格式的数据。

 

 原文:jQuery方法扩展:type, toJSON, evalJSON. http://zhkac.iteye.com/blog/499330 .2013-05-19

(function($) { 
    // the code of this function is from  
    // http://lucassmith.name/pub/typeof.html 
    $.type = function(o) { 
        var _toS = Object.prototype.toString; 
        var _types = { 
            'undefined': 'undefined', 
            'number': 'number', 
            'boolean': 'boolean', 
            'string': 'string', 
            '[object Function]': 'function', 
            '[object RegExp]': 'regexp', 
            '[object Array]': 'array', 
            '[object Date]': 'date', 
            '[object Error]': 'error' 
        }; 
        return _types[typeof o] || _types[_toS.call(o)] || (o ? 'object' : 'null'); 
    }; 
    // the code of these two functions is from mootools 
    // http://mootools.net 
    var $specialChars = { '\b': '\\b', '\t': '\\t', '\n': '\\n', '\f': '\\f', '\r': '\\r', '"': '\\"', '\\': '\\\\' }; 
    var $replaceChars = function(chr) { 
        return $specialChars[chr] || '\\u00' + Math.floor(chr.charCodeAt() / 16).toString(16) + (chr.charCodeAt() % 16).toString(16); 
    }; 
    $.toJSON = function(o) { 
        var s = []; 
        switch ($.type(o)) { 
            case 'undefined': 
                return 'undefined'; 
                break; 
            case 'null': 
                return 'null'; 
                break; 
            case 'number': 
            case 'boolean': 
            case 'date': 
            case 'function': 
                return o.toString(); 
                break; 
            case 'string': 
                return '"' + o.replace(/[\x00-\x1f\\"]/g, $replaceChars) + '"'; 
                break; 
            case 'array': 
                for (var i = 0, l = o.length; i < l; i++) { 
                    s.push($.toJSON(o[i])); 
                } 
                return '[' + s.join(',') + ']'; 
                break; 
            case 'error': 
            case 'object': 
                for (var p in o) { 
                    s.push(p + ':' + $.toJSON(o[p])); 
                } 
                return '{' + s.join(',') + '}'; 
                break; 
            default: 
                return ''; 
                break; 
        } 
    }; 
    $.evalJSON = function(s) { 
        if ($.type(s) != 'string' || !s.length) return null; 
        return eval('(' + s + ')'); 
    }; 
})(jQuery); 
with tmp_table as (select update_time, e1 as integratedindex, e2 as pm25, e3 as pm10, e4 as co, e5 as no2, e6 as so2, e7 as o3, e8 as aqi, e9 as tsp from dc_dm_air_city_air_data_national_ranking_d t lateral view explode_json_array_json(integrated_index_list) tmp1 as e1 lateral view explode_json_array_json(pm25_list) tmp2 as e2 lateral view explode_json_array_json(pm10_list) tmp3 as e3 lateral view explode_json_array_json(co_list) tmp4 as e4 lateral view explode_json_array_json(no2_list) tmp5 as e5 lateral view explode_json_array_json(so2_list) tmp6 as e6 lateral view explode_json_array_json(o3_list) tmp7 as e7 lateral view explode_json_array_json(aqi_list) tmp8 as e8 lateral view explode_json_array_json(tsp_list) tmp9 as e9 where air_region_key = #{ranking} and update_time BETWEEN date_format(&apos;${sTime}&apos;, '%Y-%m-%d') AND date_format(&apos;${eTime}&apos;, '%Y-%m-%d')), yoy_tmp_table as (select update_time, e1 as integratedindex, e2 as pm25, e3 as pm10, e4 as co, e5 as no2, e6 as so2, e7 as o3, e8 as aqi, e9 as tsp from dc_dm_air_city_air_data_national_ranking_d t lateral view explode_json_array_json(integrated_index_list) tmp1 as e1 lateral view explode_json_array_json(pm25_list) tmp2 as e2 lateral view explode_json_array_json(pm10_list) tmp3 as e3 lateral view explode_json_array_json(co_list) tmp4 as e4 lateral view explode_json_array_json(no2_list) tmp5 as e5 lateral view explode_json_array_json(so2_list) tmp6 as e6 lateral view explode_json_array_json(o3_list) tmp7 as e7 lateral view explode_json_array_json(aqi_list) tmp8 as e8 lateral view explode_json_array_json(tsp_list) tmp9 as e9 where air_region_key = #{ranking} and update_time between date_sub(date_format(&apos;${sTime}&apos;, '%Y-%m-%d'), interval 1 YEAR) and date_sub(date_format(&apos;${eTime}&apos;,'%Y-%m-%d'), interval 1 YEAR) )优化一下该sql查询,现在太慢了
03-11
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值