Mercurial > dive4elements > river
comparison artifacts/src/test/java/org/dive4elements/river/utils/MapUtilsTest.java @ 9672:b70b1bc0eece 3.2.x
Essentially rewrite MapUtils.getConnection() to cope with driver capabilities
author | Tom Gottfried <tom@intevation.de> |
---|---|
date | Sat, 23 May 2020 10:37:23 +0200 |
parents | 9cfc495a9f40 |
children | f4fdf7798bab |
comparison
equal
deleted
inserted
replaced
9671:9cfc495a9f40 | 9672:b70b1bc0eece |
---|---|
5 * and comes with ABSOLUTELY NO WARRANTY! Check out the | 5 * and comes with ABSOLUTELY NO WARRANTY! Check out the |
6 * documentation coming with Dive4Elements River for details. | 6 * documentation coming with Dive4Elements River for details. |
7 */ | 7 */ |
8 | 8 |
9 import static org.junit.Assert.assertEquals; | 9 import static org.junit.Assert.assertEquals; |
10 import static org.junit.Assert.assertNull; | |
10 | 11 |
11 import org.junit.Test; | 12 import org.junit.Test; |
12 | 13 |
13 import org.dive4elements.river.utils.MapUtils; | 14 import org.dive4elements.river.utils.MapUtils; |
14 | 15 |
24 private static final String PORT = "2345"; | 25 private static final String PORT = "2345"; |
25 | 26 |
26 private static final String PG_CON_SUFFIX = " sslmode=disable"; | 27 private static final String PG_CON_SUFFIX = " sslmode=disable"; |
27 | 28 |
28 @Test | 29 @Test |
30 public void noJDBCURL() { | |
31 String con = MapUtils.getConnection(USER, PSWD, "xx"); | |
32 assertNull(con); | |
33 } | |
34 | |
35 @Test | |
36 public void invalidHostPG() { | |
37 String con = MapUtils.getConnection( | |
38 USER, PSWD, DRV_PG + "//invalid_host_name/"); | |
39 assertNull(con); | |
40 } | |
41 | |
42 @Test | |
43 public void localNamedPG() { | |
44 String con = MapUtils.getConnection( | |
45 USER, PSWD, DRV_PG + DB); | |
46 assertEquals( | |
47 "dbname=" + DB | |
48 + " user=" + USER | |
49 + " password='" + PSWD + "'" + PG_CON_SUFFIX, | |
50 con); | |
51 } | |
52 | |
53 @Test | |
54 public void localUserPG() { | |
55 String con = MapUtils.getConnection( | |
56 USER, PSWD, DRV_PG + "/"); | |
57 assertEquals( | |
58 "dbname=" + USER | |
59 + " user=" + USER | |
60 + " password='" + PSWD + "'" + PG_CON_SUFFIX, | |
61 con); | |
62 } | |
63 | |
64 @Test | |
65 public void hostNamedPG() { | |
66 String con = MapUtils.getConnection( | |
67 USER, PSWD, DRV_PG + "//" + HOST + "/" + DB); | |
68 assertEquals( | |
69 "dbname=" + DB | |
70 + " user=" + USER | |
71 + " host='" + HOST + "'" | |
72 + " password='" + PSWD + "'" + PG_CON_SUFFIX, | |
73 con); | |
74 } | |
75 | |
76 @Test | |
77 public void hostUserPG() { | |
78 String con = MapUtils.getConnection( | |
79 USER, PSWD, DRV_PG + "//" + HOST + "/"); | |
80 assertEquals( | |
81 "dbname=" + USER | |
82 + " user=" + USER | |
83 + " host='" + HOST + "'" | |
84 + " password='" + PSWD + "'" + PG_CON_SUFFIX, | |
85 con); | |
86 } | |
87 | |
88 @Test | |
89 public void hostPortUserPG() { | |
90 String con = MapUtils.getConnection( | |
91 USER, PSWD, DRV_PG + "//" + HOST + ":" + PORT + "/"); | |
92 assertEquals( | |
93 "dbname=" + USER | |
94 + " user=" + USER | |
95 + " host='" + HOST + "' port=" + PORT | |
96 + " password='" + PSWD + "'" + PG_CON_SUFFIX, | |
97 con); | |
98 } | |
99 | |
100 @Test | |
29 public void hostPortNamedPG() { | 101 public void hostPortNamedPG() { |
30 MapUtils mu = new MapUtils(); | |
31 String con = MapUtils.getConnection( | 102 String con = MapUtils.getConnection( |
32 USER, PSWD, DRV_PG + "//" + HOST + ":" + PORT + "/" + DB); | 103 USER, PSWD, DRV_PG + "//" + HOST + ":" + PORT + "/" + DB); |
33 assertEquals( | 104 assertEquals( |
34 "dbname=" + DB | 105 "dbname=" + DB |
35 + " host='" + HOST + "' user=" + USER + " port=" + PORT | 106 + " user=" + USER |
107 + " host='" + HOST + "' port=" + PORT | |
36 + " password='" + PSWD + "'" + PG_CON_SUFFIX, | 108 + " password='" + PSWD + "'" + PG_CON_SUFFIX, |
37 con); | 109 con); |
38 } | 110 } |
39 | 111 |
40 @Test | 112 @Test |
41 public void serviceNameORA() { | 113 public void serviceNameORA() { |
42 MapUtils mu = new MapUtils(); | |
43 String con = MapUtils.getConnection( | 114 String con = MapUtils.getConnection( |
44 USER, PSWD, DRV_ORA + "@//" + HOST + ":" + PORT + "/" + DB); | 115 USER, PSWD, DRV_ORA + "@//" + HOST + ":" + PORT + "/" + DB); |
45 assertEquals( | 116 assertEquals( |
46 USER + "/" + PSWD + "@" + HOST + ":" + PORT + "/" + DB, | 117 USER + "/" + PSWD + "@" + HOST + ":" + PORT + "/" + DB, |
47 con); | 118 con); |
48 } | 119 } |
120 | |
121 @Test | |
122 public void connectDescriptorORA() { | |
123 String con = MapUtils.getConnection( | |
124 USER, PSWD, DRV_ORA | |
125 + "@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=" | |
126 + HOST + ")(PORT=" + PORT + "))(CONNECT_DATA=(SERVICE_NAME=" | |
127 + DB + ")))"); | |
128 assertEquals( | |
129 USER + "/" + PSWD | |
130 + "@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=" | |
131 + HOST + ")(PORT=" + PORT + "))(CONNECT_DATA=(SERVICE_NAME=" | |
132 + DB + ")))", | |
133 con); | |
134 } | |
49 } | 135 } |