Package org.apache.metamodel.schema

Examples of org.apache.metamodel.schema.Column


        if (splitColumns.isEmpty() || getRowCount() <= _maxRows) {
            if (getRowCount() > 0) {
                result.add(_query);
            }
        } else {
            Column firstColumn = splitColumns.get(0);
            splitColumns.remove(0);
            List<Query> splitQueries = splitQueryBasedOnColumn(firstColumn);
            for (Query splitQuery : splitQueries) {
                QuerySplitter qs = new QuerySplitter(_dataContext, splitQuery).setMaxRows(_maxRows);
                if (qs.getRowCount() > _maxRows) {
View Full Code Here


    private List<Column> getSplitColumns() {
        List<Column> result = new ArrayList<Column>();
        if (_query.getGroupByClause().getItemCount() != 0) {
            List<GroupByItem> groupByItems = _query.getGroupByClause().getItems();
            for (GroupByItem groupByItem : groupByItems) {
                Column column = groupByItem.getSelectItem().getColumn();
                if (column != null) {
                    if (column.isIndexed()) {
                        // Indexed columns have first priority, they will be
                        // added to the beginning of the list
                        result.add(0, column);
                    } else {
                        result.add(column);
View Full Code Here

    }

    private static void addColumnsToResult(Table table, List<Column> result) {
        Column[] numberColumns = table.getNumberColumns();
        for (int i = 0; i < numberColumns.length; i++) {
            Column column = numberColumns[i];
            if (column.isIndexed()) {
                // Indexed columns have first priority, they will be
                // added to the beginning of the list
                result.add(0, column);
            } else {
                result.add(column);
View Full Code Here

        };
    }

    @Override
    public FilterBuilder<RowUpdationBuilder> where(String columnName) {
        Column column = getTable().getColumnByName(columnName);
        return where(column);
    }
View Full Code Here

                }

                // Loop through aggregate functions to check for validity
                for (SelectItem item : functionItems) {
                    List<Object> objects = functionInput.get(item);
                    Column column = item.getColumn();
                    if (column != null) {
                        Object value = row.getValue(new SelectItem(column));
                        objects.add(value);
                    } else if (SelectItem.isCountAllItem(item)) {
                        // Just use the empty string, since COUNT(*) don't
View Full Code Here

        final List<Row> resultRows = new ArrayList<Row>();
        while (dataSet.next()) {
            final Row inputRow = dataSet.getRow();
            for (SelectItem item : functionItems) {
                final AggregateBuilder<?> aggregateBuilder = aggregateBuilders.get(item);
                final Column column = item.getColumn();
                if (column != null) {
                    Object value = inputRow.getValue(new SelectItem(column));
                    aggregateBuilder.add(value);
                } else if (SelectItem.isCountAllItem(item)) {
                    // Just use the empty string, since COUNT(*) don't
View Full Code Here

    Query query = new Query().from(table1, "f").from(table2, "b");
    GroupedQueryBuilderImpl gqbi = new GroupedQueryBuilderImpl(dataContext,
        query);

    Column col = gqbi.findColumn("b.col2");
    assertEquals("bar.col2", col.getQualifiedLabel());

    col = gqbi.findColumn("f.col2");
    assertEquals("foo.col2", col.getQualifiedLabel());

    try {
      col = gqbi.findColumn("f.col4");
      fail("Exception expected");
    } catch (IllegalArgumentException e) {
View Full Code Here

      }
    };
    Table tableAB = new MutableTable("tableAB");
    Table tableC = new MutableTable("tableC");

    Column colA = new MutableColumn("colA", null, tableAB, 0, true);
    Column colB = new MutableColumn("colB", null, tableAB, 1, true);
    Column colC = new MutableColumn("colC", null, tableC, 0, true);

    Query q = dc.query().from(tableAB).leftJoin(tableC).on(colB, colC)
        .select(colA).as("a").select(colB).as("b").select(colC).as("c")
        .toQuery();
View Full Code Here

        assertEquals("tabl_e.col", dc.getColumnByQualifiedLabel("sch.tabl_e.col").getQualifiedLabel());
    }

    public void testGetColumnByQualifiedLabelCaseInsensitive() throws Exception {
        MyDataContext dc = new MyDataContext();
        Column result = dc.getColumnByQualifiedLabel("FOOBAR.TABLE.COL1");
        assertNotNull(result);
        assertEquals("col1", result.getName());
    }
View Full Code Here

        return dataContext;
    }

    public void testDistinct() throws Exception {

        Column roleColumn = table2.getColumnByName(COLUMN_ROLE_ROLE_NAME);

        Query q = new Query().select(roleColumn).from(table2).orderBy(roleColumn);
        q.getSelectClause().setDistinct(true);

        DataContext dc = getDataContext();
View Full Code Here

TOP

Related Classes of org.apache.metamodel.schema.Column

Copyright © 2018 www.massapicom. All rights reserved.
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.