Examples of org.apache.metamodel.query.Query

org.apache.metamodel.query.Query
Represents a query to retrieve data by. A query is made up of six clauses, equivalent to the SQL standard:
- the SELECT clause, which define the wanted columns of the resulting DataSet
- the FROM clause, which define where to retrieve the data from
- the WHERE clause, which define filters on the retrieved data
- the GROUP BY clause, which define if the result should be grouped and aggregated according to some columns acting as categories
- the HAVING clause, which define filters on the grouped data
- the ORDER BY clause, which define sorting of the resulting dataset
In addition two properties are applied to queries to limit the resulting dataset:
- First row: The first row (aka. offset) of the result of the query.
- Max rows: The maximum amount of rows to return when executing the query.
Queries are executed using the DataContext.executeQuery method or can alternatively be used directly in JDBC by using the toString() method. @see DataContext

        assertEquals("SELECT a.foo AS f FROM sch.tbl a INNER JOIN sch.tbl b ON a.foo = b.foo ORDER BY a.foo ASC",
                q.toSql());
    }


    public void testSelectEverythingFromTable() throws Exception {
        Query q = MetaModelHelper.parseQuery(dc, "SELECT * FROM sch.tbl");
        assertEquals("SELECT tbl.foo, tbl.bar, tbl.baz FROM sch.tbl", q.toSql());
    }

View Full Code Here

        Query q = MetaModelHelper.parseQuery(dc, "SELECT * FROM sch.tbl");
        assertEquals("SELECT tbl.foo, tbl.bar, tbl.baz FROM sch.tbl", q.toSql());
    }


    public void testSelectEverythingFromJoin() throws Exception {
        Query q = MetaModelHelper.parseQuery(dc, "SELECT * FROM sch.tbl a INNER JOIN sch.tbl b ON a.foo = b.foo");
        assertEquals(
                "SELECT a.foo, a.bar, a.baz, b.foo, b.bar, b.baz FROM sch.tbl a INNER JOIN sch.tbl b ON a.foo = b.foo",
                q.toSql());


        q = MetaModelHelper.parseQuery(dc, "SELECT a.foo, b.* FROM sch.tbl a INNER JOIN sch.tbl b ON a.foo = b.foo");
        assertEquals("SELECT a.foo, b.foo, b.bar, b.baz FROM sch.tbl a INNER JOIN sch.tbl b ON a.foo = b.foo",
                q.toSql());
    }

View Full Code Here


    public void testSelectColumnWithDotInName() throws Exception {
        MutableColumn col = (MutableColumn) dc.getTableByQualifiedLabel("tbl").getColumn(0);
        col.setName("fo.o");


        Query q = MetaModelHelper.parseQuery(dc, "SELECT fo.o AS f FROM sch.tbl");
        assertEquals("SELECT tbl.fo.o AS f FROM sch.tbl", q.toSql());
    }

View Full Code Here

        Query q = MetaModelHelper.parseQuery(dc, "SELECT fo.o AS f FROM sch.tbl");
        assertEquals("SELECT tbl.fo.o AS f FROM sch.tbl", q.toSql());
    }


    public void testSelectAlias() throws Exception {
        Query q = MetaModelHelper.parseQuery(dc, "SELECT foo AS f FROM sch.tbl");
        assertEquals("SELECT tbl.foo AS f FROM sch.tbl", q.toSql());


        q = MetaModelHelper.parseQuery(dc, "SELECT a.foo AS foobarbaz FROM sch.tbl a WHERE foobarbaz = '123'");
        assertEquals("SELECT a.foo AS foobarbaz FROM sch.tbl a WHERE foobarbaz = '123'", q.toSql());
    }

View Full Code Here

    Table[] tables = schema.getTables();
        Table table1 = tables[0];
        Table table2 = tables[2];
        assertNotSame(table1, table2);


    Query q = composite
        .query()
        .from(table1)
        .leftJoin(table2)
        .on(table1.getColumnByName("foo"),
            table2.getColumnByName("foo"))
        .select(table1.getColumnByName("foo"),
            table2.getColumnByName("foo"),
            table1.getColumnByName("bar"),
            table2.getColumnByName("baz")).toQuery();
    assertEquals(
        "SELECT table.foo, table.foo, table.bar, table.baz "
            + "FROM schema.table LEFT JOIN schema.table ON table.foo = table.foo",
        q.toSql());


    DataSet ds = composite.executeQuery(q);
    assertTrue(ds.next());
    assertEquals("Row[values=[1, 1, hello, world]]", ds.getRow().toString());
    assertTrue(ds.next());

View Full Code Here

    Schema[] schemas = dc.getSchemas();
    assertEquals("[Schema[name=mysql], Schema[name=performance_schema], Schema[name=portal], "
        + "Schema[name=sakila], Schema[name=world]]", Arrays.toString(schemas));


    Table table = dc.getSchemaByName("sakila").getTableByName("film");
    Query q = new Query().from(table).select(table.getColumns());
    DataSet data = dc.executeQuery(q);
    TableModel tableModel = new DataSetTableModel(data);
    assertEquals(13, tableModel.getColumnCount());
    assertEquals(1000, tableModel.getRowCount());
  }

View Full Code Here

        "[Column[name=actor_id,columnNumber=0,type=SMALLINT,nullable=false,nativeType=SMALLINT UNSIGNED,columnSize=5], "
            + "Column[name=film_id,columnNumber=1,type=SMALLINT,nullable=false,nativeType=SMALLINT UNSIGNED,columnSize=5], "
            + "Column[name=last_update,columnNumber=2,type=TIMESTAMP,nullable=false,nativeType=TIMESTAMP,columnSize=19]]",
        Arrays.toString(filmActorJoinTable.getColumns()));


    Query q = new Query();
    q.from(new FromItem(actorTable).setAlias("a"));
    q.select(actorTable.getColumns());
    q.getSelectClause().getItem(0).setAlias("foo-bar");
    assertEquals(
        "SELECT a.`actor_id` AS foo-bar, a.`first_name`, a.`last_name`, a.`last_update` FROM sakila.`actor` a",
        q.toString());
    FilterItem f1 = new FilterItem(q.getSelectClause().getItem(0), OperatorType.EQUALS_TO, 5);
    FilterItem f2 = new FilterItem(q.getSelectClause().getItem(0), OperatorType.EQUALS_TO, 8);
    q.where(new FilterItem(f1, f2));


    DataSet dataSet = dc.executeQuery(q);
    TableModel tableModel = new DataSetTableModel(dataSet);
    assertEquals(4, tableModel.getColumnCount());
    assertEquals(2, tableModel.getRowCount());
    assertEquals("LOLLOBRIGIDA", tableModel.getValueAt(0, 2));


    q.setMaxRows(1);
    dataSet = dc.executeQuery(q);
    tableModel = new DataSetTableModel(dataSet);
    assertEquals(4, tableModel.getColumnCount());
    assertEquals(1, tableModel.getRowCount());
    assertEquals("LOLLOBRIGIDA", tableModel.getValueAt(0, 2));
    
    q.setMaxRows(1);
    q.setFirstRow(2);
        dataSet = dc.executeQuery(q);
        tableModel = new DataSetTableModel(dataSet);
        assertEquals(4, tableModel.getColumnCount());
        assertEquals(1, tableModel.getRowCount());
        assertEquals("JOHANSSON", tableModel.getValueAt(0, 2));


    q.getWhereClause().removeItems();
    q.setMaxRows(25);
    q.setFirstRow(1);
    dataSet = dc.executeQuery(q);
    tableModel = new DataSetTableModel(dataSet);
    assertEquals(4, tableModel.getColumnCount());
    assertEquals(25, tableModel.getRowCount());
    assertEquals("GUINESS", tableModel.getValueAt(0, 2).toString());

View Full Code Here

            return input.select(table.getColumnByName("bar"));


          }
        });


    DataSet ds = dc.executeQuery(new Query().from(table));
    assertEquals("[table.foo, table.bar]", Arrays.toString(ds.getSelectItems()));
  }

View Full Code Here

            return;
        }
        
    DataContext dc = new JdbcDataContext(getConnection());
    Table table = dc.getDefaultSchema().getTableByName("film");
    Query q = new Query().select(table.getColumns()).from(table).setMaxRows(400);
    dc.executeQuery(q);
  }

View Full Code Here

    assertNotNull(paymentTable);
    Column countryColumn = staffListTable.getColumnByName("country");
    assertNotNull(countryColumn);
    Column paymentColumn = paymentTable.getColumns()[0];
    assertNotNull(paymentColumn);
    Query q = new Query().from(staffListTable, "sl").from(paymentTable, "e").select(countryColumn, paymentColumn);
    assertEquals("SELECT sl.`country`, e.`payment_id` FROM sakila.`staff_list` sl, sakila.`payment` e",
        q.toString());


    QuerySplitter qs = new QuerySplitter(dc, q);
    assertEquals(32098, qs.getRowCount());
    List<Query> splitQueries = qs.setMaxRows(8000).splitQuery();
    assertEquals(7, splitQueries.size());

View Full Code Here

0 1 2 3 4 5 6 7 8 9

TOP

Related Classes of org.apache.metamodel.query.Query

org.apache.metamodel.AbstractDataContext

org.apache.metamodel.CompositeDataContextTest

org.apache.metamodel.CompositeQueryDelegate

org.apache.metamodel.convert.ConvertedDataSetInterceptorTest

org.apache.metamodel.convert.Converters

org.apache.metamodel.convert.ConvertersTest

org.apache.metamodel.csv.CsvBigFileMemoryTest

org.apache.metamodel.csv.CsvDataContextTest

org.apache.metamodel.DB2Test

org.apache.metamodel.dbmains.PostgresqlMain

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.