Examples of org.gdbms.engine.data.DataSource.start()

org.gdbms.engine.data.DataSource.start()
Opens the DataSource to access the data it contains. If the data is accessed without a previous opening a ClosedDataSourceException is thrown. If this method is invoked twice then only the second call to stop will close the DataSource.
If the DataSource was obtained with an AUTOMATIC_OPENING mode, there's no need to open the DataSource. Indeed start calls are ignored. It's possible to close the DataSource by a single call to the close method @throws DriverException if the operation fails

    }
    
    public void testBetweenClause() throws Exception {
        DataSource d = ds.executeSQL(
                "select * from persona where id between 0 and 2;");
        d.start();
        Value v0 = ValueFactory.createValue(1);
        Value v1 = ValueFactory.createValue("huracan");
        Value v2 = ValueFactory.createValue("gonsales");
        assertTrue(d.getRowCount() == 1);
        assertTrue(((BooleanValue) d.getFieldValue(0, 0).equals(v0)).getValue());

View Full Code Here

        assertTrue(((BooleanValue) d.getFieldValue(0, 1).equals(v1)).getValue());
        assertTrue(((BooleanValue) d.getFieldValue(0, 2).equals(v2)).getValue());
        d.stop();


        d = ds.executeSQL("select * from persona where id not between 0 and 2;");
        d.start();
        v0 = ValueFactory.createValue(0);
        v1 = ValueFactory.createValue("fernando");
        v2 = ValueFactory.createValue("gonzalez");
        Value v3 = ValueFactory.createValue(2);
        Value v4 = ValueFactory.createValue("fernan");

View Full Code Here

    
    public void testInClause() throws Exception {
        DataSource d = ds.executeSQL(
                "select * from persona where id in (0, 2);");
        
        d.start();
        Value v0 = ValueFactory.createValue(0);
        Value v1 = ValueFactory.createValue("fernando");
        Value v2 = ValueFactory.createValue("gonzalez");
        Value v3 = ValueFactory.createValue(2);
        Value v4 = ValueFactory.createValue("fernan");

View Full Code Here

        d.stop();
        
        d = ds.executeSQL(
                "select * from persona where id not in (0, 2);");
        
        d.start();
        v0 = ValueFactory.createValue(1);
        v1 = ValueFactory.createValue("huracan");
        v2 = ValueFactory.createValue("gonsales");
        assertTrue(d.getRowCount() == 1);
        assertTrue(((BooleanValue) d.getFieldValue(0, 0).equals(v0)).getValue());

View Full Code Here

    
    public void testAggregate() throws Exception {
        DataSource d = ds.executeSQL(
                "select count(id) from persona where id < 2;");
        
        d.start();
        assertTrue(d.getRowCount() == 1);
        assertTrue(((BooleanValue)d.getFieldValue(0, 0).equals(ValueFactory.createValue(2))).getValue());
        d.stop();
        
        d = ds.executeSQL(

View Full Code Here

        d.stop();
        
        d = ds.executeSQL(
                "select count(id) from persona;");
        
        d.start();
        assertTrue(d.getRowCount() == 1);
        assertTrue(((BooleanValue)d.getFieldValue(0, 0).equals(ValueFactory.createValue(3))).getValue());
        d.stop();
    }

View Full Code Here

    
    public void testTwoTimesTheSameAggregate() throws Exception {
        DataSource d = ds.executeSQL(
                "select count(id), count(id), sum(id) from persona where id > 0;");
        
        d.start();
        assertTrue(d.getRowCount() == 1);
        assertTrue(((BooleanValue)d.getFieldValue(0, 0).equals(ValueFactory.createValue(2))).getValue());
        assertTrue(((BooleanValue)d.getFieldValue(0, 1).equals(ValueFactory.createValue(2))).getValue());
        assertTrue(((BooleanValue)d.getFieldValue(0, 2).equals(ValueFactory.createValue(3))).getValue());
        d.stop();

View Full Code Here

        d.stop();
        
        d = ds.executeSQL(
                "select count(id), count(id), sum(id) from persona;");
        
        d.start();
        assertTrue(d.getRowCount() == 1);
        assertTrue(((BooleanValue)d.getFieldValue(0, 0).equals(ValueFactory.createValue(3))).getValue());
        assertTrue(((BooleanValue)d.getFieldValue(0, 1).equals(ValueFactory.createValue(3))).getValue());
        assertTrue(((BooleanValue)d.getFieldValue(0, 2).equals(ValueFactory.createValue(3))).getValue());
        d.stop();

View Full Code Here

    
    public void testDistinct() throws Exception {
        DataSource d = ds.executeSQL(
                "select distinct id1 from sort ;");
        
        d.start();
        assertTrue(d.getRowCount() == 2);
        assertTrue(((BooleanValue)d.getFieldValue(0, 0).equals(ValueFactory.createValue(0))).getValue());
        assertTrue(((BooleanValue)d.getFieldValue(1, 0).equals(ValueFactory.createValue(2))).getValue());
        d.stop();
    }

View Full Code Here

    
    public void testDistinctManyFields() throws Exception {
        DataSource d = ds.executeSQL(
                "select distinct id1, id2 from sort ;");
        
        d.start();
        assertTrue(d.getRowCount() == 4);
        assertTrue(((BooleanValue)d.getFieldValue(0, 0).equals(ValueFactory.createValue(0))).getValue());
        assertTrue(((BooleanValue)d.getFieldValue(0, 1).equals(ValueFactory.createValue(1))).getValue());
        assertTrue(((BooleanValue)d.getFieldValue(1, 0).equals(ValueFactory.createValue(0))).getValue());
        assertTrue(((BooleanValue)d.getFieldValue(1, 1).equals(ValueFactory.createValue(3))).getValue());

View Full Code Here

0 1 2 3 4 5

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.