connectivity/qa/drivers/hsqldb/DatabaseMetaData.java

   1 /*
   2  * Class.java
   3  *
   4  * Created on June 23, 2003, 3:19 PM
   5  */
   6
   7 /**
   8  *
   9  * @author  oj93728
  10  */
  11 package qa.drivers.hsqldb;
  12 import java.sql.*;
  13 import com.sun.star.uno.UnoRuntime;
  14 import complexlib.ComplexTestCase;
  15 import java.lang.reflect.Method;
  16 import qa.drivers.hsqldb.DriverTest;
  17
  18
  19 public class DatabaseMetaData {
  20
  21     private java.sql.DatabaseMetaData m_xMD;
  22     private DriverTest m_TestCase;
  23
  24     /** Creates a new instance of DatabaseMetaData */
  25     public DatabaseMetaData(DriverTest _testCase,java.sql.DatabaseMetaData _xmd) {
  26         m_TestCase = _testCase;
  27         m_xMD = _xmd;
  28     }
  29
  30     protected void assure(String _sText,boolean btest){
  31         m_TestCase.assurePublic(_sText,btest);
  32     }
  33
  34     protected void testMethod(String sName,Class[] params,Object[] objParams,int nCount){
  35         try {
  36             System.out.println("test method " + sName);
  37
  38             Method aGet = ((Object)m_xMD).getClass().getDeclaredMethod(sName, params);
  39             if ( aGet != null ){
  40                 ResultSet rs = (ResultSet)aGet.invoke(m_xMD, objParams);
  41                 ResultSetMetaData rsMD = rs.getMetaData();
  42
  43                 assure( sName + " returns wrong column count" , rsMD.getColumnCount() == nCount);
  44             }
  45             else
  46                 assure( sName + " returns wrong column count" , false);
  47         } catch( java.lang.NoSuchMethodException ex ) {
  48             assure("Method " + sName + " could not be found!",false);
  49         } catch( java.lang.IllegalAccessException ex ) {
  50             assure("IllegalAccessException!",false);
  51         } catch( SQLException ex ) {
  52             assure("SQLException occured: " + ex.getMessage() ,false);
  53         } catch( java.lang.reflect.InvocationTargetException ex ) {
  54             assure("IllegalAccessException!",false);
  55         } finally {
  56
  57         }
  58     }
  59
  60     public void test(){
  61
  62    //     try {
  63
  64             try{
  65         ResultSet rs = m_xMD.getTables(null,null,"TESTCASE",null);
  66         while ( rs.next() )
  67         {
  68             String catalog = rs.getString( 1 );
  69             if ( rs.wasNull() )
  70                 catalog = null;
  71
  72             String schema = rs.getString( 2 );
  73             if ( rs.wasNull() )
  74                 schema = null;
  75
  76             String table = rs.getString( 3 );
  77             String type = rs.getString( 4 );
  78             System.out.println("Catalog: " + catalog + " Schema: " + schema + " Table: " + table + " Type: " + type);
  79             System.out.println("------------------ Columns ------------------");
  80             ResultSet rsColumns = m_xMD.getColumns(catalog,schema,table,"%");
  81             while ( rsColumns.next() )
  82             {
  83                 System.out.println("Column: " + rsColumns.getString( 4 ) + " Type: " + rsColumns.getInt( 5 ) + " TypeName: " + rsColumns.getString( 6 ) );
  84             }
  85
  86         }
  87             } catch(Exception e){
  88
  89             }
  90             //testMethod("getTypeInfo", zclass,empty,17);
  91 /*
  92             Class[] zclass = new Class[]{};
  93             Object[] empty = new Object[]{};
  94             testMethod("getCatalogs", zclass,empty,1);
  95
  96             testMethod("getSchemas", zclass,empty,2);
  97             testMethod("getTableTypes", zclass,empty,1);
  98             Class[] a4 = new Class[4];
  99             Object[] o4 = new Object[4];
 100             a4[0] = Class.forName("java.lang.Object");
 101             a4[1] = Class.forName("java.lang.String");
 102             a4[2] = Class.forName("java.lang.String");
 103             a4[3] = Class.forName("java.lang.String");
 104
 105             o4[0] = null;
 106             o4[1] = null;
 107             o4[2] = null;
 108             o4[3] = "%";
 109             testMethod("getColumnPrivileges", a4,o4,7);
 110             testMethod("getColumns", a4,o4,18);
 111             testMethod("getProcedureColumns", a4,o4,13);
 112             testMethod("getColumns", a4,o4,18);
 113
 114             Class[] a3 = new Class[3];
 115             Object[] o3 = new Object[3];
 116             a3[0] = Class.forName("java.lang.Object");
 117             a3[1] = Class.forName("java.lang.String");
 118             a3[2] = Class.forName("java.lang.String");
 119
 120             o3[0] = null;
 121             o3[1] = null;
 122             o3[2] = "%";
 123
 124             testMethod("getExportedKeys", a3,o3,14);
 125             testMethod("getImportedKeys", a3,o3,14);
 126             testMethod("getPrimaryKeys", a3,o3,14);
 127             testMethod("getProcedures", a3,o3,5);
 128             testMethod("getTablePrivileges", a3,o3,6);
 129             testMethod("getVersionColumns", a3,o3,7);
 130             // testMethod("getCrossReference", a3,o3,14);
 131
 132         } catch( java.lang.ClassNotFoundException ex) {
 133             assure("ClassNotFoundException: " + ex.getMessage() ,false);
 134         }
 135  */
 136     }
 137 /*
 138     public com.sun.star.sdbc.XResultSet getCrossReference(Object obj, String str, String str2, Object obj3, String str4, String str5) {
 139     }
 140     public com.sun.star.sdbc.XResultSet getIndexInfo(Object obj, String str, String str2, boolean param, boolean param4) {
 141     }
 142
 143     public com.sun.star.sdbc.XResultSet getTables(Object obj, String str, String str2, String[] str3) {
 144     }
 145
 146     public com.sun.star.sdbc.XResultSet getUDTs(Object obj, String str, String str2, int[] values) {
 147     }
 148
 149     public com.sun.star.sdbc.XResultSet getBestRowIdentifier(Object obj, String str, String str2, int param, boolean param4) throws com.sun.star.sdbc.SQLException {
 150     }
 151  */
 152 }