20110712-update-renewal_flag-develop-drb-server-swissmedic

<< | Index | >>

1. Reset all the renewal_flag to nil
2. Develop DRb server swissmedic
3. Survey for new data format bbmb.ch

Goal/Estimate/Evaluation

• Update renewal_flag / 100% / 100%
• Develop DRb server swissmedic / 70% / 40%

Milestones

• move methods from ODDB::SwissindexPlugin to ODDB::Swissinex::Updater
  1. known_data suspend
  2. set_all_export_flag_false
  3. update_* methods
  4. delete
  5. recheck_deletions
  6. deactivate

Summary

Commits

Reset all the renewal_flag to nil

• src/util/oddbapp.rb#set_all_renewal_flag_nil

  def set_all_renewal_flag_nil
    count = 0
    each_registration do |reg|
      if reg.renewal_flag
        update reg.pointer, {:renewal_flag => nil, :renewal_flag_swissmedic => nil}, :admin
        count += 1
      end
    end
    'set ' + count.to_s + ' renewal_flags of registration nil'
  end

Run

• bin/oddbd
• ext/export/bin/exportd
• bin/admin

ch.oddb> set_all_renewal_flag_nil
-> set 110 renewal_flags of registration nil
ch.oddb> Updater.new(self).update_swissmedic
-> Hash
ch.oddb> Updater.new(self).export_oddb_csv
-> mhatakeyama@ywesee.com

Conclusion

• This method is not helpful
• We should change the renewal_flags by hand

Note (update_swissmedic)

• If there is no Packungen-latest.xls, then the new Packungen.xls is compared with the data in the database
• In such a case, the registrations (sequences, packages) of @diff.updates are NOT updated
• only the registrations of @diff.news are updated (created)

Run

• change renewal_flag and deactive date by manual
• bin/admin

ch.oddb> Updater.new(self).export_oddb_csv

Result

• Email ch.ODDB.org Report - oddb.csv - 07/2011
• The number of renewal_flags is 33
• This is correct

Develop DRb server swissmedic

Problem

• If there is no Packungen-latest.xls, we have to take the data from database that is compared with a new Packungen.xls downloaded.
• But the @app instance is in the memory of bin/oddbd process
• One possibility is to call some methods via readonly server

Survey for new data format bbmb.ch

New

• Cutomer and Order formats will change in the future

Question

• Can the system (in particular, the archive (log data)) work with the new file format?