21. EPMO Open Source Coordination Office Redaction File Detail Report

Produced by Araxis Merge on 5/29/2018 12:14:32 PM Central Daylight Time. See www.araxis.com for information about Merge. This report uses XHTML and CSS2, and is best viewed with a modern standards-compliant browser. For optimum results when printing this report, use landscape orientation and enable printing of background images and colours in your browser.

21.1 Files compared

# Location File Last Modified
1 mobile-kidney-web-2.0.0.zip\mobile-kidney-web\acceptance_test\watir\lib\module DBOperationsModule.rb Wed Apr 4 20:16:46 2018 UTC
2 mobile-kidney-web-2.0.0.zip\mobile-kidney-web\acceptance_test\watir\lib\module DBOperationsModule.rb Tue May 29 15:32:16 2018 UTC

21.2 Comparison summary

Description Between
Files 1 and 2
Text Blocks Lines
Unchanged 5 82
Changed 4 20
Inserted 0 0
Removed 0 0

21.3 Comparison options

Whitespace
Character case Differences in character case are significant
Line endings Differences in line endings (CR and LF characters) are ignored
CR/LF characters Not shown in the comparison detail

21.4 Active regular expressions

No regular expressions were active.

21.5 Comparison detail

  1   require 'w atir-webdr iver'
  2  
  3   # Commente d out for  remote cap ability
  4   # require  'oci8'
  5  
  6   module DBO perationsM odule
  7       DBPASSWORD  = "A I "
  8       USER = " AI "
  9       SCHEMA = "
A I "
  10     AUTHSCHE MA = "AUTH DB"
  11     MOCKSCHE MA = "MOCK DB"
  12  
  13  
  14     def dele teUserFrom RightOfAcc ess(patien tId)
  15         con = Mysq l.new(' IP        ', USER, D BPASSWORD,  SCHEMA)
  16       rs = c on.query(' DELETE FRO M USER_RIG HTOFACCESS  WHERE USE R_ID="' +  patientId  + '"')
  17       con.cl ose
  18       puts " Deleted RO A for User ID=" + pat ientId
  19     end
  20  
  21     def setD efaultROAF orPatient( patientId)
  22         con = Mysq l.new(' IP        ', USER, D BPASSWORD,  SCHEMA)
  23       rs = c on.query(' SELECT * F ROM USER_R IGHTOFACCE SS WHERE U SER_ID="'  + patientI d + '"')
  24       entry  = rs.fetch _hash
  25       if ent ry == nil  then
  26         con. query('INS ERT INTO U SER_RIGHTO FACCESS (U SER_ID, RO A_STATE, R OA_DATE, R OA_FORM) V ALUES ("'  + patientI d + '", "1 ", "2014-0 9-18 18:59 :59", "emp ty")')
  27       end
  28       con.cl ose
  29       puts " Updated RO A State"
  30     end
  31  
  32     def upda teUserRigh tOfAccess( patientId, roaState)
  33         host     = " IP        "
  34         user     = "
A I "
  35         dbpass = " A I "
  36         port     PORT
  37         sid      = " AI "
  38       conn_s tring="(DE SCRIPTION= (ADDRESS=( PROTOCOL=T CP)(HOST=# {host})(PO RT=#{port} ))(CONNECT _DATA=(SER VER=DEDICA TED)(SID=# {sid})))"
  39  
  40       conn =  OCI8.new( user+"/"+d bpass+"@"+ conn_strin g)
  41  
  42       puts " patientId: roaState :  " + "#{pa tientId}"+ ":"+"#{roa State}"
  43  
  44       conn.e xec("UPDAT E USER_RIG HTOFACCESS  ura
  45                      SE T ura.ROA_ STATE = '# {roaState} '
  46                    WHER E ura.USER _ID ='#{pa tientId}'" )
  47       conn.e xec("COMMI T")
  48  
  49     end
  50  
  51   end