Examples of org.apache.ddlutils.platform.ModelBasedResultSetIterator

            "  <TestTable TheId='1' TheText='Text 1'/>\n"+
            "  <TestTable TheId='2' TheText='Text 2'/>\n"+
            "  <TestTable TheId='3' TheText='Text 3'/>"+
            "</data>");


        ModelBasedResultSetIterator it = (ModelBasedResultSetIterator)getPlatform().query(getModel(),
                                                                                          "SELECT * FROM TestTable",
                                                                                          new Table[] { getModel().getTable(0) });


        assertTrue(it.hasNext());
        // we call the method a second time to assert that the result set does not get advanced twice
        assertTrue(it.hasNext());


        DynaBean bean = (DynaBean)it.next();


        assertEquals(new Integer(1),
                     getPropertyValue(bean, "TheId"));
        assertEquals("Text 1",
                     getPropertyValue(bean, "TheText"));
        
        assertTrue(it.hasNext());


        bean = (DynaBean)it.next();


        assertEquals(new Integer(2),
                     getPropertyValue(bean, "TheId"));
        assertEquals("Text 2",
                     getPropertyValue(bean, "TheText"));


        assertTrue(it.hasNext());


        bean = (DynaBean)it.next();


        assertEquals(new Integer(3),
                     getPropertyValue(bean, "TheId"));
        assertEquals("Text 3",
                     getPropertyValue(bean, "TheText"));


        assertFalse(it.hasNext());
        assertFalse(it.isConnectionOpen());
    }

            "  <TestTable2 Id='1' Avalue='Text 1'/>\n"+
            "  <TestTable2 Id='2' Avalue='Text 2'/>\n"+
            "  <TestTable2 Id='3' Avalue='Text 3'/>"+
            "</data>");


        ModelBasedResultSetIterator it = (ModelBasedResultSetIterator)getPlatform().query(getModel(),
                                                                                          "SELECT Id1, Avalue FROM TestTable1, TestTable2 WHERE Id2 = Id",
                                                                                          new Table[] { getModel().getTable(0), getModel().getTable(1) });


        assertTrue(it.hasNext());


        DynaBean bean = (DynaBean)it.next();


        assertEquals(new Integer(2),
                     getPropertyValue(bean, "Id1"));
        assertEquals("Text 3",
                     getPropertyValue(bean, "Avalue"));


        assertFalse(it.hasNext());
        assertFalse(it.isConnectionOpen());
    }

Examples of org.apache.ddlutils.platform.ModelBasedResultSetIterator

Related Classes of org.apache.ddlutils.platform.ModelBasedResultSetIterator