Openfire (master)

• 

  Guus der Kinderen 13 Mar 2025 bce2e716675f6644e15b8fbfd395125e38e0c57a

  Remove invalid SQL added for testing purposes

  • distribution/src/database/openfire_mysql.sql (version bce2e716675f6644e15b8fbfd395125e38e0c57a)
  • distribution/src/database/openfire_postgresql.sql (version bce2e716675f6644e15b8fbfd395125e38e0c57a)
  • distribution/src/database/openfire_sqlserver.sql (version bce2e716675f6644e15b8fbfd395125e38e0c57a)
• 

  Guus der Kinderen 13 Mar 2025 365f84b1755fcd97471e4e2d97ddc59bbeb0da5c

  CI: Introduce checks for the database install scripts
  Prior to this commit, Openfire's continuous integration already had some scripts that verify the scripts used to update the database managed by Openfire from some base version to a newer version. These checks do not verify the installation script - only the update scripts, which provide a 'delta'.
  
  In this commit, the mechanism used to test the update scripts is repurposed to also test the install scripts:
  - instead of provisioning the database with a known-good (but old) database installation script, the latest version of the script is used (which is the system under test)
  - the 'update runner' is not executed at all - instead, it is assumed that a bug in the install script will cause the docker build to fail.

  • .github/workflows/continuous-integration-workflow.yml (version 365f84b1755fcd97471e4e2d97ddc59bbeb0da5c)
• 

  Guus der Kinderen 13 Mar 2025 6df3cfa9f6f32956f44ed65d2a5f53a74d6937e7

  CI: Explicitly test for DB install success
  By running the 'update' checker (which generically verifies if the database schema as installed is up-to-date), CI now explicitly checks if the execution of the install script was successful.

  • .github/workflows/continuous-integration-workflow.yml (version 6df3cfa9f6f32956f44ed65d2a5f53a74d6937e7)
  • build/ci/updater/src/main/java/com/igniterealtime/openfire/updaterunner/Main.java (version 6df3cfa9f6f32956f44ed65d2a5f53a74d6937e7)
  • distribution/src/database/openfire_db2.sql (version 6df3cfa9f6f32956f44ed65d2a5f53a74d6937e7)
  • distribution/src/database/openfire_hsqldb.sql (version 6df3cfa9f6f32956f44ed65d2a5f53a74d6937e7)
  • distribution/src/database/openfire_mysql.sql (version 6df3cfa9f6f32956f44ed65d2a5f53a74d6937e7)
  • distribution/src/database/openfire_oracle.sql (version 6df3cfa9f6f32956f44ed65d2a5f53a74d6937e7)
  • distribution/src/database/openfire_postgresql.sql (version 6df3cfa9f6f32956f44ed65d2a5f53a74d6937e7)
  • distribution/src/database/openfire_sqlserver.sql (version 6df3cfa9f6f32956f44ed65d2a5f53a74d6937e7)
  • distribution/src/database/openfire_sybase.sql (version 6df3cfa9f6f32956f44ed65d2a5f53a74d6937e7)
• 

  Guus der Kinderen 13 Mar 2025 950d3f3342f7df2ff1dc62d1a06f780ba63a6ae5

  MUST BE REVERTED BEFORE MERGE: introduce errors to test CI
  This adds errors in the database installation scripts, in order to find out if the new CI scripts pick up on this.

  • distribution/src/database/openfire_mysql.sql (version 950d3f3342f7df2ff1dc62d1a06f780ba63a6ae5)
  • distribution/src/database/openfire_postgresql.sql (version 950d3f3342f7df2ff1dc62d1a06f780ba63a6ae5)
  • distribution/src/database/openfire_sqlserver.sql (version 950d3f3342f7df2ff1dc62d1a06f780ba63a6ae5)