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