java/sql-dk/src/info/globalcode/sql/dk/formatting/XmlFormatter.java
author František Kučera <franta-hg@frantovo.cz>
Fri, 10 Jan 2014 20:13:16 +0100
branchv_0
changeset 154 016836529e6c
parent 151 21eb46c5e2ec
child 155 eb3676c6929b
permissions -rw-r--r--
XML: batchResults → batchResult
franta-hg@29
     1
/**
franta-hg@29
     2
 * SQL-DK
franta-hg@29
     3
 * Copyright © 2013 František Kučera (frantovo.cz)
franta-hg@29
     4
 *
franta-hg@29
     5
 * This program is free software: you can redistribute it and/or modify
franta-hg@29
     6
 * it under the terms of the GNU General Public License as published by
franta-hg@29
     7
 * the Free Software Foundation, either version 3 of the License, or
franta-hg@29
     8
 * (at your option) any later version.
franta-hg@29
     9
 *
franta-hg@29
    10
 * This program is distributed in the hope that it will be useful,
franta-hg@29
    11
 * but WITHOUT ANY WARRANTY; without even the implied warranty of
franta-hg@29
    12
 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
franta-hg@29
    13
 * GNU General Public License for more details.
franta-hg@29
    14
 *
franta-hg@29
    15
 * You should have received a copy of the GNU General Public License
franta-hg@29
    16
 * along with this program. If not, see <http://www.gnu.org/licenses/>.
franta-hg@29
    17
 */
franta-hg@29
    18
package info.globalcode.sql.dk.formatting;
franta-hg@29
    19
franta-hg@128
    20
import info.globalcode.sql.dk.Parameter;
franta-hg@128
    21
import info.globalcode.sql.dk.Xmlns;
franta-hg@128
    22
import info.globalcode.sql.dk.configuration.DatabaseDefinition;
franta-hg@128
    23
import static info.globalcode.sql.dk.formatting.AbstractXmlFormatter.qname;
franta-hg@128
    24
import static info.globalcode.sql.dk.Functions.notNull;
franta-hg@128
    25
import info.globalcode.sql.dk.NamedParameter;
franta-hg@128
    26
import java.util.LinkedHashMap;
franta-hg@128
    27
import java.util.List;
franta-hg@128
    28
import java.util.Map;
franta-hg@128
    29
import javax.xml.namespace.QName;
franta-hg@128
    30
franta-hg@29
    31
/**
franta-hg@29
    32
 *
franta-hg@29
    33
 * @author Ing. František Kučera (frantovo.cz)
franta-hg@29
    34
 */
franta-hg@128
    35
public class XmlFormatter extends AbstractXmlFormatter {
franta-hg@29
    36
franta-hg@79
    37
	public static final String NAME = "xml"; // bash-completion:formatter
franta-hg@131
    38
	public static final String PROPERTY_LABELED_COLUMNS = "labeledColumns";
franta-hg@131
    39
	private final boolean labeledColumns;
franta-hg@29
    40
franta-hg@29
    41
	public XmlFormatter(FormatterContext formatterContext) {
franta-hg@29
    42
		super(formatterContext);
franta-hg@131
    43
		labeledColumns = formatterContext.getProperties().getBoolean(PROPERTY_LABELED_COLUMNS, false);
franta-hg@29
    44
	}
franta-hg@128
    45
franta-hg@128
    46
	@Override
franta-hg@128
    47
	public void writeStartBatch() {
franta-hg@128
    48
		super.writeStartBatch();
franta-hg@128
    49
		printStartDocument();
franta-hg@154
    50
		printStartElement(qname("batchResult"), singleAttribute(qname("xmlns"), Xmlns.BATCH_RESULT));
franta-hg@128
    51
	}
franta-hg@128
    52
franta-hg@128
    53
	@Override
franta-hg@128
    54
	public void writeEndBatch() {
franta-hg@128
    55
		super.writeEndBatch();
franta-hg@128
    56
		printEndElement();
franta-hg@128
    57
		printEndDocument();
franta-hg@128
    58
	}
franta-hg@128
    59
franta-hg@128
    60
	@Override
franta-hg@128
    61
	public void writeStartDatabase(DatabaseDefinition databaseDefinition) {
franta-hg@128
    62
		super.writeStartDatabase(databaseDefinition);
franta-hg@128
    63
		Map<QName, String> attributes = databaseDefinition.getName() == null ? null : singleAttribute(qname("name"), databaseDefinition.getName());
franta-hg@128
    64
		printStartElement(qname("database"), attributes);
franta-hg@128
    65
	}
franta-hg@128
    66
franta-hg@128
    67
	@Override
franta-hg@128
    68
	public void writeEndDatabase() {
franta-hg@128
    69
		super.writeEndDatabase();
franta-hg@128
    70
		printEndElement();
franta-hg@128
    71
	}
franta-hg@128
    72
franta-hg@128
    73
	@Override
franta-hg@142
    74
	public void writeStartStatement() {
franta-hg@142
    75
		super.writeStartStatement();
franta-hg@142
    76
		printStartElement(qname("statement"));
franta-hg@128
    77
	}
franta-hg@128
    78
franta-hg@128
    79
	@Override
franta-hg@142
    80
	public void writeEndStatement() {
franta-hg@142
    81
		super.writeEndStatement();
franta-hg@128
    82
		printEndElement();
franta-hg@128
    83
	}
franta-hg@128
    84
franta-hg@128
    85
	@Override
franta-hg@128
    86
	public void writeQuery(String sql) {
franta-hg@128
    87
		super.writeQuery(sql);
franta-hg@128
    88
		printTextElement(qname("sql"), null, sql);
franta-hg@128
    89
	}
franta-hg@128
    90
franta-hg@128
    91
	@Override
franta-hg@128
    92
	public void writeParameters(List<? extends Parameter> parameters) {
franta-hg@128
    93
		super.writeParameters(parameters);
franta-hg@128
    94
franta-hg@128
    95
		for (Parameter p : notNull(parameters)) {
franta-hg@128
    96
franta-hg@128
    97
			Map<QName, String> attributes = new LinkedHashMap<>(2);
franta-hg@128
    98
			if (p instanceof NamedParameter) {
franta-hg@128
    99
				attributes.put(qname("name"), ((NamedParameter) p).getName());
franta-hg@128
   100
			}
franta-hg@128
   101
			attributes.put(qname("type"), p.getType().name());
franta-hg@128
   102
franta-hg@128
   103
			printTextElement(qname("parameter"), attributes, String.valueOf(p.getValue()));
franta-hg@128
   104
		}
franta-hg@128
   105
franta-hg@128
   106
	}
franta-hg@128
   107
franta-hg@128
   108
	@Override
franta-hg@142
   109
	public void writeStartResultSet(ColumnsHeader header) {
franta-hg@142
   110
		super.writeStartResultSet(header);
franta-hg@142
   111
		printStartElement(qname("resultSet"));
franta-hg@128
   112
franta-hg@128
   113
		for (ColumnDescriptor cd : header.getColumnDescriptors()) {
franta-hg@128
   114
			Map<QName, String> attributes = new LinkedHashMap<>(4);
franta-hg@128
   115
			attributes.put(qname("label"), cd.getLabel());
franta-hg@128
   116
			attributes.put(qname("name"), cd.getName());
franta-hg@128
   117
			attributes.put(qname("typeName"), cd.getTypeName());
franta-hg@128
   118
			attributes.put(qname("type"), String.valueOf(cd.getType()));
franta-hg@128
   119
			printEmptyElement(qname("columnHeader"), attributes);
franta-hg@128
   120
		}
franta-hg@128
   121
	}
franta-hg@129
   122
franta-hg@129
   123
	@Override
franta-hg@142
   124
	public void writeEndResultSet() {
franta-hg@142
   125
		super.writeEndResultSet();
franta-hg@142
   126
		printEndElement();
franta-hg@142
   127
	}
franta-hg@142
   128
franta-hg@142
   129
	@Override
franta-hg@129
   130
	public void writeStartRow() {
franta-hg@129
   131
		super.writeStartRow();
franta-hg@129
   132
		printStartElement(qname("row"));
franta-hg@129
   133
	}
franta-hg@129
   134
franta-hg@129
   135
	@Override
franta-hg@129
   136
	public void writeColumnValue(Object value) {
franta-hg@129
   137
		super.writeColumnValue(value);
franta-hg@131
   138
franta-hg@131
   139
		Map<QName, String> attributes = null;
franta-hg@131
   140
		if (labeledColumns) {
franta-hg@151
   141
			attributes = new LinkedHashMap<>(2);
franta-hg@131
   142
			attributes.put(qname("label"), getCurrentColumnsHeader().getColumnDescriptors().get(getCurrentColumnsCount() - 1).getLabel());
franta-hg@131
   143
		}
franta-hg@131
   144
franta-hg@151
   145
		if (value == null) {
franta-hg@151
   146
			if (attributes == null) {
franta-hg@151
   147
				attributes = new LinkedHashMap<>(2);
franta-hg@151
   148
				attributes.put(qname("null"), "true");
franta-hg@151
   149
				printEmptyElement(qname("column"), attributes);
franta-hg@151
   150
			}
franta-hg@151
   151
		} else {
franta-hg@151
   152
			printTextElement(qname("column"), attributes, toString(value));
franta-hg@151
   153
		}
franta-hg@129
   154
	}
franta-hg@129
   155
franta-hg@129
   156
	@Override
franta-hg@129
   157
	public void writeEndRow() {
franta-hg@129
   158
		super.writeEndRow();
franta-hg@129
   159
		printEndElement();
franta-hg@129
   160
	}
franta-hg@129
   161
franta-hg@129
   162
	@Override
franta-hg@142
   163
	public void writeUpdatesResult(int updatedRowsCount) {
franta-hg@142
   164
		super.writeUpdatesResult(updatedRowsCount);
franta-hg@129
   165
		printTextElement(qname("updatedRows"), null, String.valueOf(updatedRowsCount));
franta-hg@129
   166
	}
franta-hg@129
   167
franta-hg@129
   168
	protected String toString(Object value) {
franta-hg@129
   169
		return String.valueOf(value);
franta-hg@129
   170
	}
franta-hg@29
   171
}