Package org.apache.metamodel

Examples of org.apache.metamodel.DataContext

59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
        final File file = getHugeFile();

        final long timeAtStart = System.currentTimeMillis();
        System.out.println("time at start: " + timeAtStart);

        final DataContext dc = new CsvDataContext(file, new CsvConfiguration(1, false, false));
        final Table t = dc.getDefaultSchema().getTables()[0];

        final long timeAfterDataContext = System.currentTimeMillis();
        System.out.println("time after DataContext: " + timeAfterDataContext);

        final Query q = new Query().select(t.getColumns()).from(t);
        DataSet ds = dc.executeQuery(q);

        long timeAfterQuery = System.currentTimeMillis();
        System.out.println("time after query: " + timeAfterQuery);

        final CountDownLatch countDown = new CountDownLatch(hugeFileRows);
View Full Code Here
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
            file.deleteOnExit();
        }
    }

    public void testApproximatedCountHugeFile() throws Exception {
        DataContext dc = new CsvDataContext(getHugeFile());

        Table table = dc.getDefaultSchema().getTables()[0];
        Query q = dc.query().from(table).selectCount().toQuery();
        SelectItem selectItem = q.getSelectClause().getItem(0);
        selectItem.setFunctionApproximationAllowed(true);

        DataSet ds = dc.executeQuery(q);
        assertTrue(ds.next());
        Object[] values = ds.getRow().getValues();
        assertEquals(1, values.length);
        assertEquals(3332, ((Long) ds.getRow().getValue(selectItem)).intValue());
        assertEquals(3332, ((Long) values[0]).intValue());
View Full Code Here
237
238
239
240
241
242
243
244
245
246
247
        if (column == null) {
            throw new IllegalArgumentException("Column cannot be null");
        }

        InterceptableDataContext interceptable = Interceptors.intercept(dc);
        DataContext delegate = interceptable.getDelegate();

        boolean interceptDataSets = true;

        if (delegate instanceof HasReadTypeConverters) {
            // some DataContexts implement the HasTypeConverters interface,
View Full Code Here
32
33
34
35
36
37
38
39
40
41
42
43
44
45
        final DataContextFactoryBean factoryBean = new DataContextFactoryBean();
        factoryBean.setType("POJO");
        factoryBean.setDatabaseName("my db");
        factoryBean.setTableDefinitions("hello world (greeting VARCHAR, who VARCHAR); foo (bar INTEGER, baz DATE);");

        final DataContext dataContext = factoryBean.getObject();
        assertTrue(dataContext instanceof PojoDataContext);

        Schema schema = dataContext.getDefaultSchema();
        assertEquals("my db", schema.getName());
        assertEquals("[foo, hello world]", Arrays.toString(schema.getTableNames()));

        assertEquals(
                "[Column[name=greeting,columnNumber=0,type=VARCHAR,nullable=true,nativeType=null,columnSize=null], "
View Full Code Here
27
28
29
30
31
32
33
34
    public void testUseDelegate() throws Exception {
        DataContextFactoryBean bean = new DataContextFactoryBean();
        bean.setUsername("foo");
        bean.setType("org.apache.metamodel.spring.MockDataContextFactoryBeanDelegate");
       
        DataContext obj = bean.getObject();
        assertEquals("org.apache.metamodel.pojo.PojoDataContext", obj.getClass().getName());
    }
View Full Code Here
129
130
131
132
133
134
135
136
137
138
139
140
        assertTrue(dataSet.next());
        assertFalse(dataSet.next());
    }

    public void testGetSchemaNormalTableTypes() throws Exception {
        DataContext dc = new JdbcDataContext(_connection, new TableType[] { TableType.TABLE, TableType.VIEW }, null);
        Schema[] schemas = dc.getSchemas();

        assertEquals(11, schemas.length);
        assertEquals("Schema[name=APP]", schemas[0].toString());
        assertEquals(13, schemas[0].getTableCount());
        assertEquals("Schema[name=NULLID]", schemas[1].toString());
View Full Code Here
158
159
160
161
162
163
164
165
166
167
168
169
170
        assertEquals("Schema[name=SYSSTAT]", schemas[10].toString());
        assertEquals(0, schemas[10].getTableCount());
    }

    public void testGetSchemaAllTableTypes() throws Exception {
        DataContext dc = new JdbcDataContext(_connection,
                new TableType[] { TableType.OTHER, TableType.GLOBAL_TEMPORARY }, null);
        Schema[] schemas = dc.getSchemas();

        assertEquals(11, schemas.length);
        assertEquals("Schema[name=APP]", schemas[0].toString());
        assertEquals(13, schemas[0].getTableCount());
        assertEquals("[Table[name=CUSTOMERS,type=TABLE,remarks=], "
View Full Code Here
57
58
59
60
61
62
63
64
65
66
67
68
69
        TableDataProvider<?> provider1 = new ObjectTableDataProvider<Person>("persons", Person.class, persons);
        TableDataProvider<?> provider2 = new MapTableDataProvider(new SimpleTableDef("titles", new String[] { "name",
                "title" }), titles);

        DataContext dc = new PojoDataContext(Arrays.<TableDataProvider<?>> asList(provider1, provider2));

        DataSet dataSet = dc.query().from("persons").innerJoin("titles").on("name", "name").selectAll().execute();

        assertEquals("[persons.age, persons.name, titles.name, titles.title]",
                Arrays.toString(dataSet.getSelectItems()));
        assertTrue(dataSet.next());
        assertEquals("Row[values=[42, Elvis Presley, Elvis Presley, The King]]", dataSet.getRow().toString());
View Full Code Here
55
56
57
58
59
60
61
62
63
64
65
66
    private final CsvConfiguration semicolonConfiguration = new CsvConfiguration(
            CsvConfiguration.DEFAULT_COLUMN_NAME_LINE, "UTF-8", ';', '\'', CsvConfiguration.DEFAULT_ESCAPE_CHAR);

    public void testEmptyFile() throws Exception {
        DataContext dc = new CsvDataContext(new File("src/test/resources/empty_file.csv"));
        assertEquals(1, dc.getDefaultSchema().getTableCount());

        Table table = dc.getDefaultSchema().getTables()[0];
        assertEquals("empty_file.csv", table.getName());
        assertEquals(0, table.getColumnCount());
    }
View Full Code Here
88
89
90
91
92
93
94
95
96
                .readFileAsString(targetFile).replaceAll("\n", "!LINEBREAK!"));
    }

    public void testHandlingOfEmptyLinesMultipleLinesSupport() throws Exception {
        // test with multiline values
        DataContext dc = new CsvDataContext(new File("src/test/resources/csv_with_empty_lines.csv"),
                new CsvConfiguration(1, false, true));
        testHandlingOfEmptyLines(dc);
    }
View Full Code Here
TOP

Related Classes of org.apache.metamodel.DataContext

  • org.apache.metamodel.convert.ConvertedDataSetInterceptorTest
  • org.apache.metamodel.convert.Converters
  • org.apache.metamodel.csv.CsvBigFileMemoryTest
  • org.apache.metamodel.csv.CsvDataContextTest
  • org.apache.metamodel.excel.ExcelDataContextTest
  • org.apache.metamodel.fixedwidth.FixedWidthDataContextTest
  • org.apache.metamodel.intercept.InterceptableDataContextTest
  • org.apache.metamodel.intercept.InterceptorListTest
  • org.apache.metamodel.jdbc.DerbyTest
  • org.apache.metamodel.jdbc.FilteredDataSetTest
    • 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.