diff options
| author | John Bintz <193517688+john-bintz-sonarsource@users.noreply.github.com> | 2025-04-11 10:16:41 -0400 |
|---|---|---|
| committer | sonartech <sonartech@sonarsource.com> | 2025-04-11 20:04:02 +0000 |
| commit | 6055f2e52a73cfea7b10c988209ae4b3c3ba71e0 (patch) | |
| tree | 514c2db8a987e24dfe6dbb61da7051a3331a27cd /server/sonar-db-dao | |
| parent | 45f227ecdfe0268d62ca16b89e6d9d0b53349f99 (diff) | |
| download | sonarqube-master.tar.gz sonarqube-master.zip | |
Co-authored-by: Havoc Pennington <havoc.pennington@sonarsource.com>
Diffstat (limited to 'server/sonar-db-dao')
| -rw-r--r-- | server/sonar-db-dao/src/it/java/org/sonar/db/purge/PurgeDaoIT.java | 3 | ||||
| -rw-r--r-- | server/sonar-db-dao/src/schema/schema-sq.ddl | 8 |
2 files changed, 6 insertions, 5 deletions
diff --git a/server/sonar-db-dao/src/it/java/org/sonar/db/purge/PurgeDaoIT.java b/server/sonar-db-dao/src/it/java/org/sonar/db/purge/PurgeDaoIT.java index b06fe15e72f..e1fb868b7c0 100644 --- a/server/sonar-db-dao/src/it/java/org/sonar/db/purge/PurgeDaoIT.java +++ b/server/sonar-db-dao/src/it/java/org/sonar/db/purge/PurgeDaoIT.java @@ -1980,13 +1980,14 @@ oldCreationDate)); "license_expression", "MIT", "known", true, "known_package", true, + "is_new", false, "created_at", 0L, "updated_at", 0L); db.executeInsert("sca_releases", merge(releaseBase, Map.of("uuid", "release-uuid1", "component_uuid", branch1Uuid))); db.executeInsert("sca_releases", merge(releaseBase, Map.of("uuid", "release-uuid2", "component_uuid", branch2Uuid))); assertThat(db.countRowsOfTable(dbSession, "sca_releases")).isEqualTo(2); var dependencyBase = Map.of("created_at", 0L, "updated_at", 0L, - "direct", true, "scope", "compile", "new_in_pull_request", true); + "direct", true, "scope", "compile", "is_new", true); db.executeInsert("sca_dependencies", merge(dependencyBase, Map.of("uuid", "dependency-uuid1", "sca_release_uuid", "release-uuid1"))); db.executeInsert("sca_dependencies", merge(dependencyBase, Map.of("uuid", "dependency-uuid2", "sca_release_uuid", "release-uuid2"))); assertThat(db.countRowsOfTable(dbSession, "sca_dependencies")).isEqualTo(2); diff --git a/server/sonar-db-dao/src/schema/schema-sq.ddl b/server/sonar-db-dao/src/schema/schema-sq.ddl index d102e2cd209..3ca28a1b342 100644 --- a/server/sonar-db-dao/src/schema/schema-sq.ddl +++ b/server/sonar-db-dao/src/schema/schema-sq.ddl @@ -1052,8 +1052,8 @@ CREATE TABLE "SCA_DEPENDENCIES"( "CHAINS" CHARACTER LARGE OBJECT, "CREATED_AT" BIGINT NOT NULL, "UPDATED_AT" BIGINT NOT NULL, - "NEW_IN_PULL_REQUEST" BOOLEAN DEFAULT FALSE NOT NULL, - "PRODUCTION_SCOPE" BOOLEAN DEFAULT TRUE NOT NULL + "PRODUCTION_SCOPE" BOOLEAN DEFAULT TRUE NOT NULL, + "IS_NEW" BOOLEAN DEFAULT FALSE NOT NULL ); ALTER TABLE "SCA_DEPENDENCIES" ADD CONSTRAINT "PK_SCA_DEPENDENCIES" PRIMARY KEY("UUID"); CREATE INDEX "SCA_DEPENDENCIES_RELEASE_UUID" ON "SCA_DEPENDENCIES"("SCA_RELEASE_UUID" NULLS FIRST); @@ -1096,9 +1096,9 @@ CREATE TABLE "SCA_RELEASES"( "KNOWN" BOOLEAN NOT NULL, "CREATED_AT" BIGINT NOT NULL, "UPDATED_AT" BIGINT NOT NULL, - "NEW_IN_PULL_REQUEST" BOOLEAN DEFAULT FALSE NOT NULL, "DECLARED_LICENSE_EXPRESSION" CHARACTER VARYING(400) DEFAULT 'NOASSERTION' NOT NULL, - "KNOWN_PACKAGE" BOOLEAN NOT NULL + "KNOWN_PACKAGE" BOOLEAN NOT NULL, + "IS_NEW" BOOLEAN DEFAULT FALSE NOT NULL ); ALTER TABLE "SCA_RELEASES" ADD CONSTRAINT "PK_SCA_RELEASES" PRIMARY KEY("UUID"); CREATE INDEX "SCA_RELEASES_COMP_UUID_UUID" ON "SCA_RELEASES"("COMPONENT_UUID" NULLS FIRST, "UUID" NULLS FIRST); |