Module: Oddb2xml

Defined in:
lib/oddb2xml.rb,
lib/oddb2xml/cli.rb,
lib/oddb2xml/calc.rb,
lib/oddb2xml/util.rb,
lib/oddb2xml/builder.rb,
lib/oddb2xml/options.rb,
lib/oddb2xml/version.rb,
lib/oddb2xml/extractor.rb,
lib/oddb2xml/compressor.rb,
lib/oddb2xml/downloader.rb

Defined Under Namespace

Modules: DownloadMethod, TxtExtractorMethods Classes: BagXmlDownloader, BagXmlExtractor, Builder, Calc, Cli, Compressor, Downloader, EphaDownloader, EphaExtractor, Extractor, GalenicForm, GalenicGroup, LppvDownloader, LppvExtractor, MedregbmDownloader, MedregbmExtractor, MigelDownloader, MigelExtractor, Options, RefdataDownloader, RefdataExtractor, SwissmedicDownloader, SwissmedicExtractor, SwissmedicInfoDownloader, SwissmedicInfoExtractor, ZurroseDownloader, ZurroseExtractor

Constant Summary collapse

WorkDir = 
Dir.pwd
Downloads = 
"#{Dir.pwd}/downloads"
COLUMNS_JULY_2015 =

please keep this constant in sync between (GEM) swissmedic-diff/lib/swissmedic-diff.rb and (GEM) oddb2xml/lib/oddb2xml/extractor.rb

{
    :iksnr => /Zulassungs-Nummer/i,                  # column-nr: 0
    :seqnr => /Dosisstärke-nummer/i,
    :name_base => /Präparatebezeichnung/i,
    :company => /Zulassungsinhaberin/i,
    :production_science => /Heilmittelcode/i,
    :index_therapeuticus => /IT-Nummer/i,            # column-nr: 5
    :atc_class => /ATC-Code/i,
    :registration_date => /Erstzulassungs-datum./i,
    :sequence_date => /Zul.datum Dosisstärke/i,
    :expiry_date => /Gültigkeitsdauer der Zulassung/i,
    :ikscd => /Packungscode/i,                 # column-nr: 10
    :size => /Packungsgrösse/i,
    :unit => /Einheit/i,
    :ikscat => /Abgabekategorie Packung/i,
    :ikscat_seq => /Abgabekategorie Dosisstärke/i,
    :ikscat_preparation => /Abgabekategorie Präparat/i, # column-nr: 15
    :substances => /Wirkstoff/i,
    :composition => /Zusammensetzung/i,
    :indication_registration => /Anwendungsgebiet Präparat/i,
    :indication_sequence => /Anwendungsgebiet Dosisstärke/i,
    :gen_production => /Gentechnisch hergestellte Wirkstoffe/i, # column-nr 20
    :insulin_category => /Kategorie bei Insulinen/i,
    :drug_index       => /Verz. bei betäubunsmittel-haltigen Präparaten/i,
}
XML_OPTIONS = 
{
'xmlns:xsd'         => 'http://www.w3.org/2001/XMLSchema',
'xmlns:xsi'         => 'http://www.w3.org/2001/XMLSchema-instance',
'xmlns'             => 'http://wiki.oddb.org/wiki.php?pagename=Swissmedic.Datendeklaration',
'CREATION_DATETIME' => Time.new.strftime('%FT%T%z'),
'PROD_DATE'         => Time.new.strftime('%FT%T%z'),
'VALID_DATE'        => Time.new.strftime('%FT%T%z'),
'GENERATED_BY'      => "oddb2xml #{VERSION}"
}
VERSION = 
"2.3.8"

Class Method Summary collapse

Class Method Details

.add_epha_changes_for_ATC(iksnr, atc_code) ⇒ Object 



23
24
25
26
27
28
29
30
31
32
33
34
 
# File 'lib/oddb2xml/util.rb', line 23

def Oddb2xml.add_epha_changes_for_ATC(iksnr, atc_code)
  if @atc_csv_content.size == 0
    open(@atc_csv_origin).readlines.each{
      |line|
        items = line.split(',')
        @atc_csv_content[[items[0], items[1]]] = items[2]
    }

  end
  new_value = @atc_csv_content[[iksnr.to_s, atc_code]]
  new_value ? new_value : atc_code
end

.add_hash(string) ⇒ Object 



115
116
117
118
119
120
121
122
123
124
 
# File 'lib/oddb2xml/util.rb', line 115

def Oddb2xml.add_hash(string)
  doc = Nokogiri::XML.parse(string)
  nr = 0
  doc.root.elements.each do |node|
    nr += 1
    next if node.name.eql?('RESULT')
    node['SHA256'] = Digest::SHA256.hexdigest node.text
  end
  doc.to_xml
end

.calc_checksum(str) ⇒ Object 



4
5
6
7
8
9
10
11
12
13
 
# File 'lib/oddb2xml/util.rb', line 4

def Oddb2xml.calc_checksum(str)
  str = str.strip
  sum = 0
  val =   str.split(//u)
  12.times do |idx|
    fct = ((idx%2)*2)+1
    sum += fct*val[idx].to_i
  end
  ((10-(sum%10))%10).to_s
end

.check_column_indices(sheet) ⇒ Object

please keep this constant in sync between (GEM) swissmedic-diff/lib/swissmedic-diff.rb and (GEM) oddb2xml/lib/oddb2xml/extractor.rb



72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
 
# File 'lib/oddb2xml/util.rb', line 72

def Oddb2xml.check_column_indices(sheet)
  row = sheet[4] # Headers are found at row 4

  error_2015 = nil
  COLUMNS_JULY_2015.each{
    |key, value|
    header_name = row[COLUMNS_JULY_2015.keys.index(key)].value.to_s
    unless value.match(header_name)
      puts "#{__LINE__}: #{key} ->  #{COLUMNS_JULY_2015.keys.index(key)} #{value}\nbut was  #{header_name}" if $VERBOSE
      error_2015 = "Packungen.xlslx_has_unexpected_column_#{COLUMNS_JULY_2015.keys.index(key)}_#{key}_#{value.to_s}_but_was_#{header_name}"
      break
    end
  }
  raise "#{error_2015}" if error_2015
end

.download_finished(file, remove_file = true) ⇒ Object 



60
61
62
63
64
65
66
67
68
69
 
# File 'lib/oddb2xml/util.rb', line 60

def Oddb2xml.download_finished(file, remove_file = true)
  src  = "#{WorkDir}/#{File.basename(file)}"
  dest = "#{Downloads}/#{File.basename(file)}"
  FileUtils.makedirs(Downloads)
  #return unless File.exists?(file)
  return unless file and File.exists?(file)
  return if File.expand_path(file).eql?(dest)
  FileUtils.cp(src, dest, :verbose => false)
  Oddb2xml.log("download_finished saved as #{dest} #{File.size(dest)} bytes.")
end

.log(msg) ⇒ Object 



36
37
38
39
40
 
# File 'lib/oddb2xml/util.rb', line 36

def Oddb2xml.log(msg)
  return unless @options[:log]
  $stdout.puts "#{Time.now.strftime("%Y-%m-%d %H:%M:%S")}: #{msg}"
  $stdout.flush
end

.save_options(options) ⇒ Object 



42
43
44
 
# File 'lib/oddb2xml/util.rb', line 42

def Oddb2xml.save_options(options)
  @options = options
end

.skip_download(file) ⇒ Object 



50
51
52
53
54
55
56
57
58
 
# File 'lib/oddb2xml/util.rb', line 50

def Oddb2xml.skip_download(file)
  return false if defined?(VCR)
  dest = "#{Downloads}/#{File.basename(file)}"
  if File.exists?(dest)
    FileUtils.cp(dest, file, :verbose => false, :preserve => true) unless File.expand_path(file).eql?(dest)
    return true
  end
  false
end

.skip_download? ⇒ Boolean

Returns:

  • (Boolean) 


46
47
48
 
# File 'lib/oddb2xml/util.rb', line 46

def Oddb2xml.skip_download?
  @options[:skip_download]
end

.verify_sha256(file) ⇒ Object 



126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
 
# File 'lib/oddb2xml/util.rb', line 126

def Oddb2xml.verify_sha256(file)
  f = File.open(file)
  doc = Nokogiri::XML(f)
  nr = 0
  doc.root.elements.each do |node|
    nr += 1
    next if node.name.eql?('RESULT')
    sha256 = Digest::SHA256.hexdigest node.text
    unless node['SHA256'].eql?(sha256)
      puts "Verifiying #{node['SHA256']} != expectd #{sha256} against node #{node.text} failed"
      exit (3)
    end
  end
  return true
end