Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

v1.9.2 #82

Merged
merged 20 commits into from
Nov 19, 2020
Merged
Show file tree
Hide file tree
Changes from 1 commit
Commits
File filter

Filter by extension

Filter by extension

Conversations
Failed to load comments.
Loading
Jump to
Jump to file
Failed to load files.
Loading
Diff view
Diff view
Next Next commit
Validation proc added
  • Loading branch information
mrpaulandrew committed Nov 13, 2020
commit ab79af0e0ad88aab1c1f80de2ef083c24882b9f8
1 change: 1 addition & 0 deletions MetadataDB/MetadataDB.sqlproj
Original file line number Diff line number Diff line change
Expand Up @@ -208,6 +208,7 @@
<Build Include="procfwk\Tables\BatchStageLink.sql" />
<Build Include="procfwkHelpers\Stored Procedures\SetDefaultBatchStageLink.sql" />
<Build Include="procfwk\Stored Procedures\CheckPreviousExeuction.sql" />
<Build Include="procfwk\Stored Procedures\SetLogPipelineValidating.sql" />
</ItemGroup>
<ItemGroup>
<PostDeploy Include="Scripts\Script.PostDeployment.sql" />
Expand Down
19 changes: 19 additions & 0 deletions MetadataDB/procfwk/Stored Procedures/SetLogPipelineValidating.sql
Original file line number Diff line number Diff line change
@@ -0,0 +1,19 @@
CREATE PROCEDURE [procfwk].[SetLogPipelineValidating]
(
@ExecutionId UNIQUEIDENTIFIER,
@StageId INT,
@PipelineId INT
)
AS
BEGIN
SET NOCOUNT ON;

UPDATE
[procfwk].[CurrentExecution]
SET
[PipelineStatus] = 'Validating'
WHERE
[LocalExecutionId] = @ExecutionId
AND [StageId] = @StageId
AND [PipelineId] = @PipelineId
END;