Refresh install-wp-tests.sh script

[swissspidy]

Feature Request

• Yes, I reviewed the contribution guidelines.

Describe your use case and the problem you are facing

This script hasn't really seen any major updates, because they haven't been necessary, but I think there's still some room for improvements.

Describe the solution you'd like

Some thoughts and ideas:

• I don't think we still need install the DB drop-in from https://github.com/markoheijnen/wp-mysqli (which just sets WP_USE_EXT_MYSQL to false) anymore.
• There is no good way to keep install-wp-tests.sh in sync with the version here. Developers miss out on important updates.
  Even just adding a link to this repo at the top of the file, maybe with a "Last updated" date, would be helpful
• Sometimes I had to add a User-Agent header to cURL requests as WordPress.org seemed to block requests otherwise.
  e.g. curl -H "User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10_13_1) AppleWebKit/537.36 (K HTML, like Gecko) Chrome/61.0.3163.100 Safari/537.36" -s "$1" > "$2";
• The script could have built-in MariaDB support, e.g. checking for mariadb-admin

[swissspidy]

Another thing that's annoying:

On macOS the files in the tmo wordpress and wordpress-tests-lib can get wiped sometimes, but the folders are still there. But because the script only checks if the folders exist and not the files, it won't recreate the setup.

To make that more robust, we can check if files like "$WP_TESTS_DIR"/includes/functions.php and "$WP_CORE_DIR"/wp-includs.php exist.

See swissspidy/performant-translations@108e443

[swissspidy]

GitHub Actions is upgrading to Ubuntu 24 and no longer installs SVN by default. See actions/runner-images#10636

Similarly, in the past Apple has removed Subversion from macOS (starting with 10.15 Catalina)

That means now many people will need to update their GitHub Actions workflows to install Subversion, or have to first install it on their computers.

Luckily WordPress source code can also be downloaded with Git, which is the preferred method for almost everyone. You only really need SVN if you need to commit to core). Thus, I suggest changing the script to use Git.