1.5.4 - Trim less

.Net 8 was a bit too eager on its assembly trimming by default, which made command-line argument parsing not work. Fixes #379

What's Changed

• Fixed test project names by @erikbra in #378
• Fixed too eager trimming on .net 8 by @erikbra in #381

Full Changelog: 1.5.3...1.5.4

1.5.3 - PostgreSQL fixes and .NET 8rc1

PostgreSQL command splitting

Thanks to @Westat-Transportation for reporting that the PostgreSQL statement splitting was still not working, and of course @wokket for taking part in discussing different solutions.

.NET 8 support

.NET 8 is in RC1, and has a go-live license from Microsoft, so there's no reason not to start using it. The dotnet tool has multi-framework support, .net 6, 7 and 8. The native, self-contained binaries are now compiled with .net 8rc1. This shouldn't make any difference to anyone, but please scream out loud if something breaks :)

Test reports with smink

I also changed to using my own tool, smink, to generate test reports. smink focuses on readability, and presenting all tests that have been run in a test suite, for documentation, accountability, and future reference. I made it because I couldnt' find anything existing that creates nice, self-contained HTML report from xUnit or NUnit xml results. You can find the HTML reports as artifacts on the CI builds. (An example) Feel free to check out the project.

What's Changed

• build(deps): update FluentAssertions requirement from 6.11.* to 6.12.* by @dependabot in #362
• build(deps): bump Microsoft.NET.Test.Sdk from 17.7.0 to 17.7.2 by @dependabot in #363
• build(deps): bump actions/checkout from 3 to 4 by @dependabot in #364
• build(deps): bump docker/login-action from 2.2.0 to 3.0.0 by @dependabot in #369
• build(deps): update NSubstitute requirement from 5.0.* to 5.1.* by @dependabot in #366
• build(deps): bump docker/build-push-action from 4.1.1 to 5.0.0 by @dependabot in #368
• Fixed PostgreSQL version number in test by @erikbra in #370
• build(deps): bump docker/metadata-action from 4.6.0 to 5.0.0 by @dependabot in #367
• Better test reports with smink by @erikbra in #372
• build(deps): bump coverlet.collector from 3.1.2 to 6.0.0 by @dependabot in #373
• build(deps): update Microsoft.NET.Test.Sdk requirement from 17.6.* to 17.7.* by @dependabot in #374
• Clean up tests a bit - for better test reports by @erikbra in #375
• Add .NET 8 support (rc1 for now) by @erikbra in #376
• Issue #371: Use internal Npgsql logic to split/parse PostgreSQL sql scripts by @erikbra in #377

Full Changelog: 1.5.2...1.5.3

1.5.2

Regression fix on PostgreSQL statement splitting

Thanks a lot to @koenekelschot for contributing this fix, and thanks to @Westat-Transportation for supplying a repro demonstrating a slightly different, but related problem.

What's Changed

• build(deps): bump Microsoft.NET.Test.Sdk from 17.6.3 to 17.7.0 by @dependabot in #359
• Issue #357: refine postgresql batch statement splitting by @koenekelschot in #358
• Issue #357: Fixed error with splitting on batch separator inside quotes by @erikbra in #360

New Contributors

• @koenekelschot made their first contribution in #358

Full Changelog: 1.5.1...1.5.2

1.5.1

What's Changed

Bugfix release, thanks to all contributors. I really appreciate that people engage!

A special thanks to first-time contributors @ryanmwright and @3nth 💯

As always, more contributors are welcome, don't be afraid to contribute, no matter how small the contribution. See a missing feature? Notice an issue? Questions about usage? All grate improvements start with us, the users, caring, and finding stuff that can be improved.

And, if you can contribute with actual code or documentation changes, this is especially appreciated. Please don't hesitate to reach out if you have never contributed to an open-source project before, and don't know where to start, and we'll try to help you get started.

Bugs fixed

• Bug #247: Don't trim assemblies on Windows - SNI problems by @erikbra in #326
• Bug #298: Error inserting large scripts in ScriptsRun and -Errors tables on Oracle by @erikbra in #327
• SQL*Plus compatible separator by @ryanmwright in #325
• Added unit tests for statement splitting on Oracle by @erikbra in #328
• Solve #245 without new command-line parameter by @erikbra in #256
• Don't try to create the LocalApplicationData folder as default by @erikbra in #344
• Bug #334: Fix batch statement splitting for PostgreSQL by @erikbra in #345
• Issue #342: Disable pipelining on MySQL/MariaDB connections if not explicitly enabled by @erikbra in #346
• 336 - SearchAllSubdirectoriesInsteadOfTraverse by @3nth in #337
• Bug #355: Fixed FolderType of RunFirstAfterUp by @erikbra in #356

Chores

• build(deps): bump docker/metadata-action from 4.3.0 to 4.4.0 by @dependabot in #331
• build(deps): update FluentAssertions requirement from 6.10.* to 6.11.* by @dependabot in #333
• build(deps): bump Microsoft.NET.Test.Sdk from 17.5.0 to 17.6.0 by @dependabot in #339
• build(deps): bump Microsoft.NET.Test.Sdk from 17.6.0 to 17.6.1 by @dependabot in #343
• build(deps): update NUnit3TestAdapter requirement from 4.4.* to 4.5.* by @dependabot in #341
• build(deps): bump docker/build-push-action from 4.0.0 to 4.1.0 by @dependabot in #351
• build(deps): bump docker/login-action from 2.1.0 to 2.2.0 by @dependabot in #349
• build(deps): bump docker/metadata-action from 4.4.0 to 4.5.0 by @dependabot in #348
• build(deps): bump Microsoft.NET.Test.Sdk from 17.6.1 to 17.6.2 by @dependabot in #347
• chore: Clean up compiler warnings/analysers by @wokket in #350
• build(deps): bump docker/metadata-action from 4.5.0 to 4.6.0 by @dependabot in #353
• build(deps): bump docker/build-push-action from 4.1.0 to 4.1.1 by @dependabot in #352
• build(deps): bump Microsoft.NET.Test.Sdk from 17.6.2 to 17.6.3 by @dependabot in #354

New Contributors

• @ryanmwright made their first contribution in #325
• @3nth made their first contribution in #337

Full Changelog: 1.5.0...1.5.1

Release 1.5.0

Release 1.5.0

As usual, quite a while between releases, as real work™️ and life itself takes some time 😄

Thanks to all the people that contribute, either via filing issues or PRs to grate! More contributors are more than welcome as well! No contribution is too small 😃

Grate is now also available via homebrew - separate cask for now, hope to get it into the official homebrew repo soon:
https://erikbra.github.io/grate/getting-grate/#homebrew

You can get the binaries from here below, if that's your thing, or you can use some of the more convenient deployment channels, listed here: https://erikbra.github.io/grate/getting-grate/

What's Changed

Bugs fixed

• Issue #235: Incorrect exception message in Migration\OracleDatabase.cs - (Maria DB -> Oracle) by @RachelAmbler in #240
• workflow donwload ref up to v1.4.0 by @OzBob in #281
• Issue #282: Respect the users console background colours by @wokket in #290
• Issue #311: Do not output 'No sql run' in Dryrun mode by @erikbra in #316
• Issue #307: Set 'master' DB name per database type by @erikbra in #314
• Issue #232: Disable connection pooling by default for SqlServer by @erikbra in #322

New features

• Create winget package on build - resolves #209 by @erikbra in #231
• .NET 7 support by @erikbra in #313
• Feat #252 custom create database by @erikbra in #289

Improvements in documentation

• Fixed some typos with AnyTime (issue #237) by @RachelAmbler in #239
• GettingStarted by @OzBob in #279
• Using Markdown comment in issue templates so user doesn't need to remove the instructions lines manually by @MangelMaxime in #293
• Clarify --adminconnectionstring purpose in docs by @mattgallagher92 in #309
• Bug #302: Clarify documentation when specifying multiple folders by @erikbra in #317
• Update configuration docs to reflect pull #314 by @mattgallagher92 in #318
• Feat #61: Added doc on how to install with homebrew by @erikbra in #323

Chores

• Bump Microsoft.NET.Test.Sdk from 17.3.1 to 17.3.2 by @dependabot in #254
• Restrict max CPU count to 2 when running tests by @erikbra in #257
• Bump docker/login-action from 2.0.0 to 2.1.0 by @dependabot in #263
• Bump docker/build-push-action from 3.1.1 to 3.2.0 by @dependabot in #262
• Bump docker/metadata-action from 4.0.1 to 4.1.0 by @dependabot in #261
• Bump gittools/actions from 0.9.13 to 0.9.14 by @dependabot in #260
• Bump Microsoft.Data.SqlClient from 5.0.0 to 5.0.1 by @dependabot in #259
• fix: Added tests using case sensitive Sql server by @wokket in #251
• Bump actions/setup-dotnet from 2 to 3 by @dependabot in #258
• Bumped PostgreSQL identifier from 14 -> 15 on latest by @erikbra in #271
• Update FluentAssertions requirement from 6.7.* to 6.8.* by @dependabot in #267
• Bump docker/metadata-action from 4.1.0 to 4.1.1 by @dependabot in #266
• Bump gittools/actions from 0.9.14 to 0.9.15 by @dependabot in #272
• Update NUnit3TestAdapter requirement from 4.2.* to 4.3.* by @dependabot in #273
• Update Microsoft.Extensions.DependencyInjection requirement from 6.0.* to 7.0.* by @dependabot in #275
• Update Microsoft.Extensions.Logging.Console requirement from 6.0.* to 7.0.* by @dependabot in #278
• Update Microsoft.Extensions.Hosting requirement from 6.0.* to 7.0.* by @dependabot in #276
• Update Microsoft.Data.Sqlite requirement from 6.0.* to 7.0.* by @dependabot in #277
• Update MySqlConnector requirement from 2.1.* to 2.2.* by @dependabot in #285
• Update NUnit.Console requirement from 3.15.* to 3.16.* by @dependabot in #287
• Bump Microsoft.NET.Test.Sdk from 17.3.2 to 17.4.1 by @dependabot in #288
• Update Npgsql requirement from 6.0.* to 7.0.* by @dependabot in #286
• Bump docker/build-push-action from 3.2.0 to 4.0.0 by @dependabot in #300
• Bump Microsoft.Data.SqlClient from 5.0.1 to 5.1.0 by @dependabot in #299
• Bump docker/metadata-action from 4.1.1 to 4.3.0 by @dependabot in #297
• Bump Microsoft.NET.Test.Sdk from 17.4.1 to 17.5.0 by @dependabot in #306
• Update NSubstitute requirement from 4.4.* to 5.0.* by @dependabot in #304
• Update FluentAssertions requirement from 6.8.* to 6.10.* by @dependabot in #303
• build(deps): bump gittools/actions from 0.9.15 to 0.10.2 by @dependabot in #312
• build(deps): update NUnit3TestAdapter requirement from 4.3.* to 4.4.* by @dependabot in #308
• Changed to using official Oracle docker image for testing by @erikbra in #291
• Make unit tests work again by @erikbra in #315
• build(deps): bump Microsoft.Data.SqlClient from 5.1.0 to 5.1.1 by @dependabot in #320

New Contributors

• @RachelAmbler made their first contribution in #239
• @MangelMaxime made their first contribution in #293
• @mattgallagher92 made their first contribution in #309

Full Changelog: 1.4.0...1.5.0

Release 1.4.0

Release 1.4.0

It's been a while since the last major grate release, sorry about that, but you know, life, and, stuff. But, more and more people are taking time to contribute to grate, and that makes this more and more of a team effort, and that's really appreciated!

Thanks as always to @wokket , which is a great contributor, as always, and does a lot of stuff related to grate!
Contributions this time includes #212 and #142 . Very nice work, thanks! I hope we can improve the output even more going forward, to make it even cleaner, more predictable, and even less noisy when nothing changed since last run.

A special thanks to first-time contributor @DjKillerMemeStar, who solved an issue we brought with us over from RoundhousE days, #196 .

And, thanks to @grrttedwards, who updated the documentation for a MySQL-specific feature of "Allow User Variables", which is not set by default by grate.

A big-ish features, implementation-wise, is #198 , which lets you go wild and use grate with totally different folder structures, including giving the existing ones other names, or create your own structure from the ground. More docs on that here. This is quite a big internal change too, so scream out if I broke something :)

In addition to these new features, there are some bug fixes:

• Bug #219: Scripts that should always run, even on failure, do not run on failure by @erikbra in #220
• Simplify check to see whether database exists by @erikbra in #227

and, some "chores":

• Bump docker/build-push-action from 3.0.0 to 3.1.0 by @dependabot in #213
• Chore: NSubstitute -> 4.4.* by @erikbra in #217
• Bump Microsoft.NET.Test.Sdk from 17.2.0 to 17.3.0 by @dependabot in #225
• Bump docker/build-push-action from 3.1.0 to 3.1.1 by @dependabot in #222
• Bump Microsoft.Data.SqlClient from 4.1.0 to 5.0.0 by @dependabot in #223
• Remove net5 from build pipeline by @erikbra in #228
• Bump Microsoft.NET.Test.Sdk from 17.3.0 to 17.3.1 by @dependabot in #229

Full list of what's changed (auto-generated)

• fix #211: Expose the CreateDatabase option on the commandline by @wokket in #212
• Add note about Allow User Variables in MySQL to breaking RH changes by @grrttedwards in #214
• Bump docker/build-push-action from 3.0.0 to 3.1.0 by @dependabot in #213
• Chore: NSubstitute -> 4.4.* by @erikbra in #217
• Bug #219: Scripts that should always run, even on failure, do not run on failure by @erikbra in #220
• Bump Microsoft.NET.Test.Sdk from 17.2.0 to 17.3.0 by @dependabot in #225
• Bump docker/build-push-action from 3.1.0 to 3.1.1 by @dependabot in #222
• Bump Microsoft.Data.SqlClient from 4.1.0 to 5.0.0 by @dependabot in #223
• Closes #142: Reduce console output, esp when folder is missing or empty. by @wokket in #226
• #198 different folder names by @erikbra in #224
• Remove net5 from build pipeline by @erikbra in #228
• Implement extra status column in version table by @DjKillerMemeStar in #196
• Simplify check to see whether database exists by @erikbra in #227
• Bump Microsoft.NET.Test.Sdk from 17.3.0 to 17.3.1 by @dependabot in #229

Full Changelog: 1.3.2...1.4.0

Point release to ease deployments

What's Changed

• fix #200: Ensure someone other than Erik can run a build! by @wokket in #208

Full Changelog: 1.3.1...1.3.2

Bug Fix Release

What's Changed

A couple of bug fixes, with thanks to @aeons for reporting #204.

• Fix #203: Missing support for (Admin)CommandTimeout by @wokket in #206
• fix #204: Ensure --baseline in combination with a --dryrun doesn't create the grate schema objects by @wokket in #205

Full Changelog: 1.3.0...1.3.1

Bug Fix release and one new feature

What's Changed

Along with a large number of updated dependencies, we have a small number of bug fixes, documentation updates and a new feature called out below:

• Docs: Fix broken Response file documentation link by @grrttedwards in #170
• Feature: Add support for access tokens when connecting to Azure Sql by @kimjamia in #185 ❤️
• Fix #67: Reorder the items in the help output by @DjKillerMemeStar in #197
• Fix #167: Ensure that we can connect to a SqlServer database if using different case by @wokket in #195

New Contributors

Thank you to everyone helping out, even small documentation improvements are greatly appreciated 🥳

• @grrttedwards made their first contribution in #170
• @kimjamia made their first contribution in #185
• @DjKillerMemeStar made their first contribution in #197

Full Changelog: 1.2.0...1.3.0

Mostly cleanup, one new feature

Mainly one new feature:

#150 Support equally named scripts in subfolders,

which was "stolen" from the RoundhousE repo, and implemented without too much effort. Love the test coverage on grate, it's easy to make changes with comfort.

What's Changed

• Bump docker/metadata-action from 3.6.0 to 3.6.1 by @dependabot in #146
• Update NUnit.Console requirement from 3.12.* to 3.13.* by @dependabot in #147
• Bump docker/metadata-action from 3.6.1 to 3.6.2 by @dependabot in #149
• Update MySqlConnector requirement from 2.0.* to 2.1.* by @dependabot in #144
• Bump JunitXml.TestLogger from 3.0.98 to 3.0.110 by @dependabot in #148
• Converted to file-scoped namespace declarations by @erikbra in #152
• Features/test reporting take 2 by @erikbra in #153
• Proper test reporting by @erikbra in #154
• Run all tests even if one test suite fails by @erikbra in #155
• Fixed code warnings (Roslyn analyzers and others) by @erikbra in #156
• Issue #22: Solved slow SQL Server tests by @erikbra in #157
• Feature #150: Support equally named scripts in subfolders by @erikbra in #151

Full Changelog: 1.1.0...1.2.0