Examples of org.apache.metamodel.schema.Table

org.apache.metamodel.schema.Table
Represents a table and it's metadata description. Tables reside within a schema and contains columns and relationships to other tables. @see Schema @see Column @author Kasper Sørensen

        assertEquals("1", ds.getRow().getValue(0));
    }


    public void testInvalidFormula() throws Exception {
        ExcelDataContext dc = new ExcelDataContext(new File("src/test/resources/invalid_formula.xls"));
        Table table = dc.getDefaultSchema().getTables()[0];


        assertEquals("[name]", Arrays.toString(table.getColumnNames()));


        Query q = dc.query().from(table).select("name").toQuery();


        DataSet ds = dc.executeQuery(dc.query().from(table).selectCount().toQuery());
        assertTrue(ds.next());

View Full Code Here

    }


    public void testEvaluateFormula() throws Exception {
        ExcelDataContext dc = new ExcelDataContext(new File("src/test/resources/xls_formulas.xls"));


        Table table = dc.getDefaultSchema().getTables()[0];
        Column[] columns = table.getColumns();


        assertEquals("[some number, some mixed formula, some int only formula]",
                Arrays.toString(table.getColumnNames()));


        Query q = dc.query().from(table).select(columns).toQuery();
        DataSet ds = dc.executeQuery(q);
        Object value;

View Full Code Here

    }


    public void testSingleCellSheet() throws Exception {
        ExcelDataContext dc = new ExcelDataContext(new File("src/test/resources/xls_single_cell_sheet.xls"));


        Table table = dc.getDefaultSchema().getTableByName("Sheet1");


        assertNotNull(table);


        assertEquals("[[Column 1], hello]", Arrays.toString(table.getColumnNames()));


        Query q = dc.query().from(table).select(table.getColumns()).toQuery();
        DataSet ds = dc.executeQuery(q);
        assertFalse(ds.next());
    }

View Full Code Here

        assertEquals("[Sheet1, Sheet2, Sheet3]", Arrays.toString(schema.getTableNames()));


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


        Table table = schema.getTableByName("Sheet1");


        assertEquals("[string, number, date]", Arrays.toString(table.getColumnNames()));


        Query q = dc.query().from(table).select(table.getColumns()).orderBy(table.getColumnByName("number")).toQuery();
        DataSet ds = dc.executeQuery(q);
        List<Object[]> objectArrays = ds.toObjectArrays();
        assertEquals(4, objectArrays.size());
        assertEquals("[hello, 1, 2010-01-01 00:00:00]", Arrays.toString(objectArrays.get(0)));
        assertEquals("[world, 2, 2010-01-02 00:00:00]", Arrays.toString(objectArrays.get(1)));

View Full Code Here


    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));

View Full Code Here

    }


    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));

View Full Code Here

        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];
        assertEquals("xls_people", table.getName());


        assertEquals(4, table.getColumnCount());
        assertEquals(0, table.getRelationshipCount());


        Column[] columns = table.getColumns();
        assertEquals("id", columns[0].getName());
        assertEquals("name", columns[1].getName());
        assertEquals("gender", columns[2].getName());
        assertEquals("age", columns[3].getName());
    }

View Full Code Here

    }


    public void testMaterializeTable() throws Exception {
        File file = new File("src/test/resources/xls_people.xls");
        ExcelDataContext dc = new ExcelDataContext(file);
        Table table = dc.getDefaultSchema().getTables()[0];
        DataSet dataSet = dc.materializeMainSchemaTable(table, table.getColumns(), -1);
        assertTrue(dataSet.next());
        assertEquals("Row[values=[1, mike, male, 18]]", dataSet.getRow().toString());
        assertTrue(dataSet.next());
        assertEquals("Row[values=[2, michael, male, 19]]", dataSet.getRow().toString());
        assertTrue(dataSet.next());

View Full Code Here

        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()));

View Full Code Here

        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()));

View Full Code Here

0 1 2 3 4 5 6 7 8 9

TOP

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

org.apache.metamodel.AbstractDataContext

org.apache.metamodel.AbstractDataContextTest

org.apache.metamodel.AbstractUpdateCallback

org.apache.metamodel.CompositeDataContext

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.CouchDbInsertionBuilder

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.