PGIntervalSQLTest.java

package com.alibaba.druid.sql.parser;

import com.alibaba.druid.sql.dialect.postgresql.ast.stmt.PGSelectStatement;
import com.alibaba.druid.sql.dialect.postgresql.parser.PGSQLStatementParser;
import junit.framework.TestCase;
import org.junit.Assert;

/**
 * Created by tianzhen.wtz on 2014/12/26 0026 20:44.
 * 类说明：
 */
public class PGIntervalSQLTest extends TestCase{


    public void testIntervalSQL(){
        String sql1="select timestamp '2001-09-28 01:00' + interval '23 hours'";
        String sql1Result="SELECT TIMESTAMP '2001-09-28 01:00' + INTERVAL '23 hours'";
        equal(sql1,sql1Result);

        String sql2="select interval '1 day' - interval '1 hour'";
        String sql2Result="SELECT INTERVAL '1 day' - INTERVAL '1 hour'";
        equal(sql2,sql2Result);

        String sql3="select date_part('month', interval '2 years 3 months')";
        String sql3Result="SELECT date_part('month', INTERVAL '2 years 3 months')";
        equal(sql3,sql3Result);
    }


    private void equal(String targetSql,String resultSql){
        PGSQLStatementParser parser=new PGSQLStatementParser(targetSql);
        PGSelectStatement statement = parser.parseSelect();
        Assert.assertTrue(statement.toString().equals(resultSql));

    }

}