20110413-add-export_flag-methods-testcases-oddb_org-plugin-lppv_rb-util-http_rb

<< | Index | >>

1. Emergency Treatment for the different swissmedic file format
2. Update testcases

Goal/Estimate/Evaluation

• Testcases / 83% / 82.30%

Milestones

• Update testcases
  1. src/plugin/lppv.rb (coverage: 100%)
  2. src/util/http.rb (coverage: 82.31%)
  3. ext/meddata/src/session.rb (coverage: 35.19%)
  4. src/view/user/register_download.rb (coverage: 80.12%)
  5. src/view/migel/result.rb (coverage: 68.12%)

Summary

• http://masay.ch/2011/04/13/add-export_flag-methods-testcases-oddb_org-plugin-lppv_rb-util-http_rb/

Commits

• comment out get Praeparateliste-Latest-File because columns N and O are missing in the file (oddb.org)
• Added set_all_export_flag method for bin/admin for Registrations and Sequences to catch lazy Swissmedic that publishes wrong files. Nerv. (oddb.org)
• Updated testcases, test_plugin/lppv.rb, test_util/http.rb (oddb.org)

Emergency Treatment for the different swissmedic file format

Problem

• The latest Praeparatiste file format changed, then the export flags of all the products were set
• All the search results have gone

Emergency treatment

• Comment out the process to get the latest Praeparatiste file online, and restart the update_swissmedic method
• Add some methods to set and unset export_flag of sequence and registration to src/util/oddbapp.rb (add bin/admin commands)

Commit

• comment out get Praeparateliste-Latest-File because columns N and O are missing in the file (oddb.org)
• Added set_all_export_flag method for bin/admin for Registrations and Sequences to catch lazy Swissmedic that publishes wrong files. Nerv. (oddb.org)

Restart oddb.org

 # svc -h /service/ch-oddb

Reset all the export_flag of sequence and registration

 $ bin/admin
 ch.oddb> set_all_export_flag_registration_false
 ch.oddb> set_all_export_flag_sequence_false

Replace the latest Packunge file and Präparatiste file to the previous ones on server

 sudo -u apache cp Packungen-2011.04.07.xls Packungen-latest.xls
 sudo -u apache cp Präparateliste-2011.03.05.xls Präparateliste-latest.xls

Restart update_swissmedic

 $ bin/admin
 ch.oddb> Updater.new(self).update_swissmedic

Note

• At the current script, Präparatiste file will be not updated but Packungen file will be updated
• Remove or move the lateset Packungen file if you execute update_swissmedic method again, because the condition to execute update_swissmedic depends on the latest Packungen file
• N and O columns (Anz. Packungen Seq. and Packungsgrösse) have gone from Präparatiste file
• Originally, if the value of N column equals '0' (it means there is no package), the export_flag of sequence and registration will be set to 'true', then the searching result does not show the sequence and registration on browser

Memo (vim, color scheme)

Refer: http://blog.toddwerth.com/entries/show/8