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

        d.stop();


        d = ds.executeSQL(
                "select * from persona order by id asc;");
        
        d.start();
        assertTrue(d.getRowCount() == 3);
        assertTrue(((BooleanValue)d.getFieldValue(2, 0).equals(ValueFactory.createValue(2))).getValue());
        assertTrue(((BooleanValue)d.getFieldValue(2, 1).equals(ValueFactory.createValue("fernan"))).getValue());
        assertTrue(d.getFieldValue(2, 2) instanceof NullValue);
        assertTrue(((BooleanValue)d.getFieldValue(1, 0).equals(ValueFactory.createValue(1))).getValue());

View Full Code Here

    
    public void testOrderByDesc() throws Exception {
        DataSource d = ds.executeSQL(
                "select * from persona where id > 0 order by id desc;");
        
        d.start();
        assertTrue(d.getRowCount() == 2);
        assertTrue(((BooleanValue)d.getFieldValue(0, 0).equals(ValueFactory.createValue(2))).getValue());
        assertTrue(((BooleanValue)d.getFieldValue(0, 1).equals(ValueFactory.createValue("fernan"))).getValue());
        assertTrue(d.getFieldValue(0, 2) instanceof NullValue);
        assertTrue(((BooleanValue)d.getFieldValue(1, 0).equals(ValueFactory.createValue(1))).getValue());

View Full Code Here

        d.stop();


        d = ds.executeSQL(
                "select * from persona order by id desc;");
        
        d.start();
        assertTrue(d.getRowCount() == 3);
        assertTrue(((BooleanValue)d.getFieldValue(0, 0).equals(ValueFactory.createValue(2))).getValue());
        assertTrue(((BooleanValue)d.getFieldValue(0, 1).equals(ValueFactory.createValue("fernan"))).getValue());
        assertTrue(d.getFieldValue(0, 2) instanceof NullValue);
        assertTrue(((BooleanValue)d.getFieldValue(1, 0).equals(ValueFactory.createValue(1))).getValue());

View Full Code Here

    
    public void testOrderByWithNullValues() throws Exception {
        DataSource d = ds.executeSQL(
                "select * from persona order by apellido;");
        
        d.start();
        assertTrue(d.getRowCount() == 3);
        assertTrue(((BooleanValue)d.getFieldValue(0, 0).equals(ValueFactory.createValue(2))).getValue());
        assertTrue(((BooleanValue)d.getFieldValue(0, 1).equals(ValueFactory.createValue("fernan"))).getValue());
        assertTrue(d.getFieldValue(0, 2) instanceof NullValue);
        assertTrue(((BooleanValue)d.getFieldValue(1, 0).equals(ValueFactory.createValue(1))).getValue());

View Full Code Here

        d.stop();


        d = ds.executeSQL(
                "select * from persona order by apellido desc;");
        
        d.start();
        assertTrue(d.getRowCount() == 3);
        assertTrue(((BooleanValue)d.getFieldValue(0, 0).equals(ValueFactory.createValue(0))).getValue());
        assertTrue(((BooleanValue)d.getFieldValue(0, 1).equals(ValueFactory.createValue("fernando"))).getValue());
        assertTrue(((BooleanValue)d.getFieldValue(0, 2).equals(ValueFactory.createValue("gonzalez"))).getValue());
        assertTrue(((BooleanValue)d.getFieldValue(1, 0).equals(ValueFactory.createValue(1))).getValue());

View Full Code Here

    
    public void testOrderWithRepeatedValues() throws Exception {
        DataSource d = ds.executeSQL(
                "select id2 from sort order by id2 asc;");
        
        d.start();
        assertTrue(d.getRowCount() == 5);
        assertTrue(((BooleanValue)d.getFieldValue(0, 0).equals(ValueFactory.createValue(0))).getValue());
        assertTrue(((BooleanValue)d.getFieldValue(1, 0).equals(ValueFactory.createValue(0))).getValue());
        assertTrue(((BooleanValue)d.getFieldValue(2, 0).equals(ValueFactory.createValue(1))).getValue());
        assertTrue(((BooleanValue)d.getFieldValue(3, 0).equals(ValueFactory.createValue(1))).getValue());

View Full Code Here

    
    public void testOrderByMultipleCriteria() throws Exception {
        DataSource d = ds.executeSQL(
                "select * from sort order by id1 desc, id2 asc;");
        
        d.start();
        assertTrue(d.getRowCount() == 5);
        assertTrue(((BooleanValue)d.getFieldValue(0, 0).equals(ValueFactory.createValue(2))).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(0))).getValue());

View Full Code Here

    public void testCustomQuery()
      throws Exception, 
        SemanticException, IOException {
      DataSource d = ds.executeSQL("custom sumquery tables persona values (id);");
    
      d.start();
      assertTrue(((BooleanValue) d.getFieldValue(0, 0).equals(ValueFactory.createValue(
            3))).getValue());
      d.stop();
    }

View Full Code Here

 */
public class SQLTest extends DataSourceTestCase {
    public void testIsClause() throws Exception {
        DataSource d = ds.executeSQL(
                "select * from persona where apellido is null;");
        d.start();
        Value v0 = ValueFactory.createValue(2);
        Value v1 = ValueFactory.createValue("fernan");
        Value v2 = ValueFactory.createNullValue();
        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(d.getFieldValue(0, 2) instanceof NullValue);
        d.stop();


        d = ds.executeSQL("select * from persona where apellido is not null;");
        d.start();
        v0 = ValueFactory.createValue(0);
        v1 = ValueFactory.createValue("fernando");
        v2 = ValueFactory.createValue("gonzalez");
        Value v3 = ValueFactory.createValue(1);
        Value v4 = ValueFactory.createValue("huracan");

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.