parser

Написать ответ на текущее сообщение

 

 
   команды управления поиском

Работает и с фасетами...

Sumo 14.11 21:41 / 14.11 21:42

Если внимательно написать запросы, которые костя показывал. У меня сейчас третий Сфинкс, но и для второго по тоже работает — я пробовал когда ввели фичу.

Хеш, где ключами будут 0 для запроса и 1 и 2 для фасетов. А в значениях — таблички.
  ^connect[$core.sphinx.connectString]{
    $res[^hash::sql{
      select 0, account_id, address
      from index_1
      where match('иванов')
            and period in ('2026-01-01', '2026-02-01')
      limit 10
      facet 1, region_id, region_name
      facet 2, period, mc_name
    }[
      $.type[table]
      $.distinct(true)
    ]]
  }
  <pre>
    ^json:string[$res;$.indent(true)]
  </pre>

{
	"0":[
		{"0":"0","account_id":"10108...","address":"..."},
		{"0":"0","account_id":"10114...","address":"..."},
		{"0":"0","account_id":"10504...","address":"..."},
		{"0":"0","account_id":"10507...","address":"..."},
		{"0":"0","account_id":"10582...","address":"..."},
		{"0":"0","account_id":"10603...","address":"..."},
		{"0":"0","account_id":"10604...","address":"..."},
		{"0":"0","account_id":"10507...","address":"..."},
		{"0":"0","account_id":"10401...","address":"..."},
		{"0":"0","account_id":"10606...","address":"..."}
	],
	"1":[
		{"1":"1","region_id":"101","region_name":"...","count(*)":"18"},
		{"1":"1","region_id":"105","region_name":"...","count(*)":"17"},
		{"1":"1","region_id":"106","region_name":"...","count(*)":"11"},
		{"1":"1","region_id":"104","region_name":"...","count(*)":"6"},
		{"1":"1","region_id":"107","region_name":"...","count(*)":"11"},
		{"1":"1","region_id":"108","region_name":"...","count(*)":"10"},
		{"1":"1","region_id":"102","region_name":"...","count(*)":"5"},
		{"1":"1","region_id":"103","region_name":"...","count(*)":"2"},
		{"1":"1","region_id":"109","region_name":"...","count(*)":"2"}
	],
	"2":[
		{"2":"2","period":"2026-02-01","mc_name":"..."},
		{"2":"2","period":"2026-02-01","mc_name":"..."},
		{"2":"2","period":"2026-02-01","mc_name":"..."},
		{"2":"2","period":"2026-01-01","mc_name":"..."}
	]
}
и тоже самое, но в массив таблиц...
  ^connect[$core.sphinx.connectString]{
    $res[^array::sql{
      select 0, account_id, address
      from index_1
      where match('иванов')
            and period in ('2026-01-01', '2026-02-01')
      limit 10
      facet 1, region_id, region_name
      facet 2, period, mc_name
    }[
      $.type[table]
      $.distinct(true)
      $.sparse(true)
    ]]
  }
  <pre>
    ^json:string[$res;$.indent(true)]
  </pre>

[
	[
		{"0":"0","account_id":"10108...","address":"..."},
		{"0":"0","account_id":"10114...","address":"..."},
		{"0":"0","account_id":"10504...","address":"..."},
		{"0":"0","account_id":"10507...","address":"..."},
		{"0":"0","account_id":"10582...","address":"..."},
		{"0":"0","account_id":"10603...","address":"..."},
		{"0":"0","account_id":"10604...","address":"..."},
		{"0":"0","account_id":"10507...","address":"..."},
		{"0":"0","account_id":"10401...","address":"..."},
		{"0":"0","account_id":"10606...","address":"..."}
	],
	[
		{"1":"1","region_id":"101","region_name":"...","count(*)":"18"},
		{"1":"1","region_id":"105","region_name":"...","count(*)":"17"},
		{"1":"1","region_id":"106","region_name":"...","count(*)":"11"},
		{"1":"1","region_id":"104","region_name":"...","count(*)":"6"},
		{"1":"1","region_id":"107","region_name":"...","count(*)":"11"},
		{"1":"1","region_id":"108","region_name":"...","count(*)":"10"},
		{"1":"1","region_id":"102","region_name":"...","count(*)":"5"},
		{"1":"1","region_id":"103","region_name":"...","count(*)":"2"},
		{"1":"1","region_id":"109","region_name":"...","count(*)":"2"}
	],
	[
		{"2":"2","period":"2026-02-01","mc_name":"..."},
		{"2":"2","period":"2026-02-01","mc_name":"..."},
		{"2":"2","period":"2026-02-01","mc_name":"..."},
		{"2":"2","period":"2026-01-01","mc_name":"..."}
	]
]
А дальше вытаскиваем уже по номеру результата.