26566491872

Committed 28 May 2026 09:28AM UTC coverage: 57.019% (-0.08%) from 57.099%

Build # 26566491872

Build Type

push

github

Committed by

web-flow

Commit Message

Merge pull request #2337 from HicServices/task/rdmp-378-extraction-pk-parity

Ensure Extraction PK PArity & enabkle Viewing of Archive Trigger

Coverage Stats

11557 of 21809 branches covered (52.99%)

Branch coverage included in aggregate %.

13 of 112 new or added lines in 17 files covered. (11.61%)

32686 of 55785 relevant lines covered (58.59%)

9031.31 hits per line

Source File
Press 'n' to go to next uncovered line, 'b' for previous

0.0

/Rdmp.Core/DataViewing/ViewCohortIdentificationConfigurationSqlCollection.cs

﻿// Copyright (c) The University of Dundee 2018-2021
// This file is part of the Research Data Management Platform (RDMP).
// RDMP is free software: you can redistribute it and/or modify it under the terms of the GNU General Public License as published by the Free Software Foundation, either version 3 of the License, or (at your option) any later version.
// RDMP is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License for more details.
// You should have received a copy of the GNU General Public License along with RDMP. If not, see <https://www.gnu.org/licenses/>.

using System.Collections.Generic;
using System.Linq;
using FAnsi.Discovery.QuerySyntax;
using Rdmp.Core.Curation.Data;
using Rdmp.Core.Curation.Data.Cohort;
using Rdmp.Core.Curation.Data.Dashboarding;
using Rdmp.Core.QueryBuilding;
using Rdmp.Core.ReusableLibraryCode.DataAccess;


namespace Rdmp.Core.DataViewing;

internal class ViewCohortIdentificationConfigurationSqlCollection : PersistableObjectCollection,
    IViewSQLAndResultsCollection
{
    public bool UseQueryCache { get; set; }
    public bool DisableRun => false;

    public ViewCohortIdentificationConfigurationSqlCollection()
    {
    }

    public ViewCohortIdentificationConfigurationSqlCollection(CohortIdentificationConfiguration config) : this()
    {
        DatabaseObjects.Add(config);
    }

    public IEnumerable<DatabaseEntity> GetToolStripObjects()
    {
        if (UseQueryCache)
        {
            var cache = GetCacheServer();
            if (cache != null)
                yield return cache;
        }
    }

    private ExternalDatabaseServer GetCacheServer() =>
        CohortIdentificationConfiguration is { QueryCachingServer_ID: not null }
            ? CohortIdentificationConfiguration.QueryCachingServer
            : null;


    public IDataAccessPoint GetDataAccessPoint()
    {
        var cache = GetCacheServer();

        if (UseQueryCache && cache != null)
            return cache;

        var builder = new CohortQueryBuilder(CohortIdentificationConfiguration, null);
        builder.RegenerateSQL();
        return new SelfCertifyingDataAccessPoint(builder.Results.TargetServer);
    }

    public string GetSql()
    {
        var builder = new CohortQueryBuilder(CohortIdentificationConfiguration, null);

        if (!UseQueryCache && CohortIdentificationConfiguration.QueryCachingServer_ID.HasValue)
            builder.CacheServer = null;


        return builder.SQL;
    }

    public string GetTabName() => $"View {CohortIdentificationConfiguration}";

    public void AdjustAutocomplete(IAutoCompleteProvider autoComplete)
    {
    }

    private CohortIdentificationConfiguration CohortIdentificationConfiguration =>
        DatabaseObjects.OfType<CohortIdentificationConfiguration>().SingleOrDefault();

    public IQuerySyntaxHelper GetQuerySyntaxHelper() => GetDataAccessPoint()?.GetQuerySyntaxHelper();
}

1	// Copyright (c) The University of Dundee 2018-2021
2	// This file is part of the Research Data Management Platform (RDMP).
3	// RDMP is free software: you can redistribute it and/or modify it under the terms of the GNU General Public License as published by the Free Software Foundation, either version 3 of the License, or (at your option) any later version.
4	// RDMP is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License for more details.
5	// You should have received a copy of the GNU General Public License along with RDMP. If not, see <https://www.gnu.org/licenses/>.
6
7	using System.Collections.Generic;
8	using System.Linq;
9	using FAnsi.Discovery.QuerySyntax;
10	using Rdmp.Core.Curation.Data;
11	using Rdmp.Core.Curation.Data.Cohort;
12	using Rdmp.Core.Curation.Data.Dashboarding;
13	using Rdmp.Core.QueryBuilding;
14	using Rdmp.Core.ReusableLibraryCode.DataAccess;
15
16
17	namespace Rdmp.Core.DataViewing;
18
19	internal class ViewCohortIdentificationConfigurationSqlCollection : PersistableObjectCollection,
20	IViewSQLAndResultsCollection
21	{
22	public bool UseQueryCache { get; set; }	×
NEW 23	public bool DisableRun => false;	×
24
25	public ViewCohortIdentificationConfigurationSqlCollection()	×
26	{
27	}	×
28
29	public ViewCohortIdentificationConfigurationSqlCollection(CohortIdentificationConfiguration config) : this()	×
30	{
31	DatabaseObjects.Add(config);	×
32	}	×
33
34	public IEnumerable<DatabaseEntity> GetToolStripObjects()
35	{
36	if (UseQueryCache)	×
37	{
38	var cache = GetCacheServer();	×
39	if (cache != null)	×
40	yield return cache;	×
41	}
42	}	×
43
44	private ExternalDatabaseServer GetCacheServer() =>
45	CohortIdentificationConfiguration is { QueryCachingServer_ID: not null }	×
46	? CohortIdentificationConfiguration.QueryCachingServer	×
47	: null;	×
48
49
50	public IDataAccessPoint GetDataAccessPoint()
51	{
52	var cache = GetCacheServer();	×
53
54	if (UseQueryCache && cache != null)	×
55	return cache;	×
56
57	var builder = new CohortQueryBuilder(CohortIdentificationConfiguration, null);	×
58	builder.RegenerateSQL();	×
59	return new SelfCertifyingDataAccessPoint(builder.Results.TargetServer);	×
60	}
61
62	public string GetSql()
63	{
64	var builder = new CohortQueryBuilder(CohortIdentificationConfiguration, null);	×
65
66	if (!UseQueryCache && CohortIdentificationConfiguration.QueryCachingServer_ID.HasValue)	×
67	builder.CacheServer = null;	×
68
69
70	return builder.SQL;	×
71	}
72
73	public string GetTabName() => $"View {CohortIdentificationConfiguration}";	×
74
75	public void AdjustAutocomplete(IAutoCompleteProvider autoComplete)
76	{
77	}	×
78
79	private CohortIdentificationConfiguration CohortIdentificationConfiguration =>
80	DatabaseObjects.OfType<CohortIdentificationConfiguration>().SingleOrDefault();	×
81
82	public IQuerySyntaxHelper GetQuerySyntaxHelper() => GetDataAccessPoint()?.GetQuerySyntaxHelper();	×
83	}

HicServices / RDMP / 26566491872

Source File Press 'n' to go to next uncovered line, 'b' for previous

Source File
Press 'n' to go to next uncovered line, 'b' for previous