searchBitlogByTerm.js 876 B

12345678910111213141516171819202122232425262728
  1. var input = JSON.parse(decodeURIComponent(INPUT));
  2. var search = function(){
  3. var rtn = null;
  4. var mqlStr = "";
  5. try{
  6. var compiled = _.template("SELECT <%= bucket%><%= key%>.time('<%= time%>')<%= words%><%= limit%> FROM <%= className%> where id='<%= id%>'");
  7. mqlStr = compiled({
  8. bucket: input.field,
  9. key: input.file?"['"+input.file+"']":'',
  10. time: input.time.join("','"),
  11. className: input.class,
  12. id: input.id,
  13. words: input.words.length>0?".find('"+input.words.join("','")+"')":'',
  14. limit: '.limit(2000)'
  15. });
  16. log.debug(mqlStr)
  17. rtn = {result:odb.mql(mqlStr).data[0][input.field],mql:mqlStr};
  18. }catch(err){
  19. return {result:err,mql:mqlStr};
  20. }
  21. return rtn;
  22. }
  23. OUTPUT = search();