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

82.61

/Rdmp.Core/MapsDirectlyToDatabaseTable/UpdateCommandStore.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 System.Linq;
using FAnsi.Implementation;
using Rdmp.Core.ReusableLibraryCode;

namespace Rdmp.Core.MapsDirectlyToDatabaseTable;

/// <summary>
/// Stores DbCommands for saving IMapsDirectlyToDatabaseTable objects to the database.
/// 
/// <para>Each time a novel IMapsDirectlyToDatabaseTable object Type is encountered an UPDATE sql command (DbCommand) is created for saving the object back to
/// the database (using DbCommandBuilder).  Since this operation (figuring out the UPDATE command) is slow and we might be saving lots of objects we cache
/// the command so that we can apply it to all objects of that Type as they are saved.</para>
/// </summary>
public class UpdateCommandStore
{
    public Dictionary<Type, DbCommand> UpdateCommands { get; private set; }

    public UpdateCommandStore()
    {
        UpdateCommands = new Dictionary<Type, DbCommand>();
    }

    public DbCommand this[IMapsDirectlyToDatabaseTable o] => UpdateCommands[o.GetType()];

    public DbCommand this[Type t] => UpdateCommands[t];

    public void Add(Type o, DbConnectionStringBuilder builder, DbConnection connection, DbTransaction transaction)
    {
        var syntax = ImplementationManager.GetImplementation(builder).GetQuerySyntaxHelper();

        var command = DatabaseCommandHelper.GetCommand($"UPDATE {syntax.EnsureWrapped(o.Name)} SET {{0}} WHERE ID=@ID;",
            connection, transaction);

        var props = TableRepository.GetPropertyInfos(o);

        foreach (var p in props)
            command.Parameters.Add(DatabaseCommandHelper.GetParameter($"@{p.Name}", command));

        command.CommandText = string.Format(command.CommandText,
            string.Join(",",
                props.Where(p => p.Name != "ID").Select(p => $"{syntax.EnsureWrapped(p.Name)}=@{p.Name}")));

        UpdateCommands.Add(o, command);
    }

    public bool ContainsKey(IMapsDirectlyToDatabaseTable toCreate) => UpdateCommands.ContainsKey(toCreate.GetType());
    public bool ContainsKey(Type toCreate) => UpdateCommands.ContainsKey(toCreate);

    public void Clear()
    {
        UpdateCommands.Clear();
    }
}

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 System.Linq;
11	using FAnsi.Implementation;
12	using Rdmp.Core.ReusableLibraryCode;
13
14	namespace Rdmp.Core.MapsDirectlyToDatabaseTable;
15
16	/// <summary>
17	/// Stores DbCommands for saving IMapsDirectlyToDatabaseTable objects to the database.
18	///
19	/// <para>Each time a novel IMapsDirectlyToDatabaseTable object Type is encountered an UPDATE sql command (DbCommand) is created for saving the object back to
20	/// the database (using DbCommandBuilder). Since this operation (figuring out the UPDATE command) is slow and we might be saving lots of objects we cache
21	/// the command so that we can apply it to all objects of that Type as they are saved.</para>
22	/// </summary>
23	public class UpdateCommandStore
24	{
25	public Dictionary<Type, DbCommand> UpdateCommands { get; private set; }	39,948✔
26
27	public UpdateCommandStore()	942✔
28	{
29	UpdateCommands = new Dictionary<Type, DbCommand>();	942✔
30	}	942✔
31
32	public DbCommand this[IMapsDirectlyToDatabaseTable o] => UpdateCommands[o.GetType()];	×
33
34	public DbCommand this[Type t] => UpdateCommands[t];	18,743✔
35
36	public void Add(Type o, DbConnectionStringBuilder builder, DbConnection connection, DbTransaction transaction)
37	{
38	var syntax = ImplementationManager.GetImplementation(builder).GetQuerySyntaxHelper();	1,520✔
39
40	var command = DatabaseCommandHelper.GetCommand($"UPDATE {syntax.EnsureWrapped(o.Name)} SET {{0}} WHERE ID=@ID;",	1,520✔
41	connection, transaction);	1,520✔
42
43	var props = TableRepository.GetPropertyInfos(o);	1,520✔
44
45	foreach (var p in props)	41,184✔
46	command.Parameters.Add(DatabaseCommandHelper.GetParameter($"@{p.Name}", command));	19,072✔
47
48	command.CommandText = string.Format(command.CommandText,	1,520✔
49	string.Join(",",	1,520✔
50	props.Where(p => p.Name != "ID").Select(p => $"{syntax.EnsureWrapped(p.Name)}=@{p.Name}")));	38,144✔
51
52	UpdateCommands.Add(o, command);	1,520✔
53	}	1,520✔
54
55	public bool ContainsKey(IMapsDirectlyToDatabaseTable toCreate) => UpdateCommands.ContainsKey(toCreate.GetType());	×
56	public bool ContainsKey(Type toCreate) => UpdateCommands.ContainsKey(toCreate);	18,743✔
57
58	public void Clear()
59	{
60	UpdateCommands.Clear();	×
61	}	×
62	}

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