author | František Kučera <franta-hg@frantovo.cz> |
Sat, 04 Jan 2014 20:24:27 +0100 | |
branch | v_0 |
changeset 131 | 347a7dd94a3f |
parent 39 | be8db46a38c3 |
permissions | -rw-r--r-- |
22
37fe883f8410
formatter: interface and abstract class
František Kučera <franta-hg@frantovo.cz>
parents:
diff
changeset
|
1 |
/** |
37fe883f8410
formatter: interface and abstract class
František Kučera <franta-hg@frantovo.cz>
parents:
diff
changeset
|
2 |
* SQL-DK |
37fe883f8410
formatter: interface and abstract class
František Kučera <franta-hg@frantovo.cz>
parents:
diff
changeset
|
3 |
* Copyright © 2013 František Kučera (frantovo.cz) |
37fe883f8410
formatter: interface and abstract class
František Kučera <franta-hg@frantovo.cz>
parents:
diff
changeset
|
4 |
* |
37fe883f8410
formatter: interface and abstract class
František Kučera <franta-hg@frantovo.cz>
parents:
diff
changeset
|
5 |
* This program is free software: you can redistribute it and/or modify |
37fe883f8410
formatter: interface and abstract class
František Kučera <franta-hg@frantovo.cz>
parents:
diff
changeset
|
6 |
* it under the terms of the GNU General Public License as published by |
37fe883f8410
formatter: interface and abstract class
František Kučera <franta-hg@frantovo.cz>
parents:
diff
changeset
|
7 |
* the Free Software Foundation, either version 3 of the License, or |
37fe883f8410
formatter: interface and abstract class
František Kučera <franta-hg@frantovo.cz>
parents:
diff
changeset
|
8 |
* (at your option) any later version. |
37fe883f8410
formatter: interface and abstract class
František Kučera <franta-hg@frantovo.cz>
parents:
diff
changeset
|
9 |
* |
37fe883f8410
formatter: interface and abstract class
František Kučera <franta-hg@frantovo.cz>
parents:
diff
changeset
|
10 |
* This program is distributed in the hope that it will be useful, |
37fe883f8410
formatter: interface and abstract class
František Kučera <franta-hg@frantovo.cz>
parents:
diff
changeset
|
11 |
* but WITHOUT ANY WARRANTY; without even the implied warranty of |
37fe883f8410
formatter: interface and abstract class
František Kučera <franta-hg@frantovo.cz>
parents:
diff
changeset
|
12 |
* MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the |
37fe883f8410
formatter: interface and abstract class
František Kučera <franta-hg@frantovo.cz>
parents:
diff
changeset
|
13 |
* GNU General Public License for more details. |
37fe883f8410
formatter: interface and abstract class
František Kučera <franta-hg@frantovo.cz>
parents:
diff
changeset
|
14 |
* |
37fe883f8410
formatter: interface and abstract class
František Kučera <franta-hg@frantovo.cz>
parents:
diff
changeset
|
15 |
* You should have received a copy of the GNU General Public License |
37fe883f8410
formatter: interface and abstract class
František Kučera <franta-hg@frantovo.cz>
parents:
diff
changeset
|
16 |
* along with this program. If not, see <http://www.gnu.org/licenses/>. |
37fe883f8410
formatter: interface and abstract class
František Kučera <franta-hg@frantovo.cz>
parents:
diff
changeset
|
17 |
*/ |
37fe883f8410
formatter: interface and abstract class
František Kučera <franta-hg@frantovo.cz>
parents:
diff
changeset
|
18 |
package info.globalcode.sql.dk.formatting; |
37fe883f8410
formatter: interface and abstract class
František Kučera <franta-hg@frantovo.cz>
parents:
diff
changeset
|
19 |
|
23
d8faf91519a5
formatter: ColumnDescriptor
František Kučera <franta-hg@frantovo.cz>
parents:
22
diff
changeset
|
20 |
import java.sql.ResultSetMetaData; |
d8faf91519a5
formatter: ColumnDescriptor
František Kučera <franta-hg@frantovo.cz>
parents:
22
diff
changeset
|
21 |
import java.sql.SQLException; |
d8faf91519a5
formatter: ColumnDescriptor
František Kučera <franta-hg@frantovo.cz>
parents:
22
diff
changeset
|
22 |
import java.util.ArrayList; |
d8faf91519a5
formatter: ColumnDescriptor
František Kučera <franta-hg@frantovo.cz>
parents:
22
diff
changeset
|
23 |
import java.util.List; |
d8faf91519a5
formatter: ColumnDescriptor
František Kučera <franta-hg@frantovo.cz>
parents:
22
diff
changeset
|
24 |
|
22
37fe883f8410
formatter: interface and abstract class
František Kučera <franta-hg@frantovo.cz>
parents:
diff
changeset
|
25 |
/** |
37fe883f8410
formatter: interface and abstract class
František Kučera <franta-hg@frantovo.cz>
parents:
diff
changeset
|
26 |
* |
37fe883f8410
formatter: interface and abstract class
František Kučera <franta-hg@frantovo.cz>
parents:
diff
changeset
|
27 |
* @author Ing. František Kučera (frantovo.cz) |
37fe883f8410
formatter: interface and abstract class
František Kučera <franta-hg@frantovo.cz>
parents:
diff
changeset
|
28 |
*/ |
37fe883f8410
formatter: interface and abstract class
František Kučera <franta-hg@frantovo.cz>
parents:
diff
changeset
|
29 |
public class ColumnsHeader { |
39
be8db46a38c3
TabularFormatter: basic column padding
František Kučera <franta-hg@frantovo.cz>
parents:
37
diff
changeset
|
30 |
|
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:
23
diff
changeset
|
31 |
private ResultSetMetaData metaData; |
39
be8db46a38c3
TabularFormatter: basic column padding
František Kučera <franta-hg@frantovo.cz>
parents:
37
diff
changeset
|
32 |
|
23
d8faf91519a5
formatter: ColumnDescriptor
František Kučera <franta-hg@frantovo.cz>
parents:
22
diff
changeset
|
33 |
public ColumnsHeader(ResultSetMetaData metaData) { |
d8faf91519a5
formatter: ColumnDescriptor
František Kučera <franta-hg@frantovo.cz>
parents:
22
diff
changeset
|
34 |
this.metaData = metaData; |
d8faf91519a5
formatter: ColumnDescriptor
František Kučera <franta-hg@frantovo.cz>
parents:
22
diff
changeset
|
35 |
} |
39
be8db46a38c3
TabularFormatter: basic column padding
František Kučera <franta-hg@frantovo.cz>
parents:
37
diff
changeset
|
36 |
|
22
37fe883f8410
formatter: interface and abstract class
František Kučera <franta-hg@frantovo.cz>
parents:
diff
changeset
|
37 |
public int getColumnCount() { |
23
d8faf91519a5
formatter: ColumnDescriptor
František Kučera <franta-hg@frantovo.cz>
parents:
22
diff
changeset
|
38 |
try { |
d8faf91519a5
formatter: ColumnDescriptor
František Kučera <franta-hg@frantovo.cz>
parents:
22
diff
changeset
|
39 |
return metaData.getColumnCount(); |
d8faf91519a5
formatter: ColumnDescriptor
František Kučera <franta-hg@frantovo.cz>
parents:
22
diff
changeset
|
40 |
} catch (SQLException e) { |
d8faf91519a5
formatter: ColumnDescriptor
František Kučera <franta-hg@frantovo.cz>
parents:
22
diff
changeset
|
41 |
throw new IllegalStateException("Error during getting column count.", e); |
d8faf91519a5
formatter: ColumnDescriptor
František Kučera <franta-hg@frantovo.cz>
parents:
22
diff
changeset
|
42 |
} |
22
37fe883f8410
formatter: interface and abstract class
František Kučera <franta-hg@frantovo.cz>
parents:
diff
changeset
|
43 |
} |
39
be8db46a38c3
TabularFormatter: basic column padding
František Kučera <franta-hg@frantovo.cz>
parents:
37
diff
changeset
|
44 |
|
23
d8faf91519a5
formatter: ColumnDescriptor
František Kučera <franta-hg@frantovo.cz>
parents:
22
diff
changeset
|
45 |
public List<ColumnDescriptor> getColumnDescriptors() { |
d8faf91519a5
formatter: ColumnDescriptor
František Kučera <franta-hg@frantovo.cz>
parents:
22
diff
changeset
|
46 |
try { |
d8faf91519a5
formatter: ColumnDescriptor
František Kučera <franta-hg@frantovo.cz>
parents:
22
diff
changeset
|
47 |
int count = metaData.getColumnCount(); |
d8faf91519a5
formatter: ColumnDescriptor
František Kučera <franta-hg@frantovo.cz>
parents:
22
diff
changeset
|
48 |
List<ColumnDescriptor> list = new ArrayList<>(count); |
39
be8db46a38c3
TabularFormatter: basic column padding
František Kučera <franta-hg@frantovo.cz>
parents:
37
diff
changeset
|
49 |
|
23
d8faf91519a5
formatter: ColumnDescriptor
František Kučera <franta-hg@frantovo.cz>
parents:
22
diff
changeset
|
50 |
for (int i = 1; i <= count; i++) { |
d8faf91519a5
formatter: ColumnDescriptor
František Kučera <franta-hg@frantovo.cz>
parents:
22
diff
changeset
|
51 |
ColumnDescriptor cd = new ColumnDescriptor(); |
39
be8db46a38c3
TabularFormatter: basic column padding
František Kučera <franta-hg@frantovo.cz>
parents:
37
diff
changeset
|
52 |
|
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:
23
diff
changeset
|
53 |
cd.setFirstColumn(i == 1); |
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:
23
diff
changeset
|
54 |
cd.setLastColumn(i == count); |
39
be8db46a38c3
TabularFormatter: basic column padding
František Kučera <franta-hg@frantovo.cz>
parents:
37
diff
changeset
|
55 |
cd.setColumnNumber(i); |
be8db46a38c3
TabularFormatter: basic column padding
František Kučera <franta-hg@frantovo.cz>
parents:
37
diff
changeset
|
56 |
|
23
d8faf91519a5
formatter: ColumnDescriptor
František Kučera <franta-hg@frantovo.cz>
parents:
22
diff
changeset
|
57 |
cd.setLabel(metaData.getColumnLabel(i)); |
d8faf91519a5
formatter: ColumnDescriptor
František Kučera <franta-hg@frantovo.cz>
parents:
22
diff
changeset
|
58 |
cd.setName(metaData.getColumnName(i)); |
d8faf91519a5
formatter: ColumnDescriptor
František Kučera <franta-hg@frantovo.cz>
parents:
22
diff
changeset
|
59 |
cd.setType(metaData.getColumnType(i)); |
d8faf91519a5
formatter: ColumnDescriptor
František Kučera <franta-hg@frantovo.cz>
parents:
22
diff
changeset
|
60 |
cd.setTypeName(metaData.getColumnTypeName(i)); |
d8faf91519a5
formatter: ColumnDescriptor
František Kučera <franta-hg@frantovo.cz>
parents:
22
diff
changeset
|
61 |
/** TODO: more properties */ |
d8faf91519a5
formatter: ColumnDescriptor
František Kučera <franta-hg@frantovo.cz>
parents:
22
diff
changeset
|
62 |
list.add(cd); |
d8faf91519a5
formatter: ColumnDescriptor
František Kučera <franta-hg@frantovo.cz>
parents:
22
diff
changeset
|
63 |
} |
39
be8db46a38c3
TabularFormatter: basic column padding
František Kučera <franta-hg@frantovo.cz>
parents:
37
diff
changeset
|
64 |
|
23
d8faf91519a5
formatter: ColumnDescriptor
František Kučera <franta-hg@frantovo.cz>
parents:
22
diff
changeset
|
65 |
return list; |
d8faf91519a5
formatter: ColumnDescriptor
František Kučera <franta-hg@frantovo.cz>
parents:
22
diff
changeset
|
66 |
} catch (SQLException e) { |
d8faf91519a5
formatter: ColumnDescriptor
František Kučera <franta-hg@frantovo.cz>
parents:
22
diff
changeset
|
67 |
throw new IllegalStateException("Error during building column descriptors.", e); |
d8faf91519a5
formatter: ColumnDescriptor
František Kučera <franta-hg@frantovo.cz>
parents:
22
diff
changeset
|
68 |
} |
d8faf91519a5
formatter: ColumnDescriptor
František Kučera <franta-hg@frantovo.cz>
parents:
22
diff
changeset
|
69 |
} |
22
37fe883f8410
formatter: interface and abstract class
František Kučera <franta-hg@frantovo.cz>
parents:
diff
changeset
|
70 |
} |