Examples of DataSetTableModel

org.apache.metamodel.data.DataSetTableModel
{@link TableModel} implementation which wraps a {@link DataSet} and presents its data. @author Kasper Sørensen @since 3.0
org.jboss.dashboard.displayer.table.DataSetTableModel
Table model which feeds from a data set.

Examples of org.apache.metamodel.data.DataSetTableModel

        "SELECT \"EMPLOYEES\".\"EMAIL\" AS e-mail, \"DEPARTMENTS\".\"DEPARTMENT_NAME\" FROM HR.\"EMPLOYEES\" INNER JOIN HR.\"DEPARTMENTS\" ON \"EMPLOYEES\".\"EMPLOYEE_ID\" = \"DEPARTMENTS\".\"MANAGER_ID\"",
        q.toString());


    DataSet data = _dataContext.executeQuery(q);
    assertNotNull(data);
    TableModel tableModel = new DataSetTableModel(data);
    assertEquals(2, tableModel.getColumnCount());
    assertEquals(11, tableModel.getRowCount());
    assertEquals("JWHALEN", tableModel.getValueAt(0, 0).toString());
    assertEquals("Administration", tableModel.getValueAt(0, 1).toString());
  }

View Full Code Here

Examples of org.apache.metamodel.data.DataSetTableModel

    Query q = new Query().select(table.getColumns()).from(table, "p");
    assertEquals(
        "SELECT p.id, p.project, p.name FROM xml_input_eobjects.xml.projects_project p",
        q.toString());
    DataSet data = dc.executeQuery(q);
    TableModel tableModel = new DataSetTableModel(data);
    assertEquals(3, tableModel.getColumnCount());
    assertEquals(2, tableModel.getRowCount());


    // ID
    assertEquals(1, tableModel.getValueAt(0, 0));
    assertEquals(2, tableModel.getValueAt(1, 0));


    // Project (text content)
    assertEquals("Some description", tableModel.getValueAt(0, 1));
    assertNull(tableModel.getValueAt(1, 1));


    // Name
    assertEquals("datacleaner", tableModel.getValueAt(0, 2));
    assertEquals("MetaModel", tableModel.getValueAt(1, 2));


    // Make a new query that joins the normalized tables together
    table = schema.getTableByName("contributors_person_address");
    Relationship relationShip = table.getRelationships()[0];
    q = new Query().select(relationShip.getPrimaryTable().getColumns())
        .select(relationShip.getForeignTable().getColumns())
        .from(new FromItem(JoinType.INNER, relationShip));


    assertEquals(
        "SELECT contributors_person.id, contributors_person_address.id, "
            + "contributors_person_address.contributors_person_id, contributors_person_address.address "
            + "FROM xml_input_eobjects.xml.contributors_person INNER JOIN xml_input_eobjects.xml.contributors_person_address "
            + "ON contributors_person.id = contributors_person_address.contributors_person_id",
        q.toString());


    data = dc.executeQuery(q);
    tableModel = new DataSetTableModel(data);
    assertEquals(4, tableModel.getColumnCount());
    assertEquals(4, tableModel.getRowCount());


    assertEquals("1", tableModel.getValueAt(0, 0).toString());
    assertEquals("1", tableModel.getValueAt(0, 1).toString());
    assertEquals("1", tableModel.getValueAt(0, 2).toString());
    assertEquals("My address", tableModel.getValueAt(0, 3).toString());


    assertEquals("1", tableModel.getValueAt(1, 0).toString());
    assertEquals("2", tableModel.getValueAt(1, 1).toString());
    assertEquals("1", tableModel.getValueAt(1, 2).toString());
    assertEquals("Another address", tableModel.getValueAt(1, 3).toString());


    assertEquals("1", tableModel.getValueAt(2, 0).toString());
    assertEquals("3", tableModel.getValueAt(2, 1).toString());
    assertEquals("1", tableModel.getValueAt(2, 2).toString());
    assertEquals("A third address", tableModel.getValueAt(2, 3).toString());


    assertEquals("2", tableModel.getValueAt(3, 0).toString());
    assertEquals("4", tableModel.getValueAt(3, 1).toString());
    assertEquals("2", tableModel.getValueAt(3, 2).toString());
    assertEquals("Asbjorns address", tableModel.getValueAt(3, 3).toString());
  }

View Full Code Here

Examples of org.apache.metamodel.data.DataSetTableModel


        Schema schema = dc.getDefaultSchema();
        Query q = new Query();
        q.from(schema.getTableByName("CUSTOMERS")).select(new SelectItem("COUNT(*)", null));
        DataSet data = dc.executeQuery(q);
        TableModel tableModel = new DataSetTableModel(data);
        assertEquals(1, tableModel.getRowCount());
        assertEquals(1, tableModel.getColumnCount());
        assertEquals(122, tableModel.getValueAt(0, 0));


        EasyMock.verify(ds);


        String assertionFailMsg = "Expected 5x true: " + con1.isClosed() + "," + con2.isClosed() + ","
                + con3.isClosed() + "," + con4.isClosed() + "," + con5.isClosed();

View Full Code Here

Examples of org.apache.metamodel.data.DataSetTableModel

            public String rewriteQuery(Query query) {
                return "SELECT COUNT(*) FROM PUBLIC.CUSTOMERS";
            }
        };
        dc = dc.setQueryRewriter(rewriter);
        TableModel tm = new DataSetTableModel(dc.executeQuery(new Query().selectCount()));
        assertEquals(1, tm.getRowCount());
        assertEquals(1, tm.getColumnCount());
        assertEquals("122", tm.getValueAt(0, 0).toString());
    }

View Full Code Here

Examples of org.apache.metamodel.data.DataSetTableModel

        assertTrue(data1.next());
        assertEquals("Row[values=[Australia, 430300.0]]", data1.getRow().toString());
        DataSet data2 = dataContext2.executeQuery(q);
        assertTrue(data2.next());
        assertEquals("Row[values=[Australia, 430300.0]]", data2.getRow().toString());
        assertEquals(new DataSetTableModel(data1), new DataSetTableModel(data2));
    }

View Full Code Here

Examples of org.apache.metamodel.data.DataSetTableModel

        Column productPriceColumn = productsTable.getColumnByName("price");
        q.select(titleColumn, productPriceColumn);
        q.getSelectClause().getItem(0).setAlias("product-title");


        DataSet data = dc.executeQuery(q);
        TableModel tableModel = new DataSetTableModel(data);
        assertEquals(2, tableModel.getColumnCount());
        assertEquals(10000, tableModel.getRowCount());


        assertEquals("ACADEMY ACADEMY", tableModel.getValueAt(0, 0).toString());
        assertEquals("25.99", tableModel.getValueAt(0, 1).toString());


        assertEquals("ACADEMY HORN", tableModel.getValueAt(432, 0).toString());
        assertEquals("16.99", tableModel.getValueAt(6346, 1).toString());


        assertEquals("ALADDIN ZORRO", tableModel.getValueAt(9999, 0).toString());
        assertEquals("10.99", tableModel.getValueAt(9999, 1).toString());


        data = null;
        tableModel = null;


        Column prodIdColumn = productsTable.getColumnByName("prod_id");
        Table orderlinesTable = schema.getTableByName("orderlines");
        Column commonProdIdColumn = orderlinesTable.getColumnByName("prod_id");
        Column quantityColumn = orderlinesTable.getColumnByName("quantity");


        q.from(orderlinesTable);
        q.where(new FilterItem(new SelectItem(prodIdColumn), OperatorType.EQUALS_TO, new SelectItem(commonProdIdColumn)));
        q.groupBy(titleColumn);
        q.getSelectClause().removeItem(q.getSelectClause().getSelectItem(productPriceColumn));
        SelectItem quantitySum = new SelectItem(FunctionType.SUM, quantityColumn).setAlias("orderAmount");
        q.select(quantitySum);
        q.having(new FilterItem(quantitySum, OperatorType.GREATER_THAN, 25));
        q.orderBy(new OrderByItem(q.getSelectClause().getItem(0)));


        assertEquals("SELECT \"products\".\"title\" AS product-title, SUM(\"orderlines\".\"quantity\") AS orderAmount "
                + "FROM public.\"products\", public.\"orderlines\" "
                + "WHERE \"products\".\"prod_id\" = \"orderlines\".\"prod_id\" " + "GROUP BY \"products\".\"title\" "
                + "HAVING SUM(\"orderlines\".\"quantity\") > 25 " + "ORDER BY \"products\".\"title\" ASC", q.toString());
        data = dc.executeQuery(q);
        tableModel = new DataSetTableModel(data);
        assertEquals(2, tableModel.getColumnCount());
        assertEquals(136, tableModel.getRowCount());


        assertEquals("ACADEMY ALABAMA", tableModel.getValueAt(0, 0).toString());
        assertEquals("27", tableModel.getValueAt(0, 1).toString());


        assertEquals("AIRPORT MOURNING", tableModel.getValueAt(99, 0).toString());
        assertEquals("29", tableModel.getValueAt(99, 1).toString());


        assertEquals("ALADDIN WORKER", tableModel.getValueAt(135, 0).toString());
        assertEquals("27", tableModel.getValueAt(135, 1).toString());
    }

View Full Code Here

Examples of org.apache.metamodel.data.DataSetTableModel

        assertEquals(2.0, tableModel.getValueAt(2, 0));


        q = dc.query().from(table2).select("name").orderBy("name").toQuery();
        q.getSelectClause().setDistinct(true);


        tableModel = new DataSetTableModel(dc.executeQuery(q));
        assertEquals(3, tableModel.getRowCount());
        assertEquals(1, tableModel.getColumnCount());
        assertEquals("advisor", tableModel.getValueAt(0, 0));
        assertEquals("developer", tableModel.getValueAt(1, 0));
        assertEquals("founder", tableModel.getValueAt(2, 0));

View Full Code Here

Examples of org.apache.metamodel.data.DataSetTableModel


        DataContext dc = getDataContext();
        DataSet data = dc.executeQuery(q);
        assertEquals(1, data.getSelectItems().length);
        assertEquals("r.name", data.getSelectItems()[0].toString());
        TableModel tableModel = new DataSetTableModel(data);
        assertEquals(3, tableModel.getRowCount());


        q.select(new SelectItem(FunctionType.COUNT, "*", "c"));
        q.where(new FilterItem(new SelectItem(roleColumn), OperatorType.EQUALS_TO, "founder"));
        data = dc.executeQuery(q);
        assertEquals(2, data.getSelectItems().length);
        assertEquals("r.name", data.getSelectItems()[0].toString());
        assertEquals("COUNT(*) AS c", data.getSelectItems()[1].toString());
        tableModel = new DataSetTableModel(data);
        assertEquals(1, tableModel.getRowCount());
        assertEquals("founder", tableModel.getValueAt(0, 0));
        assertEquals(2l, tableModel.getValueAt(0, 1));


        q.select(new SelectItem(FunctionType.SUM, table2.getColumns()[0]));
        assertEquals(
                "SELECT r.name, COUNT(*) AS c, SUM(r.contributor_id) FROM MetaModelSchema.role r WHERE r.name = 'founder' GROUP BY r.name",
                q.toString());
        data = dc.executeQuery(q);
        assertEquals(3, data.getSelectItems().length);
        assertEquals("r.name", data.getSelectItems()[0].toString());
        assertEquals("COUNT(*) AS c", data.getSelectItems()[1].toString());
        assertEquals("SUM(r.contributor_id)", data.getSelectItems()[2].toString());
        tableModel = new DataSetTableModel(data);
        assertEquals(1, tableModel.getRowCount());
        assertEquals("founder", tableModel.getValueAt(0, 0));
        assertEquals(2l, tableModel.getValueAt(0, 1));
        assertEquals(7.0, tableModel.getValueAt(0, 2));
    }

View Full Code Here

Examples of org.apache.metamodel.data.DataSetTableModel

        q.toString());


    DataSet data = _dataContext.executeQuery(q);
    assertNotNull(data);


    TableModel tableModel = new DataSetTableModel(data);
    assertEquals(2, tableModel.getColumnCount());
    assertEquals(17, tableModel.getRowCount());
    assertEquals("Quality Assurance", tableModel.getValueAt(4, 0).toString());


    Date date = (Date) tableModel.getValueAt(4, 1);
    assertEquals("1989-04-17 00:00:00.000000", new SimpleDateFormat("yyyy-MM-dd HH:mm:ss.SSSSSS").format(date));


  }

View Full Code Here

Examples of org.apache.metamodel.data.DataSetTableModel

        "SELECT \"EMPLOYEES\".\"EMAIL\" AS e-mail, \"DEPARTMENTS\".\"DEPARTMENT_NAME\" FROM HR.\"EMPLOYEES\" INNER JOIN HR.\"DEPARTMENTS\" ON \"EMPLOYEES\".\"EMPLOYEE_ID\" = \"DEPARTMENTS\".\"MANAGER_ID\"",
        q.toString());


    DataSet data = _dataContext.executeQuery(q);
    assertNotNull(data);
    TableModel tableModel = new DataSetTableModel(data);
    assertEquals(2, tableModel.getColumnCount());
    assertEquals(11, tableModel.getRowCount());
    assertEquals("JWHALEN", tableModel.getValueAt(0, 0).toString());
    assertEquals("Administration", tableModel.getValueAt(0, 1).toString());
  }

View Full Code Here

0 1 2 3

TOP

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.