001/* 
002 * JKNIV, whinstone one contract to access your database.
003 * 
004 * Copyright (C) 2017, the original author or authors.
005 *
006 * This library is free software; you can redistribute it and/or
007 * modify it under the terms of the GNU Lesser General Public
008 * License as published by the Free Software Foundation; either
009 * version 2.1 of the License.
010 * 
011 * This library is distributed in the hope that it will be useful,
012 * but WITHOUT ANY WARRANTY; without even the implied warranty of
013 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the GNU
014 * Lesser General Public License for more details.
015 * 
016 * You should have received a copy of the GNU Lesser General Public
017 * License along with this library; if not, write to the Free Software Foundation, Inc., 
018 * 51 Franklin Street, Fifth Floor, Boston, MA  02110-1301  USA
019 */
020package net.sf.jkniv.whinstone.jdbc.dialect;
021
022import net.sf.jkniv.sqlegance.dialect.AnsiDialect;
023import net.sf.jkniv.sqlegance.dialect.SqlFeatureFactory;
024import net.sf.jkniv.sqlegance.dialect.SqlFeatureSupport;
025
026/**
027 * Dialect to INFORMIX
028 * 
029 * <p>
030 * Limit clause:
031 *  <code>select SKIP 2 FIRST 1 name from author</code>
032 * </p>
033 * <ul>
034 *  <li>Supports limits? true</li>
035 *  <li>Supports limit off set? true</li>
036 *  <li>Supports rownum? false</li>
037 * </ul>
038 *
039 * @author Alisson Gomes 
040 * @since 0.6.0
041 */
042public class InformixDialect extends AnsiDialect
043{
044    public InformixDialect()
045    {
046        super();
047        addFeature(SqlFeatureFactory.newInstance(SqlFeatureSupport.LIMIT, true));
048        addFeature(SqlFeatureFactory.newInstance(SqlFeatureSupport.LIMIT_OFF_SET, true));    
049    }
050    
051    /**
052     *  LIMIT and OFFSET clause for Informix, where LIMIT and OFFSET are parameter from
053     *  String.format
054     *  
055     *  @return Return query pattern: 
056     *  
057     *   select SKIP 2 FIRST 1 name from author
058     * 
059     */
060    @Override
061    public String getSqlPatternPaging()
062    {
063        return "select SKIP %3$s FIRST %2$s %1$s";
064    }
065    
066    //@Override public void buildSqlLimits()
067    @Override
068    public String buildQueryPaging(final String sqlText, int offset, int max)
069    {
070        String sqlTextPaginated = null;
071//        if (isSelect())
072//        {
073            //this.sql = queryable.getSql().getSql(queryable.getParams());
074            String pagingSelect = getSqlPatternPaging();
075            String sqlPreparedToSkip = sqlText.replaceFirst("select", "");
076            if (supportsFeature(SqlFeatureSupport.LIMIT_OFF_SET))
077                sqlTextPaginated = String.format(pagingSelect, sqlPreparedToSkip, max,
078                        offset);
079            else
080                sqlTextPaginated = String.format(pagingSelect, sqlPreparedToSkip, max);
081//        }
082//        else
083//            this.sql = queryable.getSql().getSql(queryable.getParams());
084//        
085//        replaceForQuestionMark();
086        return sqlTextPaginated;
087    }
088}