Commits

Commits on Feb 10, 2021

Fixed Pivot, Extract, Adaptors, added tests.
jeffshumphreys@gmail.com
committed

Commits on Jan 4, 2021

Cleanup
jeffshumphreys@gmail.com
committed

Commits on Oct 28, 2020

A variety of tests of odd formed inputs.
jeffshumphreys@gmail.com
committed
Push new function to server.
jeffshumphreys@gmail.com
committed
New function. Deal with weirdnesses of captured or partially captured n-part data object names. Needs more work for corner cases.
jeffshumphreys@gmail.com
committed
More tests for problematic inputs. Also converted this test to testing ONE pattern with many inputs.
jeffshumphreys@gmail.com
committed
An oops. convert SqlString to string first.
jeffshumphreys@gmail.com
committed
Added some internal helpers, established "CS" as a suffix meaning an array of characters also represented as a string.
jeffshumphreys@gmail.com
committed

Commits on Oct 27, 2020

Fix not-working ExtractX function. Tested the fix.
jeffshumphreys@gmail.com
committed

Commits on Oct 15, 2020

Added some string extractors, fixed a typo in the register script. Getting into some interesting stuff: Extracting Personal names. Next: Addresses, nicknames, ticket #s, job names, dates, initial…
jeffshumphreys@gmail.com
committed

Commits on Sep 26, 2020

Restored name to "M" not "Mth". makes more sense.
jeffshumphreys@gmail.com
committed
Fixed error in test where I was expecting the wrong output due to me forgetting it was case sensitive.
jeffshumphreys@gmail.com
committed
Added 1 test and finished out test stub so as to get 100% on coverage. New tests are a bit on the simple side.
jeffshumphreys@gmail.com
committed
Finished all staged tests, though some functions are missing tests. Cleaned up test names to match new function naming style.
jeffshumphreys@gmail.com
committed
Need to add case insensitive versions, accent insensitive.
jeffshumphreys@gmail.com
committed
Added SQL wrappers for Max3DateTimes and Max4DateTimes. Fixed return type to be DATETIME2.
jeffshumphreys@gmail.com
committed

Commits on Sep 23, 2020

Added test for the Split 8.
jeffshumphreys@gmail.com
committed
Bug in CapturesX fixed. Was not returning multiple captures.
jeffshumphreys@gmail.com
committed
Added a SplitTo8 function since I had a use case for it.
jeffshumphreys@gmail.com
committed

Commits on Sep 11, 2020

Added the new RightOfN function. Also started to add some ExpectedValues so the tests are actually useful.
jeffshumphreys@gmail.com
committed
Casing realign
jeffshumphreys@gmail.com
committed
Silly case change to match pattern of extensions being in upper case to avoid 1) having totally different names for same external function and 2) preventing collision in deployment since SQL Server…
jeffshumphreys@gmail.com
committed
New function. Much like substring, but I don't SQL SUBSTRING supports a single index parameter. You always have to put the damn length.
jeffshumphreys@gmail.com
committed
Becoming a common pattern to wrap externalized functions in uppercase extensions for use within the library.
jeffshumphreys@gmail.com
committed
Massive improvements on capabilities, but no tests added. Fixed to return null instead of true if it gets an unrecognized request.
jeffshumphreys@gmail.com
committed

Commits on Aug 27, 2020

Added StringSplit file.
jeffshumphreys@gmail.com
committed
Added the String Splits function, and my new function.
jeffshumphreys@gmail.com
committed
Added one test to verify my new split line into columns.
jeffshumphreys@gmail.com
committed
Moved out the splitters into their own file.
jeffshumphreys@gmail.com
committed
Moved string splitters, possible unused, out of pivots and into Splits.
jeffshumphreys@gmail.com
committed
Placement error: SingleStringAsArray is not an extraction, but rather a transformation.
jeffshumphreys@gmail.com
committed
New distinction between the pivots, which generate real rows, and the splits which just create additional columns for your OUTER APPLY function.
jeffshumphreys@gmail.com
committed

Commits on Aug 25, 2020

Merge branch 'master' of https://github.com/jeffshumphreys/MySQLCLRFunctions
jeffshumphreys
committed
sync and pick up changes from new machine?????
jeffshumphreys@gmail.com
committed
Added notes.
jeffshumphreys
committed