9
9
*
10
10
* PS: Do you know how difficult it is to type on a train? ;-)
11
11
*
12
- * $PostgreSQL: pgsql/src/interfaces/jdbc/org/postgresql/test/jdbc2/DatabaseMetaDataTest.java,v 1.21 2003/12/11 15:50:20 davec Exp $
12
+ * $PostgreSQL: pgsql/src/interfaces/jdbc/org/postgresql/test/jdbc2/DatabaseMetaDataTest.java,v 1.22 2003/12/12 18:30:27 davec Exp $
13
13
*/
14
14
15
15
public class DatabaseMetaDataTest extends TestCase
@@ -52,28 +52,28 @@ public void testTables()
52
52
ResultSet rs =dbmd .getTables (null ,null ,"testmetadat%" ,new String [] {"TABLE" });
53
53
assertTrue (rs .next () );
54
54
String tableName =rs .getString ("TABLE_NAME" );
55
- assertTrue ( tableName . equals ( "testmetadata" ) );
55
+ assertEquals ( "testmetadata" , tableName );
56
56
String tableType =rs .getString ("TABLE_TYPE" );
57
- assertTrue ( tableType . equals ( "TABLE" ) );
57
+ assertEquals ( "TABLE" , tableType );
58
58
//There should only be one row returned
59
59
assertTrue ("getTables() returned too many rows" ,rs .next () ==false );
60
60
rs .close ();
61
61
62
62
rs =dbmd .getColumns ("" ,"" ,"test%" ,"%" );
63
63
assertTrue (rs .next () );
64
- assertTrue ( rs .getString ("TABLE_NAME" ). equals ( "testmetadata " ) );
65
- assertTrue ( rs .getString ("COLUMN_NAME" ). equals ( "id " ) );
66
- assertTrue ( rs .getInt ("DATA_TYPE" ) == java . sql . Types . INTEGER );
64
+ assertEquals ( "testmetadata" , rs .getString ("TABLE_NAME" ) );
65
+ assertEquals ( "id" , rs .getString ("COLUMN_NAME" ) );
66
+ assertEquals ( java . sql . Types . INTEGER , rs .getInt ("DATA_TYPE" ) );
67
67
68
68
assertTrue (rs .next () );
69
- assertTrue ( rs .getString ("TABLE_NAME" ). equals ( "testmetadata " ) );
70
- assertTrue ( rs .getString ("COLUMN_NAME" ). equals ( "name " ) );
71
- assertTrue ( rs .getInt ("DATA_TYPE" ) == java . sql . Types . VARCHAR );
69
+ assertEquals ( "testmetadata" , rs .getString ("TABLE_NAME" ) );
70
+ assertEquals ( "name" , rs .getString ("COLUMN_NAME" ) );
71
+ assertEquals ( java . sql . Types . VARCHAR , rs .getInt ("DATA_TYPE" ) );
72
72
73
73
assertTrue (rs .next () );
74
- assertTrue ( rs .getString ("TABLE_NAME" ). equals ( "testmetadata " ) );
75
- assertTrue ( rs .getString ("COLUMN_NAME" ). equals ( "updated " ) );
76
- assertTrue ( rs .getInt ("DATA_TYPE" ) == java . sql . Types . TIMESTAMP );
74
+ assertEquals ( "testmetadata" , rs .getString ("TABLE_NAME" ) );
75
+ assertEquals ( "updated" , rs .getString ("COLUMN_NAME" ) );
76
+ assertEquals ( java . sql . Types . TIMESTAMP , rs .getInt ("DATA_TYPE" ) );
77
77
78
78
}
79
79
catch (SQLException ex )
@@ -102,13 +102,13 @@ public void testCrossReference()
102
102
{
103
103
104
104
String pkTableName =rs .getString ("PKTABLE_NAME" );
105
- assertTrue (pkTableName . equals ( "vv" ) );
105
+ assertEquals ("vv" , pkTableName );
106
106
107
107
String pkColumnName =rs .getString ("PKCOLUMN_NAME" );
108
108
assertTrue (pkColumnName .equals ("a" ) ||pkColumnName .equals ("b" ));
109
109
110
110
String fkTableName =rs .getString ("FKTABLE_NAME" );
111
- assertTrue ( fkTableName . equals ( "ww" ) );
111
+ assertEquals ( "ww" , fkTableName );
112
112
113
113
String fkColumnName =rs .getString ("FKCOLUMN_NAME" );
114
114
assertTrue (fkColumnName .equals ("m" ) ||fkColumnName .equals ("n" ) ) ;
@@ -121,10 +121,10 @@ public void testCrossReference()
121
121
}
122
122
123
123
String pkName =rs .getString ("PK_NAME" );
124
- assertTrue ( pkName . equals ( "vv_pkey" ) );
124
+ assertEquals ( "vv_pkey" , pkName );
125
125
126
126
int keySeq =rs .getInt ("KEY_SEQ" );
127
- assertTrue ( keySeq == j );
127
+ assertEquals ( j , keySeq );
128
128
}
129
129
130
130
@@ -263,10 +263,10 @@ public void testForeignKeys()
263
263
assertTrue (pkTableName .equals ("people" ) ||pkTableName .equals ("policy" ) );
264
264
265
265
String pkColumnName =rs .getString ("PKCOLUMN_NAME" );
266
- assertTrue ( pkColumnName . equals ( "id" ) );
266
+ assertEquals ( "id" , pkColumnName );
267
267
268
268
String fkTableName =rs .getString ("FKTABLE_NAME" );
269
- assertTrue ( fkTableName . equals ( "users" ) );
269
+ assertEquals ( "users" , fkTableName );
270
270
271
271
String fkColumnName =rs .getString ("FKCOLUMN_NAME" );
272
272
assertTrue (fkColumnName .equals ("people_id" ) ||fkColumnName .equals ("policy_id" ) ) ;
@@ -286,11 +286,11 @@ public void testForeignKeys()
286
286
// this is hacky, but it will serve the purpose
287
287
assertTrue (rs .next () );
288
288
289
- assertTrue ( rs . getString ( "PKTABLE_NAME" ). equals ("people " ) );
290
- assertTrue ( rs . getString ( "PKCOLUMN_NAME" ). equals ("id " ) );
289
+ assertEquals ( "people" , rs . getString ("PKTABLE_NAME " ) );
290
+ assertEquals ( "id" , rs . getString ("PKCOLUMN_NAME " ) );
291
291
292
- assertTrue ( rs . getString ( "FKTABLE_NAME" ). equals ("users " ) );
293
- assertTrue ( rs . getString ( "FKCOLUMN_NAME" ). equals ("people_id " ) );
292
+ assertEquals ( "users" , rs . getString ("FKTABLE_NAME " ) );
293
+ assertEquals ( "people_id" , rs . getString ("FKCOLUMN_NAME " ) );
294
294
295
295
assertTrue (rs .getString ("FK_NAME" ).startsWith ("people" ) );
296
296