test_Rollup.test tam kosu son tam gunden sonraki eksik gunleri tamamlar ve son tam gunu ilerletir

CREATE   PROCEDURE test_Rollup.[test tam kosu son tam gunden sonraki eksik gunleri tamamlar ve son tam gunu ilerletir]
AS
BEGIN
    EXEC test_Rollup.KosuHazirla;
    DECLARE @today datetime = CAST(CAST(DBA.fn_Now() AS date) AS datetime);
    DECLARE @y datetime = DATEADD(day, -1, @today), @d2 datetime = DATEADD(day, -2, @today), @d3 datetime = DATEADD(day, -3, @today);
    -- Son tam gün bugün-4: bugün-3 ve bugün-2 geceleri kaçmış
    INSERT DBA.CollectionWatermark (ServerID, DatabaseName, SourceType, LastValue)
    VALUES (0, N'(tümü)', 'ROLLUP', CONVERT(bigint, CONVERT(char(8), DATEADD(day, -4, @today), 112)));
    EXEC test_Rollup.GunEkle @d3, 3;
    EXEC test_Rollup.GunEkle @y, 4;
    EXEC test_Rollup.GunEkle @today, 5;

    EXEC DBA.usp_Rollup_Daily;

    DECLARE @days nvarchar(200) = (SELECT STRING_AGG(CONVERT(char(10), StatDateUtc, 23), ',') WITHIN GROUP (ORDER BY StatDateUtc)
                                   FROM perf.QueryDailyStats WHERE StatDateUtc >= @d3),
            @prof nvarchar(200) = (SELECT STRING_AGG(CONVERT(char(10), StatDateUtc, 23), ',') WITHIN GROUP (ORDER BY StatDateUtc)
                                   FROM rag.usp_EmbedQueue_EnqueueProfiles_SpyProcedureLog),
            @imp int = (SELECT COUNT(*) FROM rag.usp_AnalysisImpact_Measure_SpyProcedureLog),
            @mark int = (SELECT COUNT(*) FROM rag.usp_QueryCandidates_Mark_SpyProcedureLog),
            @wm bigint = (SELECT LastValue FROM DBA.CollectionWatermark WHERE ServerID = 0 AND SourceType = 'ROLLUP'),
            @log nvarchar(100) = (SELECT CONCAT(Status, N'/', RowsLoaded) FROM DBA.CollectionRunLog WHERE SourceType = 'ROLLUP');
    DECLARE @expDays nvarchar(200) = CONCAT(CONVERT(char(10), @d3, 23), N',', CONVERT(char(10), @y, 23), N',', CONVERT(char(10), @today, 23)),
            @expProf nvarchar(200) = CONCAT(CONVERT(char(10), @d3, 23), N',', CONVERT(char(10), @d2, 23), N',', CONVERT(char(10), @y, 23)),
            @expWm bigint = CONVERT(bigint, CONVERT(char(8), @y, 112));
    EXEC tSQLt.AssertEqualsString @expDays, @days;
    EXEC tSQLt.AssertEqualsString @expProf, @prof;   -- bugün profil kuyruğuna girmez
    EXEC tSQLt.AssertEquals 1, @imp;
    EXEC tSQLt.AssertEquals 1, @mark;
    EXEC tSQLt.AssertEquals @expWm, @wm;
    EXEC tSQLt.AssertEqualsString N'OK/3', @log;
END;