Mercurial > dive4elements > river

comparison artifacts/src/test/java/org/dive4elements/river/utils/MapUtilsTest.java @ 9672:b70b1bc0eece 3.2.x

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
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 }
http://dive4elements.wald.intevation.org