package gudusoft.gsqlparser.nodes.netezza;

import java.util.regex.Matcher;
import java.util.regex.Pattern;

import gudusoft.gsqlparser.nodes.TParseTreeNode;

public class TExternalTableOption extends TParseTreeNode {
        
        private boolean init = false;;

        private String delimiter;
        private String dateTimeDelim;
        private String decimalDelim;
        private String dateDelim;
        private String escapeChar;
        private String logDir;
        private String meridianDelim;
        private String nullValue;
        private String recordDelim;
        private String timeDelim;
        private String compress;
        private String includeHeader;
        private String includeZeroSeconds;
        private String requireQuotes;
        private String timeRoundNanos;
        private String timeExtraZeros;
        private String truncString;
        private String boolStyle;
        private String dateStyle;
        private String encoding;
        private String format;
        private String quotedValue;
        private String remoteSource;
        private String timeStyle;
        private String dataObject;
        private String recordLength;
        private String socketBufSize;
        private Boolean cRinString;
        private Boolean ctrlChars;
        private Boolean fillRecord;
        private Boolean ignoreZero;
        private Boolean lFinString;
        private Integer maxErrors;
        private Integer maxRows;
        private Integer y2Base;
        private Long skipRows;

        public String getDelimiter() {
                parseTableOptions();
                return delimiter;
        }

        public String getDateTimeDelim() {
                parseTableOptions();
                return dateTimeDelim;
        }

        public String getDecimalDelim() {
                parseTableOptions();
                return decimalDelim;
        }

        public String getDateDelim() {
                parseTableOptions();
                return dateDelim;
        }

        public String getEscapeChar() {
                parseTableOptions();
                return escapeChar;
        }

        public String getLogDir() {
                parseTableOptions();
                return logDir;
        }

        public String getMeridianDelim() {
                parseTableOptions();
                return meridianDelim;
        }

        public String getNullValue() {
                parseTableOptions();
                return nullValue;
        }

        public String getRecordDelim() {
                parseTableOptions();
                return recordDelim;
        }

        public String getTimeDelim() {
                parseTableOptions();
                return timeDelim;
        }

        public String getCompress() {
                parseTableOptions();
                return compress;
        }

        public String getIncludeHeader() {
                parseTableOptions();
                return includeHeader;
        }

        public String getIncludeZeroSeconds() {
                parseTableOptions();
                return includeZeroSeconds;
        }

        public String getRequireQuotes() {
                parseTableOptions();
                return requireQuotes;
        }

        public String getTimeRoundNanos() {
                parseTableOptions();
                return timeRoundNanos;
        }

        public String getTimeExtraZeros() {
                parseTableOptions();
                return timeExtraZeros;
        }

        public String getTruncString() {
                parseTableOptions();
                return truncString;
        }

        public String getBoolStyle() {
                parseTableOptions();
                return boolStyle;
        }

        public String getDateStyle() {
                parseTableOptions();
                return dateStyle;
        }

        public String getEncoding() {
                parseTableOptions();
                return encoding;
        }

        public String getFormat() {
                parseTableOptions();
                return format;
        }

        public String getQuotedValue() {
                parseTableOptions();
                return quotedValue;
        }

        public String getRemoteSource() {
                parseTableOptions();
                return remoteSource;
        }

        public String getTimeStyle() {
                parseTableOptions();
                return timeStyle;
        }

        public String getDataObject() {
                parseTableOptions();
                return dataObject;
        }

        public String getRecordLength() {
                parseTableOptions();
                return recordLength;
        }

        public String getSocketBufSize() {
                parseTableOptions();
                return socketBufSize;
        }

        public Boolean getcRinString() {
                parseTableOptions();
                return cRinString;
        }

        public Boolean getCtrlChars() {
                parseTableOptions();
                return ctrlChars;
        }

        public Boolean getFillRecord() {
                parseTableOptions();
                return fillRecord;
        }

        public Boolean getIgnoreZero() {
                parseTableOptions();
                return ignoreZero;
        }

        public Boolean getlFinString() {
                parseTableOptions();
                return lFinString;
        }

        public Integer getMaxErrors() {
                parseTableOptions();
                return maxErrors;
        }

        public Integer getMaxRows() {
                parseTableOptions();
                return maxRows;
        }

        public Integer getY2Base() {
                parseTableOptions();
                return y2Base;
        }

        public Long getSkipRows() {
                parseTableOptions();
                return skipRows;
        }

        public TExternalTableOption(String optionText) {
                this.optionText = optionText;
        }

        private String optionText;

        public void setOptionText(String optionText) {
                this.optionText = optionText;
                init = false;
        }

        public String getOptionText() {
                return optionText;
        }

        public void parseTableOptions() {
                if (!init && optionText != null) {
                        this.delimiter = getPatternString(optionText, "delimiter");
                        this.dateTimeDelim = getPatternString(optionText, "dateTimeDelim");
                        this.decimalDelim = getPatternString(optionText, "decimalDelim");
                        this.dateDelim = getPatternString(optionText, "dateDelim");
                        this.escapeChar = getPatternString(optionText, "escapeChar");
                        this.logDir = getPatternString(optionText, "logDir");
                        this.meridianDelim = getPatternString(optionText, "meridianDelim");
                        this.nullValue = getPatternString(optionText, "nullValue");
                        this.recordDelim = getPatternString(optionText, "recordDelim");
                        this.timeDelim = getPatternString(optionText, "timeDelim");
                        this.compress = getPatternString(optionText, "compress");
                        this.includeHeader = getPatternString(optionText, "includeHeader");
                        this.includeZeroSeconds = getPatternString(optionText, "includeZeroSeconds");
                        this.requireQuotes = getPatternString(optionText, "requireQuotes");
                        this.timeRoundNanos = getPatternString(optionText, "timeRoundNanos");
                        this.timeExtraZeros = getPatternString(optionText, "timeExtraZeros");
                        this.truncString = getPatternString(optionText, "truncString");
                        this.dataObject = getPatternString(optionText, "dataObject");
                        this.boolStyle = getPatternString(optionText, "boolStyle");
                        this.boolStyle = getPatternString(optionText, "boolStyle");
                        this.dateStyle = getPatternString(optionText, "dateStyle");
                        this.encoding = getPatternString(optionText, "encoding");
                        this.format = getPatternString(optionText, "format");
                        this.quotedValue = getPatternString(optionText, "quotedValue");
                        this.remoteSource = getPatternString(optionText, "remoteSource");
                        this.timeStyle = getPatternString(optionText, "timeStyle");
                        this.recordLength = getPatternString(optionText, "recordLength");
                        this.socketBufSize = getPatternString(optionText, "socketBufSize");
                        this.cRinString = getPatternBoolean(optionText, "cRinString");
                        this.ctrlChars = getPatternBoolean(optionText, "ctrlChars");
                        this.fillRecord = getPatternBoolean(optionText, "fillRecord");
                        this.ignoreZero = getPatternBoolean(optionText, "ignoreZero");
                        this.ignoreZero = getPatternBoolean(optionText, "ignoreZero");
                        this.lFinString = getPatternBoolean(optionText, "lFinString");
                        this.maxErrors = getPatternInteger(optionText, "maxErrors");
                        this.maxRows = getPatternInteger(optionText, "maxRows");
                        this.y2Base = getPatternInteger(optionText, "y2Base");
                        this.skipRows = getPatternLong(optionText, "skipRows");
                }
                init = true;
        }

        private Long getPatternLong(String content, String field) {
                String b = getPatternString(content, field);
                if (null == b) {
                        return null;
                }
                return Long.parseLong(b);
        }

        private Integer getPatternInteger(String content, String field) {
                String b = getPatternString(content, field);
                if (null == b) {
                        return null;
                }
                return Integer.parseInt(b);
        }

        private Boolean getPatternBoolean(String content, String field) {
                String b = getPatternString(content, field);
                if (null == b) {
                        return null;
                }
                if ("on".equalsIgnoreCase(b)) {
                        return true;
                } else if ("off".equalsIgnoreCase(b)) {
                        return false;
                }
                return Boolean.parseBoolean(b);
        }

        private String getPatternString(String content, String field) {
                String patternExp = "(?is)" + field + "\\s*('.+?')\\s*";
                Pattern pattern = Pattern.compile(patternExp);
                Matcher matcher = pattern.matcher(content);
                if (matcher.find()) {
                        String s = matcher.group(1).trim().replaceAll("'", "");
                        return "".equals(s) ? "'" : s;
                }
                
                patternExp = "(?is)" + field + "\\s*\\((.+?)\\)";
                pattern = Pattern.compile(patternExp);
                matcher = pattern.matcher(content);
                if (matcher.find()) {
                        String s = matcher.group(1).trim().replaceAll("'", "");
                        return "".equals(s) ? "'" : s;
                }
                
                patternExp = "(?is)" + field + "\\s*(.+)";
                pattern = Pattern.compile(patternExp);
                matcher = pattern.matcher(content);
                if (matcher.find()) {
                        String c = matcher.group(1).trim();
                        return c.replaceAll("\r\n", ".").replaceAll("\n", ".").replaceAll("\r", ".").replaceAll(" ", ".")
                                        .split("\\.")[0].replaceAll("\"", "");
                }
                return null;
        }

}