2705. EPMO Open Source Coordination Office Redaction File Detail Report

Produced by Araxis Merge on 5/10/2018 8:40:53 AM 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.

2705.1 Files compared

# Location File Last Modified
1 MHED_APPS_CIF.zip\VATS v2.1.2\var-utility-web-2.1.2@c27506c69b7.zip\acceptance-tests\watir-ruby\module DBUtility.rb Fri Mar 9 16:50:58 2018 UTC
2 MHED_APPS_CIF.zip\VATS v2.1.2\var-utility-web-2.1.2@c27506c69b7.zip\acceptance-tests\watir-ruby\module DBUtility.rb Thu May 3 17:09:18 2018 UTC

2705.2 Comparison summary

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

2705.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

2705.4 Active regular expressions

No regular expressions were active.

2705.5 Comparison detail

  1   require "o ci8"
  2  
  3   module DBU tility
  4       DBPASSWORD  = " RED A CTED "
  5       USER         = " REDACTED "
  6       HOST         = " IP        "
  7  
  8     def dele teStaffUse rDisclaime r(userId)
  9         conn_strin g = "(DESC RIPTION=(A DDRESS=(PR OTOCOL=TCP )(HOST= IP        )(PORT= PORT ))(CONNECT _DATA=(SER VER=DEDICA TED)(SID=v amfdb)))"
  10       puts U SER+"/"+DB PASSWORD+" @"+conn_st ring
  11       conn =  OCI8.new( USER+"/"+D BPASSWORD+ "@"+conn_s tring)
  12       conn.e xec("DELET E from HAD B.STAFF_US ER_DISCLAI MER where  USER_ID='"  + userId  + "'")
  13       conn.e xec("COMMI T")
  14       puts " Deleted DS U for User ID=" + use rId
  15     end
  16  
  17     def upda teStaffUse rDisclaime rDate(user Id, date)
  18       p user Id
  19       p date
  20         conn_strin g = "(DESC RIPTION=(A DDRESS=(PR OTOCOL=TCP )(HOST= IP        )(PORT= PORT ))(CONNECT _DATA=(SER VER=DEDICA TED)(SID=v amfdb)))"
  21       puts U SER+"/"+DB PASSWORD+" @"+conn_st ring
  22       conn =  OCI8.new( USER+"/"+D BPASSWORD+ "@"+conn_s tring)
  23       conn.e xec("UPDAT E  HADB.ST AFF_USER_D ISCLAIMER  set SUD_DA TE= '"+ da te + "' wh ere USER_I D = '" + u serId + "' ")
  24       conn.e xec("COMMI T")
  25       puts " Updated SU D for User ID=" + use rId
  26     end
  27  
  28     def setS taffUserDi sclaimer(u serId, vis taLocation )
  29       puts " Start [set StaffUserD isclamimer Date]"
  30         conn_strin g = "(DESC RIPTION=(A DDRESS=(PR OTOCOL=TCP )(HOST= IP        )(PORT= PORT ))(CONNECT _DATA=(SER VER=DEDICA TED)(SID=v amfdb)))"
  31       puts U SER+"/"+DB PASSWORD+" @"+conn_st ring
  32       conn =  OCI8.new( USER+"/"+D BPASSWORD+ "@"+conn_s tring)
  33  
  34       num_ro ws = conn. exec("SELE CT * FROM  HADB.STAFF _USER_DISC LAIMER WHE RE USER_ID ='" + user Id + "' an d VISTA_LO CATION='"  + vistaLoc ation + "' "  ) do |r |
  35         puts  r.join(', ')
  36       end
  37  
  38       if num _rows == n il  || num _rows == 0  then
  39         sqlS tring = "I NSERT INTO  HADB.STAF F_USER_DIS CLAIMER (U SER_ID, VI STA_LOCATI ON, SUD_ST ATE, SUD_D ATE ) VALU ES ('" + u serId + "' " + ", '"  + vistaLoc ation + "' , TO_NUMBE R(1), TO_D ATE('2017/ 02/01', 'Y YYY/MM/DD' ))"
  40  
  41         conn .exec(sqlS tring)
  42         conn .commit
  43       end
  44  
  45       conn.l ogoff
  46       puts " End [setSt affUserDis clamimerDa te]"
  47     end
  48  
  49   end