Package org.apache.metamodel.schema

Examples of org.apache.metamodel.schema.Column

201
202
203
204
205
206
207
208
209
210
211
        row = new DefaultRow(header, new Object[] { null, null });
        assertTrue(c.evaluate(row));
    }

    public void testEvaluateDates() throws Exception {
        Column col1 = new MutableColumn("Col1", ColumnType.DATE);
        SelectItem s1 = new SelectItem(col1);
        SelectItem[] selectItems = new SelectItem[] { s1 };
        CachingDataSetHeader header = new CachingDataSetHeader(selectItems);

        long currentTimeMillis = System.currentTimeMillis();
View Full Code Here
218
219
220
221
222
223
224
225
226
227
228
        row = new DefaultRow(header, new Object[] { new java.sql.Date(currentTimeMillis - 10000000) });
        assertTrue(c.evaluate(row));
    }

    public void testEvaluateBooleans() throws Exception {
        Column col1 = new MutableColumn("Col1", ColumnType.BIT);
        SelectItem s1 = new SelectItem(col1);
        SelectItem[] selectItems = new SelectItem[] { s1 };
        DataSetHeader header = new SimpleDataSetHeader(selectItems);

        FilterItem c = new FilterItem(s1, OperatorType.EQUALS_TO, true);
View Full Code Here
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
     * <li>the hashcode is the same when run twice on an unaltered object</li>
     * <li>if o1.equals(o2) then this condition must be true: o1.hashCode() ==
     * 02.hashCode()
     */
    public void testEqualsAndHashCode() throws Exception {
        Column col1 = new MutableColumn("Col1", ColumnType.BIT);

        FilterItem c1 = new FilterItem(new SelectItem(col1), OperatorType.EQUALS_TO, true);
        FilterItem c2 = new FilterItem(new SelectItem(col1), OperatorType.EQUALS_TO, true);
        assertEquals(c1, c2);
        assertEquals(c1.hashCode(), c2.hashCode());

        c2 = new FilterItem(new SelectItem(col1), OperatorType.GREATER_THAN, true);
        assertFalse(c1.equals(c2));
        assertFalse(c1.hashCode() == c2.hashCode());

        Column col2 = new MutableColumn("Col2", ColumnType.VARBINARY);
        c2 = new FilterItem(new SelectItem(col2), OperatorType.EQUALS_TO, true);
        assertFalse(c1.equals(c2));
        assertFalse(c1.hashCode() == c2.hashCode());
    }
View Full Code Here
269
270
271
272
273
274
275
276
277
278
279
        assertFalse(c1.equals(c2));
        assertFalse(c1.hashCode() == c2.hashCode());
    }

    public void testOrFilterItem() throws Exception {
        Column col1 = new MutableColumn("Col1", ColumnType.VARCHAR);

        SelectItem s1 = new SelectItem(col1);
        FilterItem c1 = new FilterItem(s1, OperatorType.EQUALS_TO, "foo");
        FilterItem c2 = new FilterItem(s1, OperatorType.EQUALS_TO, "bar");
        FilterItem c3 = new FilterItem(s1, OperatorType.EQUALS_TO, "foobar");
View Full Code Here
289
290
291
292
293
294
295
296
297
298
299
        assertFalse(filter.evaluate(new DefaultRow(header, new Object[] { "foob" })));
    }

    public void testAndFilterItem() throws Exception {
        Column col1 = new MutableColumn("Col1", ColumnType.VARCHAR);

        SelectItem s1 = new SelectItem(col1);
        FilterItem c1 = new FilterItem(s1, OperatorType.LIKE, "foo%");
        FilterItem c2 = new FilterItem(s1, OperatorType.LIKE, "%bar");
        FilterItem c3 = new FilterItem(s1, OperatorType.DIFFERENT_FROM, "foobar");
View Full Code Here
315
316
317
318
319
320
321
322
323
324
325
326
327
        // define the schema
        final MutableSchema schema = new MutableSchema("s");
        MutableTable table = new MutableTable("persons", TableType.TABLE, schema);
        schema.addTable(table);
        final Column col1 = new MutableColumn("name", ColumnType.VARCHAR, table, 1, true);
        final Column col2 = new MutableColumn("role", ColumnType.VARCHAR, table, 2, true);
        final Column col3 = new MutableColumn("column_number", ColumnType.INTEGER, table, 3, true);
        table.addColumn(col1);
        table.addColumn(col2);
        table.addColumn(col3);

        Query q = new Query();
View Full Code Here
28
29
30
31
32
33
34
35
36
37
38
39
    private Schema _schema = getExampleSchema();

    public void testSelectColumnInFromItem() throws Exception {
        final Table projectTable = _schema.getTableByName(TABLE_PROJECT);
        final Column column1 = projectTable.getColumns()[0];
        final Column column2 = projectTable.getColumns()[1];

        Query q = new Query().from(projectTable, "a").from(projectTable, "b");
        q.select(column1, q.getFromClause().getItem(1));
        q.select(column2, q.getFromClause().getItem(0));
View Full Code Here
47
48
49
50
51
52
53
54
55
56
57
    public void testSubQuerySelectItem() throws Exception {
        Table projectTable = _schema.getTableByName(TABLE_PROJECT);
        Table roleTable = _schema.getTableByName(TABLE_ROLE);

        Column projectIdColumn = projectTable.getColumnByName(COLUMN_PROJECT_PROJECT_ID);

        FromItem leftSide = new FromItem(projectTable);
        leftSide.setAlias("a");
        SelectItem[] leftOn = new SelectItem[] { new SelectItem(projectIdColumn) };
View Full Code Here
338
339
340
341
342
343
344
345
346
347
348
349
350
    Schema schema = dc.getSchemaByName("sakila");
    Table staffListTable = schema.getTableByName("staff_list");
    assertNotNull(staffListTable);
    Table paymentTable = schema.getTableByName("payment");
    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());
View Full Code Here
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
     */
    protected Schema getExampleSchema() {
        MutableSchema schema = new MutableSchema("MetaModelSchema");

        MutableTable table1 = new MutableTable(TABLE_CONTRIBUTOR, TableType.TABLE, schema);
        Column column1 = new MutableColumn(COLUMN_CONTRIBUTOR_CONTRIBUTOR_ID, ColumnType.INTEGER, table1, 0, false)
                .setIndexed(true).setPrimaryKey(true);
        Column column2 = new MutableColumn(COLUMN_CONTRIBUTOR_NAME, ColumnType.VARCHAR, table1, 1, false);
        Column column3 = new MutableColumn(COLUMN_CONTRIBUTOR_COUNTRY, ColumnType.VARCHAR, table1, 2, true);
        table1.setColumns(column1, column2, column3);

        MutableTable table2 = new MutableTable(TABLE_PROJECT, TableType.TABLE, schema);
        Column column4 = new MutableColumn(COLUMN_PROJECT_PROJECT_ID, ColumnType.INTEGER, table2, 0, false)
                .setPrimaryKey(true);
        Column column5 = new MutableColumn(COLUMN_PROJECT_NAME, ColumnType.VARCHAR, table2, 1, false);
        Column column6 = new MutableColumn(COLUMN_PROJECT_LINES_OF_CODE, ColumnType.BIGINT, table2, 2, true);
        Column column7 = new MutableColumn(COLUMN_PROJECT_PARENT_PROJECT_ID, ColumnType.INTEGER, table2, 3, true);
        table2.setColumns(column4, column5, column6, column7);

        MutableTable table3 = new MutableTable(TABLE_ROLE, TableType.TABLE, schema);
        Column column8 = new MutableColumn(COLUMN_ROLE_CONTRIBUTOR_ID, ColumnType.INTEGER, table3, 0, false)
                .setPrimaryKey(true);
        Column column9 = new MutableColumn(COLUMN_ROLE_PROJECT_ID, ColumnType.INTEGER, table3, 1, false)
                .setPrimaryKey(true);
        Column column10 = new MutableColumn(COLUMN_ROLE_ROLE_NAME, ColumnType.VARCHAR, table3, 2, false);
        table3.setColumns(column8, column9, column10);

        MutableTable table4 = new MutableTable(TABLE_PROJECT_CONTRIBUTOR, TableType.VIEW, schema);
        Column column11 = new MutableColumn(COLUMN_PROJECT_CONTRIBUTOR_CONTRIBUTOR, ColumnType.VARCHAR, table4, 0,
                false);
        Column column12 = new MutableColumn(COLUMN_PROJECT_CONTRIBUTOR_PROJECT, ColumnType.VARCHAR, table4, 1, false);
        Column column13 = new MutableColumn(COLUMN_PROJECT_CONTRIBUTOR_ROLE, ColumnType.VARCHAR, table4, 2, false);
        ArrayList<Column> columnList = new ArrayList<Column>();
        columnList.add(column11);
        columnList.add(column12);
        columnList.add(column13);
        table4.setColumns(columnList);
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.