6245535001

Committed 20 Sep 2023 07:44AM UTC coverage: 57.013%. First build

Build # 6245535001

Build Type

push

github

Committed by

web-flow

Commit Message

8.1.0 Release (#1628)

* Bump Newtonsoft.Json from 13.0.1 to 13.0.2

Bumps [Newtonsoft.Json](https://github.com/JamesNK/Newtonsoft.Json) from 13.0.1 to 13.0.2.
- [Release notes](https://github.com/JamesNK/Newtonsoft.Json/releases)
- [Commits](https://github.com/JamesNK/Newtonsoft.Json/compare/13.0.1...13.0.2)

---
updated-dependencies:
- dependency-name: Newtonsoft.Json
  dependency-type: direct:production
  update-type: version-update:semver-patch
...

Signed-off-by: dependabot[bot] <support@github.com>

* Bump NLog from 5.0.5 to 5.1.0

Bumps [NLog](https://github.com/NLog/NLog) from 5.0.5 to 5.1.0.
- [Release notes](https://github.com/NLog/NLog/releases)
- [Changelog](https://github.com/NLog/NLog/blob/dev/CHANGELOG.md)
- [Commits](https://github.com/NLog/NLog/compare/v5.0.5...v5.1.0)

---
updated-dependencies:
- dependency-name: NLog
  dependency-type: direct:production
  update-type: version-update:semver-minor
...

Signed-off-by: dependabot[bot] <support@github.com>

* Bump NLog from 5.0.5 to 5.1.0

* Fix -r flag - should have been --results-directory all along

* Bump Newtonsoft.Json from 13.0.1 to 13.0.2

* Bump YamlDotNet from 12.0.2 to 12.1.0

Bumps [YamlDotNet](https://github.com/aaubry/YamlDotNet) from 12.0.2 to 12.1.0.
- [Release notes](https://github.com/aaubry/YamlDotNet/releases)
- [Commits](https://github.com/aaubry/YamlDotNet/compare/v12.0.2...v12.1.0)

---
updated-dependencies:
- dependency-name: YamlDotNet
  dependency-type: direct:production
  update-type: version-update:semver-minor
...

Signed-off-by: dependabot[bot] <support@github.com>

* Bump Moq from 4.18.2 to 4.18.3

Bumps [Moq](https://github.com/moq/moq4) from 4.18.2 to 4.18.3.
- [Release notes](https://github.com/moq/moq4/releases)
- [Changelog](https://github.com/moq/moq4/blob/main/CHANGELOG.md)
- [Commits](https://github.com/moq/moq4/compare/v4.18.2...v4.18.3)

---
updated-dependencies:
- dependency-name: Moq
... (continued)

Run Details

10732 of 20257 branches covered (0.0%)

Branch coverage included in aggregate %.

48141 of 48141 new or added lines in 1086 files covered. (100.0%)

30685 of 52388 relevant lines covered (58.57%)

7387.88 hits per line

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

0.0

/Rdmp.Core/DataExport/Checks/SupportingSQLTableChecker.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 Rdmp.Core.Curation.Data;
using Rdmp.Core.ReusableLibraryCode.Checks;

namespace Rdmp.Core.DataExport.Checks;

/// <summary>
/// Checks that a given <see cref="SupportingSQLTable"/> is reachable by the current user and that the <see cref="SupportingSQLTable.SQL"/> can be executed and returns data.
/// </summary>
public class SupportingSQLTableChecker : ICheckable
{
    private readonly SupportingSQLTable _table;

    /// <summary>
    /// Sets up checking of the supplied
    /// </summary>
    /// <param name="table"></param>
    public SupportingSQLTableChecker(SupportingSQLTable table)
    {
        _table = table;
    }

    /// <summary>
    /// Checks that the table can be reached on its listed server and that at least one row can be read from it.
    /// </summary>
    /// <param name="notifier"></param>
    public void Check(ICheckNotifier notifier)
    {
        try
        {
            notifier.OnCheckPerformed(new CheckEventArgs($"Found SupportingSQLTable {_table} about to check it",
                CheckResult.Success));

            var supportingSQLServer = _table.GetServer();

            notifier.OnCheckPerformed(supportingSQLServer.Exists()
                ? new CheckEventArgs($"Server {supportingSQLServer} exists", CheckResult.Success)
                : new CheckEventArgs($"Server {supportingSQLServer} does not exist", CheckResult.Fail));

            using var con = _table.GetServer().GetConnection();
            con.Open();

            notifier.OnCheckPerformed(new CheckEventArgs($"About to check Extraction SQL:{_table.SQL}",
                CheckResult.Success));

            using var cmd = supportingSQLServer.GetCommand(_table.SQL, con);
            using var reader = cmd.ExecuteReader();
            if (reader.Read())
                notifier.OnCheckPerformed(
                    new CheckEventArgs(
                        "SupportingSQLTable table fetched successfully and at least 1 data row was read ",
                        CheckResult.Success));
            else
                notifier.OnCheckPerformed(new CheckEventArgs(
                    $"No data was successfully read from SupportingSQLTable {_table}", CheckResult.Fail));
        }
        catch (Exception e)
        {
            notifier.OnCheckPerformed(new CheckEventArgs(
                $"Checking of SupportingSQLTable {_table} failed with Exception", CheckResult.Fail, e));
        }
    }
}

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 Rdmp.Core.Curation.Data;
9	using Rdmp.Core.ReusableLibraryCode.Checks;
10
11	namespace Rdmp.Core.DataExport.Checks;
12
13	/// <summary>
14	/// Checks that a given <see cref="SupportingSQLTable"/> is reachable by the current user and that the <see cref="SupportingSQLTable.SQL"/> can be executed and returns data.
15	/// </summary>
16	public class SupportingSQLTableChecker : ICheckable
17	{
18	private readonly SupportingSQLTable _table;
19
20	/// <summary>
21	/// Sets up checking of the supplied
22	/// </summary>
23	/// <param name="table"></param>
24	public SupportingSQLTableChecker(SupportingSQLTable table)	×
25	{
26	_table = table;	×
27	}	×
28
29	/// <summary>
30	/// Checks that the table can be reached on its listed server and that at least one row can be read from it.
31	/// </summary>
32	/// <param name="notifier"></param>
33	public void Check(ICheckNotifier notifier)
34	{
35	try
36	{
37	notifier.OnCheckPerformed(new CheckEventArgs($"Found SupportingSQLTable {_table} about to check it",	×
38	CheckResult.Success));	×
39
40	var supportingSQLServer = _table.GetServer();	×
41
42	notifier.OnCheckPerformed(supportingSQLServer.Exists()	×
43	? new CheckEventArgs($"Server {supportingSQLServer} exists", CheckResult.Success)	×
44	: new CheckEventArgs($"Server {supportingSQLServer} does not exist", CheckResult.Fail));	×
45
46	using var con = _table.GetServer().GetConnection();	×
47	con.Open();	×
48
49	notifier.OnCheckPerformed(new CheckEventArgs($"About to check Extraction SQL:{_table.SQL}",	×
50	CheckResult.Success));	×
51
52	using var cmd = supportingSQLServer.GetCommand(_table.SQL, con);	×
53	using var reader = cmd.ExecuteReader();	×
54	if (reader.Read())	×
55	notifier.OnCheckPerformed(	×
56	new CheckEventArgs(	×
57	"SupportingSQLTable table fetched successfully and at least 1 data row was read ",	×
58	CheckResult.Success));	×
59	else
60	notifier.OnCheckPerformed(new CheckEventArgs(	×
61	$"No data was successfully read from SupportingSQLTable {_table}", CheckResult.Fail));	×
62	}	×
63	catch (Exception e)	×
64	{
65	notifier.OnCheckPerformed(new CheckEventArgs(	×
66	$"Checking of SupportingSQLTable {_table} failed with Exception", CheckResult.Fail, e));	×
67	}	×
68	}	×
69	}

HicServices / RDMP / 6245535001

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