stages:
  - Mysql-project_name-env_name

project_name-updatesql:
  stage: Mysql-project_name-env_name
  tags:
    - runner-tag-name
  script:
    - echo "Project database updatesql starting"  
    - mvn liquibase:updateSQL@project_name.environment_name.updateSql -Dliquibase.logging=debug -Dliquibase.verbose=true -Dliquibase.username=mysql_username -Dliquibase.password=mysql_password -Dliquibase.url=jdbc:mysql://MYSQL_IP_ADRESESS:MYSQL_PORT_NUMBER/Database_Name
    - cat $CI_PROJECT_DIR/target/liquibase/migrate.sql
  only:
    - master


project_name-update:
  stage: Mysql-project_name-env_name
  tags:
    - runner-tag-name
  script:
    - echo "Project database update starting"  
    - mvn liquibase:update@project_name.environment_name.update -Dliquibase.logging=debug -Dliquibase.verbose=true -Dliquibase.username=mysql_username -Dliquibase.password=mysql_password -Dliquibase.url=jdbc:mysql://MYSQL_IP_ADRESESS:MYSQL_PORT_NUMBER/Database_Name
  when: manual
  only:
    - master


project_name-rollback:
  stage: Mysql-project_name-env_name
  tags:
    - runner-tag-name
  script:
    - echo "Project database rollback starting"  
    - mvn liquibase:rollback@project_name.environment_name.rollback -Dliquibase.logging=debug -Dliquibase.verbose=true -Dliquibase.username=mysql_username -Dliquibase.password=mysql_password -Dliquibase.url=jdbc:mysql://MYSQL_IP_ADRESESS:MYSQL_PORT_NUMBER/Database_Name
  when: manual
  only:
    - master