/** Basic test of DatabaseMetaData functions that access system tables */
public void testTwo() throws Exception {
Connection conn = newConnection();
int updateCount;
try {
TestUtil.testScript(conn, "testrun/hsqldb/TestSelf.txt");
DatabaseMetaData dbmeta = conn.getMetaData();
dbmeta.allProceduresAreCallable();
dbmeta.getBestRowIdentifier(null, null, "T_1", DatabaseMetaData.bestRowTransaction, true);
dbmeta.getCatalogs();
dbmeta.getColumnPrivileges(null, "PUBLIC", "T_1", "%");
dbmeta.getColumns("PUBLIC", "PUBLIC", "T_1", "%");
dbmeta.getCrossReference(null, null, "T_1", null, null, "T_1");
dbmeta.getExportedKeys(null, null, "T_1");
dbmeta.getFunctionColumns(null, "%", "%", "%");
dbmeta.getFunctions(null, "%", "%");
dbmeta.getImportedKeys("PUBLIC", "PUBLIC", "T_1");
dbmeta.getIndexInfo("PUBLIC", "PUBLIC", "T1", true, true);
dbmeta.getPrimaryKeys("PUBLIC", "PUBLIC", "T_1");
dbmeta.getProcedureColumns(null, null, "%", "%");
dbmeta.getProcedures("PUBLIC", "%", "%");
dbmeta.getSchemas(null, "#");
dbmeta.getTablePrivileges(null, "%", "%");
dbmeta.getUDTs(null, "%", "%", new int[] {Types.DISTINCT});
} catch (Exception e) {
assertTrue("unable to prepare or execute DDL", false);
} finally {
conn.close();
}
}
public ResultSet getTablePrivileges(String catalog, String schemaPattern, String tableNamePattern)
throws SQLException {
_conn.checkOpen();
try {
return DelegatingResultSet.wrapResultSet(
_conn, _meta.getTablePrivileges(catalog, schemaPattern, tableNamePattern));
} catch (SQLException e) {
handleException(e);
throw new AssertionError();
}
}
@Test
public void columnOrderOfgetTablePrivileges() throws SQLException {
ResultSet rs = meta.getTablePrivileges(null, null, null);
assertFalse(rs.next());
ResultSetMetaData rsmeta = rs.getMetaData();
assertEquals(rsmeta.getColumnCount(), 7);
assertEquals(rsmeta.getColumnName(1), "TABLE_CAT");
assertEquals(rsmeta.getColumnName(2), "TABLE_SCHEM");
assertEquals(rsmeta.getColumnName(3), "TABLE_NAME");
assertEquals(rsmeta.getColumnName(4), "GRANTOR");
assertEquals(rsmeta.getColumnName(5), "GRANTEE");
assertEquals(rsmeta.getColumnName(6), "PRIVILEGE");
assertEquals(rsmeta.getColumnName(7), "IS_GRANTABLE");
}
public ResultSet getTablePrivileges(String catalog, String schemaPattern, String tableNamePattern)
throws SQLException {
return throwExceptionDelegate.getTablePrivileges(catalog, schemaPattern, tableNamePattern);
}
public void testOne() throws Exception {
Connection conn = newConnection();
PreparedStatement pstmt;
int updateCount;
try {
pstmt = conn.prepareStatement("DROP TABLE t1 IF EXISTS");
pstmt.executeUpdate();
pstmt.close();
pstmt =
conn.prepareStatement(
"CREATE TABLE t1 (cha CHARACTER, dec DECIMAL, doub DOUBLE, lon BIGINT, \"IN\" INTEGER, sma SMALLINT, tin TINYINT, "
+ "dat DATE DEFAULT CURRENT_DATE, tim TIME DEFAULT CURRENT_TIME, timest TIMESTAMP DEFAULT CURRENT_TIMESTAMP );");
updateCount = pstmt.executeUpdate();
assertTrue("expected update count of zero", updateCount == 0);
pstmt = conn.prepareStatement("CREATE INDEX t1 ON t1 (cha );");
updateCount = pstmt.executeUpdate();
pstmt = conn.prepareStatement("DROP TABLE t2 IF EXISTS");
updateCount = pstmt.executeUpdate();
pstmt =
conn.prepareStatement(
"CREATE TABLE t2 (cha CHARACTER, dec DECIMAL, doub DOUBLE, lon BIGINT, \"IN\" INTEGER, sma SMALLINT, tin TINYINT, "
+ "dat DATE DEFAULT CURRENT_DATE, tim TIME DEFAULT CURRENT_TIME, timest TIMESTAMP DEFAULT CURRENT_TIMESTAMP );");
updateCount = pstmt.executeUpdate();
pstmt = conn.prepareStatement("CREATE INDEX t2 ON t2 (cha );");
updateCount = pstmt.executeUpdate();
DatabaseMetaData dbmd = conn.getMetaData();
ResultSet rsp = dbmd.getTablePrivileges(null, null, "T1");
while (rsp.next()) {
System.out.println("Table: " + rsp.getString(3) + " priv: " + rsp.getString(6));
}
rsp = dbmd.getIndexInfo(null, null, "T1", false, false);
while (rsp.next()) {
System.out.println("Table: " + rsp.getString(3) + " IndexName: " + rsp.getString(6));
}
rsp = dbmd.getIndexInfo(null, null, "T2", false, false);
while (rsp.next()) {
System.out.println("Table: " + rsp.getString(3) + " IndexName: " + rsp.getString(6));
}
pstmt = conn.prepareStatement("DROP INDEX t2;");
updateCount = pstmt.executeUpdate();
rsp = dbmd.getIndexInfo(null, null, "T2", false, false);
assertTrue("expected getIndexInfo returns empty resultset", rsp.next() == false);
ResultSet rs = dbmd.getTables(null, null, "T1", new String[] {"TABLE"});
ArrayList tablesarr = new ArrayList();
int i;
for (i = 0; rs.next(); i++) {
String tempstr = rs.getString("TABLE_NAME").trim().toLowerCase();
tablesarr.add(tempstr);
}
rs.close();
assertTrue("expected table t1 count of 1", i == 1);
Iterator it = tablesarr.iterator();
for (; it.hasNext(); ) {
// create new ArrayList and HashMap for the table
String tablename = ((String) it.next()).trim();
List collist = new ArrayList(30);
rs = dbmd.getColumns(null, null, tablename.toUpperCase(), null);
for (i = 0; rs.next(); i++) {
collist.add(rs.getString("COLUMN_NAME").trim().toLowerCase());
}
rs.close();
}
pstmt = conn.prepareStatement("DROP TABLE t_1 IF EXISTS");
pstmt.executeUpdate();
pstmt.close();
pstmt =
conn.prepareStatement(
"CREATE TABLE t_1 (cha CHARACTER(10), deci DECIMAL(10,2), doub DOUBLE, lon BIGINT, \"IN\" INTEGER, sma SMALLINT, tin TINYINT, "
+ "dat DATE DEFAULT CURRENT_DATE, tim TIME DEFAULT CURRENT_TIME, timest TIMESTAMP DEFAULT CURRENT_TIMESTAMP, bool BOOLEAN );");
updateCount = pstmt.executeUpdate();
assertTrue("expected update count of zero", updateCount == 0);
rs = dbmd.getTables(null, null, "T\\_1", new String[] {"TABLE"});
for (i = 0; rs.next(); i++) {
String tempstr = rs.getString("TABLE_NAME").trim().toLowerCase();
tablesarr.add(tempstr);
}
rs.close();
assertTrue("expected table t_1 count of 1", i == 1);
// test various methods
dbmd.getPrimaryKeys(null, null, "T_1");
dbmd.getImportedKeys(null, null, "T_1");
dbmd.getCrossReference(null, null, "T_1", null, null, "T_1");
// test ResultSetMetaData
pstmt = conn.prepareStatement("INSERT INTO T_1 (cha, deci, doub) VALUES ('name', 10.23, 0)");
pstmt.executeUpdate();
pstmt.close();
pstmt = conn.prepareStatement("SELECT * FROM T_1");
rs = pstmt.executeQuery();
ResultSetMetaData md = rs.getMetaData();
int x = md.getColumnDisplaySize(1);
int y = md.getColumnDisplaySize(2);
int b = md.getPrecision(2);
int c = md.getScale(1);
int d = md.getScale(2);
String e = md.getColumnClassName(10);
boolean testresult =
(x == 10)
&& (y == 12)
&& (b == 10)
&& (c == 0)
&& (d == 2)
&& e.equals("java.sql.Timestamp");
assertTrue("wrong result metadata", testresult);
e = md.getColumnClassName(11);
testresult = e.equals("java.lang.Boolean");
assertTrue("wrong result metadata", testresult);
pstmt.close();
//
} catch (Exception e) {
assertTrue("unable to prepare or execute DDL", false);
} finally {
conn.close();
}
}