Ajax query format with Elasticsearch

See also questions close to this topic

• Javascript push() - undefined output

  I currently try to safe data of different users in an array using the push() function.
  Here is my current code:

  function data()
  {
  
      var information = [];
      var imgs = '';
      var percentage;
  
      var imgs = 'ABC';
      var percentage = '1';
  
      information.push({ imgs: imgs, chance: percentage });
  
      var imgs = 'DEF';
      var percentage = '2';
  
      information.push({ imgs: imgs, chance: percentage });
  
      console.log(information);
  
      information.forEach(function(deposit)
      {
          var deposit=deposit.imgs;
          var chance=deposit.chance;
  
          console.log(deposit);
          console.log(chance);
      });
  
  
  }
  

  This is the output of console.log(information):

  [ { imgs: 'ABC', chance: '1' }, { imgs: 'DEF', chance: '2' } ]
  

  And this is the output of information.forEach(function(deposit):

  ABC
  undefined
  DEF
  undefined
  

  At that's my problem. As you can see, it outputs the chance as undefined however it should output 1 and 2. Anyone know why it do that and know how I can fix it?
• Pymongo MapReduce as sum of subarray element

  I'm trying to perform MapReduce on this kind of data set:

   {
  "_id": "599861ce7ce78cd973746906",
  "name": "Macias Rosario",
  "col": [
    {
      "date": "15/03/2016",
      "name": "MAGNEATO",
      "amount": 313.86
    },
    {
      "date": "08/08/2016",
      "name": "FORTEAN",
      "amount": 151.06
    },
    {
      "date": "05/11/2014",
      "name": "ECRATIC",
      "amount": 291.68
    }
  ]
  

  }

  Goal is to sum up all amount for name Macias Rosario. Currently I did with my code to group all by subelements this.col.name on this way:

  mapper = Code("""
                             function() {   
                             for (var index = 0; index < this.col.length; ++index) {
                                  var col = this.col[index];
                                  emit(col.name, col.amount );
                              }   
                             }
                             """)
          reducer = Code("""
                             function(key, values) {
                                 var total =  0;
                                 for( var i = 0; i < values.length; ++i){
                                      total += values[i];
  
  
                                 }
                                 return value.price;
                             }
                 """)
          result = collection.map_reduce(mapper, reducer, "myresult")
  

  Has anyone have some idea how to reference, or group by this.name and not this.col.name because I don't know anymore and I'm driving nuts? PS don't suggest me to use aggregate, did that way, want to try on this way also :) Kind regards,
• How to fit JSON.parse into Promise.all?

  I got this code to retrieve a batch of matches from Riot Games League of Legends API:

  const matches = await Promise.all(matchlist.matches.map(function(match){
      return qRequest(server, "/match/v3/matches/" + match.gameId);
  }));
  

  The return value is a JSON formatted String. So matches ends up beeing an array of JSON Strings. I need the JSON parsed though, so that matches is an array of objects.

  I just can't wrap my head around how to fit JSON.parse in here?
• I'm trying to trigger the HTML5 color picker's popup with JQuery

  When an input[type=color] is clicked, a color picker opens in a popup window. I'd like to trigger this with JS.

  HTML

  <div id="customColorPick"></div>
  <input id="customColorPickInput" type="color" />
  

  JQuery

  $("#customColorPick").click(function() {
      $("#customColorPickInput").click();
  });
  

  Why does this not work?
• Decimal one place input type only number Ionic 3 latest version (3.9.2) I'm using

  I'm using ionic latest version 3.9.2. and I'm facing one problem. I have one input box. input type number, when user input in text box they allow only one digit after the decimal. and in input box maximum only one decimal allow not more than one.

  Examples: 
  1) 1407.1
  2) 6449496.8
  3) 1.1
  

  Like this only user can input one digit after decimal
• Q.all promise never runs then callback

  I am bit lost as to how Q.all works. I have the following code snippet (jsfiddle):

  function callUrl(remoteEndPoint){
    return $.ajax({
      url: remoteEndPoint,
      method: "GET",
      dataType: "json",
      contentType: "application/json; charset=utf-8",
      success: function (data) {
        console.dir(data);
      },
      error: function (xhr, textStatus, errorThrown) {
              console.error("error");
      }
    });
  }
  Q.all([callUrl("https://httpbin.org/get"), callUrl("https://httpbin.org/undefined")]).then(function(){
      console.log("Done");
  });
  

  The first call to callUrl will succeed, the second will fail (will return an error as the url does not exist). I am expecting the Q.all to execute the then callback like what ajax.always does but this isn't the case.

  Am I doing something wrong?
• Sending Primary Key of object via Ajax

  How to send primary key(pk) of the SELECTED object via AJAX. I tried {{pk}}, but unsuccessful. I am getting an error "Uncaught error" unexpected token}

  {% extends 'homepage.html' %}
  {% load staticfiles %}
  
  {% block teacher_diary %}
  <script language="JavaScript"  src="http://ajax.googleapis.com/ajax/libs/jquery/1.10.0/jquery.min.js"></script>
  <script type="text/javascript">
      $(document).ready(function(){
          $('#grade_list').change(function(){
          var element = document.getElementById("grade_list");
          var value = element.options[element.selectedIndex].value;
      $.ajax({
          url: "get_subject/",
          type: "get",
          data: {
              'grade_id': value.{{ pk }}
          },
          dataType: "json"
      });
  
  })});
  </script>
  <select id="grade_list">
      {% for grade in grades %}
          <option >{{ grade }}</option>
      {% endfor %}
  </select>
  
• Error 500 on Ajax Call

  So I am developing a website where users can write articles. I'm coming across a problem. When a user writes a short article it works fine, but when a user writes or edits a longer article it gives me an Ajax 500 Error in the console. I'm not sure if the problem is happening because I'm working with CKEditor. Anyways this is the code I'm using to send my article with Ajax:

  var name        = $(".article_name").val().trim(),
      image       = $("#article_input").val(),
      category_id = $(".txtArticleCategory").val().trim(),
      short_body  = $(".txtShortBodyArticle").val().trim(),
      tags        = $(".txtTagsArticle").val().trim(),
      body        = CKEDITOR.instances['txtArticleBody'].getData();
  
      if(name !== "" && image !== "" && category_id > 0 && body !== "" && short_body !== "" && tags !== ""){    
        var formData = new FormData($('#insertArticleForm')[0]);
        formData.append("body", body);
  
        $.ajax({
            xhr: function() {
              var xhr = new window.XMLHttpRequest();
  
              xhr.upload.addEventListener("progress", function(evt) {
                if (evt.lengthComputable) {
                  var percentComplete = evt.loaded / evt.total;
                  percentComplete = parseInt(percentComplete * 100);
  
                  //update progress bar width
                  $('.progress-bar-custom > span').css('width', percentComplete + "%");    
                }
              }, false);
  
              return xhr;
            },
            type: "POST",
            url: '/actions/update_article.php',
            data: formData,
            processData: false,
            contentType: false,
            success: function (data) {
                $('.progress-bar-custom').css('display', 'none');
                $('.progress-bar-custom > span').css('width', '0%');
  
                if(data == 'true'){
                  // Empty textboxes
                  $(".article_name, .txtArticleCategory").val("");
                  CKEDITOR.instances['txtArticleBody'].setData("");
  
                  alert('Article added.');
                }else if (data == "size") {
                  alert('Image too big. Max size is 2mb');
                }else if (data == "false") {
                  alert('Error, please try again.');
                }
            },
            error: function(){
              alert('Error, please try again.');
            }
        });
      }else{
        alert("Complete a text fields.");
      }
    });
  

  This is the error i'm getting:

  jquery.min.js:4 POST http://sub.domain.net/actions/update_article.php 500 (Internal Server Error)
  

  The error only happens when I try adding or editing a large article, anyone know why this is happening or how I can fix it? Any help is appreciated.
• Ajax MYSQL search and sorting results

  Trying to find out how to add sort option of my mysql results that are fetched with Ajax functionality. Sorting by mysql columns or something. Below are some "th" sections where I would like to have sorting options implemented.

  HTML page

  <html>
   <head>
    <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
    <title>Tool details</title>
    <script src="https://ajax.googleapis.com/ajax/libs/jquery/2.1.3/jquery.min.js"></script>
    <script src="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.6/js/bootstrap.min.js"></script>
    <link href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.6/css/bootstrap.min.css" rel="stylesheet" />
   </head>
   <body>
  <input type="text" name="search_text" id="search_text" placeholder="Search for tool details" class="form-control" />
  <div id="result"></div>
  
  <script>
  $(document).ready(function(){
  
      load_data();
  
      function load_data(query)
      {
          $.ajax({
              url:"fetch.php",
              method:"POST",
              data:{query:query},
              success:function(data) {
                  $('#result').html(data);
              }
          });
      }
  
      $('#search_text').keyup(function(){
          var search = $(this).val();
          if(search != '') {
              load_data(search);
          } else {
              load_data();
          }
      });
  });
  </script>
  </body>
  </html>
  

  Please not that sorting is added only for ID column at the moment to avoid complicating code here.

  fetch.php

  <?php
  //fetch.php
  include($_SERVER['DOCUMENT_ROOT'].'/db/connect-db.php');
  
  $output = '';
  if(isset($_POST["query"])) {
      $search = mysqli_real_escape_string($connection, $_POST["query"]);
      $query = "SELECT * FROM tools
                  WHERE toolsn LIKE '%".$search."%'
                  OR toolcategory LIKE '%".$search."%'
                  OR tooldesc LIKE '%".$search."%'
                  OR toolpn LIKE '%".$search."%'
                  OR toolstatus LIKE '%".$search."%'";
  } else {
      $query = "SELECT * FROM tools ORDER BY id";
  }
  $result = mysqli_query($connection, $query);
  //get feedback why database not working
  if (!$result) {
      printf("Error: %s\n", mysqli_error($connection));
      exit();
  }
  if(mysqli_num_rows($result) > 0) {
      $output .= '
                  <div class="table-responsive">
                  <table class="table table bordered">
                  <tr>
                   <th>Customer Name</th>
                   <th>Address</th>
                   <th>City</th>
                   <th>Postal Code</th>
                   <th>Country</th>
                  </tr>';
      while($row = mysqli_fetch_array($result)) {
          $output .= '<tr>
                      <td>'.$row["tooldesc"].'</td>
                      <td>'.$row["toolcategory"].'</td>
                      <td>'.$row["toolsn"].'</td>
                      <td>'.$row["toolpn"].'</td>
                      <td>'.$row["toolstatus"].'</td>
                  </tr>';
      }
      echo $output;
  }else {
      echo 'Data Not Found';
  }
  ?>
  
• cURL error 7 failed to connect port 80 in Laravel

  I have called 3rd party yahoo API in my wordpress project using cURL wherein I am facing error regarding cURL error 7 connection failed . I have white listed the IP of yahoo API in wordpress.

  Code from comments:

  $client = new \GuzzleHttp\Client(); 
  $from_Currency = substr($proj->currency, 0, 3); 
  $to_Currency = $req->currency; 
  $encode_amount = 1; 
  $get = $client->get("google.com/finance/… json"); 
  $get = explode("<span class=bld>",$get); 
  $get = explode("</span>",$get[1]); 
  $converted_currency = preg_replace("/[^0-9\.]/", null, $get[0]); 
  return $converted_currency;
  
• phpBB remote POST login using CURL

  i have been trying to write a class to log in to a phpBB forum using username and password and if success, return true.

  This class can also save the cookies for the users session into a cookie file which it later can use to get a forum thread. Also, i know the cookie file is writeable, as it sets new cookies if old is deleted.

  I had some success, but then i have to manually set the cookies from a session i make by logging in with my browser, but this expires after x time which makes it a pain in the a** to maintain.

  I know for a fact that my account is not blocked, as it works in a regular browser.

  This is the response i get now: Whoops... look's like you're lost! Come home!

  Here is the code i use:

  public function _post($endpoint = '', array $params = [], $cookieStorage = false) {
      $ch = curl_init();
      curl_setopt($ch, CURLOPT_URL, $endpoint);
      curl_setopt($ch, CURLOPT_POST, 1);
      curl_setopt($ch, CURLOPT_POSTFIELDS, http_build_query($params));
      curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);
      curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, FALSE);
      if ($cookieStorage != FALSE) {
          curl_setopt($ch, CURLOPT_USERAGENT, 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_10_5) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/60.0.3112.101 Safari/537.36');
          curl_setopt($ch, CURLOPT_COOKIEJAR, $cookieStorage);
          curl_setopt($ch, CURLOPT_COOKIEFILE, $cookieStorage);
      }
      $response = curl_exec($ch);
      curl_close($ch);
      return $response;
  }
  
  public function login($username = '', $password = '') {
      $result = $this->_post(self::$BASE_URL . '/ucp.php?mode=login', [
          'username' => $username,
          'password' => $password,
          'redirect' => '/viewforum.php',
          'login' => 'Login',
          'sid' => ''
              ], $this->cookieFile);
      if (preg_match('/' . $username . '/i', $result)) {
          return TRUE;
      } elseif (preg_match('/whoops/i', $result)) {
          return $result;
      } else {
          return FALSE;
      }
  }
  
• Passing ID from json to controller with codeigniter CURL

  Hello i new on codeigniter, and i have problem when i develop my first website

  I have an API, here my url API example

  API SHOW ALL ARTICLES

  http://localhost/vectorkey/oneportalbackend/api/articles
  

  API DETAIL ARTICLES

  http://localhost/vectorkey/oneportalbackend/api/articles?id_news=13
  

  that API is show articles data with id_news is equal 13

  I want show the detail articles with that API , and fill the parameter id_news dynamically when i click button in my website.

  here my button code:

   <a href="<?= base_url().'admin/Articles/detail/'.$row->id_news ?>">
                              <button class="btn btn-xs btn-default" type="button" data-toggle="tooltip" title="Detail"><i class="fa fa-eye"></i></button>
                              </a>
  

  i tried many times,but i don't know to passing id_news to the controller, here my controller code :

  public function detail()
  {
      $data['master'] = json_decode($this->curl->simple_get('http://localhost/vectorkey/oneportalbackend/api/articles')); 
      $data['datanews'] = json_decode($this->curl->simple_get('http://localhost/vectorkey/oneportalbackend/api/articles?id_news='.$data['master']['id_news']));
  
      $this->load->view('admin/articles_detail',$data);
  }
  

  i got an error

  A PHP Error was encountered
  
  Severity: Notice
  
  Message: Undefined index: id_news
  
  Filename: admin/Articles.php
  
  Line Number: 106
  
  Backtrace:
  
  File: D:\RIFQI_FILE\xampp\htdocs\vectorkey\oneportal\application\controllers\admin\Articles.php
  Line: 106
  Function: _error_handler
  
  File: D:\RIFQI_FILE\xampp\htdocs\vectorkey\oneportal\index.php
  Line: 304
  Function: require_once
  
• What is the best for word lookup Redis vs Elastic search?

  I am working on a fourms like project and I want to work on Bad Word Detector and I want to be scale-able and fast so I am thinking of using Redis or Elastic search to store the words and allow the admin user to add more words then to split the user comment to words and look for it in this dictionary to block the comment if it contains a bad word.

  I tried to find a software provides a memory based Trie data structure to make as fast as I can but no luck.

  Am i right by thinking of Redis and Elastic search to implement this feature or I am over engineer it? Also is there is any ready made server side app for that??

  And please notice that it won't be in English so I can't use any ready made dictionary.
• java.lang.NoClassDefFoundError: org/apache/logging/log4j/Logger

  I want to perform unit testing in Elasticsearch for that I am using Java-test-framework
  I am using Elasticsearch-1.6.0 and referring to these link for help https://www.elastic.co/guide/en/elasticsearch/reference/1.6/using-elasticsearch-test-classes.html https://github.com/elastic/elasticsearch/blob/master/core/src/test/java/org/elasticsearch/action/search/SearchRequestBuilderTests.java

  here is the code

  class CampaignESTest extends ESTestCase {
  
    def getCLient():MockTransportClient={
       val settings = Settings.builder()
                  .put(Environment.PATH_HOME_SETTING.getKey(), Files.createTempDir().toString())
                  .build();
       val client = new MockTransportClient(settings);  
       client
    }
   }
  
  class CampaignTestSearch extends PlaySpec{
    val client=new CampaignESTest
  
  val response = client.prepareSearch("dbtest")
        .setTypes(CAMPAIGN_COLLECTION_NAME)
        .setSearchType(SearchType.DFS_QUERY_THEN_FETCH)
        .addFields("uuid","campaignName","artworkID","activationDate","_source")
        .setQuery(query)
        .execute()
        .actionGet()
    }
  

  I am getting this exception

    DeferredAbortedSuite:
  [info] Exception encountered when attempting to run a suite with class name: org.scalatest.DeferredAbortedSuite *** ABORTED ***
  [info]   java.lang.NoClassDefFoundError: org/apache/logging/log4j/Logger
  [info]   at org.elasticsearch.common.logging.Loggers.getLogger(Loggers.java:101)
  [info]   at org.elasticsearch.bootstrap.Bootstrap.initializeNatives(Bootstrap.java:92)
  [info]   at org.elasticsearch.bootstrap.BootstrapForTesting.<clinit>(BootstrapForTesting.java:78)
  [info]   at org.elasticsearch.test.ESTestCase.<clinit>(ESTestCase.java:138)
  [info]   at testcontrollers.campaign.CampaignTestSerach.<init>(CampaignTestSerach.scala:40)
  [info]   at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
  [info]   at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
  [info]   at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
  [info]   at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
  [info]   at java.lang.Class.newInstance(Class.java:442)
  [info]   ...
  [info]   Cause: java.lang.ClassNotFoundException: org.apache.logging.log4j.Logger
  [info]   at java.net.URLClassLoader.findClass(URLClassLoader.java:381)
  [info]   at java.lang.ClassLoader.loadClass(ClassLoader.java:424)
  [info]   at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:331)
  [info]   at java.lang.ClassLoader.loadClass(ClassLoader.java:357)
  [info]   at org.elasticsearch.common.logging.Loggers.getLogger(Loggers.java:101)
  [info]   at org.elasticsearch.bootstrap.Bootstrap.initializeNatives(Bootstrap.java:92)
  [info]   at org.elasticsearch.bootstrap.BootstrapForTesting.<clinit>(BootstrapForTesting.java:78)
  [info]   at org.elasticsearch.test.ESTestCase.<clinit>(ESTestCase.java:138)
  [info]   at testcontrollers.campaign.CampaignTestSerach.<init>(CampaignTestSerach.scala:40)
  [info]   at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
  [info]   ...
  [error] Uncaught exception when running testcontrollers.campaign.CampaignTestSerach: java.lang.NoClassDefFoundError: org/apache/logging/log4j/Logger
  

  getting an exception on this line

  val client=new CampaignESTest
  

  in class CampaignTestSearch

  here are the dependencies in build.sbt file

     "org.slf4j" % "slf4j-api" % "1.6.4",
                  "org.elasticsearch" % "elasticsearch" % "1.6.0",
                  "org.elasticsearch.test" % "framework" % "5.0.0" % "test",
                  "org.apache.lucene" % "lucene-test-framework" % "4.10.4" % "test",
                  "com.carrotsearch.randomizedtesting" % "randomizedtesting-runner" % "1.6.0" % "test",
                  "org.apache.lucene" % "lucene-codecs" % "4.10.4" % "test",
                  "org.apache.logging.log4j" % "log4j-core" % "2.8.2" ,
  "org.apache.lucene" % "lucene-expressions" % "4.10.4",
  

  i suspect the cause of the exception maybe due to some versions of the dependencies can anyone please help with the correct library dependency version to make it to work or is there something else which i am missing

  Edit removed "test" from "org.apache.logging.log4j" % "log4j-core" % "2.8.2" Update build.sbt

  "org.slf4j" % "slf4j-api" % "1.6.4",
                  "org.elasticsearch" % "elasticsearch" % "1.6.0",
                  "org.elasticsearch.test" % "framework" % "5.0.0" % "test",
                  "org.apache.lucene" % "lucene-test-framework" % "4.10.4" % "test",
                  "com.carrotsearch.randomizedtesting" % "randomizedtesting-runner" % "1.6.0" % "test",
                  "org.apache.lucene" % "lucene-codecs" % "4.10.4" % "test",
                  "org.apache.logging.log4j" % "log4j-core" % "2.8.2",
                  "org.apache.logging.log4j" % "log4j-slf4j-impl" % "2.8.2" ,
                  "org.apache.lucene" % "lucene-expressions" % "4.10.4",
  
• Elasticsearch - how to get result sorted by metric with multiple aggregations

  Basically we want to make a query semantically similar to the following SQL：

  SELECT field1,field2,count(*) FROM table GROUP BY field1,field2 ORDER BY count(*)

  Any idea how can we do this in Elasticsearch?

  What we tried is like following, of course this just get the second level buckets sorted...

  {
    "size": 0,
    "aggs": {
      "eventType": {
        "terms": {
          "field": "eventType"
        },
        "aggs": {
          "hostIpAddr": {
            "terms": {
              "field": "hostIpAddr",
              "order": {
                "_cnt": "desc"
              }
            },
            "aggs": {
              "_cnt": {
                "sum": {
                  "field": "COUNT(*)"
                }
              }
            }
          }
        }
      }
    }
  }