Application: gvSIG desktop

/*

 * gvSIG. Desktop Geographic Information System.

 * 

 * Copyright (C) 2007-2023 gvSIG Association.

 * 

 * 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 <https://www.gnu.org/licenses/>. 

 * 

 * For any additional information, do not hesitate to contact us

 * at info AT gvsig.com, or visit our website www.gvsig.com.

 */

package org.gvsig.sqlite.dal.utils;

import java.io.IOException;

import java.io.InputStream;

import java.util.ArrayList;

import java.util.HashMap;

import java.util.List;

import java.util.Map;

import org.apache.commons.io.IOUtils;

import org.apache.commons.lang3.ArrayUtils;

import org.apache.commons.lang3.StringUtils;

import org.slf4j.Logger;

import org.slf4j.LoggerFactory;

/**

 *

 * @author gvSIG Team

 */

@SuppressWarnings("UseSpecificCatch")

public class TemplateUtils {

    private static final Logger LOGGER = LoggerFactory.getLogger(TemplateUtils.class);

    private static final Map<String, Map<String, Template>> SQL_TEMPLATES_BY_GROUP = new HashMap<>();

    private static final String TEMPLATES_FOLDER = "/org/gvsig/sqlite/dal/sqltemplates/";

    private static class Template {

        List<String> parameters;

        Map<String,String> constants;

        String code;

        String name;

        public Template(String name) {

            this.name = name;

            this.parameters = new ArrayList<>();

            this.constants = new HashMap<>();

            this.code = null;

        }

        public void setCode(String code) {

            this.code = code;

        }

        public void addParameter(String parameter) {

            this.parameters.add(parameter);

        }

        public void addConstant(String name, String value) {

            this.constants.put(name, value);

        }

        public String getName() {

            return this.name;

        }

        public String getCode(Object...params) {

            if( this.parameters.isEmpty() ) {

                return String.format(this.code, params);

            }

            String s = this.code;

            for (int i = 0; i < parameters.size(); i++) {

                s = s.replace("%"+parameters.get(i)+"$", "%"+(i+1)+"$");

            }

            for (Map.Entry<String, String> entry : constants.entrySet()) {

                String cname = entry.getKey();

                String cvalue = entry.getValue();

                s = s.replace("%"+cname+"$s", cvalue);

            }

            if( ArrayUtils.isEmpty(params) ) {

                return s;

            }

            s = String.format(s, params);

            return s;

        }

        @Override

        public String toString() {

            return this.name;

        }

    }

    @SuppressWarnings("null")

    private static Map<String,Template> getSqlTemplates(String group) {

      final int SEARCHING_ITEM = 0;

      final int READING_ITEM = 1;

      InputStream sqls = TemplateUtils.class.getResourceAsStream(TEMPLATES_FOLDER+group+".sql"); 

      Map<String,Template> expecteds = new HashMap<>();

      List<String> lines;

        try {

            lines = IOUtils.readLines(sqls);

        } catch (IOException ex) {

            throw new RuntimeException("Can't read sql templates for group "+group, ex);

        }

      StringBuilder sb = null;

      Template currentItem = null;

      int lineno = 1;

      int state = SEARCHING_ITEM;

      for (String line : lines) {

          line = line + "\n";

          switch(state) {

            case SEARCHING_ITEM:

                if( line.toLowerCase().startsWith("@begin ") ) {

                    currentItem = new Template(line.substring(7).trim());

                    sb = new StringBuilder();

                    state = READING_ITEM;

                } else if( line.toLowerCase().startsWith("-- ") || line.toLowerCase().startsWith("@rem") ) {

                    // do nothing skip comment

                } else if( !StringUtils.isBlank(line) ) {

                    throw new IllegalStateException("Syntax error at '"+group+"', line "+lineno+ ".");

                }

                break;

            case READING_ITEM:

                if( line.toLowerCase().startsWith("@end ") ) {

                    String found = line.substring(5).trim();

                    if( !StringUtils.equals(currentItem.getName(),found) ) {

                      throw new IllegalStateException("Syntax error at '"+group+"', line "+lineno+ ", expected @end "+currentItem.getName()+", and found "+line+".");

                    }

                    String s = sb.toString();

                    if( s.endsWith("\n") ) {

                        s = s.substring(0, s.length()-1);

                    }

                    currentItem.setCode(s);

                    expecteds.put(currentItem.getName(), currentItem);

                    state = SEARCHING_ITEM;

                } else if( line.toLowerCase().startsWith("-- ") || line.toLowerCase().startsWith("@rem") ) {

                    // do nothing skip comment

                } else if( line.toLowerCase().startsWith("@param ") ) {

                    currentItem.addParameter(line.substring(7).trim());

                } else if( line.toLowerCase().startsWith("@const ") ) {

                    String s = line.substring(7).trim();

                    String[] ss = StringUtils.split(s, "=");

                    currentItem.addConstant(ss[0].trim(),ss[1].trim());

                } else {

                    sb.append(line);

                }

                break;

        }

        lineno++;

      }

      if( state!=SEARCHING_ITEM ) {

          throw new IllegalStateException("Syntax error at '"+group+"', expected @end "+currentItem.getName()+" and found EOF .");

      }

      return expecteds;

    }

    public static String getSqlTemplate(String group, String sqlId, Object... args){

        if(SQL_TEMPLATES_BY_GROUP.get(group) == null) {

            SQL_TEMPLATES_BY_GROUP.put(group, getSqlTemplates(group));

        }

        Template template = SQL_TEMPLATES_BY_GROUP.get(group).get(sqlId);

        if( template==null ) {

            return null;

        }

        return template.getCode(args);

    }

}