Examples of org.apache.metamodel.DataContext.query()

org.apache.metamodel.DataContext.query()
Starts building a query using the query builder API. This way of building queries is the preferred approach since it provides a more type-safe approach to building API's as well as allows the DataContext implementation to be aware of the query building process. @return a query builder component at the initial position in building aquery.

        Table table = dc.getDefaultSchema().getTables()[0];


        String[] columnNames = table.getColumnNames();
        assertEquals("[A, B, C, D]", Arrays.toString(columnNames));


        Query q = dc.query().from(table).select(table.getColumnByName("A")).toQuery();
        assertEquals("SELECT xls_people.A FROM xls_people.xls.xls_people", q.toSql());


        DataSet dataSet = dc.executeQuery(q);
        assertTrue(dataSet.next());
        assertEquals("id", dataSet.getRow().getValue(0));

View Full Code Here

        Table table = dc.getDefaultSchema().getTables()[0];


        String[] columnNames = table.getColumnNames();
        assertEquals("[1, mike, male, 18]", Arrays.toString(columnNames));


        Query q = dc.query().from(table).select(table.getColumnByName("1")).toQuery();
        assertEquals("SELECT xls_people.1 FROM xls_people.xls.xls_people", q.toSql());


        DataSet dataSet = dc.executeQuery(q);
        assertTrue(dataSet.next());
        assertEquals("2", dataSet.getRow().getValue(0));

View Full Code Here

    public void testGetStyles() throws Exception {
        DataContext dc = new ExcelDataContext(new File("src/test/resources/styles.xlsx"));
        Table table = dc.getDefaultSchema().getTables()[0];
        assertEquals("[style name, example]", Arrays.toString(table.getColumnNames()));


        DataSet ds = dc.query().from(table).select(table.getColumns()).execute();
        assertTrue(ds.next());
        assertEquals("Row[values=[bold, foo]]", ds.getRow().toString());
        assertEquals("", ds.getRow().getStyle(0).toCSS());
        assertEquals("font-weight: bold;", ds.getRow().getStyle(1).toCSS());

View Full Code Here

    final Table table = schema.getTableByName("/dependency");
    assertEquals("[row_id, /artifactId, /groupId, /version, /scope]",
        Arrays.toString(table.getColumnNames()));


    // perform a regular query
    DataSet ds = dc.query().from(table).select(table.getColumns())
        .execute();
    assertTrue(ds.next());
    assertEquals("Row[values=[0, joda-time, joda-time, 1.5.2, compile]]",
        ds.getRow().toString());

View Full Code Here

        ds.getRow().toString());
    assertFalse(ds.next());
    ds.close();


    // perform a constrained query
    Query q = dc.query().from(table).select("row_id").and("/groupId")
        .where("/scope").isNotNull().toQuery();
    q.setMaxRows(2);
    ds = dc.executeQuery(q);


    assertTrue(ds.next());

View Full Code Here

    final Table organizationTable = schema.getTableByName("/organization");
    {
      assertEquals("[row_id, /name, @type]",
          Arrays.toString(organizationTable.getColumnNames()));


      DataSet ds = dc.query().from(organizationTable)
          .select(organizationTable.getColumns()).execute();
      assertTrue(ds.next());
      assertEquals("Row[values=[0, Company A, governmental]]", ds
          .getRow().toString());
      assertTrue(ds.next());

View Full Code Here

    {
      assertEquals(
          "[row_id, /name, /gender, index(/root/organization/employees), index(/root/organization)]",
          Arrays.toString(employeeTable.getColumnNames()));


      DataSet ds = dc.query().from(employeeTable)
          .select(employeeTable.getColumns()).execute();
      assertTrue(ds.next());
      assertEquals("Row[values=[0, John Doe, M, 0, 0]]", ds.getRow()
          .toString());
      assertTrue(ds.next());

View Full Code Here

      Column orgId = organizationTable.getColumnByName("row_id");
      assertNotNull(orgId);
      Column orgName = organizationTable.getColumnByName("/name");
      assertNotNull(orgName);


      Query q = dc.query().from(employeeTable)
          .innerJoin(organizationTable).on(fk, orgId).select(empName)
          .as("employee").select(orgName).as("company").toQuery();


      assertEquals(
          "SELECT /employee./name AS employee, /organization./name AS company "

View Full Code Here

        assertEquals(ColumnType.VARCHAR, table.getColumnByName("foo").getType());
        assertEquals(ColumnType.LIST, table.getColumnByName("list").getType());
        assertEquals(ColumnType.INTEGER, table.getColumnByName("id").getType());
        assertEquals(ColumnType.ROWID, table.getColumnByName("_id").getType());


        DataSet ds = dataContext.query().from(getCollectionName()).select("name").and("foo").and("baz").and("list")
                .where("id").greaterThan(800).or("foo").isEquals("bar").execute();
        assertEquals(MongoDbDataSet.class, ds.getClass());
        assertFalse(((MongoDbDataSet) ds).isQueryPostProcessed());
        try {
            assertTrue(ds.next());

View Full Code Here

            assertFalse(ds.next());
        } finally {
            ds.close();
        }


        ds = dataContext.query().from(getCollectionName()).select("id").and("name").where("id").in(2, 6, 8, 9)
                .execute();
        assertTrue(ds.next());
        assertEquals("Row[values=[2, record no. 2]]", ds.getRow().toString());
        assertTrue(ds.next());
        assertEquals("Row[values=[6, record no. 6]]", ds.getRow().toString());

View Full Code Here

0 1 2 3 4

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.