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

        ExcelDataContext dc = new ExcelDataContext(file);


        assertEquals("[sh1]", Arrays.toString(dc.getDefaultSchema().getTableNames()));
        assertEquals(XlsxSpreadsheetReaderDelegate.class, dc.getSpreadsheetReaderDelegateClass());


        Table table = dc.getDefaultSchema().getTableByName("sh1");
        assertEquals("[Foo, Bar]", Arrays.toString(table.getColumnNames()));


        Query q = dc.query().from(table).select("Foo").toQuery();
        DataSet ds = dc.executeQuery(q);


        assertTrue(ds.next());

View Full Code Here

                Arrays.toString(schema.getTables()));


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


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


                "[Column[name=Pkg No.,columnNumber=0,type=VARCHAR,nullable=true,nativeType=null,columnSize=null], "
                        + "Column[name=Description,columnNumber=1,type=VARCHAR,nullable=true,nativeType=null,columnSize=null], "
                        + "Column[name=Room,columnNumber=2,type=VARCHAR,nullable=true,nativeType=null,columnSize=null], "
                        + "Column[name=Level,columnNumber=3,type=VARCHAR,nullable=true,nativeType=null,columnSize=null]]",
                Arrays.toString(table.getColumns()));
    }

View Full Code Here

        FileHelper.copy(new File("src/test/resources/xls_people.xls"), file);


        assertTrue(file.exists());


        ExcelDataContext dc = new ExcelDataContext(file);
        final Table table = dc.getDefaultSchema().getTables()[0];
        final Column nameColumn = table.getColumnByName("name");
        dc.executeUpdate(new UpdateScript() {
            @Override
            public void run(UpdateCallback cb) {
                Style clownStyle = new StyleBuilder().bold().foreground(255, 0, 0).background(0, 0, 255).create();

View Full Code Here

        final ExcelDataContext dc = new ExcelDataContext(file);
        dc.executeUpdate(new UpdateScript() {
            @Override
            public void run(UpdateCallback cb) {
                Schema schema = dc.getDefaultSchema();
                Table table1 = cb.createTable(schema, "my_table_1").withColumn("foo").withColumn("bar")
                        .withColumn("baz").execute();


                assertEquals(1, schema.getTableCount());
                assertSame(table1.getSchema(), schema);
                assertSame(table1, schema.getTables()[0]);


                Table table2 = cb.createTable(schema, "my_table_2").withColumn("foo").withColumn("bar")
                        .withColumn("baz").execute();


                assertSame(table2.getSchema(), schema);
                assertSame(table2, schema.getTables()[1]);
                assertEquals(2, schema.getTableCount());


                cb.insertInto(table1).value("foo", 123.0).value("bar", "str 1").value("baz", true).execute();
            }

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

     */
    public void testExecuteQueryBeforeLoadingSchema() throws Exception {
        // first use one DataContext to retreive the schema/table/column objects
        ExcelDataContext dc1 = new ExcelDataContext(new File("src/test/resources/Spreadsheet2007.xlsx"));
        Schema schema = dc1.getDefaultSchema();
        Table table = schema.getTable(0);
        Column column = table.getColumn(0);


        // query another DataContext using the schemas of the one above
        ExcelDataContext dc2 = new ExcelDataContext(new File("src/test/resources/Spreadsheet2007.xlsx"));
        DataSet ds = dc2.executeQuery(new Query().from(table).select(column));

View Full Code Here

        CsvDataContext dc1 = new CsvDataContext(file, csvConfiguration);


        Table[] tables = dc1.getDefaultSchema().getTables();
        assertEquals(1, tables.length);
        
        Table table = tables[0];
        assertEquals("testEmptyFileNoColumnHeaderLine.csv", table.getName());
        assertEquals(2, table.getColumnCount());
        
        DataSet ds = dc1.query().from(table).selectAll().execute();
        assertTrue(ds.next());
        assertEquals("Row[values=[1, 2]]", ds.getRow().toString());
        assertFalse(ds.next());

View Full Code Here

        FileHelper.copy(new File("src/test/resources/empty_file.csv"), file);


        final CsvDataContext dc = new CsvDataContext(file);
        assertEquals(1, dc.getDefaultSchema().getTableCount());


        final Table table1 = dc.getDefaultSchema().getTables()[0];
        assertEquals("testEmptyFileNoColumnHeaderLine.csv", table1.getName());
        assertEquals(0, table1.getColumnCount());


        dc.executeUpdate(new UpdateScript() {
            @Override
            public void run(UpdateCallback callback) {
                callback.dropTable(dc.getDefaultSchema().getTable(0)).execute();

View Full Code Here

     * @return an array containing the tables of the provided columns.
     */
    public static Table[] getTables(Iterable<Column> columns) {
        ArrayList<Table> result = new ArrayList<Table>();
        for (Column column : columns) {
            Table table = column.getTable();
            if (!result.contains(table)) {
                result.add(table);
            }
        }
        return result.toArray(new Table[result.size()]);

View Full Code Here

      @Override
      protected Schema getSchemaByNameInternal(String name) {
        throw new UnsupportedOperationException();
      }
    };
    Table tableAB = new MutableTable("tableAB");
    Table tableC = new MutableTable("tableC");


    Column colA = new MutableColumn("colA", null, tableAB, 0, true);
    Column colB = new MutableColumn("colB", null, tableAB, 1, true);
    Column colC = new MutableColumn("colC", null, tableC, 0, true);

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.