Guest User

Untitled

a guest
Jun 19th, 2018
108
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 7.81 KB | None | 0 0
  1. indexer
  2. {
  3. }
  4.  
  5. searchd
  6. {
  7. address = 127.0.0.1
  8. port = 3312
  9. log = /Users/aroberts/Source/doggo/log/searchd.log
  10. query_log = /Users/aroberts/Source/doggo/log/searchd.query.log
  11. pid_file = /Users/aroberts/Source/doggo/log/searchd.development.pid
  12. max_matches = 20000
  13. }
  14.  
  15. source dog_core_0
  16. {
  17. type = mysql
  18. sql_host = localhost
  19. sql_user = root
  20. sql_pass =
  21. sql_db = dog_dev
  22. sql_query_pre = UPDATE `dogs` SET `delta` = 0 WHERE `delta` = 1
  23. sql_query_pre = SET NAMES utf8
  24. sql_query = SELECT `dogs`.`id` * 1 + 0 AS `id` , CAST(`dogs`.`state` AS CHAR) AS `state`, CAST(`dogs`.`breed` AS CHAR) AS `breed`, CAST(`dogs`.`call_name` AS CHAR) AS `call_name`, CAST(`dogs`.`registered_name` AS CHAR) AS `registered_name`, CAST(`dogs`.`registration` AS CHAR) AS `registration`, CAST(`dogs`.`collaborator` AS CHAR) AS `collaborator`, CAST(`dogs`.`coat_color` AS CHAR) AS `coat_color`, CAST(`dogs`.`gender` AS CHAR) AS `gender`, CAST(`dogs`.`id` AS CHAR) AS `dog_id`, CAST(`dogs`.`broad_number` AS CHAR) AS `broad_number`, CAST(`dogs`.`collaborator_number` AS CHAR) AS `collaborator_number`, CAST(`dogs`.`notes` AS CHAR) AS `notes`, CAST(`dogs`.`related_dogs_health` AS CHAR) AS `related_dogs_health`, CAST(GROUP_CONCAT(DISTINCT CONCAT_WS(' ', `people`.`first_name`, `people`.`middle_name`, `people`.`last_name`) SEPARATOR ' ') AS CHAR) AS `owner_name`, CAST(GROUP_CONCAT(DISTINCT CONCAT_WS(' ', `people`.`address1`, `people`.`address2`, `people`.`city`, `people`.`state`, `people`.`postal_code`, `people`.`country`) SEPARATOR ' ') AS CHAR) AS `owner_address`, CAST(GROUP_CONCAT(DISTINCT `people`.`state` SEPARATOR ' ') AS CHAR) AS `owner_state`, CAST(GROUP_CONCAT(DISTINCT `people`.`phone` SEPARATOR ' ') AS CHAR) AS `owner_phone`, CAST(GROUP_CONCAT(DISTINCT `people`.`mobile_phone` SEPARATOR ' ') AS CHAR) AS `owner_mobile_phone`, CAST(GROUP_CONCAT(DISTINCT `people`.`email` SEPARATOR ' ') AS CHAR) AS `owner_email`, CAST(CONCAT_WS(' ', `vets_dogs`.`first_name`, `vets_dogs`.`last_name`) AS CHAR) AS `vet_name`, CAST(CONCAT_WS(' ', `vets_dogs`.`address1`, `vets_dogs`.`address2`, `vets_dogs`.`city`, `vets_dogs`.`state`, `vets_dogs`.`postal_code`, `vets_dogs`.`country`) AS CHAR) AS `vet_address`, CAST(`vets_dogs`.`phone` AS CHAR) AS `vet_phone`, CAST(`vets_dogs`.`mobile_phone` AS CHAR) AS `vet_mobile_phone`, CAST(`vets_dogs`.`email` AS CHAR) AS `vet_email`, CAST(GROUP_CONCAT(DISTINCT `diseases`.`name` SEPARATOR ' ') AS CHAR) AS `disease_name`, CAST(GROUP_CONCAT(DISTINCT `samples`.`lsid` SEPARATOR ' ') AS CHAR) AS `sample_lsid`, CAST(GROUP_CONCAT(DISTINCT `samples`.`freezer_address` SEPARATOR ' ') AS CHAR) AS `sample_freezer_address`, `dogs`.`id` AS `sphinx_internal_id`, 3110174621 AS `class_crc`, '3110174621' AS `subclass_crcs`, 0 AS `sphinx_deleted`, UNIX_TIMESTAMP(`dogs`.`born_on`) AS `born_on`, UNIX_TIMESTAMP(`dogs`.`created_at`) AS `created_at` FROM `dogs` LEFT OUTER JOIN `ownerships` ON (`dogs`.`id` = `ownerships`.`dog_id`) LEFT OUTER JOIN `people` ON (`people`.`id` = `ownerships`.`owner_id`) AND (`people`.`type` = 'Owner' ) LEFT OUTER JOIN `people` vets_dogs ON `vets_dogs`.id = `dogs`.vet_id AND (`vets_dogs`.`type` = 'Vet' ) LEFT OUTER JOIN `diagnoses` ON (`dogs`.`id` = `diagnoses`.`dog_id`) LEFT OUTER JOIN `diseases` ON (`diseases`.`id` = `diagnoses`.`disease_id`) LEFT OUTER JOIN `samples` ON samples.dog_id = dogs.id WHERE `dogs`.`id` >= $start AND `dogs`.`id` <= $end AND `dogs`.`delta` = 0 GROUP BY `dogs`.`id` ORDER BY NULL
  25. sql_query_range = SELECT IFNULL(MIN(`id`), 1), IFNULL(MAX(`id`), 1) FROM `dogs` WHERE `dogs`.`delta` = 0
  26. sql_attr_uint = sphinx_internal_id
  27. sql_attr_uint = class_crc
  28. sql_attr_uint = sphinx_deleted
  29. sql_attr_timestamp = born_on
  30. sql_attr_timestamp = created_at
  31. sql_attr_multi = uint subclass_crcs from field
  32. sql_query_info = SELECT * FROM `dogs` WHERE `id` = (($id - 0) / 1)
  33. }
  34.  
  35. index dog_core
  36. {
  37. source = dog_core_0
  38. path = /Users/aroberts/Source/doggo/db/sphinx/development/dog_core
  39. morphology = stem_en
  40. charset_type = utf-8
  41. charset_table = 0..9, A..Z->a..z, -, _, a..z, U+A8->U+B8, U+B8, U+C0..U+DF->U+E0..U+FF, U+E0..U+FF
  42. min_infix_len = 3
  43. enable_star = 1
  44. }
  45.  
  46. source dog_delta_0 : dog_core_0
  47. {
  48. type = mysql
  49. sql_host = localhost
  50. sql_user = root
  51. sql_pass =
  52. sql_db = dog_dev
  53. sql_query_pre =
  54. sql_query_pre = SET NAMES utf8
  55. sql_query = SELECT `dogs`.`id` * 1 + 0 AS `id` , CAST(`dogs`.`state` AS CHAR) AS `state`, CAST(`dogs`.`breed` AS CHAR) AS `breed`, CAST(`dogs`.`call_name` AS CHAR) AS `call_name`, CAST(`dogs`.`registered_name` AS CHAR) AS `registered_name`, CAST(`dogs`.`registration` AS CHAR) AS `registration`, CAST(`dogs`.`collaborator` AS CHAR) AS `collaborator`, CAST(`dogs`.`coat_color` AS CHAR) AS `coat_color`, CAST(`dogs`.`gender` AS CHAR) AS `gender`, CAST(`dogs`.`id` AS CHAR) AS `dog_id`, CAST(`dogs`.`broad_number` AS CHAR) AS `broad_number`, CAST(`dogs`.`collaborator_number` AS CHAR) AS `collaborator_number`, CAST(`dogs`.`notes` AS CHAR) AS `notes`, CAST(`dogs`.`related_dogs_health` AS CHAR) AS `related_dogs_health`, CAST(GROUP_CONCAT(DISTINCT CONCAT_WS(' ', `people`.`first_name`, `people`.`middle_name`, `people`.`last_name`) SEPARATOR ' ') AS CHAR) AS `owner_name`, CAST(GROUP_CONCAT(DISTINCT CONCAT_WS(' ', `people`.`address1`, `people`.`address2`, `people`.`city`, `people`.`state`, `people`.`postal_code`, `people`.`country`) SEPARATOR ' ') AS CHAR) AS `owner_address`, CAST(GROUP_CONCAT(DISTINCT `people`.`state` SEPARATOR ' ') AS CHAR) AS `owner_state`, CAST(GROUP_CONCAT(DISTINCT `people`.`phone` SEPARATOR ' ') AS CHAR) AS `owner_phone`, CAST(GROUP_CONCAT(DISTINCT `people`.`mobile_phone` SEPARATOR ' ') AS CHAR) AS `owner_mobile_phone`, CAST(GROUP_CONCAT(DISTINCT `people`.`email` SEPARATOR ' ') AS CHAR) AS `owner_email`, CAST(CONCAT_WS(' ', `vets_dogs`.`first_name`, `vets_dogs`.`last_name`) AS CHAR) AS `vet_name`, CAST(CONCAT_WS(' ', `vets_dogs`.`address1`, `vets_dogs`.`address2`, `vets_dogs`.`city`, `vets_dogs`.`state`, `vets_dogs`.`postal_code`, `vets_dogs`.`country`) AS CHAR) AS `vet_address`, CAST(`vets_dogs`.`phone` AS CHAR) AS `vet_phone`, CAST(`vets_dogs`.`mobile_phone` AS CHAR) AS `vet_mobile_phone`, CAST(`vets_dogs`.`email` AS CHAR) AS `vet_email`, CAST(GROUP_CONCAT(DISTINCT `diseases`.`name` SEPARATOR ' ') AS CHAR) AS `disease_name`, CAST(GROUP_CONCAT(DISTINCT `samples`.`lsid` SEPARATOR ' ') AS CHAR) AS `sample_lsid`, CAST(GROUP_CONCAT(DISTINCT `samples`.`freezer_address` SEPARATOR ' ') AS CHAR) AS `sample_freezer_address`, `dogs`.`id` AS `sphinx_internal_id`, 3110174621 AS `class_crc`, '3110174621' AS `subclass_crcs`, 0 AS `sphinx_deleted`, UNIX_TIMESTAMP(`dogs`.`born_on`) AS `born_on`, UNIX_TIMESTAMP(`dogs`.`created_at`) AS `created_at` FROM `dogs` LEFT OUTER JOIN `ownerships` ON (`dogs`.`id` = `ownerships`.`dog_id`) LEFT OUTER JOIN `people` ON (`people`.`id` = `ownerships`.`owner_id`) AND (`people`.`type` = 'Owner' ) LEFT OUTER JOIN `people` vets_dogs ON `vets_dogs`.id = `dogs`.vet_id AND (`vets_dogs`.`type` = 'Vet' ) LEFT OUTER JOIN `diagnoses` ON (`dogs`.`id` = `diagnoses`.`dog_id`) LEFT OUTER JOIN `diseases` ON (`diseases`.`id` = `diagnoses`.`disease_id`) LEFT OUTER JOIN `samples` ON samples.dog_id = dogs.id WHERE `dogs`.`id` >= $start AND `dogs`.`id` <= $end AND `dogs`.`delta` = 1 GROUP BY `dogs`.`id` ORDER BY NULL
  56. sql_query_range = SELECT IFNULL(MIN(`id`), 1), IFNULL(MAX(`id`), 1) FROM `dogs` WHERE `dogs`.`delta` = 1
  57. sql_attr_uint = sphinx_internal_id
  58. sql_attr_uint = class_crc
  59. sql_attr_uint = sphinx_deleted
  60. sql_attr_timestamp = born_on
  61. sql_attr_timestamp = created_at
  62. sql_attr_multi = uint subclass_crcs from field
  63. sql_query_info = SELECT * FROM `dogs` WHERE `id` = (($id - 0) / 1)
  64. }
  65.  
  66. index dog_delta : dog_core
  67. {
  68. source = dog_delta_0
  69. path = /Users/aroberts/Source/doggo/db/sphinx/development/dog_delta
  70. }
  71.  
  72. index dog
  73. {
  74. type = distributed
  75. local = dog_delta
  76. local = dog_core
  77. }
Add Comment
Please, Sign In to add comment