---

DTOResultSetTest.java

Go to the documentation of this file.

package net.threebit.utils.sosc.test;

/*
        Copyright 2003 Shawn Deleurme
        Copyright 2003 Kevin O'Donnell

        This program is free software; you can redistribute it and/or modify
        it under the terms of the GNU General Public License as published by
        the Free Software Foundation; either version 2 of the License, or
        (at your option) any later version.

        This program is distributed in the hope that it will be useful,
        but WITHOUT ANY WARRANTY; without even the implied warranty of
        MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
        GNU General Public License for more details.

        You should have received a copy of the GNU General Public License
        along with this program; if not, write to the Free Software
        Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA  02111-1307  USA
*/

import java.io.*;
import java.util.*;
import java.util.logging.*;
import java.sql.Date;
import java.sql.ResultSetMetaData;
import java.sql.Types;
import junit.framework.*;
import net.threebit.utils.sosc.*;

public class DTOResultSetTest extends TestCase {

        public void test1() throws Exception {
                final String col1 = "StringColumn1";
                final String val1 = "value1";
                final String col2 = "StringColumn2";
                final String val2 = "value2";
                final String col3 = "col3";
                final Date val3 = new Date( new java.util.Date().getTime() );

                DTOResultSet r = new DTOResultSet();

                // Add the first row.
                r.moveToInsertRow();
                r.updateString(col1,val1);
                r.updateString(col2,val2);
                r.updateDate(col3,val3);
                r.insertRow();

                // Reset and read it.
                r.beforeFirst();
                assertTrue(r.getRow() == 0);
                assertTrue(r.next());
                assertTrue(r.getRow() == 1);
                assertTrue(val1.equals( r.getString( col1 )));
                assertTrue(val2.equals( r.getString( col2 )));
                assertTrue(val3.equals( r.getDate( col3 )));
                assertTrue(val3.equals( r.getObject( col3 )));
                assertTrue(! r.next());
                assertTrue(r.getRow() == 0);
                System.out.println("" + r);
                r.close();
                System.out.println("" + r);
        }

        public void test2() throws Exception {
                DTOResultSet r = new DTOResultSet();

                for (int x = 1; x < 100; x++) {
                        r.moveToInsertRow();
                        r.updateString("column1",""+x);
                        r.insertRow();
                }

                r.beforeFirst();
                int x = 0;
                while (r.next()) {
                        if (x++ >= 100) { throw new Exception("TO MANY ROWS!"); }
                        assertTrue(x == r.getRow());
                        assertTrue((""+x).equals(r.getString("column1")));
                }
                r.close();
        }

        public void test3 () throws Exception {
                DTOResultSet r = new DTOResultSet();

                r.moveToInsertRow();
                r.updateString("col1","v1");
                r.updateString("col2","v2");
                r.insertRow();
                r.updateString("col1","v3");
                r.updateString("col2","v4");
                r.insertRow();

                r.beforeFirst();

                ResultSetMetaData md = r.getMetaData();
                assertTrue(md.getColumnCount() == 2);
                assertTrue(md.getColumnType(r.findColumn("col2")) == Types.VARCHAR);

        }

        public void test4 () throws Exception {
                DTOResultSet r = new DTOResultSet();

                r.moveToInsertRow();
                r.updateString("col1","v1");
                r.updateString("col2","v2");
                r.insertRow();
                r.updateString("col1","v3");
                r.updateString("col2","v4");
                r.insertRow();

                r.beforeFirst();

                DTOResultSet r2 = new DTOResultSet(r);

                ResultSetMetaData md = r2.getMetaData();
                assertTrue(md.getColumnCount() == 2);
                assertTrue(md.getColumnType(r2.findColumn("col2")) == Types.VARCHAR);

                assertTrue(r2.next());
                assertTrue("v1".equals(r2.getString("col1")));
                assertTrue("v2".equals(r2.getString("col2")));

                assertTrue(r2.next());
                assertTrue("v3".equals(r2.getString("col1")));
                assertTrue("v4".equals(r2.getString("col2")));

                assertTrue(! r2.next());
        }

}

---