Package org.apache.metamodel.data

Examples of org.apache.metamodel.data.DataSet

325
326
327
328
329
330
331
332
333
334
335
                    }

                    int firstRow = (query.getFirstRow() == null ? 1 : query.getFirstRow());
                    int maxRows = (query.getMaxRows() == null ? -1 : query.getMaxRows());

                    final DataSet dataSet = materializeMainSchemaTableInternal(table, columns, whereItems, firstRow,
                            maxRows, false);
                    return dataSet;
                }
            }
        }
View Full Code Here
371
372
373
374
375
376
377
378
379
380
381
382
            protected Schema getMainSchema() throws MetaModelException {
                return schema;
            }
        };

        DataSet result = dc.executeQuery(q);
        List<Object[]> objectArrays = result.toObjectArrays();
        assertEquals(3, objectArrays.size());
        assertEquals(2, objectArrays.get(0)[0]);
        assertEquals(4, objectArrays.get(1)[0]);
        assertEquals(5, objectArrays.get(2)[0]);
    }
View Full Code Here
43
44
45
46
47
48
49
50
51
52
53
54
55
    assertEquals("[schema1, schema2]",
        Arrays.toString(composite.getSchemaNames()));
    assertSame(dc1.getDefaultSchema(), composite.getDefaultSchema());

    DataSet ds = composite.query()
        .from(dc1.getDefaultSchema().getTables()[0]).select("foo")
        .execute();
    List<Object[]> objectArrays = ds.toObjectArrays();
    assertEquals("1", objectArrays.get(0)[0]);
    assertEquals("2", objectArrays.get(1)[0]);
    assertEquals(4, objectArrays.size());
  }
View Full Code Here
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
    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());
    assertEquals("Row[values=[2, 2, dc1, world]]", ds.getRow().toString());
    assertTrue(ds.next());
    assertEquals("Row[values=[3, 3, hi, dc2]]", ds.getRow().toString());
    assertTrue(ds.next());
    assertEquals("Row[values=[4, 4, yo, world]]", ds.getRow().toString());
    assertFalse(ds.next());
  }
View Full Code Here
84
85
86
87
88
89
90
91
92
          public DataSet intercept(DataSet dataSet) {
            return new MaxRowsDataSet(dataSet, 1);
          }
        });

    DataSet ds = dc.query().from(table).select("foo").execute();
    assertEquals(MaxRowsDataSet.class, ds.getClass());
    assertEquals(1, ds.toObjectArrays().size());
  }
View Full Code Here
105
106
107
108
109
110
111
112
            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
87
88
89
90
91
92
93
94
95
96
97
98
99
100
            data.add(new DefaultRow(header, new Object[] { "1", "hello", "world" }, null));
            data.add(new DefaultRow(header, new Object[] { "2", _value, "world" }, null));
            data.add(new DefaultRow(header, new Object[] { "3", "hi", _value }, null));
            data.add(new DefaultRow(header, new Object[] { "4", "yo", "world" }, null));

            final DataSet sourceDataSet = new InMemoryDataSet(header, data);

            final SelectItem[] columnSelectItems = MetaModelHelper.createSelectItems(columns);
            final DataSet selectionDataSet = MetaModelHelper.getSelection(columnSelectItems, sourceDataSet);
            return selectionDataSet;
        } else if ("an_empty_table".equals(table.getName())) {
            return new EmptyDataSet(columns);
        }
        throw new UnsupportedOperationException();
View Full Code Here
54
55
56
57
58
59
60
61
62
63
64
        assertEquals(getUsername().toUpperCase(), schema.getName());

        Table countryTable = schema.getTableByName("COUNTRY");
        assertNotNull(countryTable);

        DataSet ds = dc.query().from(countryTable).selectCount().execute();
        assertTrue(ds.next());
        assertEquals("Row[values=[1008]]", ds.getRow().toString());
        assertFalse(ds.next());
        ds.close();
    }
View Full Code Here
77
78
79
80
81
82
83
84
85
86
87
88
89
        Query query = dc.query().from(countryTable).select("COUNTRYCODE").limit(200).toQuery();
        assertEquals("SELECT DB2INST1.\"COUNTRY\".\"COUNTRYCODE\" FROM DB2INST1.\"COUNTRY\" "
                + "FETCH FIRST 200 ROWS ONLY", dc.getQueryRewriter().rewriteQuery(query));

        DataSet ds = dc.executeQuery(query);
        for (int i = 0; i < 200; i++) {
            assertTrue(ds.next());
            assertEquals(1, ds.getRow().getValues().length);
        }
        assertFalse(ds.next());
        ds.close();
    }
View Full Code Here
160
161
162
163
164
165
166
167
168
169
170
171
172
173
    private void runConversionTest(SalesforceDataContext dc, String tableName) {
        Query q = dc.query().from(tableName).selectAll().toQuery();
        q.setMaxRows(1);

        final DataSet ds = dc.executeQuery(q);
        final SelectItem[] selectItems = ds.getSelectItems();
        while (ds.next()) {
            Row row = ds.getRow();

            for (SelectItem selectItem : selectItems) {
                Column column = selectItem.getColumn();
                Object value = row.getValue(column);
                if (value != null) {
View Full Code Here
TOP

Related Classes of org.apache.metamodel.data.DataSet

  • org.apache.metamodel.AbstractDataContext
  • org.apache.metamodel.CompositeDataContextTest
  • org.apache.metamodel.convert.ConvertedDataSetInterceptorTest
  • org.apache.metamodel.convert.Converters
  • org.apache.metamodel.convert.ConvertersTest
  • org.apache.metamodel.couchdb.CouchDbDataContextTest
  • org.apache.metamodel.couchdb.CouchDbRowDeletionBuilder
  • org.apache.metamodel.couchdb.CouchDbRowUpdationBuilder
  • org.apache.metamodel.csv.CsvBigFileMemoryTest
  • org.apache.metamodel.csv.CsvDataContextTest
    • 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.