AfterDeploy

Rhetos.AfterDeploy is a plugin package for Rhetos development platform. It simplifies the handling of SQL scripts that need to be executed on each deployment.

Features

• This plugin will activate inside DeployPackages.exe, after database is upgraded.
• It will execute all SQL scripts placed in the AfterDeploy subfolder of each deployed package.
  • Note that these SQL scripts may directly use all tables, views and other database objects. There no need for special formatting or limitations that are present in the DataMigration scripts.
• Order of execution:
  • The SQL scripts from one package will be executed in alphabetical order, using natural sort for numbers in folder and file names.
  • The ordering of SQL scripts will respect dependencies between packages, defined in their .nuspec files.

AfterDeploy vs DataMigration scripts

AfterDeploy scripts are useful for data that is not an integral part of the business application (is not referenced by other entities) and should be refreshed on each deployment.

• Roles and permissions are a good example. There can be one script that contains predefined roles or permissions. On each deployment the script should compare the existing data to the expected, and update the database. See the chapter "Inserting the permissions on deployment".
• AfterDeploy scripts are executed at the end of the deployment process, after the database structure is upgraded.

DataMigration scripts are useful for data that needs to be changed when the business objects are changed in new versions of the business applications.

• Hard-coded data tables should be initialized in data-migration scripts. These records could be modified with new versions of the applications. More importantly, these records are usually referenced from other tables, so the data-migrations scripts for the other tables might need the hard-coded data already inserted into the database.
• DataMigration scripts are executed at the beginning of the deployment process, before the database structure is upgraded.

Installation and configuration

Installing this package to a Rhetos application:

1. Add 'Rhetos.AfterDeploy' NuGet package, available at the NuGet.org on-line gallery.

How to contribute

Contributions are very welcome. The easiest way is to fork this repo, and then make a pull request from your fork. The first time you make a pull request, you may be asked to sign a Contributor Agreement. For more info see How to Contribute on Rhetos wiki.

Building and testing the source code

• Note: This package is already available at the NuGet.org online gallery. You don't need to build it from source in order to use it in your application.
• To build the package from source, run Clean.bat, Build.bat and Test.bat.
• For the test script to work, you need to create an empty database and a settings file test\TestApp\rhetos-app.local.settings.json with the database connection string (configuration key "ConnectionStrings:RhetosConnectionString").
• The build output is a NuGet package in the "Install" subfolder.