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/ReusableLibraryCode/Rfc4180Writer.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.Data;
using System.IO;
using System.Linq;
using FAnsi.Discovery;
using TypeGuesser;

namespace Rdmp.Core.ReusableLibraryCode;

public static class Rfc4180Writer
{
    public static void WriteDataTable(DataTable sourceTable, TextWriter writer, bool includeHeaders,
        QuerySyntaxHelper escaper = null)
    {
        if (includeHeaders)
        {
            var headerValues = sourceTable.Columns
                .OfType<DataColumn>()
                .Select(column => QuoteValue(column.ColumnName));

            writer.WriteLine(string.Join(",", headerValues));
        }

        var typeDictionary = sourceTable.Columns.Cast<DataColumn>().ToDictionary(c => c, c => new Guesser());
        foreach (var kvp in typeDictionary)
            kvp.Value.AdjustToCompensateForValues(kvp.Key);

        foreach (DataRow row in sourceTable.Rows)
        {
            var line = (from DataColumn col in sourceTable.Columns
                        select QuoteValue(GetStringRepresentation(row[col],
                            typeDictionary[col].Guess.CSharpType == typeof(DateTime), escaper))).ToList();
            writer.WriteLine(string.Join(",", line));
        }

        writer.Flush();
    }

    private static string GetStringRepresentation(object o, bool allowDates, QuerySyntaxHelper escaper = null)
    {
        if (o == null || o == DBNull.Value)
            return null;

        switch (o)
        {
            case string s when allowDates && DateTime.TryParse(s, out var dt):
                return GetStringRepresentation(dt);
            case DateTime dateTime:
                return GetStringRepresentation(dateTime);
        }

        var str = o.ToString();

        str = escaper != null ? escaper.Escape(str) : str.Replace("\"", "\"\"");

        return str;
    }

    private static string GetStringRepresentation(DateTime dt) =>
        dt.ToString(dt.TimeOfDay == TimeSpan.Zero ? "yyyy-MM-dd" : "yyyy-MM-dd HH:mm:ss.fff");

    private static string QuoteValue(string value) => value == null ? "NULL" : $"\"{value}\"";
}

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.Data;
9	using System.IO;
10	using System.Linq;
11	using FAnsi.Discovery;
12	using TypeGuesser;
13
14	namespace Rdmp.Core.ReusableLibraryCode;
15
16	public static class Rfc4180Writer
17	{
18	public static void WriteDataTable(DataTable sourceTable, TextWriter writer, bool includeHeaders,
19	QuerySyntaxHelper escaper = null)
20	{
21	if (includeHeaders)	×
22	{
23	var headerValues = sourceTable.Columns	×
24	.OfType<DataColumn>()	×
25	.Select(column => QuoteValue(column.ColumnName));	×
26
27	writer.WriteLine(string.Join(",", headerValues));	×
28	}
29
30	var typeDictionary = sourceTable.Columns.Cast<DataColumn>().ToDictionary(c => c, c => new Guesser());	×
31	foreach (var kvp in typeDictionary)	×
32	kvp.Value.AdjustToCompensateForValues(kvp.Key);	×
33
34	foreach (DataRow row in sourceTable.Rows)	×
35	{
36	var line = (from DataColumn col in sourceTable.Columns	×
37	select QuoteValue(GetStringRepresentation(row[col],	×
38	typeDictionary[col].Guess.CSharpType == typeof(DateTime), escaper))).ToList();	×
39	writer.WriteLine(string.Join(",", line));	×
40	}
41
42	writer.Flush();	×
43	}	×
44
45	private static string GetStringRepresentation(object o, bool allowDates, QuerySyntaxHelper escaper = null)
46	{
47	if (o == null \|\| o == DBNull.Value)	×
48	return null;	×
49
50	switch (o)	×
51	{
52	case string s when allowDates && DateTime.TryParse(s, out var dt):	×
53	return GetStringRepresentation(dt);	×
54	case DateTime dateTime:
55	return GetStringRepresentation(dateTime);	×
56	}
57
58	var str = o.ToString();	×
59
60	str = escaper != null ? escaper.Escape(str) : str.Replace("\"", "\"\"");	×
61
62	return str;	×
63	}
64
65	private static string GetStringRepresentation(DateTime dt) =>
66	dt.ToString(dt.TimeOfDay == TimeSpan.Zero ? "yyyy-MM-dd" : "yyyy-MM-dd HH:mm:ss.fff");	×
67
68	private static string QuoteValue(string value) => value == null ? "NULL" : $"\"{value}\"";	×
69	}

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