java/sql-dk/src/info/globalcode/sql/dk/InfoLister.java
author František Kučera <franta-hg@frantovo.cz>
Thu, 26 Dec 2013 01:29:29 +0100
branchv_0
changeset 66 6e28893eaada
parent 65 f05be87239ad
child 67 10c9b9e54622
permissions -rw-r--r--
option --list-databases list configured databases
Ignore whitespace changes - Everywhere: Within whitespace: At end of lines:
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
 */
14
189b1260b942 show info basics
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
    18
package info.globalcode.sql.dk;
189b1260b942 show info basics
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
    19
65
f05be87239ad option --test-connection – tests connection to given database
František Kučera <franta-hg@frantovo.cz>
parents: 26
diff changeset
    20
import info.globalcode.sql.dk.configuration.ConfigurationException;
26
4ec8e5534eb9 configuration basics
František Kučera <franta-hg@frantovo.cz>
parents: 20
diff changeset
    21
import info.globalcode.sql.dk.configuration.ConfigurationProvider;
65
f05be87239ad option --test-connection – tests connection to given database
František Kučera <franta-hg@frantovo.cz>
parents: 26
diff changeset
    22
import info.globalcode.sql.dk.configuration.DatabaseDefinition;
17
d8ab8aece6f2 license option: --license
František Kučera <franta-hg@frantovo.cz>
parents: 16
diff changeset
    23
import java.io.BufferedReader;
d8ab8aece6f2 license option: --license
František Kučera <franta-hg@frantovo.cz>
parents: 16
diff changeset
    24
import java.io.InputStreamReader;
14
189b1260b942 show info basics
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
    25
import java.io.PrintStream;
65
f05be87239ad option --test-connection – tests connection to given database
František Kučera <franta-hg@frantovo.cz>
parents: 26
diff changeset
    26
import java.sql.SQLException;
14
189b1260b942 show info basics
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
    27
import java.util.EnumSet;
66
6e28893eaada option --list-databases list configured databases
František Kučera <franta-hg@frantovo.cz>
parents: 65
diff changeset
    28
import java.util.List;
17
d8ab8aece6f2 license option: --license
František Kučera <franta-hg@frantovo.cz>
parents: 16
diff changeset
    29
import java.util.logging.Level;
d8ab8aece6f2 license option: --license
František Kučera <franta-hg@frantovo.cz>
parents: 16
diff changeset
    30
import java.util.logging.Logger;
14
189b1260b942 show info basics
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
    31
189b1260b942 show info basics
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
    32
/**
189b1260b942 show info basics
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
    33
 * Displays info like help, version etc.
189b1260b942 show info basics
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
    34
 *
189b1260b942 show info basics
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
    35
 * @author Ing. František Kučera (frantovo.cz)
189b1260b942 show info basics
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
    36
 */
189b1260b942 show info basics
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
    37
public class InfoLister {
189b1260b942 show info basics
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
    38
17
d8ab8aece6f2 license option: --license
František Kučera <franta-hg@frantovo.cz>
parents: 16
diff changeset
    39
	private static final Logger log = Logger.getLogger(InfoLister.class.getName());
d8ab8aece6f2 license option: --license
František Kučera <franta-hg@frantovo.cz>
parents: 16
diff changeset
    40
	private PrintStream out;
20
e225bdcd260e refactor, configuration
František Kučera <franta-hg@frantovo.cz>
parents: 19
diff changeset
    41
	private ConfigurationProvider configurationProvider;
17
d8ab8aece6f2 license option: --license
František Kučera <franta-hg@frantovo.cz>
parents: 16
diff changeset
    42
20
e225bdcd260e refactor, configuration
František Kučera <franta-hg@frantovo.cz>
parents: 19
diff changeset
    43
	public InfoLister(PrintStream out, ConfigurationProvider configurationProvider) {
17
d8ab8aece6f2 license option: --license
František Kučera <franta-hg@frantovo.cz>
parents: 16
diff changeset
    44
		this.out = out;
20
e225bdcd260e refactor, configuration
František Kučera <franta-hg@frantovo.cz>
parents: 19
diff changeset
    45
		this.configurationProvider = configurationProvider;
17
d8ab8aece6f2 license option: --license
František Kučera <franta-hg@frantovo.cz>
parents: 16
diff changeset
    46
	}
d8ab8aece6f2 license option: --license
František Kučera <franta-hg@frantovo.cz>
parents: 16
diff changeset
    47
66
6e28893eaada option --list-databases list configured databases
František Kučera <franta-hg@frantovo.cz>
parents: 65
diff changeset
    48
	public void showInfo(CLIOptions options) throws ConfigurationException {
15
bbd335b5410c show info basics: list databases + test connection
František Kučera <franta-hg@frantovo.cz>
parents: 14
diff changeset
    49
		EnumSet<CLIOptions.INFO_TYPE> infoTypes = options.getShowInfo();
14
189b1260b942 show info basics
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
    50
		for (CLIOptions.INFO_TYPE infoType : infoTypes) {
189b1260b942 show info basics
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
    51
			switch (infoType) {
189b1260b942 show info basics
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
    52
				/**
189b1260b942 show info basics
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
    53
				 * TODO: implement show info
189b1260b942 show info basics
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
    54
				 */
189b1260b942 show info basics
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
    55
				case FORMATTERS:
17
d8ab8aece6f2 license option: --license
František Kučera <franta-hg@frantovo.cz>
parents: 16
diff changeset
    56
					println("TODO: list available formatters");
14
189b1260b942 show info basics
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
    57
					break;
189b1260b942 show info basics
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
    58
				case HELP:
19
873669135d97 help option: --help – basics
František Kučera <franta-hg@frantovo.cz>
parents: 18
diff changeset
    59
					printResource(Constants.HELP_FILE);
14
189b1260b942 show info basics
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
    60
					break;
189b1260b942 show info basics
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
    61
				case LICENSE:
18
7900bb1666f6 version info: option --version
František Kučera <franta-hg@frantovo.cz>
parents: 17
diff changeset
    62
					printResource(Constants.LICENSE_FILE);
14
189b1260b942 show info basics
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
    63
					break;
189b1260b942 show info basics
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
    64
				case TYPES:
17
d8ab8aece6f2 license option: --license
František Kučera <franta-hg@frantovo.cz>
parents: 16
diff changeset
    65
					println("TODO: list supported types");
14
189b1260b942 show info basics
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
    66
					break;
189b1260b942 show info basics
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
    67
				case VERSION:
18
7900bb1666f6 version info: option --version
František Kučera <franta-hg@frantovo.cz>
parents: 17
diff changeset
    68
					printResource(Constants.VERSION_FILE);
14
189b1260b942 show info basics
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
    69
					break;
15
bbd335b5410c show info basics: list databases + test connection
František Kučera <franta-hg@frantovo.cz>
parents: 14
diff changeset
    70
				case DATABASES:
66
6e28893eaada option --list-databases list configured databases
František Kučera <franta-hg@frantovo.cz>
parents: 65
diff changeset
    71
					final List<DatabaseDefinition> configuredDatabases = configurationProvider.getConfiguration().getDatabases();
6e28893eaada option --list-databases list configured databases
František Kučera <franta-hg@frantovo.cz>
parents: 65
diff changeset
    72
					if (configuredDatabases.isEmpty()) {
6e28893eaada option --list-databases list configured databases
František Kučera <franta-hg@frantovo.cz>
parents: 65
diff changeset
    73
						log.log(Level.WARNING, "No databases are configured.");
6e28893eaada option --list-databases list configured databases
František Kučera <franta-hg@frantovo.cz>
parents: 65
diff changeset
    74
					} else {
6e28893eaada option --list-databases list configured databases
František Kučera <franta-hg@frantovo.cz>
parents: 65
diff changeset
    75
						for (DatabaseDefinition dd : configuredDatabases) {
6e28893eaada option --list-databases list configured databases
František Kučera <franta-hg@frantovo.cz>
parents: 65
diff changeset
    76
							log.log(Level.INFO, "Configured database: {0}", dd.getName());
6e28893eaada option --list-databases list configured databases
František Kučera <franta-hg@frantovo.cz>
parents: 65
diff changeset
    77
						}
6e28893eaada option --list-databases list configured databases
František Kučera <franta-hg@frantovo.cz>
parents: 65
diff changeset
    78
					}
15
bbd335b5410c show info basics: list databases + test connection
František Kučera <franta-hg@frantovo.cz>
parents: 14
diff changeset
    79
					break;
bbd335b5410c show info basics: list databases + test connection
František Kučera <franta-hg@frantovo.cz>
parents: 14
diff changeset
    80
				case CONNECTION:
65
f05be87239ad option --test-connection – tests connection to given database
František Kučera <franta-hg@frantovo.cz>
parents: 26
diff changeset
    81
					boolean connectionTestResult = false;
f05be87239ad option --test-connection – tests connection to given database
František Kučera <franta-hg@frantovo.cz>
parents: 26
diff changeset
    82
					String dbName = options.getDatabaseNameToTest();
f05be87239ad option --test-connection – tests connection to given database
František Kučera <franta-hg@frantovo.cz>
parents: 26
diff changeset
    83
					log.log(Level.FINE, "Testing connection to database: {0}", dbName);
f05be87239ad option --test-connection – tests connection to given database
František Kučera <franta-hg@frantovo.cz>
parents: 26
diff changeset
    84
					try {
f05be87239ad option --test-connection – tests connection to given database
František Kučera <franta-hg@frantovo.cz>
parents: 26
diff changeset
    85
						DatabaseDefinition dd = configurationProvider.getConfiguration().getDatabase(dbName);
f05be87239ad option --test-connection – tests connection to given database
František Kučera <franta-hg@frantovo.cz>
parents: 26
diff changeset
    86
						if (dd == null) {
f05be87239ad option --test-connection – tests connection to given database
František Kučera <franta-hg@frantovo.cz>
parents: 26
diff changeset
    87
							log.log(Level.SEVERE, "No database with this name is configured: {0}", dbName);
f05be87239ad option --test-connection – tests connection to given database
František Kučera <franta-hg@frantovo.cz>
parents: 26
diff changeset
    88
						} else {
f05be87239ad option --test-connection – tests connection to given database
František Kučera <franta-hg@frantovo.cz>
parents: 26
diff changeset
    89
							log.log(Level.FINE, "Database definition was loaded from configuration");
f05be87239ad option --test-connection – tests connection to given database
František Kučera <franta-hg@frantovo.cz>
parents: 26
diff changeset
    90
							DatabaseConnection dc = dd.connect();
f05be87239ad option --test-connection – tests connection to given database
František Kučera <franta-hg@frantovo.cz>
parents: 26
diff changeset
    91
							connectionTestResult = dc.test();
f05be87239ad option --test-connection – tests connection to given database
František Kučera <franta-hg@frantovo.cz>
parents: 26
diff changeset
    92
						}
f05be87239ad option --test-connection – tests connection to given database
František Kučera <franta-hg@frantovo.cz>
parents: 26
diff changeset
    93
					} catch (ConfigurationException | SQLException e) {
f05be87239ad option --test-connection – tests connection to given database
František Kučera <franta-hg@frantovo.cz>
parents: 26
diff changeset
    94
						log.log(Level.SEVERE, "Error during testing connection", e);
f05be87239ad option --test-connection – tests connection to given database
František Kučera <franta-hg@frantovo.cz>
parents: 26
diff changeset
    95
					}
f05be87239ad option --test-connection – tests connection to given database
František Kučera <franta-hg@frantovo.cz>
parents: 26
diff changeset
    96
					log.log(Level.INFO, "Connection test result: {0}", connectionTestResult ? "success" : "failure");
15
bbd335b5410c show info basics: list databases + test connection
František Kučera <franta-hg@frantovo.cz>
parents: 14
diff changeset
    97
					break;
14
189b1260b942 show info basics
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
    98
				default:
189b1260b942 show info basics
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
    99
					throw new IllegalArgumentException("Unsupported INFO_TYPE: " + infoType);
189b1260b942 show info basics
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
   100
			}
189b1260b942 show info basics
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
   101
		}
189b1260b942 show info basics
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
   102
	}
17
d8ab8aece6f2 license option: --license
František Kučera <franta-hg@frantovo.cz>
parents: 16
diff changeset
   103
18
7900bb1666f6 version info: option --version
František Kučera <franta-hg@frantovo.cz>
parents: 17
diff changeset
   104
	private void printResource(String fileName) {
7900bb1666f6 version info: option --version
František Kučera <franta-hg@frantovo.cz>
parents: 17
diff changeset
   105
		try (BufferedReader reader = new BufferedReader(new InputStreamReader(getClass().getClassLoader().getResourceAsStream(fileName)))) {
17
d8ab8aece6f2 license option: --license
František Kučera <franta-hg@frantovo.cz>
parents: 16
diff changeset
   106
			while (true) {
18
7900bb1666f6 version info: option --version
František Kučera <franta-hg@frantovo.cz>
parents: 17
diff changeset
   107
				String line = reader.readLine();
17
d8ab8aece6f2 license option: --license
František Kučera <franta-hg@frantovo.cz>
parents: 16
diff changeset
   108
				if (line == null) {
d8ab8aece6f2 license option: --license
František Kučera <franta-hg@frantovo.cz>
parents: 16
diff changeset
   109
					break;
d8ab8aece6f2 license option: --license
František Kučera <franta-hg@frantovo.cz>
parents: 16
diff changeset
   110
				} else {
d8ab8aece6f2 license option: --license
František Kučera <franta-hg@frantovo.cz>
parents: 16
diff changeset
   111
					println(line);
d8ab8aece6f2 license option: --license
František Kučera <franta-hg@frantovo.cz>
parents: 16
diff changeset
   112
				}
d8ab8aece6f2 license option: --license
František Kučera <franta-hg@frantovo.cz>
parents: 16
diff changeset
   113
			}
d8ab8aece6f2 license option: --license
František Kučera <franta-hg@frantovo.cz>
parents: 16
diff changeset
   114
		} catch (Exception e) {
18
7900bb1666f6 version info: option --version
František Kučera <franta-hg@frantovo.cz>
parents: 17
diff changeset
   115
			log.log(Level.SEVERE, "Unable to print this info. Please see our website for it: " + Constants.WEBSITE, e);
17
d8ab8aece6f2 license option: --license
František Kučera <franta-hg@frantovo.cz>
parents: 16
diff changeset
   116
		}
d8ab8aece6f2 license option: --license
František Kučera <franta-hg@frantovo.cz>
parents: 16
diff changeset
   117
	}
d8ab8aece6f2 license option: --license
František Kučera <franta-hg@frantovo.cz>
parents: 16
diff changeset
   118
d8ab8aece6f2 license option: --license
František Kučera <franta-hg@frantovo.cz>
parents: 16
diff changeset
   119
	private void println(String line) {
d8ab8aece6f2 license option: --license
František Kučera <franta-hg@frantovo.cz>
parents: 16
diff changeset
   120
		out.println(line);
d8ab8aece6f2 license option: --license
František Kučera <franta-hg@frantovo.cz>
parents: 16
diff changeset
   121
	}
14
189b1260b942 show info basics
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
   122
}