19852309549

Committed 02 Dec 2025 08:38AM UTC coverage: 55.8% (-1.4%) from 57.197%

Build # 19852309549

Build Type

Pull #2279

github

Committed by

JFriel

Commit Message

fix build

Pull Request Pull Request #2279: [UI Overhaul] Spike/refresh

Run Details

11249 of 21727 branches covered (51.77%)

Branch coverage included in aggregate %.

807 of 1108 new or added lines in 29 files covered. (72.83%)

724 existing lines in 67 files now uncovered.

31893 of 55588 relevant lines covered (57.37%)

16683.65 hits per line

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

75.61

/Rdmp.Core/Curation/Data/ExtractionFilterParameterSetValue.cs

// Copyright (c) The University of Dundee 2018-2019
// 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;
using System.Collections.Generic;
using System.Data.Common;
using FAnsi.Discovery.QuerySyntax;
using Rdmp.Core.MapsDirectlyToDatabaseTable;
using Rdmp.Core.MapsDirectlyToDatabaseTable.Attributes;
using Rdmp.Core.MapsDirectlyToDatabaseTable.Injection;
using Rdmp.Core.QueryBuilding.SyntaxChecking;
using Rdmp.Core.Repositories;
using Rdmp.Core.ReusableLibraryCode.Checks;

namespace Rdmp.Core.Curation.Data;

/// <summary>
/// Stores a known specific useful value for a given ExtractionFilterParameter.  See <see cref="Data.ExtractionFilterParameterSet"/> for a use case for this.
/// </summary>
public class ExtractionFilterParameterSetValue : DatabaseEntity, ISqlParameter, IInjectKnown<ExtractionFilterParameter>
{
    #region Database Properties

    private string _value;
    private int _extractionFilterParameterSetID;
    private int _extractionFilterParameterID;

    /// <summary>
    /// The 'known good parameter set' (<see cref="ExtractionFilterParameterSet"/>) to which this parameter value belongs
    /// </summary>
    public int ExtractionFilterParameterSet_ID
    {
        get => _extractionFilterParameterSetID;
        set => SetField(ref _extractionFilterParameterSetID, value);
    }

    /// <summary>
    /// The specific parameter that this object is providing a 'known value' for in the parent <see cref="ExtractionFilter"/> e.g. @DrugList='123.2,123.2,... etc'.
    /// </summary>
    public int ExtractionFilterParameter_ID
    {
        get => _extractionFilterParameterID;
        set => SetField(ref _extractionFilterParameterID, value);
    }

    /// <inheritdoc/>
    [Sql]
    public string Value
    {
        get => _value;
        set => SetField(ref _value, value);
    }

    #endregion

    #region cached values stored so we can act like a readonly ISqlParameter but secretly only Value will actually be changeable

    private Lazy<ExtractionFilterParameter> _knownExtractionFilterParameter;

    /// <inheritdoc/>
    /// <remarks>Readonly, fetched from associated <see cref="ExtractionFilterParameter_ID"/></remarks>
    [NoMappingToDatabase]
    public string ParameterName => _knownExtractionFilterParameter.Value.ParameterName;

    /// <inheritdoc/>
    /// <remarks>Readonly, fetched from associated <see cref="ExtractionFilterParameter_ID"/></remarks>
    [Sql]
    [NoMappingToDatabase]
    public string ParameterSQL
    {
        get => _knownExtractionFilterParameter.Value.ParameterSQL;
        set { }
    }

    /// <inheritdoc/>
    /// <remarks>Readonly, fetched from associated <see cref="ExtractionFilterParameter_ID"/></remarks>
    [NoMappingToDatabase]
    public string Comment
    {
        get => _knownExtractionFilterParameter.Value.Comment;
        set { }
    }

    /// <summary>
    /// Returns the <see cref="ExtractionFilterParameterSet"/> this known good value belongs to
    /// </summary>
    /// <returns></returns>
    public IMapsDirectlyToDatabaseTable GetOwnerIfAny() => ExtractionFilterParameterSet;

    #endregion

    #region Relationships

    /// <inheritdoc cref="ExtractionFilterParameterSet_ID"/>
    [NoMappingToDatabase]
    public ExtractionFilterParameterSet ExtractionFilterParameterSet =>
        Repository.GetObjectByID<ExtractionFilterParameterSet>(ExtractionFilterParameterSet_ID);

    /// <inheritdoc cref="ExtractionFilterParameter_ID"/>
    [NoMappingToDatabase]
    public ExtractionFilterParameter ExtractionFilterParameter => _knownExtractionFilterParameter.Value;

    #endregion


    public ExtractionFilterParameterSetValue()
    {
        ClearAllInjections();
    }

    internal ExtractionFilterParameterSetValue(ICatalogueRepository repository, DbDataReader r)
        : base(repository, r)
    {
        ExtractionFilterParameterSet_ID = Convert.ToInt32(r["ExtractionFilterParameterSet_ID"]);
        ExtractionFilterParameter_ID = Convert.ToInt32(r["ExtractionFilterParameter_ID"]);
        Value = r["Value"] as string;

        ClearAllInjections();
    }

    /// <summary>
    /// Creates a record of what value to use with the given <see cref="ISqlParameter"/> of the <see cref="ExtractionFilterParameterSet"/> <see cref="IFilter"/> to achieve the concept.
    /// 
    /// <para>For example if there is an <see cref="ExtractionFilter"/> 'Prescribed Drug X' with a parameter @DrugList and you create an <see cref="ExtractionFilterParameterSet"/>
    /// 'Diabetic Drugs' then this will create a <see cref="ExtractionFilterParameterSetValue"/> of '@DrugList='123.23,121,2... etc'.</para>
    /// 
    /// <para>If a filter has more than one parameter then you will need one <see cref="ExtractionFilterParameterSetValue"/> per parameter per <see cref="ExtractionFilterParameterSet"/></para>
    /// </summary>
    /// <param name="repository"></param>
    /// <param name="parent"></param>
    /// <param name="valueIsForParameter"></param>
    public ExtractionFilterParameterSetValue(ICatalogueRepository repository, ExtractionFilterParameterSet parent,
        ExtractionFilterParameter valueIsForParameter)
    {
        repository.InsertAndHydrate(this, new Dictionary<string, object>
        {
            { "ExtractionFilterParameterSet_ID", parent.ID },
            { "ExtractionFilterParameter_ID", valueIsForParameter.ID }
        });

        ClearAllInjections();
    }

    /// <inheritdoc/>
    public IQuerySyntaxHelper GetQuerySyntaxHelper() => ExtractionFilterParameter.GetQuerySyntaxHelper();

    /// <inheritdoc/>
    public void Check(ICheckNotifier notifier)
    {
        new ParameterSyntaxChecker(this).Check(notifier);
    }

    public override string ToString() => $"{ParameterName} = {Value}";

    public void InjectKnown(ExtractionFilterParameter instance)
    {
        _knownExtractionFilterParameter = new Lazy<ExtractionFilterParameter>(instance);
    }

    public void ClearAllInjections()
    {
        _knownExtractionFilterParameter = new Lazy<ExtractionFilterParameter>(() =>
            Repository.GetObjectByID<ExtractionFilterParameter>(ExtractionFilterParameter_ID));
    }
}

1	// Copyright (c) The University of Dundee 2018-2019
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;
8	using System.Collections.Generic;
9	using System.Data.Common;
10	using FAnsi.Discovery.QuerySyntax;
11	using Rdmp.Core.MapsDirectlyToDatabaseTable;
12	using Rdmp.Core.MapsDirectlyToDatabaseTable.Attributes;
13	using Rdmp.Core.MapsDirectlyToDatabaseTable.Injection;
14	using Rdmp.Core.QueryBuilding.SyntaxChecking;
15	using Rdmp.Core.Repositories;
16	using Rdmp.Core.ReusableLibraryCode.Checks;
17
18	namespace Rdmp.Core.Curation.Data;
19
20	/// <summary>
21	/// Stores a known specific useful value for a given ExtractionFilterParameter. See <see cref="Data.ExtractionFilterParameterSet"/> for a use case for this.
22	/// </summary>
23	public class ExtractionFilterParameterSetValue : DatabaseEntity, ISqlParameter, IInjectKnown<ExtractionFilterParameter>
24	{
25	#region Database Properties
26
27	private string _value;
28	private int _extractionFilterParameterSetID;
29	private int _extractionFilterParameterID;
30
31	/// <summary>
32	/// The 'known good parameter set' (<see cref="ExtractionFilterParameterSet"/>) to which this parameter value belongs
33	/// </summary>
34	public int ExtractionFilterParameterSet_ID
35	{
36	get => _extractionFilterParameterSetID;	30✔
37	set => SetField(ref _extractionFilterParameterSetID, value);	30✔
38	}
39
40	/// <summary>
41	/// The specific parameter that this object is providing a 'known value' for in the parent <see cref="ExtractionFilter"/> e.g. @DrugList='123.2,123.2,... etc'.
42	/// </summary>
43	public int ExtractionFilterParameter_ID
44	{
45	get => _extractionFilterParameterID;	14✔
46	set => SetField(ref _extractionFilterParameterID, value);	30✔
47	}
48
49	/// <inheritdoc/>
50	[Sql]
51	public string Value
52	{
53	get => _value;	22✔
54	set => SetField(ref _value, value);	16✔
55	}
56
57	#endregion
58
59	#region cached values stored so we can act like a readonly ISqlParameter but secretly only Value will actually be changeable
60
61	private Lazy<ExtractionFilterParameter> _knownExtractionFilterParameter;
62
63	/// <inheritdoc/>
64	/// <remarks>Readonly, fetched from associated <see cref="ExtractionFilterParameter_ID"/></remarks>
65	[NoMappingToDatabase]
66	public string ParameterName => _knownExtractionFilterParameter.Value.ParameterName;	16✔
67
68	/// <inheritdoc/>
69	/// <remarks>Readonly, fetched from associated <see cref="ExtractionFilterParameter_ID"/></remarks>
70	[Sql]
71	[NoMappingToDatabase]
72	public string ParameterSQL
73	{
74	get => _knownExtractionFilterParameter.Value.ParameterSQL;	10✔
75	set { }	×
76	}
77
78	/// <inheritdoc/>
79	/// <remarks>Readonly, fetched from associated <see cref="ExtractionFilterParameter_ID"/></remarks>
80	[NoMappingToDatabase]
81	public string Comment
82	{
83	get => _knownExtractionFilterParameter.Value.Comment;	10✔
84	set { }	×
85	}
86
87	/// <summary>
88	/// Returns the <see cref="ExtractionFilterParameterSet"/> this known good value belongs to
89	/// </summary>
90	/// <returns></returns>
91	public IMapsDirectlyToDatabaseTable GetOwnerIfAny() => ExtractionFilterParameterSet;	8✔
92
93	#endregion
94
95	#region Relationships
96
97	/// <inheritdoc cref="ExtractionFilterParameterSet_ID"/>
98	[NoMappingToDatabase]
99	public ExtractionFilterParameterSet ExtractionFilterParameterSet =>
100	Repository.GetObjectByID<ExtractionFilterParameterSet>(ExtractionFilterParameterSet_ID);	18✔
101
102	/// <inheritdoc cref="ExtractionFilterParameter_ID"/>
103	[NoMappingToDatabase]
104	public ExtractionFilterParameter ExtractionFilterParameter => _knownExtractionFilterParameter.Value;	2✔
105
106	#endregion
107
108
109	public ExtractionFilterParameterSetValue()	×
110	{
111	ClearAllInjections();	×
112	}	×
113
114	internal ExtractionFilterParameterSetValue(ICatalogueRepository repository, DbDataReader r)
115	: base(repository, r)	8✔
116	{
117	ExtractionFilterParameterSet_ID = Convert.ToInt32(r["ExtractionFilterParameterSet_ID"]);	8✔
118	ExtractionFilterParameter_ID = Convert.ToInt32(r["ExtractionFilterParameter_ID"]);	8✔
119	Value = r["Value"] as string;	8✔
120
121	ClearAllInjections();	8✔
122	}	8✔
123
124	/// <summary>
125	/// Creates a record of what value to use with the given <see cref="ISqlParameter"/> of the <see cref="ExtractionFilterParameterSet"/> <see cref="IFilter"/> to achieve the concept.
126	///
127	/// <para>For example if there is an <see cref="ExtractionFilter"/> 'Prescribed Drug X' with a parameter @DrugList and you create an <see cref="ExtractionFilterParameterSet"/>
128	/// 'Diabetic Drugs' then this will create a <see cref="ExtractionFilterParameterSetValue"/> of '@DrugList='123.23,121,2... etc'.</para>
129	///
130	/// <para>If a filter has more than one parameter then you will need one <see cref="ExtractionFilterParameterSetValue"/> per parameter per <see cref="ExtractionFilterParameterSet"/></para>
131	/// </summary>
132	/// <param name="repository"></param>
133	/// <param name="parent"></param>
134	/// <param name="valueIsForParameter"></param>
135	public ExtractionFilterParameterSetValue(ICatalogueRepository repository, ExtractionFilterParameterSet parent,	22✔
136	ExtractionFilterParameter valueIsForParameter)	22✔
137	{
138	repository.InsertAndHydrate(this, new Dictionary<string, object>	22✔
139	{	22✔
140	{ "ExtractionFilterParameterSet_ID", parent.ID },	22✔
141	{ "ExtractionFilterParameter_ID", valueIsForParameter.ID }	22✔
142	});	22✔
143
144	ClearAllInjections();	22✔
145	}	22✔
146
147	/// <inheritdoc/>
148	public IQuerySyntaxHelper GetQuerySyntaxHelper() => ExtractionFilterParameter.GetQuerySyntaxHelper();	×
149
150	/// <inheritdoc/>
151	public void Check(ICheckNotifier notifier)
152	{
153	new ParameterSyntaxChecker(this).Check(notifier);	×
154	}	×
155
156	public override string ToString() => $"{ParameterName} = {Value}";	4✔
157
158	public void InjectKnown(ExtractionFilterParameter instance)
159	{
UNCOV 160	_knownExtractionFilterParameter = new Lazy<ExtractionFilterParameter>(instance);	×
UNCOV 161	}	×
162
163	public void ClearAllInjections()
164	{
165	_knownExtractionFilterParameter = new Lazy<ExtractionFilterParameter>(() =>	30✔
166	Repository.GetObjectByID<ExtractionFilterParameter>(ExtractionFilterParameter_ID));	38✔
167	}	30✔
168	}

HicServices / RDMP / 19852309549

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