Produced by Araxis Merge on 5/2/2019 1:17:39 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.
# | Location | File | Last Modified |
---|---|---|---|
1 | C:\AraxisMergeCompare\Pri_un\EPRS\EPRS_ODSDB\EPRS.ODSDB\EPRS.ODSDB\TestScripts | RegionVisnStationProcTests.sql | Thu Apr 18 16:51:44 2019 UTC |
2 | C:\AraxisMergeCompare\Pri_re\EPRS\EPRS_ODSDB\EPRS.ODSDB\EPRS.ODSDB\TestScripts | RegionVisnStationProcTests.sql | Tue Apr 30 12:51:48 2019 UTC |
Description | Between Files 1 and 2 |
|
---|---|---|
Text Blocks | Lines | |
Unchanged | 3 | 226 |
Changed | 2 | 4 |
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 | --Test scr ipts for e nsuring th at regiona l pulls ar e working after rela tionship c hanges | |
2 | DECLARE @r egionIds v archar(max ) | |
3 | DECLARE @c cnRegionId s varchar( max) | |
4 | DECLARE @u serId int | |
5 | DECLARE @m oduleIds v archar(max ) | |
6 | DECLARE @v isnIds var char(max) | |
7 | DECLARE @s tationIds varchar(ma x) | |
8 | DECLARE @a dDomains v archar(max ) | |
9 | DECLARE @a ccessLevel Ids varcha r(max) | |
10 | DECLARE @s ensitivity LevelIds v archar(max ) | |
11 | DECLARE @a ccessStatu ses varcha r(max) | |
12 | DECLARE @p artialName varchar(m ax) | |
13 | ||
14 | SET @userI d = 1; | |
15 | SET @stati onIds = nu ll; | |
16 | SET @modul eIds = '1' ; | |
17 | SET @adDom ains = NUL L; | |
18 | SET @acces sLevelIds = '1,3'; | |
19 | SET @acces sStatuses = 'APPROVE D'; | |
20 | SET @sensi tivityLeve lIds = nul l; | |
21 | SET @parti alName = N ULL; | |
22 | --select * from secl yr.users; | |
23 | --select * from secl yr.userrol es where u serid = 50 ; | |
24 | -- test uspGe tUserMaxSe nsitivityL evel; | |
25 | --ex pectation: @userId o f 1, @mod uleIds = 1 , @station Ids = null ; result: 1; passes | |
26 | --ex pectation: @userId o f 50, @mod uleIds = 1 , @station Ids = null , result = 5; passes | |
27 | --ex pectation: @userId o f 50, @mod uleIds = 1 , @station Ids = 3, r esult = 1; passes (s tationId 3 non-exist ent) | |
28 | EX EC seclyr. uspGetUser MaxSensiti vityLevel @userId, @ moduleIds, @stationI ds; | |
29 | ||
30 | -- test uspGe tUserRegio ns | |
31 | --ex pectation: @userId o f 1, @mod uleIds = 1 , @station Ids = null ; result: returns Re gions 1 - 5; passes | |
32 | --ex pectation: @userId o f 50, @mod uleIds = 1 , @station Ids = null , result = returns R egions 1- 5; passes | |
33 | EX EC seclyr. uspGetUser Regions @u serId, @mo duleIds; | |
34 | ||
35 | -- test uspGe tUserStati onRoles, e xpectation : | |
36 | --ex pectation: @userId o f 1, @mod uleIds = 1 , @station Ids = null ; result: returns 16 8 stations ; passes | |
37 | --ex pectation: @userId o f 50, @mo duleIds = 2, @statio nIds = nul l; result: returns 0 stations; passes | |
38 | EX EC seclyr. uspGetUser StationRol es @userId , @moduleI ds; | |
39 | ||
40 | -- test uspGe tUserVisns (NOTE: us pGetUserVi sns return s region i nfo, which will resu lt in some VISNs sho wing more than once due to Reg ion lines | |
41 | --ex pectation: @userId o f 1, @mod uleIds = 1 , @station Ids = null ; result: returns 25 Visns; pa sses | |
42 | --ex pectation: @userId o f 50, @mo duleIds = 2, @statio nIds = nul l; result: returns 0 Visns; pa sses | |
43 | EX EC seclyr. uspGetUser Visns @use rId, @modu leIds | |
44 | ||
45 | -- test uspRp tDetUserLo ginActivit y | |
46 | --ex pectation: @userId o f 1, @mod uleIds = 1 , @adDomai ns = 'DVA' = null; r esult: ret urns 4 rec ords; pass es | |
47 | --ex pectation: @userId o f 50, @mo duleIds = 2, @adDoma ins = null ; result: returns 0 records; p asses | |
48 | EX EC seclyr. uspRptDetU serLoginAc tivity @ad Domains, @ moduleIds, @userId; | |
49 | ||
50 | -- test uspRp tDetUserMg t | |
51 | --ex pectation: @userId o f 1, @mod uleIds = 1 , all else = null; r esult: ret urns 14 re cords; pas ses | |
52 | --expectat ion: @user Id of 50, @moduleIds = 2, @adD omains = ' DN S ', all els e = null; result: re turns 7 re cords; pas ses | |
53 | EX EC seclyr. uspRptDetU serMgt @mo duleIds, @ adDomains, @accessLe velIds, @s ensitivity LevelIds, @accessSta tuses, @us erId, @par tialName; | |
54 | ||
55 | -- test uspRp tDetUserRo les | |
56 | --ex pectation: @userId o f 1, @mod uleIds = 1 , @accessL evelIds = '1,2', @ac cessStatus es = 'APPR OVED', all else = nu ll; result : returns 6 records; passes | |
57 | --expectat ion: @user Id of 50, @moduleIds = 1, @adD omains = ' DN S ', @access LevelIds = '1,3', @a ccessStatu ses = 'APP ROVED', @s ensitivity LevelIds = '1,2,3', all else = null; res ult: retur ns 3 recor ds; passes | |
58 | EX EC seclyr. uspRptDetU serRoles @ moduleIds, @adDomain s, @access LevelIds, @sensitivi tyLevelIds , @accessS tatuses, @ userId, @p artialName ; | |
59 | ||
60 | -- test uspRp tGetUserCC NRegionsLi st | |
61 | --ex pectation: @userId o f 1, @mod uleIds = 1 ; result: returns 5 records; p asses | |
62 | --ex pectation: @userId o f 50, @mo duleIds = 2; result: returns 0 records; passes | |
63 | EX EC seclyr. uspRptGetU serCCNRegi onsList @m oduleIds, @userId; | |
64 | ||
65 | -- test uspRp tGetUserCC NRegionsLi stWithNull Handler | |
66 | --ex pectation: @userId o f 1, @mod uleIds = 1 ; result: returns 6 records; p asses | |
67 | --ex pectation: @userId o f 50, @mo duleIds = 2; result: returns 1 record; p asses | |
68 | EX EC seclyr. uspRptGetU serCCNRegi onsListWit hNullHandl er @module Ids, @user Id; | |
69 | ||
70 | -- test uspRp tGetUserPa rentStatio nsList | |
71 | --ex pectation: @userId o f 1, @mod uleIds = 1 , @regionI ds = null, @ccnRegio nIds = nul l, @visnId s = null; result: re turns 130 records; p asses | |
72 | --ex pectation: @userId o f 1, @mod uleIds = 1 ; @regionI ds = null, @ccnRegio nIds = nul l, @visnId s = '5,6', result: r eturns 13 record; pa sses | |
73 | EX EC seclyr. uspRptGetU serParentS tationsLis t @regionI ds, @ccnRe gionIds, @ visnIds, @ userId, @m oduleIds; | |
74 | ||
75 | -- test uspRp tGetUserPa rentStatio nsListWith NullHandle r | |
76 | --ex pectation: @userId o f 1, @mod uleIds = 1 , @regionI ds = null, @ccnRegio nIds = nul l, @visnId s = null; result: re turns 131 records; p asses | |
77 | --ex pectation: @userId o f 50, @mo duleIds = 2, @region Ids = null , @ccnRegi onIds = nu ll, @visnI ds = '5,6' ; result: returns 14 record; p asses | |
78 | EX EC seclyr. uspRptGetU serParentS tationsLis tWithNullH andler @re gionIds, @ ccnRegionI ds, @visnI ds, @userI d, @module Ids; | |
79 | ||
80 | -- test uspRp tGetUserRe gionsList | |
81 | --ex pectation: @userId o f 1, @mod uleIds = 1 ; result: returns 4 records; p asses | |
82 | --ex pectation: @userId o f 50, @mo duleIds = 2; result: returns 0 records; passes | |
83 | EX EC seclyr. uspRptGetU serRegions List @modu leIds, @us erId; | |
84 | ||
85 | -- test uspRp tGetUserRe gionsListW ithNullHan dler | |
86 | --ex pectation: @userId o f 1, @mod uleIds = 1 ; result: returns 5 records; p asses | |
87 | --ex pectation: @userId o f 50, @mo duleIds = 2; result: returns 1 records; passes | |
88 | EX EC seclyr. uspRptGetU serRegions ListWithNu llHandler @moduleIds , @userId; | |
89 | ||
90 | -- test uspRp tGetUserSt ationMaxSe nsitivityL evel | |
91 | --ex pectation: @userId o f 1, @mod uleIds = 1 ; result: returns 16 8 records, max sensi tivity = 1 ; passes | |
92 | --ex pectation: @userId o f 50, @mo duleIds = 1, @statio nIds = '65 6, 675'; r esult: ret urns 2 rec ords, max sensitivit y = 5; pas ses | |
93 | EX EC seclyr. uspRptGetU serStation MaxSensiti vityLevel @userId, @ moduleIds, @stationI ds; | |
94 | ||
95 | -- test uspRp tGetUserSt ationsList | |
96 | --ex pectation: @userId o f 1, @mod uleIds = 1 , @regionI ds = '1,2' , @ccnRegi onId = nul l, @visnId s = null; result: re turns 25 r ecords; pa sses | |
97 | --ex pectation: @userId o f 1, @mod uleIds = 1 , @regionI ds = null, @ccnRegio nIds = '1' , @visnIds = '5,6'; result: re turns 14 r ecords; pa sses | |
98 | EX EC seclyr. uspRptGetU serStation sList @reg ionIds, @c cnRegionId s, @visnId s, @userId , @moduleI ds; | |
99 | ||
100 | -- test uspRp tGetUserSt ationsList WithNullHa ndler | |
101 | --ex pectation: @userId o f 1, @mod uleIds = 1 , @regionI ds = '1,2' , @ccnRegi onId = nul l, @visnId s = null; result: re turns 26 r ecords; pa sses | |
102 | --ex pectation: @userId o f 1, @mod uleIds = 1 , @regionI ds = null, @ccnRegio nIds = '1' , @visnIds = '5,6'; result: re turns 15 r ecords; pa sses | |
103 | EX EC seclyr. uspRptGetU serStation sListWithN ullHandler @regionId s, @ccnReg ionIds, @v isnIds, @u serId, @mo duleIds; | |
104 | ||
105 | -- test uspRp tGetUserVi snsList | |
106 | --ex pectation: @userId o f 1, @mod uleIds = 1 , @regionI ds = '1,2' , @ccnRegi onId = nul l, @visnId s = null; result: re turns 9 re cords; pas ses | |
107 | --ex pectation: @userId o f 1, @mod uleIds = 1 , @regionI ds = null, @ccnRegio nIds = '1' , result: returns 5 records; p asses | |
108 | EX EC seclyr. uspRptGetU serVisnsLi st @region Ids, @ccnR egionIds, @userId, @ moduleIds; | |
109 | ||
110 | -- test uspRp tGetUserVi snsListWit hNullHandl er | |
111 | --ex pectation: @userId o f 1, @mod uleIds = 1 , @regionI ds = '1,2' , @ccnRegi onId = nul l, @visnId s = null; result: re turns 10 r ecords; pa sses | |
112 | --ex pectation: @userId o f 1, @mod uleIds = 1 , @regionI ds = null, @ccnRegio nIds = '1' , result: returns 6 records; p asses | |
113 | EX EC seclyr. uspRptGetU serVisnsLi st @region Ids, @ccnR egionIds, @userId, @ moduleIds; | |
114 | ||
115 |
Araxis Merge (but not the data content of this report) is Copyright © 1993-2016 Araxis Ltd (www.araxis.com). All rights reserved.