java/sql-dk/src/info/globalcode/sql/dk/formatting/AbstractFormatter.java
author František Kučera <franta-hg@frantovo.cz>
Mon, 23 Dec 2013 16:19:21 +0100
branchv_0
changeset 41 514df5061f59
parent 39 be8db46a38c3
child 88 102ba0fcb07f
permissions -rw-r--r--
No special formatting for generated keys. Use 'INSERT … RETURNING id' or 'INSERT … RETURNING *' to get generated keys.
franta-hg@22
     1
/**
franta-hg@22
     2
 * SQL-DK
franta-hg@22
     3
 * Copyright © 2013 František Kučera (frantovo.cz)
franta-hg@22
     4
 *
franta-hg@22
     5
 * This program is free software: you can redistribute it and/or modify
franta-hg@22
     6
 * it under the terms of the GNU General Public License as published by
franta-hg@22
     7
 * the Free Software Foundation, either version 3 of the License, or
franta-hg@22
     8
 * (at your option) any later version.
franta-hg@22
     9
 *
franta-hg@22
    10
 * This program is distributed in the hope that it will be useful,
franta-hg@22
    11
 * but WITHOUT ANY WARRANTY; without even the implied warranty of
franta-hg@22
    12
 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
franta-hg@22
    13
 * GNU General Public License for more details.
franta-hg@22
    14
 *
franta-hg@22
    15
 * You should have received a copy of the GNU General Public License
franta-hg@22
    16
 * along with this program. If not, see <http://www.gnu.org/licenses/>.
franta-hg@22
    17
 */
franta-hg@22
    18
package info.globalcode.sql.dk.formatting;
franta-hg@22
    19
franta-hg@22
    20
import info.globalcode.sql.dk.Parameter;
franta-hg@29
    21
import info.globalcode.sql.dk.configuration.DatabaseDefinition;
franta-hg@22
    22
import java.util.EmptyStackException;
franta-hg@22
    23
import java.util.EnumSet;
franta-hg@22
    24
import java.util.List;
franta-hg@22
    25
import java.util.Stack;
franta-hg@22
    26
franta-hg@22
    27
/**
franta-hg@22
    28
 *
franta-hg@22
    29
 * @author Ing. František Kučera (frantovo.cz)
franta-hg@22
    30
 */
franta-hg@22
    31
public abstract class AbstractFormatter implements Formatter {
franta-hg@22
    32
franta-hg@22
    33
	private Stack<State> state = new Stack<>();
franta-hg@24
    34
	private FormatterContext formatterContext;
franta-hg@22
    35
	private ColumnsHeader currentColumnsHeader;
franta-hg@22
    36
	private String currentQuery;
franta-hg@22
    37
	private int currentColumnsCount;
franta-hg@25
    38
	private int currentRowCount;
franta-hg@22
    39
franta-hg@24
    40
	public AbstractFormatter(FormatterContext formatterContext) {
franta-hg@24
    41
		this.formatterContext = formatterContext;
franta-hg@22
    42
		state.push(State.ROOT);
franta-hg@22
    43
	}
franta-hg@22
    44
franta-hg@22
    45
	/*
franta-hg@22
    46
	 * root
franta-hg@22
    47
	 * .database
franta-hg@22
    48
	 * ..resultSet
franta-hg@22
    49
	 * ...@query
franta-hg@22
    50
	 * ...@parameters
franta-hg@22
    51
	 * ...@columnsHeader
franta-hg@22
    52
	 * ...row
franta-hg@22
    53
	 * ....@columnValue
franta-hg@22
    54
	 * ..updatesResult
franta-hg@22
    55
	 * ...@query
franta-hg@22
    56
	 * ...@parameters
franta-hg@22
    57
	 * ...@updatedRowsCount
franta-hg@22
    58
	 */
franta-hg@22
    59
	protected enum State {
franta-hg@22
    60
franta-hg@22
    61
		ROOT,
franta-hg@22
    62
		DATABASE,
franta-hg@22
    63
		RESULT_SET,
franta-hg@22
    64
		ROW,
franta-hg@41
    65
		UPDATES_RESULT
franta-hg@22
    66
	}
franta-hg@22
    67
franta-hg@22
    68
	/**
franta-hg@22
    69
	 * Go down in hierarchy.
franta-hg@22
    70
	 * Pushes new state and verifies the old one.
franta-hg@22
    71
	 *
franta-hg@22
    72
	 * @param current the new state – currently entering
franta-hg@22
    73
	 * @param expected expected previous states (any of them is valid)
franta-hg@22
    74
	 * @return previous state
franta-hg@22
    75
	 * @throws IllegalStateException if previous state was not one from expected
franta-hg@22
    76
	 */
franta-hg@22
    77
	private State pushState(State current, EnumSet expected) {
franta-hg@22
    78
		State previous = state.peek();
franta-hg@22
    79
franta-hg@22
    80
		if (expected.contains(previous)) {
franta-hg@22
    81
			state.push(current);
franta-hg@22
    82
			return previous;
franta-hg@22
    83
		} else {
franta-hg@22
    84
			throw new IllegalStateException("Formatter was in wrong state: " + previous + " when it should be in one of: " + expected);
franta-hg@22
    85
		}
franta-hg@22
    86
	}
franta-hg@22
    87
franta-hg@22
    88
	protected State peekState(EnumSet expected) {
franta-hg@22
    89
		State current = state.peek();
franta-hg@22
    90
franta-hg@22
    91
		if (expected.contains(current)) {
franta-hg@22
    92
			return current;
franta-hg@22
    93
		} else {
franta-hg@22
    94
			throw new IllegalStateException("Formatter is in wrong state: " + current + " when it should be in one of: " + expected);
franta-hg@22
    95
		}
franta-hg@22
    96
franta-hg@22
    97
	}
franta-hg@22
    98
franta-hg@22
    99
	/**
franta-hg@22
   100
	 * Go up in hierarchy.
franta-hg@22
   101
	 * Pops the superior state/branch.
franta-hg@22
   102
	 *
franta-hg@22
   103
	 * @param expected expected superior state
franta-hg@22
   104
	 * @return the superior state
franta-hg@22
   105
	 * @throws IllegalStateException if superior state was not one from expected or if there is no
franta-hg@22
   106
	 * more superior state (we are at root level)
franta-hg@22
   107
	 */
franta-hg@22
   108
	private State popState(EnumSet expected) {
franta-hg@22
   109
		try {
franta-hg@34
   110
			state.pop();
franta-hg@34
   111
			State superior = state.peek();
franta-hg@22
   112
			if (expected.contains(superior)) {
franta-hg@22
   113
				return superior;
franta-hg@22
   114
			} else {
franta-hg@22
   115
				throw new IllegalStateException("Formatter had wrong superior state: " + superior + " when it should be in one of: " + expected);
franta-hg@22
   116
			}
franta-hg@22
   117
		} catch (EmptyStackException e) {
franta-hg@22
   118
			throw new IllegalStateException("Formatter was already at root level – there is nothing above that.", e);
franta-hg@22
   119
		}
franta-hg@22
   120
	}
franta-hg@22
   121
franta-hg@22
   122
	@Override
franta-hg@29
   123
	public void writeStartDatabase(DatabaseDefinition databaseDefinition) {
franta-hg@22
   124
		pushState(State.DATABASE, EnumSet.of(State.ROOT));
franta-hg@22
   125
	}
franta-hg@22
   126
franta-hg@22
   127
	@Override
franta-hg@22
   128
	public void writeEndDatabase() {
franta-hg@22
   129
		popState(EnumSet.of(State.ROOT));
franta-hg@22
   130
	}
franta-hg@22
   131
franta-hg@22
   132
	@Override
franta-hg@22
   133
	public void writeStartResultSet() {
franta-hg@41
   134
		pushState(State.RESULT_SET, EnumSet.of(State.DATABASE));
franta-hg@25
   135
		currentRowCount = 0;
franta-hg@22
   136
	}
franta-hg@22
   137
franta-hg@22
   138
	@Override
franta-hg@22
   139
	public void writeEndResultSet() {
franta-hg@41
   140
		popState(EnumSet.of(State.DATABASE));
franta-hg@22
   141
		currentColumnsHeader = null;
franta-hg@22
   142
	}
franta-hg@22
   143
franta-hg@22
   144
	@Override
franta-hg@22
   145
	public void writeQuery(String sql) {
franta-hg@22
   146
		peekState(EnumSet.of(State.RESULT_SET, State.UPDATES_RESULT));
franta-hg@22
   147
franta-hg@22
   148
		if (currentColumnsHeader == null) {
franta-hg@22
   149
			currentQuery = sql;
franta-hg@22
   150
		} else {
franta-hg@22
   151
			throw new IllegalStateException("Query string '" + sql + "' must be set before columns header – was already set: " + currentColumnsHeader);
franta-hg@22
   152
		}
franta-hg@22
   153
	}
franta-hg@22
   154
franta-hg@22
   155
	@Override
franta-hg@34
   156
	public void writeParameters(List<? extends Parameter> parameters) {
franta-hg@22
   157
		peekState(EnumSet.of(State.RESULT_SET, State.UPDATES_RESULT));
franta-hg@22
   158
franta-hg@22
   159
		if (currentColumnsHeader != null) {
franta-hg@22
   160
			throw new IllegalStateException("Parameters '" + parameters + "' must be set before columns header – was already set: " + currentColumnsHeader);
franta-hg@22
   161
		}
franta-hg@22
   162
franta-hg@22
   163
		if (currentQuery == null) {
franta-hg@22
   164
			throw new IllegalStateException("Parameters '" + parameters + "' must be set after query – was not yet set.");
franta-hg@22
   165
		}
franta-hg@22
   166
	}
franta-hg@22
   167
franta-hg@22
   168
	@Override
franta-hg@22
   169
	public void writeColumnsHeader(ColumnsHeader header) {
franta-hg@41
   170
		peekState(EnumSet.of(State.RESULT_SET));
franta-hg@22
   171
franta-hg@22
   172
		if (currentColumnsHeader == null) {
franta-hg@22
   173
			currentColumnsHeader = header;
franta-hg@22
   174
		} else {
franta-hg@22
   175
			throw new IllegalStateException("Columns header can be set only once per result set – was already set: " + currentColumnsHeader);
franta-hg@22
   176
		}
franta-hg@22
   177
	}
franta-hg@22
   178
franta-hg@22
   179
	@Override
franta-hg@22
   180
	public void writeStartRow() {
franta-hg@22
   181
		pushState(State.ROW, EnumSet.of(State.RESULT_SET));
franta-hg@22
   182
		currentColumnsCount = 0;
franta-hg@25
   183
		currentRowCount++;
franta-hg@22
   184
	}
franta-hg@22
   185
franta-hg@22
   186
	@Override
franta-hg@22
   187
	public void writeEndRow() {
franta-hg@22
   188
		popState(EnumSet.of(State.RESULT_SET));
franta-hg@22
   189
	}
franta-hg@22
   190
franta-hg@22
   191
	@Override
franta-hg@22
   192
	public void writeColumnValue(Object value) {
franta-hg@22
   193
		peekState(EnumSet.of(State.ROW));
franta-hg@22
   194
		currentColumnsCount++;
franta-hg@22
   195
franta-hg@22
   196
		int declaredCount = currentColumnsHeader.getColumnCount();
franta-hg@22
   197
		if (currentColumnsCount > declaredCount) {
franta-hg@22
   198
			throw new IllegalStateException("Current columns count is " + currentColumnsCount + " which is more than declared " + declaredCount + " in header.");
franta-hg@22
   199
		}
franta-hg@22
   200
	}
franta-hg@22
   201
franta-hg@39
   202
	/**
franta-hg@39
   203
	 * @param value from ResultSet
franta-hg@39
   204
	 * @return String representation of given value
franta-hg@39
   205
	 */
franta-hg@39
   206
	protected String toString(Object value) {
franta-hg@39
   207
		/**
franta-hg@39
   208
		 * TODO: basic formatting: boolean, null, date, numbers…
franta-hg@39
   209
		 */
franta-hg@39
   210
		return String.valueOf(value);
franta-hg@39
   211
	}
franta-hg@39
   212
franta-hg@22
   213
	@Override
franta-hg@22
   214
	public void writeStartUpdatesResult() {
franta-hg@37
   215
		pushState(State.UPDATES_RESULT, EnumSet.of(State.DATABASE));
franta-hg@22
   216
	}
franta-hg@22
   217
franta-hg@22
   218
	@Override
franta-hg@22
   219
	public void writeEndUpdatesResult() {
franta-hg@22
   220
		popState(EnumSet.of(State.DATABASE));
franta-hg@22
   221
		currentColumnsHeader = null;
franta-hg@22
   222
	}
franta-hg@22
   223
franta-hg@22
   224
	@Override
franta-hg@22
   225
	public void writeUpdatedRowsCount(int updatedRowsCount) {
franta-hg@22
   226
		peekState(EnumSet.of(State.UPDATES_RESULT));
franta-hg@22
   227
	}
franta-hg@22
   228
franta-hg@24
   229
	public FormatterContext getFormatterContext() {
franta-hg@24
   230
		return formatterContext;
franta-hg@22
   231
	}
franta-hg@22
   232
franta-hg@22
   233
	protected ColumnsHeader getCurrentColumnsHeader() {
franta-hg@22
   234
		return currentColumnsHeader;
franta-hg@22
   235
	}
franta-hg@22
   236
franta-hg@25
   237
	/**
franta-hg@25
   238
	 * @return column number, 1 = first
franta-hg@25
   239
	 */
franta-hg@22
   240
	protected int getCurrentColumnsCount() {
franta-hg@22
   241
		return currentColumnsCount;
franta-hg@22
   242
	}
franta-hg@25
   243
franta-hg@34
   244
	protected boolean isCurrentColumnFirst() {
franta-hg@34
   245
		return currentColumnsCount == 1;
franta-hg@34
   246
	}
franta-hg@34
   247
franta-hg@34
   248
	protected boolean isCurrentColumnLast() {
franta-hg@34
   249
		return currentColumnsCount == currentColumnsHeader.getColumnCount();
franta-hg@34
   250
	}
franta-hg@34
   251
franta-hg@25
   252
	/**
franta-hg@25
   253
	 * @return row number, 1 = first
franta-hg@25
   254
	 */
franta-hg@25
   255
	protected int getCurrentRowCount() {
franta-hg@25
   256
		return currentRowCount;
franta-hg@25
   257
	}
franta-hg@22
   258
	/**
franta-hg@22
   259
	 * TODO: write SQLWarning
franta-hg@22
   260
	 */
franta-hg@22
   261
}