6237307473

Committed 19 Sep 2023 04:02PM UTC coverage: 57.015% (-0.4%) from 57.44%

Build # 6237307473

Build Type

push

github

Committed by

web-flow

Commit Message

Feature/rc4 (#1570)

* Syntax tidying
* Dependency updates
* Event handling singletons (ThrowImmediately and co)

---------

Signed-off-by: dependabot[bot] <support@github.com>
Co-authored-by: James A Sutherland <>
Co-authored-by: James Friel <jfriel001@dundee.ac.uk>
Co-authored-by: dependabot[bot] <49699333+dependabot[bot]@users.noreply.github.com>

Run Details

10734 of 20259 branches covered (0.0%)

Branch coverage included in aggregate %.

5922 of 5922 new or added lines in 565 files covered. (100.0%)

30687 of 52390 relevant lines covered (58.57%)

7361.8 hits per line

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

0.0

/Rdmp.Core/CommandExecution/AtomicCommands/Alter/ExecuteCommandAlterTableCreatePrimaryKey.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.Collections.Generic;
using System.Linq;
using System.Threading;
using System.Threading.Tasks;
using Rdmp.Core.CommandLine.Interactive.Picking;
using Rdmp.Core.Curation.Data;
using Rdmp.Core.Repositories.Construction;
using Rdmp.Core.ReusableLibraryCode.DataAccess;

namespace Rdmp.Core.CommandExecution.AtomicCommands.Alter;

/// <summary>
/// Creates a primary key on the live database table based on one or more columns
/// </summary>
public class ExecuteCommandAlterTableCreatePrimaryKey : AlterTableCommandExecution
{
    private readonly ColumnInfo[] _columnInfos;

    [UseWithCommandLine(ParameterHelpList = "<TableInfo> <ColumnInfo1> <ColumnInfo2> etc",
        ParameterHelpBreakdown = @"TableInfo    The table you want to create a primary key on e.g. TableInfo:*Biochem*
ColumnInfos List of columns that should form the primary key (1 for simple primary key, 2+ for composite primary key)")]
    public ExecuteCommandAlterTableCreatePrimaryKey(IBasicActivateItems activator, CommandLineObjectPicker picker) :
        this(activator, (TableInfo)picker[0].GetValueForParameterOfType(typeof(TableInfo)))
    {
        if (IsImpossible)
            return;

        var pick = new List<ColumnInfo>();
        for (var i = 1; i < picker.Length; i++)
            pick.Add((ColumnInfo)picker[i].GetValueForParameterOfType(typeof(ColumnInfo)));

        _columnInfos = pick.ToArray();
    }

    public ExecuteCommandAlterTableCreatePrimaryKey(IBasicActivateItems activator, TableInfo tableInfo) : base(
        activator, tableInfo)
    {
        if (IsImpossible)
            return;

        if (Table.DiscoverColumns().Any(static c => c.IsPrimaryKey))
            SetImpossible("Table already has a primary key, try synchronizing the TableInfo");
    }

    public override void Execute()
    {
        base.Execute();

        Synchronize();

        var cols = _columnInfos;

        if (cols == null && SelectMany(TableInfo.ColumnInfos, out var selected))
            cols = selected;

        if (cols == null || cols.Length == 0)
            return;

        using var cts = new CancellationTokenSource();

        var task = Task.Run(() =>
            Table.CreatePrimaryKey(cols.Select(c => c.Discover(DataAccessContext.DataLoad)).ToArray()), cts.Token);

        Wait("Creating Primary Key...", task, cts);

        if (task.IsFaulted)
            ShowException("Create Primary Key Failed", task.Exception);

        Synchronize();

        Publish(TableInfo);
    }
}

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.Collections.Generic;
8	using System.Linq;
9	using System.Threading;
10	using System.Threading.Tasks;
11	using Rdmp.Core.CommandLine.Interactive.Picking;
12	using Rdmp.Core.Curation.Data;
13	using Rdmp.Core.Repositories.Construction;
14	using Rdmp.Core.ReusableLibraryCode.DataAccess;
15
16	namespace Rdmp.Core.CommandExecution.AtomicCommands.Alter;
17
18	/// <summary>
19	/// Creates a primary key on the live database table based on one or more columns
20	/// </summary>
21	public class ExecuteCommandAlterTableCreatePrimaryKey : AlterTableCommandExecution
22	{
23	private readonly ColumnInfo[] _columnInfos;
24
25	[UseWithCommandLine(ParameterHelpList = "<TableInfo> <ColumnInfo1> <ColumnInfo2> etc",
26	ParameterHelpBreakdown = @"TableInfo The table you want to create a primary key on e.g. TableInfo:Biochem
27	ColumnInfos List of columns that should form the primary key (1 for simple primary key, 2+ for composite primary key)")]
28	public ExecuteCommandAlterTableCreatePrimaryKey(IBasicActivateItems activator, CommandLineObjectPicker picker) :
29	this(activator, (TableInfo)picker[0].GetValueForParameterOfType(typeof(TableInfo)))	×
30	{
31	if (IsImpossible)	×
32	return;	×
33
34	var pick = new List<ColumnInfo>();	×
35	for (var i = 1; i < picker.Length; i++)	×
36	pick.Add((ColumnInfo)picker[i].GetValueForParameterOfType(typeof(ColumnInfo)));	×
37
38	_columnInfos = pick.ToArray();	×
39	}	×
40
41	public ExecuteCommandAlterTableCreatePrimaryKey(IBasicActivateItems activator, TableInfo tableInfo) : base(	×
42	activator, tableInfo)	×
43	{
44	if (IsImpossible)	×
45	return;	×
46
47	if (Table.DiscoverColumns().Any(static c => c.IsPrimaryKey))	×
48	SetImpossible("Table already has a primary key, try synchronizing the TableInfo");	×
49	}	×
50
51	public override void Execute()
52	{
53	base.Execute();	×
54
55	Synchronize();	×
56
57	var cols = _columnInfos;	×
58
59	if (cols == null && SelectMany(TableInfo.ColumnInfos, out var selected))	×
60	cols = selected;	×
61
62	if (cols == null \|\| cols.Length == 0)	×
63	return;	×
64
65	using var cts = new CancellationTokenSource();	×
66
67	var task = Task.Run(() =>	×
68	Table.CreatePrimaryKey(cols.Select(c => c.Discover(DataAccessContext.DataLoad)).ToArray()), cts.Token);	×
69
70	Wait("Creating Primary Key...", task, cts);	×
71
72	if (task.IsFaulted)	×
73	ShowException("Create Primary Key Failed", task.Exception);	×
74
75	Synchronize();	×
76
77	Publish(TableInfo);	×
78	}	×
79	}

HicServices / RDMP / 6237307473

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