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/CommandExecution/AtomicCommands/ExecuteCommandScriptTables.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.IO;
using System.Text;
using FAnsi;
using FAnsi.Discovery;
using Rdmp.Core.Curation.Data;
using Rdmp.Core.Icons.IconProvision;
using Rdmp.Core.ReusableLibraryCode.DataAccess;
using Rdmp.Core.ReusableLibraryCode.Icons.IconProvision;
using SixLabors.ImageSharp;
using SixLabors.ImageSharp.PixelFormats;

namespace Rdmp.Core.CommandExecution.AtomicCommands;

/// <summary>
/// Script multiple tables optionally porting schema to a new server/DBMS type
/// </summary>
public class ExecuteCommandScriptTables : BasicCommandExecution
{
    private readonly TableInfo[] _tableInfos;
    private readonly DatabaseType? _dbType;
    private readonly string _dbName;
    private readonly FileInfo _outFile;

    /// <summary>
    /// Scripts multiple tables schemas and optionally ports datatypes / constraints etc to alternate DBMS
    /// </summary>
    public ExecuteCommandScriptTables(IBasicActivateItems activator,
        [DemandsInitialization("Tables to script")]
        TableInfo[] tableInfos,
        [DemandsInitialization("Optional alternate DBMS Type to port the schema to")]
        DatabaseType? dbType,
        [DemandsInitialization("Optional alternate database name to use in the script generated.")]
        string dbName,
        [DemandsInitialization("Optional file to write the resulting script out to.  Pass Null to output to console.")]
        FileInfo outFile) : base(activator)
    {
        _tableInfos = tableInfos;
        _dbType = dbType;
        _dbName = dbName;
        _outFile = outFile;
    }

    public override string GetCommandHelp() => "Scripts multiple tables structure to Clipboard (without dependencies)";

    public override void Execute()
    {
        var sbScript = new StringBuilder();

        foreach (var tableInfo in _tableInfos)
        {
            var tbl = tableInfo.Discover(DataAccessContext.InternalDataProcessing);

            var hypotheticalServer = new DiscoveredServer("localhost", _dbName ?? "None",
                _dbType ?? tableInfo.DatabaseType, null, null);
            var hypotheticalTable = hypotheticalServer.ExpectDatabase(_dbName ?? tbl.Database.GetRuntimeName())
                .ExpectTable(tbl.GetRuntimeName());

            var result = tbl.ScriptTableCreation(false, false, false, hypotheticalTable);
            sbScript.AppendLine(result);
            sbScript.AppendLine();
        }

        if (_outFile != null)
            File.WriteAllText(_outFile.FullName, sbScript.ToString());
        else
            Show($"Script for {_tableInfos.Length} tables", sbScript.ToString());
    }

    public override Image<Rgba32> GetImage(IIconProvider iconProvider) => iconProvider.GetImage(RDMPConcept.SQL);
}

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.IO;
8	using System.Text;
9	using FAnsi;
10	using FAnsi.Discovery;
11	using Rdmp.Core.Curation.Data;
12	using Rdmp.Core.Icons.IconProvision;
13	using Rdmp.Core.ReusableLibraryCode.DataAccess;
14	using Rdmp.Core.ReusableLibraryCode.Icons.IconProvision;
15	using SixLabors.ImageSharp;
16	using SixLabors.ImageSharp.PixelFormats;
17
18	namespace Rdmp.Core.CommandExecution.AtomicCommands;
19
20	/// <summary>
21	/// Script multiple tables optionally porting schema to a new server/DBMS type
22	/// </summary>
23	public class ExecuteCommandScriptTables : BasicCommandExecution
24	{
25	private readonly TableInfo[] _tableInfos;
26	private readonly DatabaseType? _dbType;
27	private readonly string _dbName;
28	private readonly FileInfo _outFile;
29
30	/// <summary>
31	/// Scripts multiple tables schemas and optionally ports datatypes / constraints etc to alternate DBMS
32	/// </summary>
33	public ExecuteCommandScriptTables(IBasicActivateItems activator,
34	[DemandsInitialization("Tables to script")]
35	TableInfo[] tableInfos,
36	[DemandsInitialization("Optional alternate DBMS Type to port the schema to")]
37	DatabaseType? dbType,
38	[DemandsInitialization("Optional alternate database name to use in the script generated.")]
39	string dbName,
40	[DemandsInitialization("Optional file to write the resulting script out to. Pass Null to output to console.")]
41	FileInfo outFile) : base(activator)	×
42	{
43	_tableInfos = tableInfos;	×
44	_dbType = dbType;	×
45	_dbName = dbName;	×
46	_outFile = outFile;	×
47	}	×
48
49	public override string GetCommandHelp() => "Scripts multiple tables structure to Clipboard (without dependencies)";	×
50
51	public override void Execute()
52	{
53	var sbScript = new StringBuilder();	×
54
55	foreach (var tableInfo in _tableInfos)	×
56	{
57	var tbl = tableInfo.Discover(DataAccessContext.InternalDataProcessing);	×
58
59	var hypotheticalServer = new DiscoveredServer("localhost", _dbName ?? "None",	×
60	_dbType ?? tableInfo.DatabaseType, null, null);	×
61	var hypotheticalTable = hypotheticalServer.ExpectDatabase(_dbName ?? tbl.Database.GetRuntimeName())	×
62	.ExpectTable(tbl.GetRuntimeName());	×
63
64	var result = tbl.ScriptTableCreation(false, false, false, hypotheticalTable);	×
65	sbScript.AppendLine(result);	×
66	sbScript.AppendLine();	×
67	}
68
69	if (_outFile != null)	×
70	File.WriteAllText(_outFile.FullName, sbScript.ToString());	×
71	else
72	Show($"Script for {_tableInfos.Length} tables", sbScript.ToString());	×
73	}	×
74
75	public override Image<Rgba32> GetImage(IIconProvider iconProvider) => iconProvider.GetImage(RDMPConcept.SQL);	×
76	}

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