Package org.gdbms.engine.data

Examples of org.gdbms.engine.data.DataSource


   * Access to the PK field
   *
   * @throws Exception DOCUMENT ME!
   */
  public void testPKAccess() throws Exception {
    DataSource d = ds.getDataSource("hsqldbpersona");
    d.start();

    String[] pks = d.getDataSourceMetadata().getPrimaryKey();
    assertTrue(pks.length == 1);
    assertTrue(pks[0].toUpperCase().equals("ID"));
    d.stop();
  }
View Full Code Here


        d.commitTrans();
        assertTrue(listener.total == total);
    }
   
    public void testSelectionChange() throws Exception {
        DataSource d = ds.getDataSource("persona", DataSourceFactory.UNDOABLE);
       
        TheSelectionListener tsl = new TheSelectionListener();
        d.addSelectionListener(tsl);
        d.setSelectedRows(new int[]{1,2,3});
        assertTrue(tsl.counter == 1);
        int[] sel = new int[]{1,2,4};
        d.setSelectedRows(sel);
        assertTrue(tsl.counter == 2);
        d.setSelectedRows(sel);
        assertTrue(tsl.counter == 2);
    }
View Full Code Here


public class SelectionTest extends DataSourceTestCase {

    public void testGetSelection() throws Exception {
        DataSource d = ds.getDataSource("persona");
       
        d.start();
        d.setSelectedRows(new int[] {0, 2});
        int[] selection = d.getSelectedRows();
        assertTrue(selection.length == 2);
        assertTrue((selection[0] == 0) && (selection[1] == 2));
        d.stop();       
    }
View Full Code Here

        assertTrue((selection[0] == 0) && (selection[1] == 2));
        d.stop();       
    }
   
    public void testUndoOrRedoClearsSelection() throws Exception {
        DataSource d = ds.getDataSource("persona", DataSourceFactory.UNDOABLE);
       
        d.beginTrans();
        d.setSelectedRows(new int[]{0});
        d.insertFilledRow(d.getRow(0));
        int[] sel = d.getSelectedRows();
        assertTrue(sel.length == 1);
        assertTrue(sel[0] == 0);
        d.undo();
        assertTrue(d.getSelectedRows().length == 0);
       
        d.commitTrans();
    }
View Full Code Here

    public void testAddDirectTransaction() throws Exception {
        testAdd("hsqldbpersonatransactional", DataSource.DIRECT_MODE);
    }
 
  private void testSQLInjection(String dsName, int mode) throws Exception {
    DataSource d = ds.getDataSource(dsName);

    Value value = ValueFactory.createValue("aaa'aaa");
   
    d.beginTrans();
    d.setFieldValue(0, 1, value);
    d.commitTrans();

    d.start();
    assertTrue(((BooleanValue) d.getFieldValue(0, 1).equals(value)).getValue());
    d.stop();
    }
View Full Code Here

    public void testSQLInjectionDirectTransaction() throws Exception {
        testSQLInjection("hsqldbpersonatransactional", DataSource.DIRECT_MODE);
    }
 
  private void testInsertFilledRow(String dsName, int mode) throws Exception {
    DataSource d = ds.getDataSource(dsName);

    Value v1 = ValueFactory.createValue(4);
    Value v2 = ValueFactory.createValue("nombre");
    Value v3 = ValueFactory.createValue("apellido");
    Value v4 = ValueFactory.createValue(Date.valueOf("1998-09-05"));
    Value v5 = ValueFactory.createValue(Time.valueOf("4:30:01"));
    Value v6 = ValueFactory.createValue(Timestamp.valueOf("2005-09-05 4:30:01.666666666"));

    d.beginTrans();
    d.insertFilledRow(new Value[] {v1, v2, v3, v4, v5, v6});
    d.commitTrans();

        d.start();
    assertTrue(((BooleanValue) d.getFieldValue(3, 0).equals(v1)).getValue());
    assertTrue(((BooleanValue) d.getFieldValue(3, 1).equals(v2)).getValue());
    assertTrue(((BooleanValue) d.getFieldValue(3, 2).equals(v3)).getValue());
    assertTrue(((BooleanValue) d.getFieldValue(3, 3).equals(v4)).getValue());
    assertTrue(((BooleanValue) d.getFieldValue(3, 4).equals(v5)).getValue());
    assertTrue(((BooleanValue) d.getFieldValue(3, 5).equals(v6)).getValue());
    d.stop();
    }
View Full Code Here

    public void testInsertFilledDirectTransaction() throws Exception {
        testInsertFilledRow("hsqldbpersonatransactional", DataSource.DIRECT_MODE);
    }
   
    private void testEditingNullValues(String dsName, int mode) throws Exception {
        DataSource d = ds.getDataSource(dsName);

        Value v1 = ValueFactory.createValue(4);
        Value v2 = ValueFactory.createNullValue();
        Value v3 = ValueFactory.createValue("apellido");
        Value v4 = ValueFactory.createValue(Date.valueOf("1998-09-05"));
        Value v5 = ValueFactory.createValue(Time.valueOf("4:30:01"));
        Value v6 = ValueFactory.createValue(Timestamp.valueOf("2005-09-05 4:30:01.666666666"));

        d.beginTrans();
        d.insertFilledRow(new Value[] {v1, v2, v3, v4, v5, v6});
        d.setFieldValue(0, 1, ValueFactory.createNullValue());
        d.commitTrans();

        d.start();
        assertTrue(((BooleanValue) d.getFieldValue(3, 0).equals(v1)).getValue());
        assertTrue(((BooleanValue) ValueFactory.createValue(d.getFieldValue(3, 1) instanceof NullValue)).getValue());
        assertTrue(((BooleanValue) d.getFieldValue(3, 2).equals(v3)).getValue());
        assertTrue(((BooleanValue) d.getFieldValue(3, 3).equals(v4)).getValue());
        assertTrue(((BooleanValue) d.getFieldValue(3, 4).equals(v5)).getValue());
        assertTrue(((BooleanValue) d.getFieldValue(3, 5).equals(v6)).getValue());
        d.stop();
    }
View Full Code Here

        testDeleteUpdatedPK("objectpersona");
        testDeleteUpdatedPK("hsqldbpersonatransactional");
    }

    private void testRowCount(String dsName, int mode) throws Exception {
        DataSource d = ds.getDataSource(dsName);

        Value v1 = ValueFactory.createValue(4);
        Value v2 = ValueFactory.createNullValue();
        Value v3 = ValueFactory.createValue("apellido");
        Value v4 = ValueFactory.createValue(Date.valueOf("1998-09-05"));
        Value v5 = ValueFactory.createValue(Time.valueOf("4:30:01"));
        Value v6 = ValueFactory.createValue(Timestamp.valueOf("2005-09-05 4:30:01.666666666"));

       
        d.beginTrans();
        int rc = (int) d.getRowCount();
        d.insertFilledRow(new Value[] {v1, v2, v3, v4, v5, v6});
        assertTrue(d.getRowCount() == rc+1);
        d.commitTrans();
    }
View Full Code Here

    public void testInsertAtDirectTransaction() throws Exception {
        testInsertAt("hsqldbpersonatransactional", DataSource.DIRECT_MODE);
    }
   
    private void testEditingDates(String dsName, int mode) throws Exception {
    DataSource d = ds.getDataSource(dsName);

    Value v1 = ValueFactory.createValue(4);
    Value v2 = ValueFactory.createNullValue();
    Value v3 = ValueFactory.createValue("apellido");
    Value v4 = ValueFactory.createValue(Date.valueOf("1998-09-05"));
    Value v5 = ValueFactory.createValue(Time.valueOf("4:30:01"));
    Value v6 = ValueFactory.createValue(Timestamp.valueOf("2005-09-05 4:30:01.666666666"));
    Value v7 = ValueFactory.createValue(3);
   
    d.beginTrans();
    d.insertFilledRow(new Value[] {v1, v2, v3, v4, v5, v6, v7});
    d.setFieldValue(0, 1, ValueFactory.createNullValue());
    d.commitTrans();
    }
View Full Code Here

      testEditingDates("persona", DataSource.COHERENT_ROW_ORDER);
      testEditingDates("objectpersona", DataSource.COHERENT_ROW_ORDER);
    }
   
    public void testAutomaticDataSource() throws Exception{
    DataSource d = ds.getDataSource("persona");

        d.beginTrans();
        d.setFieldValue(0, 1, ValueFactory.createValue("la gacela"));
        d.commitTrans();
       
    d = ds.getDataSource("hsqldbpersona");

        d.beginTrans();
        d.setFieldValue(0, 1, ValueFactory.createValue("la gacela"));
        d.commitTrans();
       
    assertTrue(true);
    }
View Full Code Here

TOP

Related Classes of org.gdbms.engine.data.DataSource

Copyright © 2018 www.massapicom. All rights reserved.
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.