/*******************************************************************************
* Cloud Foundry
* Copyright (c) [2009-2016] Pivotal Software, Inc. All Rights Reserved.
*
* This product is licensed to you under the Apache License, Version 2.0 (the "License").
* You may not use this product except in compliance with the License.
*
* This product includes a number of subcomponents with
* separate copyright notices and license terms. Your use of these
* subcomponents is subject to the terms and conditions of the
* subcomponent's license, as noted in the LICENSE file.
*******************************************************************************/
package org.cloudfoundry.identity.uaa.db;
import java.sql.Connection;
import java.sql.DatabaseMetaData;
import java.sql.ResultSet;
import java.util.Arrays;
import static org.junit.Assert.assertEquals;
import static org.junit.Assert.assertTrue;
import org.apache.commons.logging.Log;
import org.apache.commons.logging.LogFactory;
import org.cloudfoundry.identity.uaa.test.JdbcTestBase;
import org.junit.Assume;
import org.junit.Before;
import org.junit.Test;
public class TableAndColumnNormalizationTest extends JdbcTestBase {
private final Log logger = LogFactory.getLog(getClass());
@Before
public void checkMysqlOrPostgresqlProfile() {
Assume.assumeTrue(
Arrays.asList(webApplicationContext.getEnvironment().getActiveProfiles()).contains("mysql") ||
Arrays.asList(webApplicationContext.getEnvironment().getActiveProfiles()).contains("postgresql")
);
}
@Test
public void checkTables() throws Exception {
Connection connection = dataSource.getConnection();
try {
DatabaseMetaData metaData = connection.getMetaData();
ResultSet rs = metaData.getTables(null, null, null, new String[] { "TABLE" });
int count = 0;
while (rs.next()) {
String name = rs.getString("TABLE_NAME");
logger.info("Checking table [" + name + "]");
if (name != null && DatabaseInformation1_5_3.tableNames.contains(name.toLowerCase())) {
count++;
logger.info("Validating table [" + name + "]");
assertTrue("Table[" + name + "] is not lower case.", name.toLowerCase().equals(name));
}
}
assertEquals("Table count:", DatabaseInformation1_5_3.tableNames.size(), count);
} finally {
try {
connection.close();
} catch (Exception ignore) {
}
}
}
@Test
public void checkColumns() throws Exception {
Connection connection = dataSource.getConnection();
try {
DatabaseMetaData metaData = connection.getMetaData();
ResultSet rs = metaData.getColumns(null, null, null, null);
int count = 0;
while (rs.next()) {
String name = rs.getString("TABLE_NAME");
String col = rs.getString("COLUMN_NAME");
logger.info("Checking column [" + name + "." + col + "]");
if (name != null && DatabaseInformation1_5_3.tableNames.contains(name.toLowerCase())) {
logger.info("Validating column [" + name + "." + col + "]");
assertTrue("Column[" + name + "." + col + "] is not lower case.", col.toLowerCase().equals(col));
}
}
} finally {
try {
connection.close();
} catch (Exception ignore) {
}
}
}
}