123456789101112131415161718192021222324252627282930313233343536373839404142 |
- var input = JSON.parse(decodeURIComponent(INPUT));
- var search = function(){
- var rtn = null;
- var mqlStr = "";
- try{
-
- // 有子对象
- if(input.defaultSubKey){
- var compiled = _.template("SELECT <%= bucket%>['<%= key%>'].time('<%= time%>').find(<%= defaultSubKey%>) FROM <%= className%> where id='<%= id%>'");
-
- mqlStr = compiled({
- bucket: input.bucket,
- key: input.key,
- time: input.time.join("','"),
- className: input.class,
- id: input.id,
- defaultSubKey: input.defaultSubKey
- });
- }
- // 没有子对象
- else{
- var compiled = _.template("SELECT <%= bucket%>['<%= key%>'].time('<%= time%>') FROM <%= className%> where id='<%= id%>'");
-
- mqlStr = compiled({
- bucket: input.bucket,
- key: input.key,
- time: input.time.join("','"),
- className: input.class,
- id: input.id
- });
- }
-
-
- rtn = {result:odb.mql(mqlStr).data[0][input.bucket],mql:mqlStr};
- }catch(err){
- return {result:err,mql:mqlStr};
- }
- return rtn;
- }
- OUTPUT = search();
|