Examples with SchemaStatVisitor com.alibaba.druid.sql.visitor.SchemaStatVisitor used on opensource projects

Example 46 with SchemaStatVisitor

use of com.alibaba.druid.sql.visitor.SchemaStatVisitor in project druid by alibaba.

the class OdpsSelectTest_over_rows method test_select.

public void test_select() throws Exception {
    //
    String sql = "SELECT sum(c) over(order by ds rows 9999 preceding) s, ds FROM t1";
    Assert.assertEquals("SELECT SUM(c) OVER (ORDER BY ds ROWS 9999 PRECEDING) AS s\n" + "\t, ds\n" + "FROM t1", SQLUtils.formatOdps(sql));
    Assert.assertEquals("select sum(c) over (order by ds rows 9999 preceding) as s\n" + "\t, ds\n" + "from t1", SQLUtils.formatOdps(sql, SQLUtils.DEFAULT_LCASE_FORMAT_OPTION));
    List<SQLStatement> statementList = SQLUtils.parseStatements(sql, JdbcConstants.ODPS);
    SQLStatement stmt = statementList.get(0);
    Assert.assertEquals(1, statementList.size());
    SchemaStatVisitor visitor = SQLUtils.createSchemaStatVisitor(JdbcConstants.ODPS);
    stmt.accept(visitor);
    //        System.out.println("Tables : " + visitor.getTables());
    //      System.out.println("fields : " + visitor.getColumns());
    //      System.out.println("coditions : " + visitor.getConditions());
    //      System.out.println("orderBy : " + visitor.getOrderByColumns());
    Assert.assertEquals(1, visitor.getTables().size());
    Assert.assertEquals(2, visitor.getColumns().size());
    Assert.assertEquals(0, visitor.getConditions().size());
//        Assert.assertTrue(visitor.getColumns().contains(new Column("abc", "name")));
}

Example 47 with SchemaStatVisitor

use of com.alibaba.druid.sql.visitor.SchemaStatVisitor in project druid by alibaba.

the class OdpsSelectTest_over_rows_1 method test_select.

public void test_select() throws Exception {
    String sql = "select last_name, first_name, department_id, hire_date, salary,\n" + "     SUM (salary)\n" + "    OVER (PARTITION BY department_id ORDER BY hire_date\n" + "          RANGE BETWEEN 365 PRECEDING AND 365 FOLLOWING) department_total\n" + "  from employee\n" + //
    "  order by department_id, hire_date;";
    Assert.assertEquals("SELECT last_name\n" + "\t, first_name\n" + "\t, department_id\n" + "\t, hire_date\n" + "\t, salary\n" + "\t, SUM(salary) OVER (PARTITION BY department_id ORDER BY hire_date RANGE BETWEEN 365 PRECEDING AND 365 FOLLOWING) AS department_total\n" + "FROM employee\n" + "ORDER BY department_id, \n" + "\thire_date;", SQLUtils.formatOdps(sql));
    Assert.assertEquals("select last_name\n" + "\t, first_name\n" + "\t, department_id\n" + "\t, hire_date\n" + "\t, salary\n" + "\t, sum(salary) over (partition by department_id order by hire_date range between 365 preceding and 365 following) as department_total\n" + "from employee\n" + "order by department_id, \n" + "\thire_date;", SQLUtils.formatOdps(sql, SQLUtils.DEFAULT_LCASE_FORMAT_OPTION));
    List<SQLStatement> statementList = SQLUtils.parseStatements(sql, JdbcConstants.ODPS);
    SQLStatement stmt = statementList.get(0);
    Assert.assertEquals(1, statementList.size());
    SchemaStatVisitor visitor = SQLUtils.createSchemaStatVisitor(JdbcConstants.ODPS);
    stmt.accept(visitor);
    //        System.out.println("Tables : " + visitor.getTables());
    //      System.out.println("fields : " + visitor.getColumns());
    //      System.out.println("coditions : " + visitor.getConditions());
    //      System.out.println("orderBy : " + visitor.getOrderByColumns());
    Assert.assertEquals(1, visitor.getTables().size());
    Assert.assertEquals(5, visitor.getColumns().size());
    Assert.assertEquals(0, visitor.getConditions().size());
//        Assert.assertTrue(visitor.getColumns().contains(new Column("abc", "name")));
}

Example 48 with SchemaStatVisitor

use of com.alibaba.druid.sql.visitor.SchemaStatVisitor in project druid by alibaba.

the class OdpsSelectTest_over_rows_2 method test_select.

public void test_select() throws Exception {
    String sql = "select last_name, first_name, department_id, hire_date, salary,\n" + "     SUM (salary)\n" + "    OVER (PARTITION BY department_id ORDER BY last_name, first_name\n" + "         RANGE 90 PRECEDING) department_total\n" + "  from employee\n" + "  order by department_id, hire_date;\n" + //
    "";
    Assert.assertEquals("SELECT last_name\n" + "\t, first_name\n" + "\t, department_id\n" + "\t, hire_date\n" + "\t, salary\n" + "\t, SUM(salary) OVER (PARTITION BY department_id ORDER BY last_name, \n" + "\t\tfirst_name RANGE 90 PRECEDING) AS department_total\n" + "FROM employee\n" + "ORDER BY department_id, \n" + "\thire_date;", SQLUtils.formatOdps(sql));
    Assert.assertEquals("select last_name\n" + "\t, first_name\n" + "\t, department_id\n" + "\t, hire_date\n" + "\t, salary\n" + "\t, sum(salary) over (partition by department_id order by last_name, \n" + "\t\tfirst_name range 90 preceding) as department_total\n" + "from employee\n" + "order by department_id, \n" + "\thire_date;", SQLUtils.formatOdps(sql, SQLUtils.DEFAULT_LCASE_FORMAT_OPTION));
    List<SQLStatement> statementList = SQLUtils.parseStatements(sql, JdbcConstants.ODPS);
    SQLStatement stmt = statementList.get(0);
    Assert.assertEquals(1, statementList.size());
    SchemaStatVisitor visitor = SQLUtils.createSchemaStatVisitor(JdbcConstants.ODPS);
    stmt.accept(visitor);
    //        System.out.println("Tables : " + visitor.getTables());
    //      System.out.println("fields : " + visitor.getColumns());
    //      System.out.println("coditions : " + visitor.getConditions());
    //      System.out.println("orderBy : " + visitor.getOrderByColumns());
    Assert.assertEquals(1, visitor.getTables().size());
    Assert.assertEquals(5, visitor.getColumns().size());
    Assert.assertEquals(0, visitor.getConditions().size());
//        Assert.assertTrue(visitor.getColumns().contains(new Column("abc", "name")));
}

Example 49 with SchemaStatVisitor

use of com.alibaba.druid.sql.visitor.SchemaStatVisitor in project druid by alibaba.

the class OdpsSelectTest_over_rows_3 method test_select.

public void test_select() throws Exception {
    //
    String sql = "SELECT sum(c) over(order by ds rows current row) s, ds FROM t1";
    Assert.assertEquals("SELECT SUM(c) OVER (ORDER BY ds ROWS CURRENT ROW) AS s\n" + "\t, ds\n" + "FROM t1", SQLUtils.formatOdps(sql));
    Assert.assertEquals("select sum(c) over (order by ds rows current row) as s\n" + "\t, ds\n" + "from t1", SQLUtils.formatOdps(sql, SQLUtils.DEFAULT_LCASE_FORMAT_OPTION));
    List<SQLStatement> statementList = SQLUtils.parseStatements(sql, JdbcConstants.ODPS);
    SQLStatement stmt = statementList.get(0);
    Assert.assertEquals(1, statementList.size());
    SchemaStatVisitor visitor = SQLUtils.createSchemaStatVisitor(JdbcConstants.ODPS);
    stmt.accept(visitor);
    //        System.out.println("Tables : " + visitor.getTables());
    //      System.out.println("fields : " + visitor.getColumns());
    //      System.out.println("coditions : " + visitor.getConditions());
    //      System.out.println("orderBy : " + visitor.getOrderByColumns());
    Assert.assertEquals(1, visitor.getTables().size());
    Assert.assertEquals(2, visitor.getColumns().size());
    Assert.assertEquals(0, visitor.getConditions().size());
//        Assert.assertTrue(visitor.getColumns().contains(new Column("abc", "name")));
}

Example 50 with SchemaStatVisitor

use of com.alibaba.druid.sql.visitor.SchemaStatVisitor in project druid by alibaba.

the class OdpsSelectTest_over_rows_5 method test_select.

public void test_select() throws Exception {
    //
    String sql = "SELECT sum(c) over(order by ds rows UNBOUNDED following) s, ds FROM t1";
    Assert.assertEquals("SELECT SUM(c) OVER (ORDER BY ds ROWS UNBOUNDED FOLLOWING) AS s\n" + "\t, ds\n" + "FROM t1", SQLUtils.formatOdps(sql));
    Assert.assertEquals("select sum(c) over (order by ds rows unbounded following) as s\n" + "\t, ds\n" + "from t1", SQLUtils.formatOdps(sql, SQLUtils.DEFAULT_LCASE_FORMAT_OPTION));
    List<SQLStatement> statementList = SQLUtils.parseStatements(sql, JdbcConstants.ODPS);
    SQLStatement stmt = statementList.get(0);
    Assert.assertEquals(1, statementList.size());
    SchemaStatVisitor visitor = SQLUtils.createSchemaStatVisitor(JdbcConstants.ODPS);
    stmt.accept(visitor);
    //        System.out.println("Tables : " + visitor.getTables());
    //      System.out.println("fields : " + visitor.getColumns());
    //      System.out.println("coditions : " + visitor.getConditions());
    //      System.out.println("orderBy : " + visitor.getOrderByColumns());
    Assert.assertEquals(1, visitor.getTables().size());
    Assert.assertEquals(2, visitor.getColumns().size());
    Assert.assertEquals(0, visitor.getConditions().size());
//        Assert.assertTrue(visitor.getColumns().contains(new Column("abc", "name")));
}