20130212-debug-migel-search

<< | Index | >>

Summary

• Debug migel database.

Index

• Debug-migel-search

Debug-migel-search

keywords

• Hartmann
• Sigvaris
• 4049500502191

links(google cache)

• http://ch.oddb.org/de/gcc/migel_search/migel_code/341501031
• http://ch.oddb.org/de/gcc/migel_search/migel_code/17.05.01.00.1

Flow

* ODDB::State::Global#search
  * ODDB::Session#search_migel_products
    * ODDB::App#search_migel_products
      * MIGEL_SERVER.migelid.search_by_migel_code
        * Migel::Model::Migelid.search_by_migel_code
      * MIGEL_SERVER.search_migel_migelid
        * Migel::Util::Server#search_migelid_fulltext
          * ODBA.cache.retrieve_from_index              #=> search from description index (migel_fulltext_index_de)
      * Migel::Util::Server#search_migelid_by_name      #=> search from name prefix (artikelname z.B. "SIGVARIS 503 A-D/F KKL2 S kurz off")

rebuild index via bin/admin

migel> rebuild_fulltext_index_tables
-> Array

source.size: 557
source.size: 557
source.size: 30737
source.size: 30737

search_by_company_name

• http://ch.oddb.org/de/gcc/migel_search/migel_code/17.05.01.00.1

migel> Migel::Model::Product.send('search_by_company_name_de', 'sigvaris').length
-> 10992
migel> Migel::Model::Product.send('search_by_company_name_de', 'hartman').length
-> 0
migel> Migel::Model::Product.send('search_by_company_name_de', 'IVF Hartmann AG').length
-> 644


# production
migel> Migel::Model::Product.send('search_by_article_name_de', 'sigvaris').length
-> 0
migel> products.values.select{|prod| prod.full_description(:de) =~ /SANOR/ }.length
-> 0
migel> rebuild_fulltext_index_tables # => rebuld method does not work
-> []
migel> init_fulltext_index_tables
-> []
migel> products.length
-> 0

problems

1. .produc
2. .production server has broken migel index. (my local migel works fine with "4049500502191(EAN)", "3446216(Pharmacode)")
3. .migel_product_fulltext_index_de index does not work, expectedly. (Some products does not have company name into "full_description")
4. .ODBA#search_by_xxxx methods use "exact match" of String. (×: hartman, ○: "IVF Hartmann AG")

Debug production server database.

migel_model_product_pharmacode

migel> ODBA.cache.index_keys('migel_model_product_pharmacode')
-> []
migel> Migel::Model::Product.all.length
-> 0