Examples of org.apache.metamodel.jdbc.JdbcDataContext.executeQuery()

Class org.apache.metamodel.jdbc.JdbcDataContext

Examples of org.apache.metamodel.jdbc.JdbcDataContext.executeQuery()

org.apache.metamodel.jdbc.JdbcDataContext.executeQuery()

                "SELECT metamodel_subquery.\"COUNTRYCODE\" FROM ("
                        + "SELECT DB2INST1.\"COUNTRY\".\"COUNTRYCODE\", ROW_NUMBER() OVER() AS metamodel_row_number FROM DB2INST1.\"COUNTRY\""
                        + ") metamodel_subquery WHERE metamodel_row_number BETWEEN 201 AND 400", dc.getQueryRewriter()
                        .rewriteQuery(query));


        DataSet ds = dc.executeQuery(query);
        for (int i = 0; i < 200; i++) {
            assertTrue(ds.next());
            assertEquals(1, ds.getRow().getValues().length);
        }
        assertFalse(ds.next());

View Full Code Here


  public void testQueryUsingExpressions() throws Exception {
    JdbcDataContext strategy = new JdbcDataContext(_connection,
        new TableType[] { TableType.TABLE, TableType.VIEW }, _databaseName);
    Query q = new Query().select("Name").from("Production.Product").where("COlor IS NOT NULL").setMaxRows(5);
    DataSet dataSet = strategy.executeQuery(q);
    assertEquals("[Name]", Arrays.toString(dataSet.getSelectItems()));
    assertTrue(dataSet.next());
    assertEquals("Row[values=[LL Crankarm]]", dataSet.getRow().toString());
    assertTrue(dataSet.next());
    assertTrue(dataSet.next());

View Full Code Here


    // Test that the original query is still the same (ie. it has been
    // cloned for execution)
    assertEquals("SELECT cus-tomers.\"AccountNumber\" AS c|o|d|e FROM Sales.\"Customer\" cus-tomers", q.toString());


    DataSet data = strategy.executeQuery(q);
    assertNotNull(data);
    data.close();
  }


  public void testQuotedString() throws Exception {

View Full Code Here


  public void testQueryUsingExpressions() throws Exception {
    JdbcDataContext strategy = new JdbcDataContext(_connection,
        new TableType[] { TableType.TABLE, TableType.VIEW }, _databaseName);
    Query q = new Query().select("Name").from("Production.Product").where("COlor IS NOT NULL").setMaxRows(5);
    DataSet dataSet = strategy.executeQuery(q);
    assertEquals("[Name]", Arrays.toString(dataSet.getSelectItems()));
    assertTrue(dataSet.next());
    assertEquals("Row[values=[LL Crankarm]]", dataSet.getRow().toString());
    assertTrue(dataSet.next());
    assertTrue(dataSet.next());

View Full Code Here


    // Test that the original query is still the same (ie. it has been
    // cloned for execution)
    assertEquals("SELECT cus-tomers.\"AccountNumber\" AS c|o|d|e FROM Sales.\"Customer\" cus-tomers", q.toString());


    DataSet data = dc.executeQuery(q);
    assertNotNull(data);
    data.close();
  }


  public void testQuotedString() throws Exception {

View Full Code Here

    IQueryRewriter queryRewriter = dc.getQueryRewriter();
    assertSame(SQLServerQueryRewriter.class, queryRewriter.getClass());


    Query q = dc.query().from("Production", "Product").select("Name").where("Color").eq("R'ed").toQuery();
    
    DataSet ds = dc.executeQuery(q);
    assertNotNull(ds);
    assertFalse(ds.next());
    ds.close();


    assertEquals(

View Full Code Here

                }
            });


            final Table table = schema.getTableByName("my_table");
            Query query = dc.query().from(table).select(table.getColumns()).toQuery();
            DataSet ds = dc.executeQuery(query);
            assertTrue(ds.next());
            assertEquals("Row[values=[1, John Doe, 42]]", ds.getRow().toString());
            assertTrue(ds.next());
            assertEquals("Row[values=[2, Jane Doe, 43]]", ds.getRow().toString());
            assertFalse(ds.next());

View Full Code Here

                    callback.update(table).value("age", 102).where("id").eq(1).execute();
                    callback.deleteFrom(table).where("id").eq(2).execute();
                }
            });


            ds = dc.executeQuery(query);
            assertTrue(ds.next());
            assertEquals("Row[values=[1, John Doe, 102]]", ds.getRow().toString());
            assertFalse(ds.next());
            ds.close();
        } finally {

View Full Code Here

                }
            });


            Table table = schema.getTableByName("my_table");
            Query query = dc.query().from(table).select(table.getColumns()).toQuery();
            DataSet ds = dc.executeQuery(query);
            assertTrue(ds.next());
            // Float value input will be rounded down into integer number.
            assertEquals("Row[values=[1, John Doe, 42]]", ds.getRow().toString());
            assertTrue(ds.next());
            // The age will be incremented as float value input will be rounded

View Full Code Here

        Column titleColumn = productsTable.getColumnByName("title");
        Column productPriceColumn = productsTable.getColumnByName("price");
        q.select(titleColumn, productPriceColumn);
        q.getSelectClause().getItem(0).setAlias("product-title");


        DataSet data = dc.executeQuery(q);
        TableModel tableModel = new DataSetTableModel(data);
        assertEquals(2, tableModel.getColumnCount());
        assertEquals(10000, tableModel.getRowCount());


        assertEquals("ACADEMY ACADEMY", tableModel.getValueAt(0, 0).toString());

View Full Code Here

0 1 2 3 4 5 6

TOP

All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.