Movatterモバイル変換

[0]ホーム
URL:

Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

 Sign up
Appearance settings

Commit1ffd044

Browse files
author
Dave Cramer
committed
added imported/exported key testDatabaseMetaDataTest.java
1 parent970ff81 commit1ffd044

File tree

2 files changed

+101
-7
lines changed

2 files changed

+101
-7
lines changed

‎src/interfaces/jdbc/org/postgresql/test/jdbc2/DatabaseMetaDataTest.java

Lines changed: 75 additions & 6 deletions
Original file line numberDiff line numberDiff line change
@@ -9,7 +9,7 @@
99
*
1010
* PS: Do you know how difficult it is to type on a train? ;-)
1111
*
12-
* $Id: DatabaseMetaDataTest.java,v 1.5 2002/04/16 15:25:17 davec Exp $
12+
* $Id: DatabaseMetaDataTest.java,v 1.6 2002/05/30 16:26:55 davec Exp $
1313
*/
1414

1515
publicclassDatabaseMetaDataTestextendsTestCase
@@ -32,7 +32,7 @@ protected void setUp() throws Exception
3232
protectedvoidtearDown()throwsException
3333
{
3434
JDBC2Tests.dropTable(con,"testmetadata" );
35-
35+
3636
JDBC2Tests.closeDB(con );
3737
}
3838
/*
@@ -51,23 +51,23 @@ public void testGetMetaData()
5151
assertTrue(rs.getString("TABLE_NAME").equals("testmetadata") );
5252

5353
rs.close();
54-
54+
5555
rs =dbmd.getColumns("","","test%","%" );
5656
assertTrue(rs.next() );
5757
assertTrue(rs.getString("TABLE_NAME").equals("testmetadata") );
5858
assertTrue(rs.getString("COLUMN_NAME").equals("id") );
5959
assertTrue(rs.getInt("DATA_TYPE") ==java.sql.Types.INTEGER );
60-
60+
6161
assertTrue(rs.next() );
6262
assertTrue(rs.getString("TABLE_NAME").equals("testmetadata") );
6363
assertTrue(rs.getString("COLUMN_NAME").equals("name") );
6464
assertTrue(rs.getInt("DATA_TYPE") ==java.sql.Types.VARCHAR );
65-
65+
6666
assertTrue(rs.next() );
6767
assertTrue(rs.getString("TABLE_NAME").equals("testmetadata") );
6868
assertTrue(rs.getString("COLUMN_NAME").equals("updated") );
6969
assertTrue(rs.getInt("DATA_TYPE") ==java.sql.Types.TIMESTAMP );
70-
70+
7171
}
7272
catch (SQLExceptionex)
7373
{
@@ -228,6 +228,75 @@ public void testIdentifiers()
228228
}
229229
}
230230

231+
publicvoidtestForeignKeys()
232+
{
233+
try
234+
{
235+
Connectioncon1 =JDBC2Tests.openDB();
236+
JDBC2Tests.createTable(con1,"people","id int4 primary key, name text" );
237+
JDBC2Tests.createTable(con1,"policy","id int4 primary key, name text" );
238+
JDBC2Tests.createTable(con1,"users","id int4 primary key, people_id int4, policy_id int4,"+
239+
"CONSTRAINT people FOREIGN KEY (people_id) references people(id),"+
240+
"constraint policy FOREIGN KEY (policy_id) references policy(id)" );
241+
242+
243+
DatabaseMetaDatadbmd =con.getMetaData();
244+
assertNotNull(dbmd);
245+
246+
ResultSetrs =dbmd.getImportedKeys(null,"","users" );
247+
intj =0;
248+
for (;rs.next();j++ )
249+
{
250+
251+
StringpkTableName =rs.getString("PKTABLE_NAME" );
252+
assertTrue (pkTableName.equals("people") ||pkTableName.equals("policy") );
253+
254+
StringpkColumnName =rs.getString("PKCOLUMN_NAME" );
255+
assertTrue(pkColumnName.equals("id") );
256+
257+
StringfkTableName =rs.getString("FKTABLE_NAME" );
258+
assertTrue(fkTableName.equals("users" ) );
259+
260+
StringfkColumnName =rs.getString("FKCOLUMN_NAME" );
261+
assertTrue(fkColumnName.equals("people_id" ) ||fkColumnName.equals("policy_id" ) ) ;
262+
263+
StringfkName =rs.getString("FK_NAME" );
264+
assertTrue(fkName.equals("people") ||fkName.equals("policy" ) );
265+
266+
StringpkName =rs.getString("PK_NAME" );
267+
268+
}
269+
270+
assertTrue (j==2 );
271+
272+
rs =dbmd.getExportedKeys(null,"","people" );
273+
274+
// this is hacky, but it will serve the purpose
275+
assertTrue (rs.next() );
276+
277+
for (inti =0;i <14 ;i++ )
278+
{
279+
assertTrue(rs.getString("PKTABLE_NAME" ).equals("people" ) );
280+
assertTrue(rs.getString("PKCOLUMN_NAME" ).equals("id" ) );
281+
282+
assertTrue(rs.getString("FKTABLE_NAME" ).equals("users" ) );
283+
assertTrue(rs.getString("FKCOLUMN_NAME" ).equals("people_id" ) );
284+
285+
assertTrue(rs.getString("FK_NAME" ).equals("people" ) );
286+
287+
}
288+
289+
290+
JDBC2Tests.dropTable(con1,"users" );
291+
JDBC2Tests.dropTable(con1,"people" );
292+
JDBC2Tests.dropTable(con1,"policy" );
293+
294+
}
295+
catch (SQLExceptionex)
296+
{
297+
fail(ex.getMessage());
298+
}
299+
}
231300
publicvoidtestTables()
232301
{
233302
try

‎src/interfaces/jdbc/org/postgresql/test/jdbc2/MiscTest.java

Lines changed: 26 additions & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -5,7 +5,7 @@
55
importjava.sql.*;
66

77
/*
8-
* $Id: MiscTest.java,v 1.4 2001/11/19 22:33:39 momjian Exp $
8+
* $Id: MiscTest.java,v 1.5 2002/05/30 16:26:55 davec Exp $
99
*
1010
* Some simple tests based on problems reported by users. Hopefully these will
1111
* help prevent previous problems from re-occuring ;-)
@@ -51,4 +51,29 @@ public void testDatabaseSelectNullBug()
5151
fail(ex.getMessage());
5252
}
5353
}
54+
55+
publicvoidxtestLocking()
56+
{
57+
58+
System.out.println("testing lock");
59+
try
60+
{
61+
Connectioncon =JDBC2Tests.openDB();
62+
Connectioncon2 =JDBC2Tests.openDB();
63+
64+
JDBC2Tests.createTable(con,"test_lock","name text");
65+
Statementst =con.createStatement();
66+
Statementst2 =con2.createStatement();
67+
con.setAutoCommit(false);
68+
st.execute("lock table test_lock");
69+
st2.executeUpdate("insert into test_lock ( name ) values ('hello')" );
70+
con.commit();
71+
JDBC2Tests.dropTable(con,"test_lock");
72+
con.close();
73+
}
74+
catch (Exceptionex )
75+
{
76+
fail(ex.getMessage() );
77+
}
78+
}
5479
}

0 commit comments

Comments
 (0)
[8]ページ先頭
©2009-2025 Movatter.jp