< Summary

Information

Class:	Elsa.Secrets.Persistence.EFCore.SqlServer.Migrations.Secrets.SecretDefaultTenantUniqueness
Assembly:	Elsa.Secrets.Persistence.EFCore.SqlServer
File(s):	File 1: /home/runner/work/elsa-core/elsa-core/src/modules/Elsa.Secrets.Persistence.EFCore.SqlServer/Migrations/Secrets/20260914120000_SecretDefaultTenantUniqueness.cs File 2: /home/runner/work/elsa-core/elsa-core/src/modules/Elsa.Secrets.Persistence.EFCore.SqlServer/Migrations/Secrets/20260914120000_SecretDefaultTenantUniqueness.Designer.cs

Line coverage

91%

Covered lines:	137
Uncovered lines:	12
Coverable lines:	149
Total lines:	205
Line coverage:	91.9%

Branch coverage

N/A

Covered branches:	0
Total branches:	0
Branch coverage:	N/A

Method coverage

Feature is only available for sponsors

Upgrade to PRO version

Metrics

Method	Branch coverage	Crap Score	Cyclomatic complexity	Line coverage
File 1: .ctor(...)	100%	1	1	100%
File 1: Up(...)	100%	1	1	100%
File 1: Down(...)	100%	2	1	0%
File 2: BuildTargetModel(...)	100%	1	1	100%

File(s)

/home/runner/work/elsa-core/elsa-core/src/modules/Elsa.Secrets.Persistence.EFCore.SqlServer/Migrations/Secrets/20260914120000_SecretDefaultTenantUniqueness.cs

#	Line	Line coverage
	`1`	`using Microsoft.EntityFrameworkCore.Migrations;`
	`2`
	`3`	`#nullable disable`
	`4`
	`5`	`namespace Elsa.Secrets.Persistence.EFCore.SqlServer.Migrations.Secrets`
	`6`	`{`
	`7`	`/// <inheritdoc />`
	`8`	`public partial class SecretDefaultTenantUniqueness : Migration`
	`9`	`{`
	`10`	`private readonly Elsa.Persistence.EFCore.IElsaDbContextSchema _schema;`
	`11`
	`12`	`/// <inheritdoc />`
2	`13`	`public SecretDefaultTenantUniqueness(Elsa.Persistence.EFCore.IElsaDbContextSchema schema)`
	`14`	`{`
2	`15`	`_schema = schema;`
2	`16`	`}`
	`17`
	`18`	`/// <inheritdoc />`
	`19`	`protected override void Up(MigrationBuilder migrationBuilder)`
	`20`	`{`
2	`21`	`migrationBuilder.DropIndex(`
2	`22`	`name: "IX_Secret_TenantId_NormalizedName",`
2	`23`	`schema: _schema.Schema,`
2	`24`	`table: "Secrets");`
	`25`
	`26`	`// Default tenant is "" (not null). Stamp leftover nulls so the filtered unique`
	`27`	`// index (TenantId IS NOT NULL) covers them. Duplicates are not deleted.`
2	`28`	`migrationBuilder.Sql($"""`
2	`29`	`UPDATE [{_schema.Schema}].[Secrets]`
2	`30`	`SET [TenantId] = N''`
2	`31`	`WHERE [TenantId] IS NULL;`
2	`32`	`""");`
	`33`
	`34`	`// No silent dedupe. List leftover keys and abort; operators must resolve them before upgrading.`
2	`35`	`migrationBuilder.Sql($"""`
2	`36`	`IF EXISTS (`
2	`37`	`SELECT 1`
2	`38`	`FROM [{_schema.Schema}].[Secrets]`
2	`39`	`GROUP BY [TenantId], [NormalizedName]`
2	`40`	`HAVING COUNT(*) > 1`
2	`41`	`)`
2	`42`	`BEGIN`
2	`43`	`DECLARE @DuplicateKeys nvarchar(max);`
2	`44`
2	`45`	`SELECT @DuplicateKeys = STRING_AGG(`
2	`46`	`CAST(CONCAT(N'(', ISNULL([TenantId], N'<null>'), N', ', [NormalizedName], N')') AS nvarchar(max)`
2	`47`	`N'; '`
2	`48`	`)`
2	`49`	`FROM (`
2	`50`	`SELECT [TenantId], [NormalizedName]`
2	`51`	`FROM [{_schema.Schema}].[Secrets]`
2	`52`	`GROUP BY [TenantId], [NormalizedName]`
2	`53`	`HAVING COUNT(*) > 1`
2	`54`	`) AS Duplicates;`
2	`55`
2	`56`	`DECLARE @ErrorMessage nvarchar(2048);`
2	`57`	`SET @ErrorMessage = CONCAT(`
2	`58`	`N'Cannot create unique index IX_Secret_TenantId_NormalizedName because leftover duplicate (Tenan`
2	`59`	`LEFT(@DuplicateKeys, 1500)`
2	`60`	`);`
2	`61`	`THROW 50001, @ErrorMessage, 1;`
2	`62`	`END`
2	`63`	`""");`
	`64`
2	`65`	`migrationBuilder.CreateIndex(`
2	`66`	`name: "IX_Secret_TenantId_NormalizedName",`
2	`67`	`schema: _schema.Schema,`
2	`68`	`table: "Secrets",`
2	`69`	`columns: new[] { "TenantId", "NormalizedName" },`
2	`70`	`unique: true,`
2	`71`	`filter: "[TenantId] IS NOT NULL");`
2	`72`	`}`
	`73`
	`74`	`/// <inheritdoc />`
	`75`	`protected override void Down(MigrationBuilder migrationBuilder)`
	`76`	`{`
0	`77`	`migrationBuilder.DropIndex(`
0	`78`	`name: "IX_Secret_TenantId_NormalizedName",`
0	`79`	`schema: _schema.Schema,`
0	`80`	`table: "Secrets");`
	`81`
0	`82`	`migrationBuilder.CreateIndex(`
0	`83`	`name: "IX_Secret_TenantId_NormalizedName",`
0	`84`	`schema: _schema.Schema,`
0	`85`	`table: "Secrets",`
0	`86`	`columns: new[] { "TenantId", "NormalizedName" },`
0	`87`	`unique: true,`
0	`88`	`filter: "[TenantId] IS NOT NULL");`
0	`89`	`}`
	`90`	`}`
	`91`	`}`

/home/runner/work/elsa-core/elsa-core/src/modules/Elsa.Secrets.Persistence.EFCore.SqlServer/Migrations/Secrets/20260914120000_SecretDefaultTenantUniqueness.Designer.cs

#	Line	Line coverage
	`1`	`// <auto-generated />`
	`2`	`using System;`
	`3`	`using Elsa.Secrets.Persistence.EFCore;`
	`4`	`using Microsoft.EntityFrameworkCore;`
	`5`	`using Microsoft.EntityFrameworkCore.Infrastructure;`
	`6`	`using Microsoft.EntityFrameworkCore.Metadata;`
	`7`	`using Microsoft.EntityFrameworkCore.Migrations;`
	`8`	`using Microsoft.EntityFrameworkCore.Storage.ValueConversion;`
	`9`
	`10`	`#nullable disable`
	`11`
	`12`	`namespace Elsa.Secrets.Persistence.EFCore.SqlServer.Migrations.Secrets`
	`13`	`{`
	`14`	`[DbContext(typeof(SecretsElsaDbContext))]`
	`15`	`[Migration("20260914120000_SecretDefaultTenantUniqueness")]`
	`16`	`partial class SecretDefaultTenantUniqueness`
	`17`	`{`
	`18`	`/// <inheritdoc />`
	`19`	`protected override void BuildTargetModel(ModelBuilder modelBuilder)`
	`20`	`{`
	`21`	`#pragma warning disable 612, 618`
2	`22`	`modelBuilder`
2	`23`	`.HasDefaultSchema("Elsa")`
2	`24`	`.HasAnnotation("ProductVersion", "10.0.9")`
2	`25`	`.HasAnnotation("Relational:MaxIdentifierLength", 128);`
	`26`
2	`27`	`SqlServerModelBuilderExtensions.UseIdentityColumns(modelBuilder);`
	`28`
2	`29`	`modelBuilder.Entity("Elsa.Secrets.Models.Secret", b =>`
2	`30`	`{`
2	`31`	`b.Property<string>("Id")`
2	`32`	`.HasColumnType("nvarchar(450)");`
2	`33`
2	`34`	`b.Property<DateTimeOffset>("CreatedAt")`
2	`35`	`.HasColumnType("datetimeoffset");`
2	`36`
2	`37`	`b.Property<string>("Description")`
2	`38`	`.HasColumnType("nvarchar(max)");`
2	`39`
2	`40`	`b.Property<string>("DisplayName")`
2	`41`	`.IsRequired()`
2	`42`	`.HasMaxLength(200)`
2	`43`	`.HasColumnType("nvarchar(200)");`
2	`44`
2	`45`	`b.Property<string>("Name")`
2	`46`	`.IsRequired()`
2	`47`	`.HasMaxLength(200)`
2	`48`	`.HasColumnType("nvarchar(200)");`
2	`49`
2	`50`	`b.Property<string>("NormalizedName")`
2	`51`	`.IsRequired()`
2	`52`	`.HasMaxLength(200)`
2	`53`	`.HasColumnType("nvarchar(200)");`
2	`54`
2	`55`	`b.Property<string>("Scope")`
2	`56`	`.HasMaxLength(200)`
2	`57`	`.HasColumnType("nvarchar(200)");`
2	`58`
2	`59`	`b.Property<string>("SerializedTags")`
2	`60`	`.IsRequired()`
2	`61`	`.HasColumnType("nvarchar(max)")`
2	`62`	`.HasColumnName("Tags");`
2	`63`
2	`64`	`b.Property<string>("SerializedVersions")`
2	`65`	`.IsRequired()`
2	`66`	`.HasColumnType("nvarchar(max)")`
2	`67`	`.HasColumnName("Versions");`
2	`68`
2	`69`	`b.Property<string>("Status")`
2	`70`	`.IsRequired()`
2	`71`	`.HasMaxLength(32)`
2	`72`	`.HasColumnType("nvarchar(32)");`
2	`73`
2	`74`	`b.Property<string>("StoreName")`
2	`75`	`.IsRequired()`
2	`76`	`.HasMaxLength(100)`
2	`77`	`.HasColumnType("nvarchar(100)");`
2	`78`
2	`79`	`b.Property<string>("TenantId")`
2	`80`	`.HasColumnType("nvarchar(450)");`
2	`81`
2	`82`	`b.Property<string>("TypeName")`
2	`83`	`.IsRequired()`
2	`84`	`.HasMaxLength(100)`
2	`85`	`.HasColumnType("nvarchar(100)");`
2	`86`
2	`87`	`b.Property<DateTimeOffset?>("UpdatedAt")`
2	`88`	`.HasColumnType("datetimeoffset");`
2	`89`
2	`90`	`b.HasKey("Id");`
2	`91`
2	`92`	`b.HasIndex("Scope")`
2	`93`	`.HasDatabaseName("IX_Secret_Scope");`
2	`94`
2	`95`	`b.HasIndex("Status")`
2	`96`	`.HasDatabaseName("IX_Secret_Status");`
2	`97`
2	`98`	`b.HasIndex("StoreName")`
2	`99`	`.HasDatabaseName("IX_Secret_StoreName");`
2	`100`
2	`101`	`b.HasIndex("TypeName")`
2	`102`	`.HasDatabaseName("IX_Secret_TypeName");`
2	`103`
2	`104`	`b.HasIndex("TenantId", "NormalizedName")`
2	`105`	`.IsUnique()`
2	`106`	`.HasDatabaseName("IX_Secret_TenantId_NormalizedName")`
2	`107`	`.HasFilter("[TenantId] IS NOT NULL");`
2	`108`
2	`109`	`b.ToTable("Secrets", "Elsa");`
4	`110`	`});`
	`111`	`#pragma warning restore 612, 618`
2	`112`	`}`
	`113`	`}`
	`114`	`}`

< Summary

Metrics

File(s)

/home/runner/work/elsa-core/elsa-core/src/modules/Elsa.Secrets.Persistence.EFCore.SqlServer/Migrations/Secrets/20260914120000_SecretDefaultTenantUniqueness.cs

/home/runner/work/elsa-core/elsa-core/src/modules/Elsa.Secrets.Persistence.EFCore.SqlServer/Migrations/Secrets/20260914120000_SecretDefaultTenantUniqueness.Designer.cs

Methods/Properties