| gvSIG desktop 1

import com.hardcode.driverManager.DriverLoadException;

import com.hardcode.gdbms.DataSourceTestCase;

import com.hardcode.gdbms.engine.data.DataSource;

import com.hardcode.gdbms.engine.data.DataSourceFactory;

import com.hardcode.gdbms.engine.data.NoSuchTableException;

     *

     * @throws NoSuchTableException DOCUMENT ME!

     * @throws DriverException DOCUMENT ME!

     */

    private void doTestNullValues(String dsName)

        DataSource d = ds.createRandomDataSource(dsName,

                DataSourceFactory.MANUAL_OPENING);

        d.start();

        assertTrue(ValueWriterImpl.escapeString("pp'pp").equals("pp''pp"));

        assertTrue(ValueWriterImpl.escapeString("pp''pp").equals("pp''''pp"));

    }

    public void testBooleanComparations() {

        Value vTrue = ValueFactory.createValue(true);

        Value vFalse = ValueFactory.createValue(false);

        assertTrue(((BooleanValue) ValueFactory.createValueByType(ts.toString(), Types.TIMESTAMP).equals(ValueFactory.createValue(

                    ts))).getValue());

    }

    public void testToStringFromStringCoherente() throws Exception {

        Value v = ValueFactory.createValue(13.5d);

        assertTrue(((BooleanValue) v.equals(ValueFactory.createValueByType(v.toString(), Types.DOUBLE))).getValue());

        v = ValueFactory.createValue(13.5f);

        assertTrue(((BooleanValue) v.equals(ValueFactory.createValueByType(v.toString(), Types.REAL))).getValue());

        v = ValueFactory.createValue(13L);

        assertTrue(((BooleanValue) v.equals(ValueFactory.createValueByType(v.toString(), Types.BIGINT))).getValue());

        v = ValueFactory.createValue(true);

        assertTrue(((BooleanValue) v.equals(ValueFactory.createValueByType(v.toString(), Types.BIT))).getValue());

        v = ValueFactory.createValue(false);

        assertTrue(((BooleanValue) v.equals(ValueFactory.createValueByType(v.toString(), Types.BIT))).getValue());

        v = ValueFactory.createValue("hola");

        assertTrue(((BooleanValue) v.equals(ValueFactory.createValueByType(v.toString(), Types.VARCHAR))).getValue());

        Calendar c = Calendar.getInstance();

        //month is 0-based

        Date d = c.getTime();

        v = ValueFactory.createValue(d);

        assertTrue(((BooleanValue) v.equals(ValueFactory.createValueByType(v.toString(), Types.DATE))).getValue());

        v = ValueFactory.createValue(15);

        assertTrue(((BooleanValue) v.equals(ValueFactory.createValueByType(v.toString(), Types.INTEGER))).getValue());

        v = ValueFactory.createValue((short) 13);

        assertTrue(((BooleanValue) v.equals(ValueFactory.createValueByType(v.toString(), Types.SMALLINT))).getValue());

        v = ValueFactory.createValue((byte) 5);

        assertTrue(((BooleanValue) v.equals(ValueFactory.createValueByType(v.toString(), Types.TINYINT))).getValue());

        v = ValueFactory.createValue(new byte[]{4,5,7,8,3,8});

        assertTrue(((BooleanValue) v.equals(ValueFactory.createValueByType(v.toString(), Types.BINARY))).getValue());

        c.set(1970, 0, 1, 22, 45, 20);

        c.set(Calendar.MILLISECOND, 0);

        Time t = new Time(c.getTime().getTime());

        v = ValueFactory.createValue(t);

        assertTrue(((BooleanValue) v.equals(ValueFactory.createValueByType(v.toString(), Types.TIME))).getValue());

        v = ValueFactory.createValue(new Timestamp(2465));

        assertTrue(((BooleanValue) v.equals(ValueFactory.createValueByType(v.toString(), Types.TIMESTAMP))).getValue());

    }