Skip to content

Latest commit

 

History

History
136 lines (100 loc) · 8.91 KB

CHANGELOG.md

File metadata and controls

136 lines (100 loc) · 8.91 KB
Raw

Change log

Represents the NuGet versions.

v4.2.5

  • Fixed: Remove redundant async-await where returning Task will suffice within DatabaseConsole.

v4.2.4

  • Fixed: Updated target frameworks to be netcoreapp3.1;net6.0.

v4.2.3

  • Enhancement: Database migration capabilities moved into new DbEx and referenced.
  • Enhancement: Updated to account for changes to Beef.CodeGen.Core and newly extracted base OnRamp capabilities.
  • Enhancement: DatabaseConsoleWrapper has been removed; use DatabaseConsole (breaking change).
  • Enhancement: Command-line arguments and options have been adjusted and may result in breaking change; they are as follows:
Beef.Database.Core Database Tool.

Usage: Beef.Database.Core [options] <command> <script-args>

Arguments:
  command                    Database command.
                             Allowed values are: None, Drop, Create, Migrate, CodeGen, Schema, Deploy, Reset, Data, DeployWithData, Database, DropAndDatabase, All, DropAndAll, ResetAndData, ResetAndDatabase, ResetAndAll, Script.
  script-args                Script arguments (first being the script name). [Script]

Options:
  -?|-h|--help               Show help information.
  -cs|--connection-string    Database connection string.
  -cv|--connection-varname   Database connection string environment variable name.
  -so|--schema-order         Database schema name (multiple can be specified in priority order).
  -a|--assembly              Assembly containing embedded resources (multiple can be specified in probing order).
  -eo|--entry-assembly-only  Use the entry assembly only (ignore all other assemblies).
  -su|--supported            Supported commands (integer)
  -s|--script                Script orchestration file name. [CodeGen]
  -c|--config                Configuration data file name. [CodeGen]
  -o|--output                Output directory path. [CodeGen]
  -p|--param                 Parameter expressed as a 'Name=Value' pair (multiple can be specified). [CodeGen]
  -enc|--expect-no-changes   Indicates to expect _no_ changes in the artefact output (e.g. error within build pipeline). [CodeGen]
  -sim|--simulation          Indicates whether the code-generation is a simulation (i.e. does not update the artefacts). [CodeGen]
  -x2y|--xml-to-yaml         Convert the XML configuration into YAML equivalent (will not codegen). [CodeGen]

v4.2.2

  • Enhancement: Updated for changes to Beef.Abstractions and Beef.Core.

v4.2.1

  • Enhancement: Re-baseline all Beef components to version v4.2.1 required by Beef.Abstractions introduction; including updating all dependent NuGet packages to their latest respective version.

v4.1.7

  • Fixed: Fix error Cannot delete rows from a temporal history table when resetting (deleting) temporal table contents during test fixture start-up.

v4.1.6

  • Enhancement: Added ability to specify within the data YAML the IIdentifierGenerators type using global ^Type property. Where a table is prefixed with a ^ or $^ then the identifier value will be generated and set using the appropriate IIdentifierGenerator.
  • Enhancement: Updated project to produce symbol packages for improved debugging.
  • Enhancement: Added ^(Namespace.Type.Property.Method().etc, AssemblyName) runtime value lookup syntax to data YAML.

v4.1.5

  • Enhancement: Added additional statistics information to console output.
  • Enhancement: Will strip out bin/debug and bin/release folders from default directory path to find the output directory; meaning the path does not need to be explicity set when running/debugging from Visual Studio.

v4.1.4

  • Enhancement: Updated all dependent NuGet packages to their latest respective version.
  • Fixed: The DeleteAllAndReset.sql updated to ignore schema cdc.

v4.1.3

  • Enhancement: All database code generation now completely replaced by Handlebars.Net.
  • Enhancement: Reference data schema specification now removed throughout; will now be inferred from the database itself (columns Code, Text, IsActive and SortOrder). This will allow any schema to be used.
  • Enhancement: A new command line option --environmentVariableName has been added so that this value can be overridden versus using the default; this option also added to direct Beef.Database.Core execution. Where this is specified, and a corresponding value is found, this will take precedence.

v4.1.2

  • Enhancement: The ScriptNew option has been changed to add support for a new -createref to create using the reference data schema; instead of the inferring from the schema name (this support has been removed). This way the developer explicitly decides and allows reference data to be used in any schema.
  • Fixed: Issue 71 has been resolved. A runtime error will now correctly result in a return code of -1.

v4.1.1

  • Enhancement: Introduction of Dependency Injection support.

v3.1.10

v3.1.9

  • Enhancement: Added useBeefDbo option to the DatabaseExecutor.RunAsync to include the standard Beef dbo schema objects. Avoids having to specify the Beef.Database.Core assembly.
  • Fix: Threading issue with the Insert or Merge of Yaml data process that has been resolved. Also updated to return the number of rows affected and output to the log.

v3.1.8

  • Fixed: Issue 55 has been resolved. Refactored database reset to no longer use sp_MSforeachtable which is not available in Azure SQL.

v3.1.7

  • Fixed: Issue 53 has been resolved. The Beef.Database.Core environment variable naming for connection string has been renamed to be more consistent and compatible with linux.

v3.1.6

  • Fixed: Code-gen templates updated to correct warnings identified by FxCop. Where no direct fix, or by intention, these have been explicitly ignored.

v3.1.5

  • Enhancement: Updated all dependent NuGet packages to their latest respective version.

v3.1.4

  • Enhancement: Added fnGetUserId and updated spSetSessionContext to support the new ExecutionContext.UserId.

v3.1.3

  • Enhancement: Updated all dependent NuGet packages to their latest respective version.

v3.1.2

  • Fixed: Migrations scripts were being executed by DbUp in alphabetical order regardless of Assembly order (DbUp default); now will execute in Assembly, then alphabetical order (override).
  • Fixed: Migrations scripts were being executed by DbUp as WithTransactionPerScript which has been updated to WithoutTransaction as some DDL statements cannot run within a transactional context. However, it is recommended where possible that each migration script is transactional to avoid partial update on script failure; i.e. each script should only perform a single unit of work to ensure database consistency at all times.

v3.1.1

  • Upgrade: Upgraded the project to .NET Standard 2.1 (compatible with .NET Core 3.1).
  • Enhancement: Tool updated to execute asynchoronously. Both DatabaseConsole and DatabaseConsoleWrapper have breaking change; Run has been removed, replaced with RunAsync.

v2.1.9

  • Fixed: fnGetUsername updated to support usernames as nvarchar(1024) to enable any reasonable username size to be supported. This is the same as what is currently supported by spSetSessionContext.

v2.1.8

v2.1.7

  • Fixed: Introduced FxCop Analysis to Beef.Database.Core; this version represents the remediation based on the results.

v2.1.6

  • Fixed: Database merge statements updated to include AND EXISTS (...) for a WHEN MATCHED to avoid updates where column data has not changed.

v2.1.5

  • Enhancement: All usernames will be set to ExecutionContext.EnvironmentUsername (this results in the same outcome).

v2.1.4

  • Fixed: Internal Beef dependencies changed as a result of other changes.

v2.1.3

  • Fixed: Create of new script will no longer make the schema and table names lowercase for the script file name and will honour the input case.

v2.1.2

  • Fixed: Inconsistent version numbers.

v2.1.1

  • New: Initial publish to GitHub.