simon28082 / elasticsearch Goto Github PK

View Code? Open in Web Editor NEW

103.0 2.0 15.0 105 KB

Use SQL statements to query elasticsearch

License: MIT License

PHP 100.00%

elasticsearch laravel query orm php sql

elasticsearch's People

Contributors

Stargazers

Watchers

Forkers

x12311231 529834149 zhenyangze ivancoacher zhangkch fanglinks zhengbingithub imanner leirhy ilizhu qq11243094 1cool filefox allesx mohsenmojadam2019

elasticsearch's Issues

Can not find user: anonymous

es 有账号密码时添加数据报错：

{"status":401,"message":"Can not find user: anonymous"}

创建索引时：

    $hosts  = [
        config("elasticsearch.host")
    ];
    $client = ClientBuilder::create()
                           ->setHosts($hosts) 
                           ->setBasicAuthentication(config("elasticsearch.username"), config("elasticsearch.password"))
                           ->build();

可以正常执行，那添加数据时，如何传递账号密码？

$this->builder->index($index);

Support for elasticsearch 7

Will ES 7 support be done
thank you so much

关于 No alive nodes found in your cluster in 问题

composer下来后运行查询报错
product.ERROR: Elasticsearch\Common\Exceptions\NoNodesAvailableException: No alive nodes found in your cluster in F:\WNMP\WWW\product_houtai_hn\vendor\elasticsearch\elasticsearch\src\Elasticsearch\ConnectionPool\StaticNoPingConnectionPool.php:53
Stack trace:

百度好久了找不到解决方法呃。。。

其他框架怎么使用这个？

Call to undefined function CrCms\ElasticSearch\array_pull()

query：
$builder = $this->builder->index('index')->type('type');
$result = $builder->whereTerm('id',10015)->first();

error:
Call to undefined function CrCms\ElasticSearch\array_pull()
at vendor/crcms/elasticsearch/src/Grammar.php:62

orWhereMatch的默认参数有问题

public function orWhereMatch($field, $value, $boolean = 'and'): self
{
return $this->whereMatch($field, $value, $boolean);
}
应该是：
public function orWhereMatch($field, $value, $boolean = 'or'): self
{
return $this->whereMatch($field, $value, $boolean);
}

怎么获取 aggBy 得到的数据

public function get(): Collection
{
     $results = $this->runQuery($this->grammar->compileSelect($this));

     return $this->metaData($results);
}

protected function metaData(array $results): Collection
{
     return collect($results['hits']['hits'])->map(function ($hit) {
          return $this->sourceToObject($hit);
      });
}

这里直接抛弃了 aggregations 中的数据，仅返回 hits 数据么，那我该怎么获取aggregations中的数据呢？

Builder类分页paginate方法有报错

        $maxPage = intval(ceil($results['hits']['total'] / $perPage));

        return collect([
            'total'        => $results['hits']['total'],
            'per_page'     => $perPage,
            'current_page' => $page,
            'next_page'    => $page < $maxPage ? $page + 1 : $maxPage,
            //'last_page' => $maxPage,
            'total_pages' => $maxPage,
            'from'        => $from,
            'to'          => $from + $perPage,
            'data'        => $data,
        ]);

应改为

       $maxPage = intval(ceil($results['hits']['total']['value'] / $perPage));

        return collect([
            'total'        => $results['hits']['total']['value'],
            'per_page'     => $perPage,
            'current_page' => $page,
            'next_page'    => $page < $maxPage ? $page + 1 : $maxPage,
            //'last_page' => $maxPage,
            'total_pages' => $maxPage,
            'from'        => $from,
            'to'          => $from + $perPage,
            'data'        => $data,
        ]);

因为$results打印为

array:4 [▼
  "took" => 5
  "timed_out" => false
  "_shards" => array:4 [▼
    "total" => 1
    "successful" => 1
    "skipped" => 0
    "failed" => 0
  ]
  "hits" => array:3 [▼
    "total" => array:2 [▼
      "value" => 176
      "relation" => "eq"
    ]
    "max_score" => 1.0
    "hits" => array:15 [▶]
  ]
]