接着搞【附近】---Elasticsearch还是Postgre？（四）

select * from user where uid = 'xiaodushe'

select * from tiantuan where name = '老李'

select id from user where description like '%行军途中曾经背过炊事班的黑锅%' or description like '%年轻时是十里八乡有名的俊后生%' or description like '%曾经从事过编筐篾匠手工艺行业%'

曾经和老李在一个班服役  =》 丁炸桥一度说过学习学个屁啊    =》 丁炸桥泥腿子                 =》 丁炸桥，孔过瘾，老李差点儿被山本端了老窝    =》 孔过瘾 曾经服役于独立团        =》 孔过瘾，老李曾经从事过编筐篾匠手工艺行业 =》 老李年轻时是十里八乡有名的俊后生 =》 老李行军途中曾经背过炊事班的黑锅 =》 老李

泥腿子                     = {丁炸桥，孔过瘾，老李}曾经服役于独立团            = {孔过瘾，老李}曾经从事过编筐篾匠手工艺行业 = {老李}年轻时是十里八乡有名的俊后生 = {老李}行军途中曾经背过炊事班的黑锅 = {老李}

brew install elasticsearchbrew services start elasticsearch// 然而默认服务启动后，IP是监听在127.0.0.1：9200上// 所以配置需要修改一下sudo vim /usr/local/etc/elasticsearch/elasticsearch.yml// 找到network.host: 127.0.0.1// 修改成你自己的IP地址// 重启ES服务brew services restart elasticesearch// 确认下服务状态？netstat -ant | grep 9200

curl -X PUT \  http://192.168.199.225:9200/momo \  -H 'Accept: */*' \  -H 'Cache-Control: no-cache' \  -H 'Connection: keep-alive' \  -H 'Content-Type: application/json' \  -H 'Host: 192.168.199.225:9200' \  -H 'Postman-Token: d4c2303e-983d-49a9-a7d4-79f2b78ea6a3,4913986c-8cbe-4439-b7fd-80794b2a0bdc' \  -H 'User-Agent: PostmanRuntime/7.15.0' \  -H 'accept-encoding: gzip, deflate' \  -H 'cache-control: no-cache' \  -H 'content-length: 361' \  -d '{    "mappings" : {        "user" : {            "properties" : {                "age" : {                    "type" : "integer"                },                "gender" : {                    "type" : "integer"                },                "location" : {                    "type" : "geo_point"                }            }        }    }}'

{    "acknowledged": true,    "shards_acknowledged": true,    "index": "user"}

<?phprequire 'vendor/autoload.php';use Elasticsearch\ClientBuilder;$client = ClientBuilder::create()->setHosts( array(  '192.168.199.225') )->build();
/*// 删除一条数据$params = [  'index' => 'momo',  'type'  => 'user',  'id'    => 1];$response = $client->delete( $params );print_r( $response );exit;*/// 造1000个假数据for( $i = 1; $i <= 1000; $i++ ) {   // 生成一个维度  $lat = mt_rand( 38, 40 ).'.'.mt_rand( 100000, 999999 );  // 生成一个经度  $lon = mt_rand( 115, 116 ).'.'.mt_rand( 100000, 999999 );  $params = array(    'index' => 'momo',    'type'  => 'user',    'id'    => $i,     'body'  => array(      'age'      => mt_rand( 18, 25 ),      'gender'   => mt_rand( 1, 2 ),      'location' => array(        'lat' => $lat,        'lon' => $lon,      ),    ),  );  $response = $client->index( $params );  print_r( $response );}

<?phprequire 'vendor/autoload.php';use Elasticsearch\ClientBuilder;$client = ClientBuilder::create()->setHosts( array(  '192.168.199.225') )->build();$params = array(  'index' => 'momo',  'type'  => 'user',  'body'  => array(    'query' => array(      // bool      "bool" => array(        "must" => array(          "match" => array(            'gender' => 2,          ),        ),        "filter" => array(          "range" => array(            "age" => array(              "gte" => 18,              "lte" => 18,            ),          ),        ),      ),  // bool END.    ), // query END.    'sort' => array(      '_geo_distance' => array(        "location" => array(          'lat' => 39.972023,           'lon' => 116.324356,        ),        'order' => 'asc',        'unit'  => 'km',        'distance_type' => 'plane',      ),    ),  // sort END.  ),  // query END);$response = $client->search( $params );foreach( $response['hits']['hits'] as $key => $item ) {  echo "用户ID：{$item['_id']}，性别：{$item['_source']['gender']}，年龄：{$item['_source']['age']}，距您：{$item['sort'][0]}KM".PHP_EOL;  }