searchPerformanceByTerm.js 1.3 KB

123456789101112131415161718192021222324252627282930313233343536373839404142
  1. var input = JSON.parse(decodeURIComponent(INPUT));
  2. var search = function(){
  3. var rtn = null;
  4. var mqlStr = "";
  5. try{
  6. // 有子对象
  7. if(input.defaultSubKey){
  8. var compiled = _.template("SELECT <%= bucket%>['<%= key%>'].time('<%= time%>').find(<%= defaultSubKey%>) FROM <%= className%> where id='<%= id%>'");
  9. mqlStr = compiled({
  10. bucket: input.bucket,
  11. key: input.key,
  12. time: input.time.join("','"),
  13. className: input.class,
  14. id: input.id,
  15. defaultSubKey: input.defaultSubKey
  16. });
  17. }
  18. // 没有子对象
  19. else{
  20. var compiled = _.template("SELECT <%= bucket%>['<%= key%>'].time('<%= time%>') FROM <%= className%> where id='<%= id%>'");
  21. mqlStr = compiled({
  22. bucket: input.bucket,
  23. key: input.key,
  24. time: input.time.join("','"),
  25. className: input.class,
  26. id: input.id
  27. });
  28. }
  29. rtn = {result:odb.mql(mqlStr).data[0][input.bucket],mql:mqlStr};
  30. }catch(err){
  31. return {result:err,mql:mqlStr};
  32. }
  33. return rtn;
  34. }
  35. OUTPUT = search();