From 42c37450359276e494538931c00d22db1dfb7ee1 Mon Sep 17 00:00:00 2001 From: Julien Lancelot Date: Fri, 27 Mar 2020 10:51:09 +0100 Subject: SONAR-13221 Set primary key of 'EVENTS' table to column 'UUID' and drop 'ID' --- .../src/testFixtures/java/org/sonar/db/AbstractDbTester.java | 12 ++++++++++++ 1 file changed, 12 insertions(+) (limited to 'server/sonar-db-core') diff --git a/server/sonar-db-core/src/testFixtures/java/org/sonar/db/AbstractDbTester.java b/server/sonar-db-core/src/testFixtures/java/org/sonar/db/AbstractDbTester.java index 4daa7612714..2595ae70ae3 100644 --- a/server/sonar-db-core/src/testFixtures/java/org/sonar/db/AbstractDbTester.java +++ b/server/sonar-db-core/src/testFixtures/java/org/sonar/db/AbstractDbTester.java @@ -357,6 +357,18 @@ public class AbstractDbTester extends ExternalResource { } } + public void assertNoPrimaryKey(String tableName) { + try (Connection connection = getConnection()) { + PK pk = pkOf(connection, tableName.toUpperCase(Locale.ENGLISH)); + if (pk == null) { + pkOf(connection, tableName.toLowerCase(Locale.ENGLISH)); + } + assertThat(pk).as("Primary key is still defined on table %s", tableName).isNull(); + } catch (SQLException e) { + throw new IllegalStateException("Fail to check primary key", e); + } + } + @CheckForNull private PK pkOf(Connection connection, String tableName) throws SQLException { try (ResultSet resultSet = connection.getMetaData().getPrimaryKeys(null, null, tableName)) { -- cgit v1.2.3