mirror of
https://github.com/bitwarden/server.git
synced 2026-04-12 00:31:55 -05:00
0a14d95779
* PM-32517 initial migration commit * pm-32517 fixing integration unit test * PM-32517 removing .claude changes * PM-32517 changing implementation of migration test * PM-32517 adding type for ReportFile * PM-32517 adding report file type * PM-32517 changing unit tests * PM-32517 adding new statement in migration script
139 lines
4.2 KiB
Transact-SQL
139 lines
4.2 KiB
Transact-SQL
-- Add ReportFile column to OrganizationReport
|
|
IF COL_LENGTH('[dbo].[OrganizationReport]', 'ReportFile') IS NULL
|
|
BEGIN
|
|
ALTER TABLE [dbo].[OrganizationReport]
|
|
ADD [ReportFile] NVARCHAR(MAX) NULL;
|
|
END
|
|
GO
|
|
|
|
-- Recreate OrganizationReport_Create to include ReportFile
|
|
CREATE OR ALTER PROCEDURE [dbo].[OrganizationReport_Create]
|
|
@Id UNIQUEIDENTIFIER OUTPUT,
|
|
@OrganizationId UNIQUEIDENTIFIER,
|
|
@ReportData NVARCHAR(MAX),
|
|
@CreationDate DATETIME2(7),
|
|
@ContentEncryptionKey VARCHAR(MAX),
|
|
@SummaryData NVARCHAR(MAX),
|
|
@ApplicationData NVARCHAR(MAX),
|
|
@RevisionDate DATETIME2(7),
|
|
@ApplicationCount INT = NULL,
|
|
@ApplicationAtRiskCount INT = NULL,
|
|
@CriticalApplicationCount INT = NULL,
|
|
@CriticalApplicationAtRiskCount INT = NULL,
|
|
@MemberCount INT = NULL,
|
|
@MemberAtRiskCount INT = NULL,
|
|
@CriticalMemberCount INT = NULL,
|
|
@CriticalMemberAtRiskCount INT = NULL,
|
|
@PasswordCount INT = NULL,
|
|
@PasswordAtRiskCount INT = NULL,
|
|
@CriticalPasswordCount INT = NULL,
|
|
@CriticalPasswordAtRiskCount INT = NULL,
|
|
@ReportFile NVARCHAR(MAX) = NULL
|
|
AS
|
|
BEGIN
|
|
SET NOCOUNT ON;
|
|
|
|
INSERT INTO [dbo].[OrganizationReport](
|
|
[Id],
|
|
[OrganizationId],
|
|
[ReportData],
|
|
[CreationDate],
|
|
[ContentEncryptionKey],
|
|
[SummaryData],
|
|
[ApplicationData],
|
|
[RevisionDate],
|
|
[ApplicationCount],
|
|
[ApplicationAtRiskCount],
|
|
[CriticalApplicationCount],
|
|
[CriticalApplicationAtRiskCount],
|
|
[MemberCount],
|
|
[MemberAtRiskCount],
|
|
[CriticalMemberCount],
|
|
[CriticalMemberAtRiskCount],
|
|
[PasswordCount],
|
|
[PasswordAtRiskCount],
|
|
[CriticalPasswordCount],
|
|
[CriticalPasswordAtRiskCount],
|
|
[ReportFile]
|
|
)
|
|
VALUES (
|
|
@Id,
|
|
@OrganizationId,
|
|
@ReportData,
|
|
@CreationDate,
|
|
@ContentEncryptionKey,
|
|
@SummaryData,
|
|
@ApplicationData,
|
|
@RevisionDate,
|
|
@ApplicationCount,
|
|
@ApplicationAtRiskCount,
|
|
@CriticalApplicationCount,
|
|
@CriticalApplicationAtRiskCount,
|
|
@MemberCount,
|
|
@MemberAtRiskCount,
|
|
@CriticalMemberCount,
|
|
@CriticalMemberAtRiskCount,
|
|
@PasswordCount,
|
|
@PasswordAtRiskCount,
|
|
@CriticalPasswordCount,
|
|
@CriticalPasswordAtRiskCount,
|
|
@ReportFile
|
|
);
|
|
END
|
|
GO
|
|
|
|
-- Recreate OrganizationReport_Update to include ReportFile
|
|
CREATE OR ALTER PROCEDURE [dbo].[OrganizationReport_Update]
|
|
@Id UNIQUEIDENTIFIER,
|
|
@OrganizationId UNIQUEIDENTIFIER,
|
|
@ReportData NVARCHAR(MAX),
|
|
@CreationDate DATETIME2(7),
|
|
@ContentEncryptionKey VARCHAR(MAX),
|
|
@SummaryData NVARCHAR(MAX),
|
|
@ApplicationData NVARCHAR(MAX),
|
|
@RevisionDate DATETIME2(7),
|
|
@ApplicationCount INT = NULL,
|
|
@ApplicationAtRiskCount INT = NULL,
|
|
@CriticalApplicationCount INT = NULL,
|
|
@CriticalApplicationAtRiskCount INT = NULL,
|
|
@MemberCount INT = NULL,
|
|
@MemberAtRiskCount INT = NULL,
|
|
@CriticalMemberCount INT = NULL,
|
|
@CriticalMemberAtRiskCount INT = NULL,
|
|
@PasswordCount INT = NULL,
|
|
@PasswordAtRiskCount INT = NULL,
|
|
@CriticalPasswordCount INT = NULL,
|
|
@CriticalPasswordAtRiskCount INT = NULL,
|
|
@ReportFile NVARCHAR(MAX) = NULL
|
|
AS
|
|
BEGIN
|
|
SET NOCOUNT ON;
|
|
UPDATE [dbo].[OrganizationReport]
|
|
SET
|
|
[OrganizationId] = @OrganizationId,
|
|
[ReportData] = @ReportData,
|
|
[CreationDate] = @CreationDate,
|
|
[ContentEncryptionKey] = @ContentEncryptionKey,
|
|
[SummaryData] = @SummaryData,
|
|
[ApplicationData] = @ApplicationData,
|
|
[RevisionDate] = @RevisionDate,
|
|
[ApplicationCount] = @ApplicationCount,
|
|
[ApplicationAtRiskCount] = @ApplicationAtRiskCount,
|
|
[CriticalApplicationCount] = @CriticalApplicationCount,
|
|
[CriticalApplicationAtRiskCount] = @CriticalApplicationAtRiskCount,
|
|
[MemberCount] = @MemberCount,
|
|
[MemberAtRiskCount] = @MemberAtRiskCount,
|
|
[CriticalMemberCount] = @CriticalMemberCount,
|
|
[CriticalMemberAtRiskCount] = @CriticalMemberAtRiskCount,
|
|
[PasswordCount] = @PasswordCount,
|
|
[PasswordAtRiskCount] = @PasswordAtRiskCount,
|
|
[CriticalPasswordCount] = @CriticalPasswordCount,
|
|
[CriticalPasswordAtRiskCount] = @CriticalPasswordAtRiskCount,
|
|
[ReportFile] = @ReportFile
|
|
WHERE [Id] = @Id;
|
|
END;
|
|
GO
|
|
|
|
EXECUTE sp_refreshview N'[dbo].[OrganizationReportView]';
|
|
GO
|