Examples of org.apache.metamodel.DataContext

org.apache.metamodel.DataContext
A DataContext represents the central entry point for interactions with datastores. The DataContext contains of the structure of data (in the form of schemas) and interactions (in the form of queries) with data. @author Kasper Sørensen

    assertEquals(1, ds.toObjectArrays().size());
  }


  public void testInterceptQuery() throws Exception {


    DataContext dc = new InterceptableDataContext(delegateDataContext)
        .addQueryInterceptor(new QueryInterceptor() {
          @Override
          public Query intercept(Query input) {
            return input.select(table.getColumnByName("foo"));
          }
        }).addQueryInterceptor(new QueryInterceptor() {
          @Override
          public Query intercept(Query input) {
            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


        assertSame(file, dc.getFile());
    }


    public void testEmptyFileNoHeaderLine() throws Exception {
        DataContext dc = new ExcelDataContext(new File("src/test/resources/empty_file.xls"), new ExcelConfiguration(
                ExcelConfiguration.NO_COLUMN_NAME_LINE, false, false));
        assertEquals(1, dc.getDefaultSchema().getTableCount());


        Table table = dc.getDefaultSchema().getTables()[0];
        assertEquals("sheet", table.getName());
        assertEquals(0, table.getColumnCount());
    }

View Full Code Here

        assertEquals("sheet", table.getName());
        assertEquals(0, table.getColumnCount());
    }


    public void testUnexistingHeaderLine() throws Exception {
        DataContext dc = new ExcelDataContext(new File("src/test/resources/xls_people.xls"), new ExcelConfiguration(20,
                true, false));
        assertEquals(1, dc.getDefaultSchema().getTableCount());


        Table table = dc.getDefaultSchema().getTables()[0];
        assertEquals("xls_people", table.getName());
        assertEquals(0, table.getColumnCount());
    }

View Full Code Here

        assertEquals("[bar, 4, 2010-01-04 00:00:00]", Arrays.toString(objectArrays.get(3)));
    }


    public void testConfigurationWithoutHeader() throws Exception {
        File file = new File("src/test/resources/xls_people.xls");
        DataContext dc = new ExcelDataContext(file, new ExcelConfiguration(ExcelConfiguration.NO_COLUMN_NAME_LINE,
                true, true));
        Table table = dc.getDefaultSchema().getTables()[0];


        String[] columnNames = table.getColumnNames();
        assertEquals("[A, B, C, D]", Arrays.toString(columnNames));


        Query q = dc.query().from(table).select(table.getColumnByName("A")).toQuery();
        assertEquals("SELECT xls_people.A FROM xls_people.xls.xls_people", q.toSql());


        DataSet dataSet = dc.executeQuery(q);
        assertTrue(dataSet.next());
        assertEquals("id", dataSet.getRow().getValue(0));
        for (int i = 1; i <= 9; i++) {
            assertTrue(dataSet.next());
            assertEquals(i + "", dataSet.getRow().getValue(0));

View Full Code Here

        assertFalse(dataSet.next());
    }


    public void testConfigurationNonDefaultColumnNameLineNumber() throws Exception {
        File file = new File("src/test/resources/xls_people.xls");
        DataContext dc = new ExcelDataContext(file, new ExcelConfiguration(2, true, true));
        Table table = dc.getDefaultSchema().getTables()[0];


        String[] columnNames = table.getColumnNames();
        assertEquals("[1, mike, male, 18]", Arrays.toString(columnNames));


        Query q = dc.query().from(table).select(table.getColumnByName("1")).toQuery();
        assertEquals("SELECT xls_people.1 FROM xls_people.xls.xls_people", q.toSql());


        DataSet dataSet = dc.executeQuery(q);
        assertTrue(dataSet.next());
        assertEquals("2", dataSet.getRow().getValue(0));
        for (int i = 3; i <= 9; i++) {
            assertTrue(dataSet.next());
            assertEquals(i + "", dataSet.getRow().getValue(0));

View Full Code Here

        assertFalse(dataSet.next());
    }


    public void testGetSchemas() throws Exception {
        File file = new File("src/test/resources/xls_people.xls");
        DataContext dc = new ExcelDataContext(file);
        Schema[] schemas = dc.getSchemas();
        assertEquals(2, schemas.length);
        Schema schema = schemas[1];
        assertEquals("xls_people.xls", schema.getName());
        assertEquals(1, schema.getTableCount());
        Table table = schema.getTables()[0];

View Full Code Here

        assertNull(dataSet.getRow());
    }


    public void testMissingValues() throws Exception {
        File file = new File("src/test/resources/xls_missing_values.xls");
        DataContext dc = new ExcelDataContext(file);
        Schema schema = dc.getDefaultSchema();
        assertEquals(1, schema.getTableCount());


        Table table = schema.getTables()[0];
        assertEquals("[Column[name=a,columnNumber=0,type=VARCHAR,nullable=true,nativeType=null,columnSize=null], "
                + "Column[name=b,columnNumber=1,type=VARCHAR,nullable=true,nativeType=null,columnSize=null], "
                + "Column[name=c,columnNumber=2,type=VARCHAR,nullable=true,nativeType=null,columnSize=null], "
                + "Column[name=d,columnNumber=3,type=VARCHAR,nullable=true,nativeType=null,columnSize=null]]",
                Arrays.toString(table.getColumns()));


        Query q = new Query().select(table.getColumns()).from(table);
        DataSet ds = dc.executeQuery(q);
        assertTrue(ds.next());
        assertEquals("[1, 2, 3, null]", Arrays.toString(ds.getRow().getValues()));
        assertTrue(ds.next());
        assertEquals("[5, null, 7, 8]", Arrays.toString(ds.getRow().getValues()));
        assertTrue(ds.next());

View Full Code Here

        assertFalse(ds.next());
    }


    public void testMissingColumnHeader() throws Exception {
        File file = new File("src/test/resources/xls_missing_column_header.xls");
        DataContext dc = new ExcelDataContext(file);
        Schema schema = dc.getDefaultSchema();
        assertEquals(1, schema.getTableCount());


        Table table = schema.getTables()[0];
        assertEquals("[Column[name=a,columnNumber=0,type=VARCHAR,nullable=true,nativeType=null,columnSize=null], "
                + "Column[name=b,columnNumber=1,type=VARCHAR,nullable=true,nativeType=null,columnSize=null], "
                + "Column[name=[Column 3],columnNumber=2,type=VARCHAR,nullable=true,nativeType=null,columnSize=null], "
                + "Column[name=d,columnNumber=3,type=VARCHAR,nullable=true,nativeType=null,columnSize=null]]",
                Arrays.toString(table.getColumns()));


        Query q = new Query().select(table.getColumns()).from(table);
        DataSet ds = dc.executeQuery(q);
        assertTrue(ds.next());
        assertEquals("[1, 2, 3, 4]", Arrays.toString(ds.getRow().getValues()));
        assertTrue(ds.next());
        assertEquals("[5, 6, 7, 8]", Arrays.toString(ds.getRow().getValues()));
        assertTrue(ds.next());

View Full Code Here

        assertFalse(ds.next());
    }


    public void testTicket99defect() throws Exception {
        File file = new File("src/test/resources/ticket_199_inventory.xls");
        DataContext dc = new ExcelDataContext(file);
        Schema schema = dc.getDefaultSchema();
        assertEquals(
                "[Table[name=Sheet1,type=null,remarks=null], Table[name=Sheet2,type=null,remarks=null], Table[name=Sheet3,type=null,remarks=null]]",
                Arrays.toString(schema.getTables()));


        assertEquals(0, schema.getTableByName("Sheet2").getColumnCount());

View Full Code Here


        assertEquals(1, dc.getDefaultSchema().getTableCount());
    }


    public void testGetStyles() throws Exception {
        DataContext dc = new ExcelDataContext(new File("src/test/resources/styles.xlsx"));
        Table table = dc.getDefaultSchema().getTables()[0];
        assertEquals("[style name, example]", Arrays.toString(table.getColumnNames()));


        DataSet ds = dc.query().from(table).select(table.getColumns()).execute();
        assertTrue(ds.next());
        assertEquals("Row[values=[bold, foo]]", ds.getRow().toString());
        assertEquals("", ds.getRow().getStyle(0).toCSS());
        assertEquals("font-weight: bold;", ds.getRow().getStyle(1).toCSS());

View Full Code Here

0 1 2 3 4 5 6 7 8 9

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

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.