StringExtractTests.cs

using MySQLCLRFunctions;
using Xunit;
using static MySQLCLRFunctions.StringExtract;

namespace MySQLCLRFunctions.Tests
{
    public class StringExtractTests
    {
        [Fact]
        public void LeftOfSTest()
        {
            const string input = "GetTHEMIDDLEofthis";
            const string validoutput = "GetTHEMIDDLE";
            var output = LeftOfS(input, "of");
            Assert.Equal(expected: validoutput, output);
        }

        [Fact]
        public void LeftOfNthSTest()
        {
            const string input = "I,JJJJ,K";
            const string validoutput = "JJJJ";
            var output = LeftOfNthS(input, ",", 2);
            Assert.Equal(expected: validoutput, output);
        }

        [Fact]
        public void LeftMOfNthSTest()
        {
            const string input = "EDWPROD.UserData.x.y";
            const string validoutput = "EDWPROD.UserData";
            var output = LeftMOfNthS(input, ".", 2, 2);
            Assert.Equal(expected: validoutput, output);
        }
        [Fact]
        public void LeftOfAnyCTest()
        {
            const string input = "This is a,space";
            const string validoutput = "This";
            var output = LeftOfAnyC(input, " ,");
            Assert.Equal(expected: validoutput, output);
        }

        [Fact]
        public void RightOfSTest()
        {
            const string input = "This is a,space";
            const string validoutput = "space";
            var output = RightOfS(input, ",");
            Assert.Equal(expected: validoutput, output);
        }

        [Fact]
        public void RightOfAnyCTest()
        {
            const string input = "So what?";
            const string validoutput = "";
            var output = RightOfAnyC(input, ",:#?");
            Assert.Equal(expected: validoutput, output);
        }

        [Fact]
        public void MidTest()
        {
            const string input = "GetTHEMIDDLEofthis";
            const string validoutput = "THEMIDDLE";
            var output = Mid(input, 4, 12);
            Assert.Equal(expected: validoutput, output);
        }

        [Fact]
        public void MidTest_OverloadBySign()
        {
            const string input = "GetTHEMIDDLEofthis";
            const string validoutput = "th";
            var output = Mid(input, -4, -2);
            Assert.Equal(expected: validoutput, output);
        }

        [Fact]
        public void MidTest_OverloadBySignButOnlyOnEnd()
        {
            const string input = "[test]";
            const string validoutput = "test";
            var output = Mid(input, 1, -1);
            Assert.Equal(expected: validoutput, output);
        }

        [Fact]
        public void MIDTest()
        {
            const string input = "GetTHEMIDDLEofthis";
            const string validoutput = "THEMIDDLE";
            var output = input.MID(4, 12);
            Assert.Equal(expected: validoutput, output);
        }

        [Fact]
        public void GetFirstNameTest()
        {
            const string input = "Jeff Humphreys";
            const string validoutput = "Jeff";
            var output = GetFirstName(input);
            Assert.Equal(expected: validoutput, output);
        }

        [Fact]
        public void GetFirstNameTest2()
        {
            const string input = "Humphreys, Jeff";
            const string validoutput = "Jeff";
            var output = GetFirstName(input);
            Assert.Equal(expected: validoutput, output);
        }

        [Fact]
        public void GetFirstNameTest3()
        {
            const string input = "Humphreys, Jeff S.";
            const string validoutput = "Jeff";
            var output = GetFirstName(input);
            Assert.Equal(expected: validoutput, output);
        }

        [Fact]
        public void LeftTest()
        {
            const string input = "Humphreys, Jeff S.";
            const string validoutput = "Hum";
#pragma warning disable RCS1196 // Call extension method as instance method.
            var output = Left(input, 3);
#pragma warning restore RCS1196 // Call extension method as instance method.
            Assert.Equal(expected: validoutput, output);
        }

        [Fact]
        public void FirstWordTest()
        {
            const string input = "Humphreys, Jeff S.";
            const string validoutput = "Humphreys";
            var output = FirstWordW(input);
            Assert.Equal(expected: validoutput, output);
        }

        [Fact]
        public void PieceNumberTest()
        {
            const string input = "Humphreys, Jeff S.";
            const string validoutput = "Humphreys";
            var output = PieceNumberX(input, ",", 1);
            Assert.Equal(expected: validoutput, output);
        }

        [Fact]
        public void LastPieceTest()
        {
            const string input = "Humphreys, Jeff S.";
            const string validoutput = " Jeff S.";
            var output = LastPieceX(input, ",");
            Assert.Equal(expected: validoutput, output);
        }

        [Fact]
        public void FirstWordBeforeSTest()
        {
            const string input = "Humphreys, Jeff S.";
            const string validoutput = "Humphreys, ";
            var output = FirstWordBeforeS(input, "Je");
            Assert.Equal(expected: validoutput, output);
        }

        [Fact]
        public void FirstWordBeforeAnyCTest()
        {
            const string input = "Humphreys, Jeff S.";
            const string validoutput = "Humphr";
            var output = FirstWordBeforeAnyC(input, "e,.");
            Assert.Equal(expected: validoutput, output);
        }

        [Fact]
        public void EverythingAfterSTest()
        {
            const string input = "Humphreys, Jeff S.";
            const string validoutput = " Jeff S.";
            var output = EverythingAfterS(input, ",");
            Assert.Equal(expected: validoutput, output);
        }

        [Fact()]
        public void EverythingAfterXTest()
        {
            const string input = "Hi,There-data";
            const string validoutput = "There-data";
            var output = EverythingAfterX(input, "[\\,\\-]");
            Assert.Equal(expected: validoutput, output);
        }

        [Theory]
        [InlineData("EXEC ETLSteps.[0001_Tickets_0001_Customers]", "ETLSteps.[0001_Tickets_0001_Customers]")]
        [InlineData("EXEC ETLSteps.0001_Tickets_0001_Customers @x=3", "ETLSteps.0001_Tickets_0001_Customers")]
        [InlineData("EXEC ETLSteps.0001_Tickets_0001_Customers", "ETLSteps.0001_Tickets_0001_Customers")]
        [InlineData("EXEC ETLSteps.0001_Tickets_0001_Customers ", "ETLSteps.0001_Tickets_0001_Customers")]
        [InlineData("EXEC ETLSteps.0001_Tickets_0001_Customers] ", "ETLSteps.0001_Tickets_0001_Customers]")]
        [InlineData("EXEC ETLSteps.0001_Tickets_0001_Customers] @d", "ETLSteps.0001_Tickets_0001_Customers]")]
        [InlineData(@"EXEC ETLSteps.[0001_Tickets_0002_Journals_1_ChangeHistory+TeamMembers_1] @RebuildFromScratch = 1, @PullAndAppendNewOnly = 0

CheckForTranAGAIN:
IF @@trancount > 0
BEGIN
    PRINT 'Committing'
    COMMIT TRANSACTION
    GOTO CheckForTranAGAIN
END

/*
	TODO: move transaction work into proc.  Convert to RebuildFromScratch = 0
*/", "ETLSteps.[0001_Tickets_0002_Journals_1_ChangeHistory+TeamMembers_1]")]
        public void ExtractXTestForPerfectDataObjectRemoval(string input, string validoutput)
        {
            var match = @"EXEC (\[?.+?\]?\.\[?.+])\r|EXEC (\[?.+?\]?\.\[?.+])$|EXEC (\[?.+?\]?\.\[?.+?\]?) |EXEC (\[?.+?\]?\.\[?.+?\]?)$";
            var output = ExtractX(input, match);
            Assert.Equal(expected: validoutput, output);
        }

        [Theory]
        [InlineData("Requested by Jeff Humphreys(3/1/2017 DL 128641)", "Jeff Humphreys")]
        [InlineData("requested by Jeff Humphreys (7/31/19 MJ 718827)", "Jeff Humphreys")]
        [InlineData("Req by Jeff Humphreys 4/6/2012mh", "Jeff Humphreys")]
        [InlineData("Req by FPT#  623633", "")]
        [InlineData("Req by Jeff Humphreys 1-7-11 (FP#342527) se PG: We need to identify a new owner of the distribution list that is from the Team", "Jeff Humphreys")]
        [InlineData("Requested by Jeff Humphreys - 2-27-2019 AB 592618)", "Jeff Humphreys")]
        // Requested by Humphreys, Jeff (3/12/19 BC 601941)
        // Ownership changed to Humphreys, Jeff - 1/8/20 - SR 823688        Access to xxxxxxx List
        public void ExtractPersonsNameTest(string input, string validoutput)
        {
            var output = ExtractPersonsName(input);
            Assert.Equal(expected: validoutput, output);
        }

        [Theory]
        [InlineData(@"use [JRS_Data];
go
/****** Object:  StoredProcedure [pdm].[Update_Specification_History]    Script Date: 9/13/2017 1:34:09 PM ******/
set ansi_nulls on;
go
set quoted_identifier on;
go
-- pdm.UpdateSpecificationHistory
", @"go
"
, 3
, @"-- pdm.UpdateSpecificationHistory
")]
        public void EverythingAfterNthSTest(string input, string marker, int howmany, string validoutput)
        {
            var output = EverythingAfterNthS(input, marker, howmany);
            Assert.Equal(expected: validoutput, output);
        }
    }
}