/**

  * SQL-DK

  * Copyright © 2013 František Kučera (frantovo.cz)

  *

  * This program is free software: you can redistribute it and/or modify

  * it under the terms of the GNU General Public License as published by

  * the Free Software Foundation, either version 3 of the License, or

  * (at your option) any later version.

  *

  * This program is distributed in the hope that it will be useful,

  * but WITHOUT ANY WARRANTY; without even the implied warranty of

  * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the

  * GNU General Public License for more details.

  *

  * You should have received a copy of the GNU General Public License

  * along with this program. If not, see <http://www.gnu.org/licenses/>.

  */

 package info.globalcode.sql.dk.formatting;

 import info.globalcode.sql.dk.ColorfulPrintWriter;

 import static info.globalcode.sql.dk.ColorfulPrintWriter.*;

 import static info.globalcode.sql.dk.Functions.lpad;

 import static info.globalcode.sql.dk.Functions.rpad;

 import static info.globalcode.sql.dk.Functions.repeat;

 import java.util.List;

 import java.util.regex.Matcher;

 import java.util.regex.Pattern;

 /**

  * <p>

  * Prints human-readable output – tables of result sets and text messages with update counts.

  * </p>

  *

  * <p>

  * Longer values might break the table – overflow the cells – see alternative tabular formatters

  * and the {@linkplain #PROPERTY_TRIM} property.

  * </p>

  *

  * @author Ing. František Kučera (frantovo.cz)

  * @see TabularPrefetchingFormatter

  * @see TabularWrappingFormatter

  */

 public class TabularFormatter extends AbstractFormatter {

 	public static final String NAME = "tabular"; // bash-completion:formatter

 	private static final String HEADER_TYPE_PREFIX = " (";

 	private static final String HEADER_TYPE_SUFFIX = ")";

 	public static final String PROPERTY_ASCII = "ascii";

 	public static final String PROPERTY_COLORFUL = "color";

 	public static final String PROPERTY_TRIM = "trim";

 	private static final String NBSP = " ";

 	private static final Pattern whitespaceToReplace = Pattern.compile("\\n|\\r|\\t|" + NBSP);

 	protected ColorfulPrintWriter out;

 	private boolean firstResult = true;

 	private int[] columnWidth;

 	/**

 	 * use ASCII borders instead of unicode ones

 	 */

 	private final boolean asciiNostalgia;

 	/**

 	 * Trim values if they are longer than cell size

 	 */

 	private final boolean trimValues;

 	public TabularFormatter(FormatterContext formatterContext) {

 		super(formatterContext);

 		out = new ColorfulPrintWriter(formatterContext.getOutputStream());

 		asciiNostalgia = formatterContext.getProperties().getBoolean(PROPERTY_ASCII, false);

 		trimValues = formatterContext.getProperties().getBoolean(PROPERTY_TRIM, false);

 		out.setColorful(formatterContext.getProperties().getBoolean(PROPERTY_COLORFUL, true));

 	}

 	@Override

 	public void writeStartResultSet(ColumnsHeader header) {

 		super.writeStartResultSet(header);

 		printResultSeparator();

 		initColumnWidths(header.getColumnCount());

 		printTableIndent();

 		printTableBorder("╭");

 		List<ColumnDescriptor> columnDescriptors = header.getColumnDescriptors();

 		for (ColumnDescriptor cd : columnDescriptors) {

 			// padding: make header cell at least same width as data cells in this column

 			int typeWidth = cd.getTypeName().length() + HEADER_TYPE_PREFIX.length() + HEADER_TYPE_SUFFIX.length();

 			cd.setLabel(rpad(cd.getLabel(), getColumnWidth(cd.getColumnNumber()) - typeWidth));

 			updateColumnWidth(cd.getColumnNumber(), cd.getLabel().length() + typeWidth);

 			if (!cd.isFirstColumn()) {

 				printTableBorder("┬");

 			}

 			printTableBorder(repeat('─', getColumnWidth(cd.getColumnNumber()) + 2));

 		}

 		printTableBorder("╮");

 		out.println();

 		for (ColumnDescriptor cd : columnDescriptors) {

 			if (cd.isFirstColumn()) {

 				printTableIndent();

 				printTableBorder("│ ");

 			} else {

 				printTableBorder(" │ ");

 			}

 			out.print(TerminalStyle.Bright, cd.getLabel());

 			out.print(HEADER_TYPE_PREFIX);

 			out.print(cd.getTypeName());

 			out.print(HEADER_TYPE_SUFFIX);

 			if (cd.isLastColumn()) {

 				printTableBorder(" │");

 			}

 		}

 		out.println();

 		printTableIndent();

 		printTableBorder("├");

 		for (int i = 1; i <= header.getColumnCount(); i++) {

 			if (i > 1) {

 				printTableBorder("┼");

 			}

 			printTableBorder(repeat('─', getColumnWidth(i) + 2));

 		}

 		printTableBorder("┤");

 		out.println();

 		out.flush();

 	}

 	/**

 	 * Must be called before

 	 * {@linkplain #updateColumnWidth(int, int)}

 	 * and {@linkplain #getColumnWidth(int)}

 	 * for each result set.

 	 *

 	 * @param columnCount number of columns in current result set

 	 */

 	protected void initColumnWidths(int columnCount) {

 		if (columnWidth == null) {

 			columnWidth = new int[columnCount];

 		}

 	}

 	protected void cleanColumnWidths() {

 		columnWidth = null;

 	}

 	@Override

 	public void writeColumnValue(Object value) {

 		super.writeColumnValue(value);

 		writeColumnValueInternal(value);

 	}

 	protected void writeColumnValueInternal(Object value) {

 		if (isCurrentColumnFirst()) {

 			printTableIndent();

 			printTableBorder("│ ");

 		} else {

 			printTableBorder(" │ ");

 		}

 		String valueString = toString(value);

 		printValueWithWhitespaceReplaced(valueString);

 		if (isCurrentColumnLast()) {

 			printTableBorder(" │");

 		}

 	}

 	protected int getColumnWidth(int columnNumber) {

 		return columnWidth[columnNumber - 1];

 	}

 	private void setColumnWidth(int columnNumber, int width) {

 		columnWidth[columnNumber - 1] = width;

 	}

 	protected void updateColumnWidth(int columnNumber, int width) {

 		int oldWidth = getColumnWidth(columnNumber);

 		setColumnWidth(columnNumber, Math.max(width, oldWidth));

 	}

 	protected String toString(Object value) {

 		final int width = getColumnWidth(getCurrentColumnsCount());

 		String result;

 		if (value instanceof Number || value instanceof Boolean) {

 			result = lpad(String.valueOf(value), width);

 		} else {

 			result = rpad(String.valueOf(value), width);

 		}

 		// ?	value = (boolean) value ? "✔" : "✗";

 		if (trimValues && result.length() > width) {

 			result = result.substring(0, width - 1) + "…";

 		}

 		return result;

 	}

 	@Override

 	public void writeEndRow() {

 		super.writeEndRow();

 		writeEndRowInternal();

 	}

 	public void writeEndRowInternal() {

 		out.println();

 		out.flush();

 	}

 	@Override

 	public void writeEndResultSet() {

 		int columnCount = getCurrentColumnsHeader().getColumnCount();

 		super.writeEndResultSet();

 		printTableIndent();

 		printTableBorder("╰");

 		for (int i = 1; i <= columnCount; i++) {

 			if (i > 1) {

 				printTableBorder("┴");

 			}

 			printTableBorder(repeat('─', getColumnWidth(i) + 2));

 		}

 		printTableBorder("╯");

 		out.println();

 		cleanColumnWidths();

 		out.print(TerminalColor.Yellow, "Record count: ");

 		out.println(getCurrentRowCount());

 		out.bell();

 		out.flush();

 	}

 	@Override

 	public void writeUpdatesResult(int updatedRowsCount) {

 		super.writeUpdatesResult(updatedRowsCount);

 		printResultSeparator();

 		out.print(TerminalColor.Red, "Updated records: ");

 		out.println(updatedRowsCount);

 		out.bell();

 		out.flush();

 	}

 	@Override

 	public void writeEndDatabase() {

 		super.writeEndDatabase();

 		out.flush();

 	}

 	private void printResultSeparator() {

 		if (firstResult) {

 			firstResult = false;

 		} else {

 			out.println();

 		}

 	}

 	protected void printTableBorder(String border) {

 		if (asciiNostalgia) {

 			border = border.replaceAll("─", "-");

 			border = border.replaceAll("│", "|");

 			border = border.replaceAll("[╭┬╮├┼┤╰┴╯]", "+");

 		}

 		out.print(TerminalColor.Green, border);

 	}

 	protected void printTableIndent() {

 		out.print(" ");

 	}

 	protected void printValueWithWhitespaceReplaced(String valueString) {

 		Matcher m = whitespaceToReplace.matcher(valueString);

 		int start = 0;

 		while (m.find(start)) {

 			out.print(TerminalColor.Cyan, valueString.substring(start, m.start()));

 			switch (m.group()) {

 				case "\n":

 					out.print(TerminalColor.Red, "↲");

 					break;

 				case "\r":

 					out.print(TerminalColor.Red, "⏎");

 					break;

 				case "\t":

 					out.print(TerminalColor.Red, "↹");

 					break;

 				case NBSP:

 					out.print(TerminalColor.Red, "⎵");

 					break;

 				default:

 					throw new IllegalStateException("Unexpected whitespace token: „" + m.group() + "“");

 			}

 			start = m.end();

 		}

 		out.print(TerminalColor.Cyan, valueString.substring(start, valueString.length()));

 	}

 }