view · edit · sidebar · attach · print · history

20130212-debug-migel-search

<< | Index | >>


Summary

  • Debug migel database.

Index


Debug-migel-search

keywords
  • Hartmann
  • Sigvaris
  • 4049500502191
links(google cache)

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

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
view · edit · sidebar · attach · print · history
Page last modified on February 13, 2013, at 07:11 AM