Database Migration - missing dbm-* commands in grails shell

[jamesfredley]

Issue description

Grails 7.0.0-M5 and 7.0.0-SNAPSHOT

Currently two are available.

grails> dbm-c                                                                                                                                                                                                        

dbm-changelog-to-groovy   dbm-create-changelog  

a longer list is available as Gradle tasks. The lists are expected to be the same after the script commands were previously restored.

dbmChangelogSync
dbmChangelogSyncSql
dbmClearChecksums
dbmDbDoc
dbmDiff
dbmDropAll
dbmFutureRollbackCountSql
dbmFutureRollbackSql
dbmGenerateChangelog
dbmGenerateGormChangelog
dbmGormDiff
dbmListLocks
dbmMarkNextChangesetRan
dbmMarkNextChangesetRanSql
dbmPreviousChangesetSql
dbmReleaseLocks
dbmRollback
dbmRollbackCount
dbmRollbackCountSql
dbmRollbackSql
dbmRollbackToDate
dbmRollbackToDateSql
dbmStatus
dbmTag
dbmUpdate
dbmUpdateCount
dbmUpdateCountSql
dbmUpdateSql
dbmValidate

[jdaugherty]

If you open the interactive console and hit tab, are they all there?

[jamesfredley]

grails> help                                                                                                                                                                                                         

Usage (optionals marked with *):'
grails [environment]* [target] [arguments]*'


| Examples:
$ grails dev run-app
$ grails create-app books

| Available Commands (type grails help 'command-name' for more info):
| Command Name                          Command Description
----------------------------------------------------------------------------------------------------
assemble                                Creates a JAR or WAR archive for production deployment
bug-report                              Creates a zip file that can be attached to issue reports for the current project
clean                                   Cleans a Grails application's compiled sources
compile                                 Compiles a Grails application
console                                 Runs the Grails interactive console
create-command                          Creates an Application Command
create-controller                       Creates a controller
create-domain-class                     Creates a Domain Class
create-integration-test                 Creates an integration test
create-interceptor                      Creates an interceptor
create-scaffold-controller              Creates a scaffolded controller
create-script                           Creates a Grails script
create-service                          Creates a Service
create-taglib                           Creates a Tag Library
create-unit-test                        Creates a unit test
dbm-changelog-to-groovy                 Converts a changelog file to a Groovy DSL file
dbm-create-changelog                    Creates an empty changelog file
dependency-report                       Prints out the Grails application's dependencies
generate-all                            Generates a controller that performs CRUD operations and the associated views
generate-async-controller               Generates an asynchronous controller that performs CRUD operations
generate-controller                     Generates a controller that performs CRUD operations
generate-views                          Generates GSP views for the specified domain class
gradle                                  Allows running of Gradle tasks
help                                    Prints help information for a specific command
install-templates                       Installs scaffolding templates that use f:all to render properties
list-plugins                            Lists available plugins from the Plugin Repository
open                                    Opens a file in the project
plugin-info                             Prints information about the given plugin
run-app                                 Runs a Grails application
run-command                             Executes Grails commands
run-script                              Executes Groovy scripts in a Grails context
shell                                   Runs the Grails interactive shell
stats                                   Prints statistics about the project
stop-app                                Stops the running Grails application
test-app                                Runs the applications tests
url-mappings-report                     Prints out a report of the project's URL mappings

| Detailed usage with help [command]

[jamesfredley]

Sample app: https://github.com/jamesfredley/database-migration-test

[jamesfredley]

Taking dbm-update as an example, here is it's history

https://github.com/apache/grails-core/commits/b16893228ca30ce40e2cc8c9bf0f14daae983d3b/grails-data-hibernate5/dbmigration/grails-app/commands/org/grails/plugins/databasemigration/command/DbmUpdateCommand.groovy

https://github.com/grails/grails-database-migration/commits/6.0.x/grails-app/commands/org/grails/plugins/databasemigration/command/DbmUpdateCommand.groovy

[jamesfredley]

GrailsGradlePlugin.groovy creates the Gradle Task dbmUpdate

https://github.com/apache/grails-core/blob/7.0.x/grails-gradle/plugins/src/main/groovy/org/grails/gradle/plugin/core/GrailsGradlePlugin.groovy#L476-L504

[jamesfredley]

From Grails 6.2.3:

./gradlew task --all

dbmChangelogSync
dbmChangelogSyncSql
dbmClearChecksums
dbmDbDoc
dbmDiff
dbmDropAll
dbmFutureRollbackCountSql
dbmFutureRollbackSql
dbmGenerateChangelog
dbmGenerateGormChangelog
dbmGormDiff
dbmListLocks
dbmMarkNextChangesetRan
dbmMarkNextChangesetRanSql
dbmPreviousChangesetSql
dbmReleaseLocks
dbmRollback
dbmRollbackCount
dbmRollbackCountSql
dbmRollbackSql
dbmRollbackToDate
dbmRollbackToDateSql
dbmStatus
dbmTag
dbmUpdate
dbmUpdateCount
dbmUpdateCountSql
dbmUpdateSql
dbmValidate

./grailsw help

dbm-changelog-sync                      Mark all changes as executed in the database
dbm-changelog-sync-sql                  Writes the SQL that will mark all changes as executed in the database to STDOUT or a file
dbm-changelog-to-groovy                 Converts a changelog file to a Groovy DSL file
dbm-clear-checksums                     Removes current checksums from database. On next run checksums will be recomputed
dbm-create-changelog                    Creates an empty changelog file
dbm-db-doc                              Generates Javadoc-like documentation based on current database and change log
dbm-diff                                Compares two databases and creates a changelog that will make the changes required to bring them into sync
dbm-drop-all                            Drops all database objects owned by the user
dbm-future-rollback-count-sql           Writes SQL to roll back the database to the current state after <number> changes in the changeslog have been applied
dbm-future-rollback-sql                 Writes SQL to roll back the database to the current state after the changes in the changeslog have been applied
dbm-generate-changelog                  Generates an initial changelog XML or Groovy DSL file from the database
dbm-generate-gorm-changelog             Generates an initial changelog XML or Groovy DSL file from current GORM classes
dbm-gorm-diff                           Diffs GORM classes against a database and generates a changelog XML or Groovy DSL file
dbm-list-locks                          Lists who currently has locks on the database changelog to STDOUT or a file
dbm-mark-next-changeset-ran             Mark the next change set as executed in the database
dbm-mark-next-changeset-ran-sql         Writes SQL to mark the next change as executed in the database to STDOUT or a file
dbm-previous-changeset-sql              Generates the SQL to apply the previous <value> change sets
dbm-release-locks                       Releases all locks on the database changelog
dbm-rollback                            Rolls back the database to the state it was in when the tag was applied
dbm-rollback-count                      Rolls back the specified number of change sets
dbm-rollback-count-sql                  Writes the SQL to roll back the specified number of change sets to STDOUT or a file
dbm-rollback-sql                        Writes SQL to roll back the database to the state it was in when the tag was applied to STDOUT or a file
dbm-rollback-to-date                    Rolls back the database to the state it was in at the given date/time
dbm-rollback-to-date-sql                Writes SQL to roll back the database to the state it was in at the given date/time to STDOUT or a file
dbm-status                              Outputs count or list of unrun change sets to STDOUT or a file
dbm-tag                                 Adds a tag to mark the current database state
dbm-update                              Updates a database to the current version
dbm-update-count                        Applies next NUM changes to the database
dbm-update-count-sql                    Writes the SQL that will partially update a database to STDOUT or a file
dbm-update-sql                          Writes the SQL that will update the database to the current version to STDOUT or a file
dbm-validate                            Checks the changelog for errors

Shell has two extras: 29 vs 31, which are the only ones currently showing up in Grails 7.0.0-SNAPSHOT

dbm-changelog-to-groovy Converts a changelog file to a Groovy DSL file
dbm-create-changelog Creates an empty changelog file