author | František Kučera <franta-hg@frantovo.cz> |
Thu, 26 Dec 2013 21:48:59 +0100 | |
branch | v_0 |
changeset 71 | e5d04a68ce1e |
parent 69 | 0befec5034c2 |
child 74 | a8444f6a54f3 |
permissions | -rw-r--r-- |
16
5b8fcd35d4d6
license: GNU GPLv3+
František Kučera <franta-hg@frantovo.cz>
parents:
15
diff
changeset
|
1 |
/** |
5b8fcd35d4d6
license: GNU GPLv3+
František Kučera <franta-hg@frantovo.cz>
parents:
15
diff
changeset
|
2 |
* SQL-DK |
5b8fcd35d4d6
license: GNU GPLv3+
František Kučera <franta-hg@frantovo.cz>
parents:
15
diff
changeset
|
3 |
* Copyright © 2013 František Kučera (frantovo.cz) |
5b8fcd35d4d6
license: GNU GPLv3+
František Kučera <franta-hg@frantovo.cz>
parents:
15
diff
changeset
|
4 |
* |
5b8fcd35d4d6
license: GNU GPLv3+
František Kučera <franta-hg@frantovo.cz>
parents:
15
diff
changeset
|
5 |
* This program is free software: you can redistribute it and/or modify |
5b8fcd35d4d6
license: GNU GPLv3+
František Kučera <franta-hg@frantovo.cz>
parents:
15
diff
changeset
|
6 |
* it under the terms of the GNU General Public License as published by |
5b8fcd35d4d6
license: GNU GPLv3+
František Kučera <franta-hg@frantovo.cz>
parents:
15
diff
changeset
|
7 |
* the Free Software Foundation, either version 3 of the License, or |
5b8fcd35d4d6
license: GNU GPLv3+
František Kučera <franta-hg@frantovo.cz>
parents:
15
diff
changeset
|
8 |
* (at your option) any later version. |
5b8fcd35d4d6
license: GNU GPLv3+
František Kučera <franta-hg@frantovo.cz>
parents:
15
diff
changeset
|
9 |
* |
5b8fcd35d4d6
license: GNU GPLv3+
František Kučera <franta-hg@frantovo.cz>
parents:
15
diff
changeset
|
10 |
* This program is distributed in the hope that it will be useful, |
5b8fcd35d4d6
license: GNU GPLv3+
František Kučera <franta-hg@frantovo.cz>
parents:
15
diff
changeset
|
11 |
* but WITHOUT ANY WARRANTY; without even the implied warranty of |
5b8fcd35d4d6
license: GNU GPLv3+
František Kučera <franta-hg@frantovo.cz>
parents:
15
diff
changeset
|
12 |
* MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the |
5b8fcd35d4d6
license: GNU GPLv3+
František Kučera <franta-hg@frantovo.cz>
parents:
15
diff
changeset
|
13 |
* GNU General Public License for more details. |
5b8fcd35d4d6
license: GNU GPLv3+
František Kučera <franta-hg@frantovo.cz>
parents:
15
diff
changeset
|
14 |
* |
5b8fcd35d4d6
license: GNU GPLv3+
František Kučera <franta-hg@frantovo.cz>
parents:
15
diff
changeset
|
15 |
* You should have received a copy of the GNU General Public License |
5b8fcd35d4d6
license: GNU GPLv3+
František Kučera <franta-hg@frantovo.cz>
parents:
15
diff
changeset
|
16 |
* along with this program. If not, see <http://www.gnu.org/licenses/>. |
5b8fcd35d4d6
license: GNU GPLv3+
František Kučera <franta-hg@frantovo.cz>
parents:
15
diff
changeset
|
17 |
*/ |
1
f32dac78d13a
WOW some classes LOL; TODO: refactor
František Kučera <franta-hg@frantovo.cz>
parents:
diff
changeset
|
18 |
package info.globalcode.sql.dk; |
f32dac78d13a
WOW some classes LOL; TODO: refactor
František Kučera <franta-hg@frantovo.cz>
parents:
diff
changeset
|
19 |
|
f32dac78d13a
WOW some classes LOL; TODO: refactor
František Kučera <franta-hg@frantovo.cz>
parents:
diff
changeset
|
20 |
import static info.globalcode.sql.dk.Functions.isNotEmpty; |
15
bbd335b5410c
show info basics: list databases + test connection
František Kučera <franta-hg@frantovo.cz>
parents:
14
diff
changeset
|
21 |
import static info.globalcode.sql.dk.Functions.isEmpty; |
14 | 22 |
import static info.globalcode.sql.dk.Functions.equalz; |
69
0befec5034c2
InfoLister, InfoType: switch → enum
František Kučera <franta-hg@frantovo.cz>
parents:
63
diff
changeset
|
23 |
import info.globalcode.sql.dk.InfoLister.InfoType; |
34
9335cf31c0f2
first working version
František Kučera <franta-hg@frantovo.cz>
parents:
29
diff
changeset
|
24 |
import java.io.OutputStream; |
1
f32dac78d13a
WOW some classes LOL; TODO: refactor
František Kučera <franta-hg@frantovo.cz>
parents:
diff
changeset
|
25 |
import java.util.ArrayList; |
f32dac78d13a
WOW some classes LOL; TODO: refactor
František Kučera <franta-hg@frantovo.cz>
parents:
diff
changeset
|
26 |
import java.util.Collection; |
14 | 27 |
import java.util.EnumSet; |
1
f32dac78d13a
WOW some classes LOL; TODO: refactor
František Kučera <franta-hg@frantovo.cz>
parents:
diff
changeset
|
28 |
import java.util.List; |
63
3b9ec9c23a37
validation: test if prefix/suffix are valid regular expressions
František Kučera <franta-hg@frantovo.cz>
parents:
54
diff
changeset
|
29 |
import java.util.regex.Pattern; |
3b9ec9c23a37
validation: test if prefix/suffix are valid regular expressions
František Kučera <franta-hg@frantovo.cz>
parents:
54
diff
changeset
|
30 |
import java.util.regex.PatternSyntaxException; |
1
f32dac78d13a
WOW some classes LOL; TODO: refactor
František Kučera <franta-hg@frantovo.cz>
parents:
diff
changeset
|
31 |
|
f32dac78d13a
WOW some classes LOL; TODO: refactor
František Kučera <franta-hg@frantovo.cz>
parents:
diff
changeset
|
32 |
/** |
f32dac78d13a
WOW some classes LOL; TODO: refactor
František Kučera <franta-hg@frantovo.cz>
parents:
diff
changeset
|
33 |
* |
f32dac78d13a
WOW some classes LOL; TODO: refactor
František Kučera <franta-hg@frantovo.cz>
parents:
diff
changeset
|
34 |
* @author Ing. František Kučera (frantovo.cz) |
f32dac78d13a
WOW some classes LOL; TODO: refactor
František Kučera <franta-hg@frantovo.cz>
parents:
diff
changeset
|
35 |
*/ |
f32dac78d13a
WOW some classes LOL; TODO: refactor
František Kučera <franta-hg@frantovo.cz>
parents:
diff
changeset
|
36 |
public class CLIOptions { |
f32dac78d13a
WOW some classes LOL; TODO: refactor
František Kučera <franta-hg@frantovo.cz>
parents:
diff
changeset
|
37 |
|
3 | 38 |
public static final String DEFAULT_NAME_PREFIX = ":"; |
54
53020d0bd2e4
named parameters: prefix/suffix are now regular expressions
František Kučera <franta-hg@frantovo.cz>
parents:
47
diff
changeset
|
39 |
public static final String DEFAULT_NAME_SUFFIX = "(?=([^\\w]|$))"; |
1
f32dac78d13a
WOW some classes LOL; TODO: refactor
František Kučera <franta-hg@frantovo.cz>
parents:
diff
changeset
|
40 |
private String sql; |
f32dac78d13a
WOW some classes LOL; TODO: refactor
František Kučera <franta-hg@frantovo.cz>
parents:
diff
changeset
|
41 |
private String databaseName; |
15
bbd335b5410c
show info basics: list databases + test connection
František Kučera <franta-hg@frantovo.cz>
parents:
14
diff
changeset
|
42 |
private String databaseNameToTest; |
3 | 43 |
private String namePrefix = DEFAULT_NAME_PREFIX; |
44
67581ec4396e
named parameters: suffix (default is empty)
František Kučera <franta-hg@frantovo.cz>
parents:
37
diff
changeset
|
44 |
private String nameSuffix = DEFAULT_NAME_SUFFIX; |
14 | 45 |
private String formatterName; |
1
f32dac78d13a
WOW some classes LOL; TODO: refactor
František Kučera <franta-hg@frantovo.cz>
parents:
diff
changeset
|
46 |
private boolean batch; |
2 | 47 |
|
48 |
public enum MODE { |
|
49 |
||
50 |
QUERY_NOW, |
|
51 |
PREPARE_BATCH, |
|
14 | 52 |
EXECUTE_BATCH, |
53 |
JUST_SHOW_INFO |
|
54 |
} |
|
34
9335cf31c0f2
first working version
František Kučera <franta-hg@frantovo.cz>
parents:
29
diff
changeset
|
55 |
private final List<NamedParameter> namedParameters = new ArrayList<>(); |
1
f32dac78d13a
WOW some classes LOL; TODO: refactor
František Kučera <franta-hg@frantovo.cz>
parents:
diff
changeset
|
56 |
private final List<Parameter> numberedParameters = new ArrayList<>(); |
69
0befec5034c2
InfoLister, InfoType: switch → enum
František Kučera <franta-hg@frantovo.cz>
parents:
63
diff
changeset
|
57 |
private final EnumSet<InfoType> showInfo = EnumSet.noneOf(InfoType.class); |
1
f32dac78d13a
WOW some classes LOL; TODO: refactor
František Kučera <franta-hg@frantovo.cz>
parents:
diff
changeset
|
58 |
|
f32dac78d13a
WOW some classes LOL; TODO: refactor
František Kučera <franta-hg@frantovo.cz>
parents:
diff
changeset
|
59 |
public void validate() throws InvalidOptionsException { |
f32dac78d13a
WOW some classes LOL; TODO: refactor
František Kučera <franta-hg@frantovo.cz>
parents:
diff
changeset
|
60 |
InvalidOptionsException e = new InvalidOptionsException(); |
f32dac78d13a
WOW some classes LOL; TODO: refactor
František Kučera <franta-hg@frantovo.cz>
parents:
diff
changeset
|
61 |
|
14 | 62 |
MODE mode = getMode(); |
63 |
if (mode == null) { |
|
1
f32dac78d13a
WOW some classes LOL; TODO: refactor
František Kučera <franta-hg@frantovo.cz>
parents:
diff
changeset
|
64 |
e.addProblem(new InvalidOptionsException.OptionProblem("Invalid combination of DB, SQL and BATCH – please specify just 2 of this 3 options")); |
14 | 65 |
} else if (mode == MODE.JUST_SHOW_INFO) { |
66 |
if (!namedParameters.isEmpty()) { |
|
67 |
e.addProblem(new InvalidOptionsException.OptionProblem("Do not use named parameters if just showing info.")); |
|
68 |
} |
|
69 |
if (!numberedParameters.isEmpty()) { |
|
70 |
e.addProblem(new InvalidOptionsException.OptionProblem("Do not use numbered parameters if just showing info.")); |
|
71 |
} |
|
72 |
if (isNotEmpty(sql, false)) { |
|
73 |
e.addProblem(new InvalidOptionsException.OptionProblem("Do not specify SQL if just showing info.")); |
|
74 |
} |
|
75 |
if (isNotEmpty(databaseName, false)) { |
|
76 |
e.addProblem(new InvalidOptionsException.OptionProblem("Do not specify database if just showing info.")); |
|
77 |
} |
|
78 |
if (batch) { |
|
79 |
e.addProblem(new InvalidOptionsException.OptionProblem("Do not specify batch if just showing info.")); |
|
80 |
} |
|
81 |
if (!equalz(namePrefix, DEFAULT_NAME_PREFIX)) { |
|
82 |
e.addProblem(new InvalidOptionsException.OptionProblem("Do not specify name prefix if just showing info.")); |
|
83 |
} |
|
44
67581ec4396e
named parameters: suffix (default is empty)
František Kučera <franta-hg@frantovo.cz>
parents:
37
diff
changeset
|
84 |
if (!equalz(nameSuffix, DEFAULT_NAME_SUFFIX)) { |
67581ec4396e
named parameters: suffix (default is empty)
František Kučera <franta-hg@frantovo.cz>
parents:
37
diff
changeset
|
85 |
e.addProblem(new InvalidOptionsException.OptionProblem("Do not specify name suffix if just showing info.")); |
67581ec4396e
named parameters: suffix (default is empty)
František Kučera <franta-hg@frantovo.cz>
parents:
37
diff
changeset
|
86 |
} |
69
0befec5034c2
InfoLister, InfoType: switch → enum
František Kučera <franta-hg@frantovo.cz>
parents:
63
diff
changeset
|
87 |
if (showInfo.contains(InfoType.CONNECTION) && isEmpty(databaseNameToTest, false)) { |
15
bbd335b5410c
show info basics: list databases + test connection
František Kučera <franta-hg@frantovo.cz>
parents:
14
diff
changeset
|
88 |
e.addProblem(new InvalidOptionsException.OptionProblem("Please specify which database should be tested.")); |
bbd335b5410c
show info basics: list databases + test connection
František Kučera <franta-hg@frantovo.cz>
parents:
14
diff
changeset
|
89 |
} |
1
f32dac78d13a
WOW some classes LOL; TODO: refactor
František Kučera <franta-hg@frantovo.cz>
parents:
diff
changeset
|
90 |
} |
f32dac78d13a
WOW some classes LOL; TODO: refactor
František Kučera <franta-hg@frantovo.cz>
parents:
diff
changeset
|
91 |
|
f32dac78d13a
WOW some classes LOL; TODO: refactor
František Kučera <franta-hg@frantovo.cz>
parents:
diff
changeset
|
92 |
if (!namedParameters.isEmpty() && !numberedParameters.isEmpty()) { |
f32dac78d13a
WOW some classes LOL; TODO: refactor
František Kučera <franta-hg@frantovo.cz>
parents:
diff
changeset
|
93 |
e.addProblem(new InvalidOptionsException.OptionProblem("Named and numbered parameters can not be used together in one command.")); |
f32dac78d13a
WOW some classes LOL; TODO: refactor
František Kučera <franta-hg@frantovo.cz>
parents:
diff
changeset
|
94 |
} |
f32dac78d13a
WOW some classes LOL; TODO: refactor
František Kučera <franta-hg@frantovo.cz>
parents:
diff
changeset
|
95 |
|
63
3b9ec9c23a37
validation: test if prefix/suffix are valid regular expressions
František Kučera <franta-hg@frantovo.cz>
parents:
54
diff
changeset
|
96 |
try { |
3b9ec9c23a37
validation: test if prefix/suffix are valid regular expressions
František Kučera <franta-hg@frantovo.cz>
parents:
54
diff
changeset
|
97 |
Pattern.compile(namePrefix + "test" + nameSuffix); |
3b9ec9c23a37
validation: test if prefix/suffix are valid regular expressions
František Kučera <franta-hg@frantovo.cz>
parents:
54
diff
changeset
|
98 |
} catch (PatternSyntaxException regexException) { |
3b9ec9c23a37
validation: test if prefix/suffix are valid regular expressions
František Kučera <franta-hg@frantovo.cz>
parents:
54
diff
changeset
|
99 |
e.addProblem(new InvalidOptionsException.OptionProblem("Ivalid regular expression in name prefix or suffix", regexException)); |
3b9ec9c23a37
validation: test if prefix/suffix are valid regular expressions
František Kučera <franta-hg@frantovo.cz>
parents:
54
diff
changeset
|
100 |
} |
1
f32dac78d13a
WOW some classes LOL; TODO: refactor
František Kučera <franta-hg@frantovo.cz>
parents:
diff
changeset
|
101 |
|
f32dac78d13a
WOW some classes LOL; TODO: refactor
František Kučera <franta-hg@frantovo.cz>
parents:
diff
changeset
|
102 |
if (e.hasProblems()) { |
f32dac78d13a
WOW some classes LOL; TODO: refactor
František Kučera <franta-hg@frantovo.cz>
parents:
diff
changeset
|
103 |
throw e; |
f32dac78d13a
WOW some classes LOL; TODO: refactor
František Kučera <franta-hg@frantovo.cz>
parents:
diff
changeset
|
104 |
} |
f32dac78d13a
WOW some classes LOL; TODO: refactor
František Kučera <franta-hg@frantovo.cz>
parents:
diff
changeset
|
105 |
} |
f32dac78d13a
WOW some classes LOL; TODO: refactor
František Kučera <franta-hg@frantovo.cz>
parents:
diff
changeset
|
106 |
|
2 | 107 |
private boolean hasSql() { |
108 |
return isNotEmpty(getSql(), true); |
|
109 |
} |
|
110 |
||
111 |
private boolean hasDb() { |
|
112 |
return isNotEmpty(getDatabaseName(), true); |
|
113 |
} |
|
114 |
||
115 |
/** |
|
116 |
* Depends on options: DB, BATCH, SQL |
|
117 |
* |
|
118 |
* @return mode | or null if options are not yet initialized or combination of options is |
|
119 |
* invalid |
|
120 |
*/ |
|
121 |
public MODE getMode() { |
|
122 |
if (hasDb() && !batch && hasSql()) { |
|
123 |
return MODE.QUERY_NOW; |
|
124 |
} else if (!hasDb() && batch && hasSql()) { |
|
125 |
return MODE.PREPARE_BATCH; |
|
126 |
} else if (hasDb() && batch && !hasSql()) { |
|
127 |
return MODE.EXECUTE_BATCH; |
|
128 |
} else { |
|
14 | 129 |
return showInfo.isEmpty() ? null : MODE.JUST_SHOW_INFO; |
2 | 130 |
} |
131 |
} |
|
132 |
||
133 |
public String getSql() { |
|
134 |
return sql; |
|
135 |
} |
|
136 |
||
137 |
public void setSql(String sql) { |
|
138 |
this.sql = sql; |
|
1
f32dac78d13a
WOW some classes LOL; TODO: refactor
František Kučera <franta-hg@frantovo.cz>
parents:
diff
changeset
|
139 |
} |
f32dac78d13a
WOW some classes LOL; TODO: refactor
František Kučera <franta-hg@frantovo.cz>
parents:
diff
changeset
|
140 |
|
2 | 141 |
public String getDatabaseName() { |
142 |
return databaseName; |
|
143 |
} |
|
144 |
||
145 |
public void setDatabaseName(String databaseName) { |
|
146 |
this.databaseName = databaseName; |
|
147 |
} |
|
148 |
||
149 |
public void setBatch(boolean batch) { |
|
150 |
this.batch = batch; |
|
151 |
} |
|
152 |
||
153 |
public Collection<NamedParameter> getNamedParameters() { |
|
154 |
return namedParameters; |
|
155 |
} |
|
156 |
||
157 |
public List<Parameter> getNumberedParameters() { |
|
158 |
return numberedParameters; |
|
159 |
} |
|
160 |
||
161 |
public void addNumberedParameter(Parameter p) { |
|
162 |
numberedParameters.add(p); |
|
163 |
} |
|
164 |
||
165 |
public void addNamedParameter(NamedParameter p) { |
|
166 |
namedParameters.add(p); |
|
1
f32dac78d13a
WOW some classes LOL; TODO: refactor
František Kučera <franta-hg@frantovo.cz>
parents:
diff
changeset
|
167 |
} |
3 | 168 |
|
54
53020d0bd2e4
named parameters: prefix/suffix are now regular expressions
František Kučera <franta-hg@frantovo.cz>
parents:
47
diff
changeset
|
169 |
/** |
53020d0bd2e4
named parameters: prefix/suffix are now regular expressions
František Kučera <franta-hg@frantovo.cz>
parents:
47
diff
changeset
|
170 |
* @return regular expression describing the name prefix |
53020d0bd2e4
named parameters: prefix/suffix are now regular expressions
František Kučera <franta-hg@frantovo.cz>
parents:
47
diff
changeset
|
171 |
*/ |
3 | 172 |
public String getNamePrefix() { |
173 |
return namePrefix; |
|
174 |
} |
|
175 |
||
54
53020d0bd2e4
named parameters: prefix/suffix are now regular expressions
František Kučera <franta-hg@frantovo.cz>
parents:
47
diff
changeset
|
176 |
/** |
53020d0bd2e4
named parameters: prefix/suffix are now regular expressions
František Kučera <franta-hg@frantovo.cz>
parents:
47
diff
changeset
|
177 |
* @see #getNamePrefix() |
53020d0bd2e4
named parameters: prefix/suffix are now regular expressions
František Kučera <franta-hg@frantovo.cz>
parents:
47
diff
changeset
|
178 |
*/ |
3 | 179 |
public void setNamePrefix(String namePrefix) { |
180 |
this.namePrefix = namePrefix; |
|
181 |
} |
|
14 | 182 |
|
54
53020d0bd2e4
named parameters: prefix/suffix are now regular expressions
František Kučera <franta-hg@frantovo.cz>
parents:
47
diff
changeset
|
183 |
/** |
53020d0bd2e4
named parameters: prefix/suffix are now regular expressions
František Kučera <franta-hg@frantovo.cz>
parents:
47
diff
changeset
|
184 |
* @return regular expression describing the name prefix |
53020d0bd2e4
named parameters: prefix/suffix are now regular expressions
František Kučera <franta-hg@frantovo.cz>
parents:
47
diff
changeset
|
185 |
*/ |
44
67581ec4396e
named parameters: suffix (default is empty)
František Kučera <franta-hg@frantovo.cz>
parents:
37
diff
changeset
|
186 |
public String getNameSuffix() { |
67581ec4396e
named parameters: suffix (default is empty)
František Kučera <franta-hg@frantovo.cz>
parents:
37
diff
changeset
|
187 |
return nameSuffix; |
67581ec4396e
named parameters: suffix (default is empty)
František Kučera <franta-hg@frantovo.cz>
parents:
37
diff
changeset
|
188 |
} |
67581ec4396e
named parameters: suffix (default is empty)
František Kučera <franta-hg@frantovo.cz>
parents:
37
diff
changeset
|
189 |
|
54
53020d0bd2e4
named parameters: prefix/suffix are now regular expressions
František Kučera <franta-hg@frantovo.cz>
parents:
47
diff
changeset
|
190 |
/** |
53020d0bd2e4
named parameters: prefix/suffix are now regular expressions
František Kučera <franta-hg@frantovo.cz>
parents:
47
diff
changeset
|
191 |
* @see #getNameSuffix() |
53020d0bd2e4
named parameters: prefix/suffix are now regular expressions
František Kučera <franta-hg@frantovo.cz>
parents:
47
diff
changeset
|
192 |
*/ |
44
67581ec4396e
named parameters: suffix (default is empty)
František Kučera <franta-hg@frantovo.cz>
parents:
37
diff
changeset
|
193 |
public void setNameSuffix(String nameSuffix) { |
67581ec4396e
named parameters: suffix (default is empty)
František Kučera <franta-hg@frantovo.cz>
parents:
37
diff
changeset
|
194 |
this.nameSuffix = nameSuffix; |
67581ec4396e
named parameters: suffix (default is empty)
František Kučera <franta-hg@frantovo.cz>
parents:
37
diff
changeset
|
195 |
} |
67581ec4396e
named parameters: suffix (default is empty)
František Kučera <franta-hg@frantovo.cz>
parents:
37
diff
changeset
|
196 |
|
14 | 197 |
public String getFormatterName() { |
198 |
return formatterName; |
|
199 |
} |
|
200 |
||
201 |
public void setFormatterName(String formatterName) { |
|
202 |
this.formatterName = formatterName; |
|
203 |
} |
|
204 |
||
69
0befec5034c2
InfoLister, InfoType: switch → enum
František Kučera <franta-hg@frantovo.cz>
parents:
63
diff
changeset
|
205 |
public void addShowInfo(InfoType info) { |
14 | 206 |
showInfo.add(info); |
207 |
} |
|
208 |
||
69
0befec5034c2
InfoLister, InfoType: switch → enum
František Kučera <franta-hg@frantovo.cz>
parents:
63
diff
changeset
|
209 |
public EnumSet<InfoType> getShowInfo() { |
14 | 210 |
return showInfo; |
211 |
} |
|
15
bbd335b5410c
show info basics: list databases + test connection
František Kučera <franta-hg@frantovo.cz>
parents:
14
diff
changeset
|
212 |
|
bbd335b5410c
show info basics: list databases + test connection
František Kučera <franta-hg@frantovo.cz>
parents:
14
diff
changeset
|
213 |
public String getDatabaseNameToTest() { |
bbd335b5410c
show info basics: list databases + test connection
František Kučera <franta-hg@frantovo.cz>
parents:
14
diff
changeset
|
214 |
return databaseNameToTest; |
bbd335b5410c
show info basics: list databases + test connection
František Kučera <franta-hg@frantovo.cz>
parents:
14
diff
changeset
|
215 |
} |
bbd335b5410c
show info basics: list databases + test connection
František Kučera <franta-hg@frantovo.cz>
parents:
14
diff
changeset
|
216 |
|
bbd335b5410c
show info basics: list databases + test connection
František Kučera <franta-hg@frantovo.cz>
parents:
14
diff
changeset
|
217 |
public void setDatabaseNameToTest(String databaseNameToTest) { |
bbd335b5410c
show info basics: list databases + test connection
František Kučera <franta-hg@frantovo.cz>
parents:
14
diff
changeset
|
218 |
this.databaseNameToTest = databaseNameToTest; |
bbd335b5410c
show info basics: list databases + test connection
František Kučera <franta-hg@frantovo.cz>
parents:
14
diff
changeset
|
219 |
} |
34
9335cf31c0f2
first working version
František Kučera <franta-hg@frantovo.cz>
parents:
29
diff
changeset
|
220 |
|
9335cf31c0f2
first working version
František Kučera <franta-hg@frantovo.cz>
parents:
29
diff
changeset
|
221 |
public SQLCommand getSQLCommand() { |
9335cf31c0f2
first working version
František Kučera <franta-hg@frantovo.cz>
parents:
29
diff
changeset
|
222 |
if (namedParameters.isEmpty()) { |
37
9e6f8e5d5f98
support SQL commands returning more ResultSets + remove COMMAND_TYPE (type is now derived from result returned from SQL – it is not needed to specify the type on CLI)
František Kučera <franta-hg@frantovo.cz>
parents:
34
diff
changeset
|
223 |
return new SQLCommandNumbered(sql, numberedParameters); |
34
9335cf31c0f2
first working version
František Kučera <franta-hg@frantovo.cz>
parents:
29
diff
changeset
|
224 |
} else { |
47 | 225 |
return new SQLCommandNamed(sql, namedParameters, namePrefix, nameSuffix); |
34
9335cf31c0f2
first working version
František Kučera <franta-hg@frantovo.cz>
parents:
29
diff
changeset
|
226 |
} |
9335cf31c0f2
first working version
František Kučera <franta-hg@frantovo.cz>
parents:
29
diff
changeset
|
227 |
} |
9335cf31c0f2
first working version
František Kučera <franta-hg@frantovo.cz>
parents:
29
diff
changeset
|
228 |
|
9335cf31c0f2
first working version
František Kučera <franta-hg@frantovo.cz>
parents:
29
diff
changeset
|
229 |
public OutputStream getOutputStream() { |
9335cf31c0f2
first working version
František Kučera <franta-hg@frantovo.cz>
parents:
29
diff
changeset
|
230 |
return System.out; |
9335cf31c0f2
first working version
František Kučera <franta-hg@frantovo.cz>
parents:
29
diff
changeset
|
231 |
} |
1
f32dac78d13a
WOW some classes LOL; TODO: refactor
František Kučera <franta-hg@frantovo.cz>
parents:
diff
changeset
|
232 |
} |