Example usage for org.hibernate.dialect MySQL5Dialect MySQL5Dialect

Introduction

In this page you can find the example usage for org.hibernate.dialect MySQL5Dialect MySQL5Dialect.

Prototype

MySQL5Dialect

Source Link

Usage

From source file:com.evinceframework.data.tests.warehouse.query.jdbc.hierarchical.HierarchicalJdbcQueryCommandTests.java

License:Apache License

public void testNullFactSelections() {

    DrillPathEntry<String> root = new DrillPathEntry<String>(TestData.dimensionA, TestData.dimensionalAttrA1);

    TestHierarchicalQueryCommand queryEngine = new TestHierarchicalQueryCommand(new MySQL5Dialect());
    HierarchicalQuery query = new HierarchicalQuery(TestData.factTable, null, new Criterion[] {}, root);

    try {/*from  w  w w  .  ja  va 2 s  .c o m*/

        queryEngine.generateSqlForTest(query);
        fail("QueryException  expected.");

    } catch (QueryException e) {
    }
}

---

From source file:com.evinceframework.data.tests.warehouse.query.jdbc.hierarchical.HierarchicalJdbcQueryCommandTests.java

License:Apache License

public void testEmptyFactSelections() {

    DrillPathEntry<String> root = new DrillPathEntry<String>(TestData.dimensionA, TestData.dimensionalAttrA1);
    TestHierarchicalQueryCommand queryEngine = new TestHierarchicalQueryCommand(new MySQL5Dialect());
    HierarchicalQuery query = new HierarchicalQuery(TestData.factTable, new FactSelection[] {},
            new Criterion[] {}, root);

    try {//  w w w.  jav  a2s .c  o m

        queryEngine.generateSqlForTest(query);
        fail("QueryException  expected.");

    } catch (QueryException e) {
    }
}

---

From source file:com.evinceframework.data.tests.warehouse.query.jdbc.hierarchical.HierarchicalJdbcQueryCommandTests.java

License:Apache License

public void testFactSelectionWithoutFunction() {

    DrillPathEntry<String> root = new DrillPathEntry<String>(TestData.dimensionA, TestData.dimensionalAttrA1);
    TestHierarchicalQueryCommand queryEngine = new TestHierarchicalQueryCommand(new MySQL5Dialect());
    HierarchicalQuery query = new HierarchicalQuery(TestData.factTable,
            new FactSelection[] { new FactSelectionImpl(TestData.simpleIntegerFact) }, new Criterion[] {},
            root);/*from   www . ja  va 2 s  .  c om*/

    try {

        queryEngine.generateSqlForTest(query);
        fail("QueryException  expected.");

    } catch (QueryException e) {
    }
}

---

From source file:com.evinceframework.data.tests.warehouse.query.jdbc.hierarchical.HierarchicalJdbcQueryCommandTests.java

License:Apache License

public void testQuerySql() throws QueryException {

    DrillPathEntry<String> root = new DrillPathEntry<String>(TestData.dimensionA, TestData.dimensionalAttrA1);
    TestHierarchicalQueryCommand queryEngine = new TestHierarchicalQueryCommand(new MySQL5Dialect());
    HierarchicalQuery query = new HierarchicalQuery(TestData.factTable,
            new FactSelection[] {
                    new FactSelectionImpl(TestData.simpleIntegerFact, FactSelectionFunction.SUM) },
            new Criterion[] {}, root);

    String sql = queryEngine.generateSqlForTest(query);

    assertNotNull(sql);/*from ww  w. j  av  a  2  s  .c  o  m*/
    assertEquals(
            "select SUM(fact.simpleInteger) as SUM_simpleInteger, dim_0.attr1 as dim_0_attr1 from fooTable fact inner join dimA dim_0 on dimA1_id=dim_0.dimA_id group by dim_0.attr1",
            sql);
}

---

From source file:com.evinceframework.data.tests.warehouse.query.jdbc.pivot.DimensionCriterionTests.java

License:Apache License

public void test_QueryEngine() throws QueryException {

    TestPivotQueryCommand queryEngine = new TestPivotQueryCommand(new MySQL5Dialect());

    PivotQuery query = new PivotQuery(TestData.factTable,
            new FactSelection[] { new FactSelectionImpl(TestData.simpleIntegerFact) },
            new Criterion[] { Expressions.eq(TestData.dimensionA, TestData.dimensionalAttrA1, "testValue") },
            new SummarizationAttribute[] {});
    query.setMaximumRowCount(null);/*from  w  w  w  . j av  a  2  s  .c om*/

    String sql = queryEngine.generateSqlForTest(query);

    assertNotNull(sql);
    assertEquals(
            "select fact.simpleInteger as fact_simpleInteger from fooTable fact inner join dimA dim_0 on dimA1_id=dim_0.dimA_id where dim_0.attr1 = ?",
            sql);
}

---

From source file:com.evinceframework.data.tests.warehouse.query.jdbc.pivot.PivotJdbcQueryCommandTests.java

License:Apache License

public void testNullFactSelections() {

    TestPivotQueryCommand queryEngine = new TestPivotQueryCommand(new MySQL5Dialect());
    PivotQuery query = new PivotQuery(TestData.factTable, null, new Criterion[] {},
            new SummarizationAttribute[] {});

    query.setMaximumRowCount(null);//from   w  ww  . j  a  v a2s .c  o  m

    try {

        queryEngine.generateSqlForTest(query);
        fail("QueryException  expected.");

    } catch (QueryException e) {
    }
}

---

From source file:com.evinceframework.data.tests.warehouse.query.jdbc.pivot.PivotJdbcQueryCommandTests.java

License:Apache License

public void testEmptyFactSelections() {

    TestPivotQueryCommand queryEngine = new TestPivotQueryCommand(new MySQL5Dialect());
    PivotQuery query = new PivotQuery(TestData.factTable, new FactSelection[] {}, new Criterion[] {},
            new SummarizationAttribute[] {});
    query.setMaximumRowCount(null);/*from w ww .  j  a v  a  2 s. c om*/

    try {

        queryEngine.generateSqlForTest(query);
        fail("QueryException  expected.");

    } catch (QueryException e) {
    }
}

---

From source file:com.evinceframework.data.tests.warehouse.query.jdbc.pivot.PivotJdbcQueryCommandTests.java

License:Apache License

public void testQuerySql() throws QueryException {

    TestPivotQueryCommand queryEngine = new TestPivotQueryCommand(new MySQL5Dialect());
    PivotQuery query = new PivotQuery(TestData.factTable,
            new FactSelection[] { new FactSelectionImpl(TestData.simpleIntegerFact) }, new Criterion[] {},
            new SummarizationAttribute[] {});

    query.setMaximumRowCount(null);/*from   w w w . jav  a2  s  .com*/

    String sql = queryEngine.generateSqlForTest(query);

    assertNotNull(sql);
    assertEquals("select fact.simpleInteger as fact_simpleInteger from fooTable fact", sql);
}

---

From source file:com.evinceframework.data.tests.warehouse.query.jdbc.pivot.PivotJdbcQueryCommandTests.java

License:Apache License

public void testQueryEngineLimitSql() throws QueryException {

    TestPivotQueryCommand queryEngine = new TestPivotQueryCommand(new MySQL5Dialect(), 10000);
    PivotQuery query = new PivotQuery(TestData.factTable,
            new FactSelection[] { new FactSelectionImpl(TestData.simpleIntegerFact) }, new Criterion[] {},
            new SummarizationAttribute[] {});

    query.setMaximumRowCount(null);/* w w w. j  a va2s.  co m*/

    String sql = queryEngine.generateSqlForTest(query);

    assertNotNull(sql);
    assertEquals("select fact.simpleInteger as fact_simpleInteger from fooTable fact limit ?", sql);
}

---

From source file:com.evinceframework.data.tests.warehouse.query.jdbc.pivot.SummarizationAttributeImplTests.java

License:Apache License

public void testSummarizationAttributeQuery() throws QueryException {

    TestPivotQueryCommand queryEngine = new TestPivotQueryCommand(new MySQL5Dialect());

    PivotQuery query = new PivotQuery(TestData.factTable,
            new FactSelection[] {
                    new FactSelectionImpl(TestData.simpleIntegerFact, FactSelectionFunction.SUM) },
            new Criterion[] {},
            new SummarizationAttribute[] { new SummarizationAttributeImpl(TestData.dimensionA) });
    query.setMaximumRowCount(null);//from   www .j av  a2s  . c  o  m

    String sql = queryEngine.generateSqlForTest(query);

    assertNotNull(sql);
    // The code for this is commented out, because it needs to be updated
    //assertEquals("select dim_0.attr1 as attr1, SUM(fact.simpleInteger) as SUM_simpleInteger from fooTable fact inner join dimA dim_0 on dimA1_id=dim_0.dimA_id group by dim_0.attr1", sql);
}

---