ArFeRR
ArFeRR
/ gist:4c96ebd52e11419a1aef
Created
March 18, 2015 13:25
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| $script = new \Elastica\Script('doc["skus.stock"].values'); | |
| $scriptAggr = new \Elastica\Aggregation\Terms('script_aggr'); | |
| $scriptAggr->setScript($script); | |
| $scriptAggr->setParam('size', 100000); | |
| $nestedAggr = new \Elastica\Aggregation\Nested('nested_sku_aggr', 'skus'); | |
| $nestedAggr->addAggregation($scriptAggr); |
ArFeRR
/ gist:eea60d1e82e3a7fb5e6c
Created
March 17, 2015 13:36
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| { | |
| "_index":"parfums", | |
| "_type":"sku", | |
| "_id":"237080", | |
| "_version":1, | |
| "found":true, | |
| "_source":{ | |
| "id":237080, | |
| "nameRu":"парфюмированная вода 50 мл", | |
| "priceOriginal":908, |
ArFeRR
/ gist:1ea0bb5be124dfb1d5db
Created
March 17, 2015 13:27
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| { | |
| "query":{ | |
| "filtered":{ | |
| "filter":{ | |
| "bool":{ | |
| "must":[ | |
| { | |
| "range":{ | |
| "skus.stock":{ | |
| "gt":0, |
ArFeRR
/ gist:1e13c718c0ba9af29db2
Created
March 17, 2015 13:17
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| { | |
| "query":{ | |
| "filtered":{ | |
| "filter":{ | |
| "bool":{ | |
| "must":[ | |
| { | |
| "range":{ | |
| "skus.stock":{ | |
| "gt":0, |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| { | |
| "parfums":{ | |
| "mappings":{ | |
| "product":{ | |
| "_meta":{ | |
| "model":"Parfums\\ProductBundle\\Entity\\Product" | |
| }, | |
| "properties":{ | |
| "brand":{ | |
| "properties":{ |
ArFeRR
/ gist:772a75775dd972e72778
Created
November 26, 2014 14:03
the product index, to which i'm writing a queries
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| { | |
| "parfums" : { | |
| "mappings" : { | |
| "product" : { | |
| "_meta" : { | |
| "model" : "Parfums\\ProductBundle\\Entity\\Product" | |
| }, | |
| "properties" : { | |
| "brand" : { | |
| "properties" : { |
ArFeRR
/ gist:12610c52a57dce9b0728
Created
November 26, 2014 14:00
elasticsearch query, doesn't work
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| { | |
| "query":{ | |
| "filtered":{ | |
| "filter":{ | |
| "bool":{ | |
| "must":[ | |
| { | |
| "range":{ | |
| "skus.stock":{ | |
| "gt":0, |
ArFeRR
/ gist:3976778079d64d5a72cd
Created
July 15, 2014 08:21
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| { | |
| "took" : 31, | |
| "timed_out" : false, | |
| "_shards" : { | |
| "total" : 5, | |
| "successful" : 5, | |
| "failed" : 0 | |
| }, | |
| "hits" : { | |
| "total" : 4, |
ArFeRR
/ gist:97671e54515dfd7be012
Created
July 14, 2014 16:39
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| { | |
| "filtered":{ | |
| "filter":{ | |
| "bool":{ | |
| "must":[ | |
| { | |
| "bool":{ | |
| "should":[ | |
| { | |
| "bool":{ |
ArFeRR
/ gist:6ea7a3e55335032e2d37
Created
July 14, 2014 16:39
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| {"filtered":{"filter":{"bool":{"must":[{"bool":{"should":[{"bool":{"must":[{"term":{"productsOptionValues.productOption":"weight"}},{"term":{"productsOptionValues.value":"2,7 kg"}}]}}]}},{"bool":{"should":[{"bool":{"must":[{"term":{"productsOptionValues.productOption":"resolution"}},{"term":{"productsOptionValues.value":"1600x900"}}]}},{"bool":{"must":[{"term":{"productsOptionValues.productOption":"resolution"}},{"term":{"productsOptionValues.value":"1920x1080"}}]}}]}}]}}}} |
NewerOlder