Package org.apache.metamodel.schema

Examples of org.apache.metamodel.schema.Column

298
299
300
301
302
303
304
305
306
307
308
309
    }

    public void testOrderByWithoutSelecting() throws Exception {
        Query q = new Query();
        q.from(new FromItem(table2).setAlias("r"));
        Column roleColumn = table2.getColumnByName(COLUMN_ROLE_ROLE_NAME);
        Column projectIdColumn = table2.getColumnByName(COLUMN_ROLE_PROJECT_ID);
        q.select(new SelectItem(projectIdColumn));
        q.orderBy(roleColumn);
        assertEquals("SELECT r.project_id FROM MetaModelSchema.role r ORDER BY r.name ASC", q.toString());

        DataContext dc = getDataContext();
View Full Code Here
337
338
339
340
341
342
343
344
345
346
347
348
    }

    public void testGroupByWithoutSelecting() throws Exception {
        Query q = new Query();
        q.from(new FromItem(table2).setAlias("r"));
        Column roleColumn = table2.getColumnByName(COLUMN_ROLE_ROLE_NAME);
        Column projectIdColumn = table2.getColumnByName(COLUMN_ROLE_PROJECT_ID);
        q.select(new SelectItem(FunctionType.SUM, projectIdColumn));
        q.groupBy(new GroupByItem(new SelectItem(roleColumn)));
        q.orderBy(roleColumn);
        assertEquals("SELECT SUM(r.project_id) FROM MetaModelSchema.role r GROUP BY r.name ORDER BY r.name ASC",
                q.toString());
View Full Code Here
372
373
374
375
376
377
378
379
380
381
382
    }

    public void testSimpleGroupBy() throws Exception {
        Query q = new Query();
        q.from(new FromItem(table2).setAlias("r"));
        Column roleColumn = table2.getColumnByName(COLUMN_ROLE_ROLE_NAME);
        q.select(new SelectItem(roleColumn));
        q.groupBy(new GroupByItem(new SelectItem(roleColumn)));
        assertEquals("SELECT r.name FROM MetaModelSchema.role r GROUP BY r.name", q.toString());

        DataContext dc = getDataContext();
View Full Code Here
414
415
416
417
418
419
420
421
422
423
424
425
    }

    public void testSimpleHaving() throws Exception {
        Query q = new Query();
        q.from(table2, "c");
        Column roleColumn = table2.getColumnByName(COLUMN_ROLE_ROLE_NAME);
        Column contributorIdColumn = table2.getColumnByName(COLUMN_ROLE_CONTRIBUTOR_ID);

        q.groupBy(roleColumn);
        SelectItem countSelectItem = new SelectItem(FunctionType.COUNT, contributorIdColumn).setAlias("my_count");
        q.select(new SelectItem(roleColumn), countSelectItem);
        q.having(new FilterItem(countSelectItem, OperatorType.GREATER_THAN, 1));
View Full Code Here
437
438
439
440
441
442
443
444
445
446
447
448
    }

    public void testHavingFunctionNotSelected() throws Exception {
        Query q = new Query();
        q.from(table2, "c");
        Column roleColumn = table2.getColumnByName(COLUMN_ROLE_ROLE_NAME);
        Column contributorIdColumn = table2.getColumnByName(COLUMN_ROLE_CONTRIBUTOR_ID);

        q.groupBy(roleColumn);
        SelectItem countSelectItem = new SelectItem(FunctionType.COUNT, contributorIdColumn).setAlias("my_count");
        q.select(new SelectItem(roleColumn));
        q.having(new FilterItem(countSelectItem, OperatorType.GREATER_THAN, 3));
View Full Code Here
307
308
309
310
311
312
313
314
315
316
317
318
                    // checking if the query is a primary key lookup query
                    if (whereItems.size() == 1) {
                        final FilterItem whereItem = whereItems.get(0);
                        final SelectItem selectItem = whereItem.getSelectItem();
                        if (!whereItem.isCompoundFilter() && selectItem != null && selectItem.getColumn() != null) {
                            final Column column = selectItem.getColumn();
                            if (column.isPrimaryKey() && whereItem.getOperator() == OperatorType.EQUALS_TO) {
                                logger.debug("Query is a primary key lookup query. Trying executePrimaryKeyLookupQuery(...)");
                                final Object operand = whereItem.getOperand();
                                final Row row = executePrimaryKeyLookupQuery(table, selectItems, column, operand);
                                if (row == null) {
                                    logger.debug("DataContext did not return any primary key lookup query results. Proceeding with manual lookup.");
View Full Code Here
385
386
387
388
389
390
391
392
393
394
395
396
            query.put("$or", orList);

        } else {

            final Column column = item.getSelectItem().getColumn();
            final String columnName = column.getName();
            final Object operand = item.getOperand();
            final String operatorName = getOperatorName(item);

            final BasicDBObject existingFilterObject = (BasicDBObject) query.get(columnName);
            if (existingFilterObject == null) {
View Full Code Here
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
        assertEquals("baz.buuh", dc.getColumnByQualifiedLabel("\"foo\".bar.\"baz.buuh\"").getName());
    }

    public void testGetColumnByQualifiedLabel() throws Exception {
        MyDataContext dc = new MyDataContext();
        Column result;

        result = dc.getColumnByQualifiedLabel("foobar.tab.le.col1");
        result = dc.getColumnByQualifiedLabel("blabla.tab.le.col4");
        result = dc.getColumnByQualifiedLabel("FOOBAR.TABLE.COL3");
        assertNull(result);

        result = dc.getColumnByQualifiedLabel("foobar.table.col1");
        assertEquals("col1", result.getName());
        assertEquals("table", result.getTable().getName());
        assertEquals("foobar", result.getTable().getSchema().getName());

        result = dc.getColumnByQualifiedLabel("foo.bar.table.col1");
        assertEquals("col1", result.getName());
        assertEquals("table", result.getTable().getName());
        assertEquals("foo.bar", result.getTable().getSchema().getName());

        result = dc.getColumnByQualifiedLabel("foobar.tab.le.col3");
        assertEquals("col3", result.getName());
        assertEquals("tab.le", result.getTable().getName());
        assertEquals("foobar", result.getTable().getSchema().getName());

        result = dc.getColumnByQualifiedLabel("FOO.BAR.tab.le.col3");
        assertEquals("col3", result.getName());
        assertEquals("tab.le", result.getTable().getName());
        assertEquals("foo.bar", result.getTable().getSchema().getName());

        result = dc.getColumnByQualifiedLabel("tab.le.col3");
        assertEquals("col3", result.getName());
        assertEquals("tab.le", result.getTable().getName());
        assertEquals("foobar", result.getTable().getSchema().getName());
    }
View Full Code Here
42
43
44
45
46
47
48
49
50
51
52
        assertEquals("SELECT COUNT(*) FROM MetaModelSchema.contributor", q.toString());
    }

    public void testCloneGroupBy() throws Exception {
        Table table = _schema.getTableByName(TABLE_PROJECT);
        Column column = table.getColumnByName(COLUMN_PROJECT_NAME);
        Query q = new Query().from(table).selectCount().select(column).groupBy(column);
        assertEquals(q.toString(), q.clone().toString());

        q.having(new FilterItem(SelectItem.getCountAllItem(), OperatorType.GREATER_THAN, 20));
        assertEquals(q.toString(), q.clone().toString());
View Full Code Here
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
    }

    public void testFromItemAlias() throws Exception {
        Query q = new Query();
        Table contributorTable = _schema.getTableByName(TABLE_CONTRIBUTOR);
        Column nameColumn = contributorTable.getColumnByName(COLUMN_CONTRIBUTOR_NAME);
        Column countryColumn = contributorTable.getColumnByName(COLUMN_CONTRIBUTOR_COUNTRY);

        FromItem fromContributor = new FromItem(contributorTable);
        q.from(fromContributor);
        q.select(nameColumn, countryColumn);
        assertEquals("SELECT contributor.name, contributor.country FROM MetaModelSchema.contributor", q.toString());

        fromContributor.setAlias("c");

        assertEquals("SELECT c.name, c.country FROM MetaModelSchema.contributor c", q.toString());

        q.groupBy(new GroupByItem(q.getSelectClause().getSelectItem(nameColumn)));
        q.groupBy(new GroupByItem(q.getSelectClause().getSelectItem(countryColumn)));
        q.select(new SelectItem(FunctionType.COUNT, "*", "total"));
        assertEquals(2, q.getGroupByClause().getItems().size());
        assertEquals(
                "SELECT c.name, c.country, COUNT(*) AS total FROM MetaModelSchema.contributor c GROUP BY c.name, c.country",
                q.toString());

        Column contributorIdColumn = contributorTable.getColumnByName(COLUMN_CONTRIBUTOR_CONTRIBUTOR_ID);
        q.where(contributorIdColumn, OperatorType.EQUALS_TO, 1);
        assertEquals(
                "SELECT c.name, c.country, COUNT(*) AS total FROM MetaModelSchema.contributor c WHERE c.contributor_id = 1 GROUP BY c.name, c.country",
                q.toString());

View Full Code Here
TOP

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

  • org.apache.metamodel.AbstractDataContext
  • org.apache.metamodel.AbstractDataContextTest
  • org.apache.metamodel.convert.ConvertedDataSetInterceptor
  • org.apache.metamodel.convert.ConvertedDataSetInterceptorTest
  • org.apache.metamodel.convert.ConvertedRowInsertionInterceptorTest
  • org.apache.metamodel.convert.Converters
  • org.apache.metamodel.couchdb.CouchDbDataContextTest
  • org.apache.metamodel.couchdb.CouchDbInsertionBuilder
  • org.apache.metamodel.couchdb.CouchDbRowUpdationBuilder
  • org.apache.metamodel.create.AbstractTableCreationBuilder
    • 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.