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.
# | 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 |
Description | Between Files 1 and 2 |
|
---|---|---|
Text Blocks | Lines | |
Unchanged | 5 | 86 |
Changed | 4 | 12 |
Inserted | 0 | 0 |
Removed | 0 | 0 |
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 |
No regular expressions were active.
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 |
Araxis Merge (but not the data content of this report) is Copyright © 1993-2016 Araxis Ltd (www.araxis.com). All rights reserved.