---

DbToolTest.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.sql.*;
import java.util.*;
import javax.xml.transform.stream.*;
import javax.xml.transform.*;
import junit.framework.*;
import net.threebit.utils.sosc.*;
import java.util.logging.*;

public class DbToolTest extends TestCase {

        String url = System.getProperty("net.threebit.utils.sosc.DbTool.jdbcURL");
        String className = System.getProperty("net.threebit.utils.sosc.DbTool.jdbcURLClassName");
        String userName = System.getProperty("net.threebit.utils.sosc.DbTool.jdbcURLUserName");
        String password = System.getProperty("net.threebit.utils.sosc.DbTool.jdbcURLPassword");

        private DbTool getDb() throws Exception {
                if (url == null) { throw new Exception("net.threebit.utils.sosc.DbTool.jdbcURL property has not been set"); }
                if (className == null) { throw new Exception("net.threebit.utils.sosc.DbTool.jdbcURLClassName property has not been set"); }
                if (userName == null) { throw new Exception("net.threebit.utils.sosc.DbTool.jdbcURLUserName property has not been set"); }
                if (password == null) { throw new Exception("net.threebit.utils.sosc.DbTool.jdbcURLPassword property has not been set"); }
                return new DbTool(className, url,userName,password);
        }

        /*
        public void test20() throws Exception {
                DbTool db = getDb();
                ArrayList list = new ArrayList();
                String r1 = "('1','2','3')";
                String r2 = "(1,2,3)";
                list.add("1");
                list.add("2");
                list.add("3");

                System.out.println("r1  : >>" + r1 + "<<");
                System.out.println("out : >>" + db.inClause(list,true) + "<<");
                System.out.println( db.inClause(list,true) );
                assertTrue( r1.equals(db.inClause(list,false)));

                System.out.println("r2  : >>" + r2 + "<<");
                System.out.println("out : >>" + db.inClause(list,true) + "<<");
                assertTrue( r2.equals(db.inClause(list,false)));
        }
        */

        public void testQuote1() throws Exception {
                DbTool db = getDb();
                assertTrue(db.quote(null) == null);
                assertTrue(db.quote("test").equals("'test'"));
                assertTrue(db.quote("o'donnell").equals("'o''donnell'"));
        }

        public void test2() throws Exception {
                DbTool db = getDb();
                StringBuffer sb = new StringBuffer();
                db.resultSetToXML(db.query("select 'one' as a, 'two' as b, 'three' as c"), sb, Integer.MAX_VALUE);
                String baseLine = 
                        "<resultSet>\n" +
                        "<row>\n" +
                        "\t<a>one</a>\n" +
                        "\t<b>two</b>\n" +
                        "\t<c>three</c>\n" +
                        "</row>\n" +
                        "</resultSet>\n"
                ;
                //System.out.println("sb: '" + sb + "'");
                //System.out.println("baseLine: '" + baseLine + "'");
                assertTrue(baseLine.equals(sb.toString()));
        }

        public void test3() throws Exception {
                DbTool db = getDb();
                ResultSet r = db.query("exec oreivrworkstackpop;");
                assertTrue(r != null);
        }

        public void test4() throws Exception {
                DbTool db = getDb();
                StringBuffer sb = db.resultSetToXML(db.query("select 1 as one;"));
                assertTrue(sb != null);
        }

}

---