WordPress testing command

create-db.bat

@ECHO OFF
SET BIN_TARGET=%~dp0/./create-db.php
php "%BIN_TARGET%" %*

create-db.php

<?php

if (!empty($argv[1])) {
	$db_name = $argv[1];

	$servername = "localhost";
	$username = "root";
	$password = "";

	// Create connection
	$conn = new mysqli($servername, $username, $password);
	// Check connection
	if ($conn->connect_error) {
	    die("Connection failed: " . $conn->connect_error);
	}

	// Create database
	$sql = "CREATE DATABASE $db_name";
	if ($conn->query($sql) === TRUE) {
	    echo "Database created successfully";
	} else {
	    echo "Error creating database: " . $conn->error;
	}

	$conn->close();

	die();
}

echo "Please add database name";

create-wordpress.bat

@ECHO OFF
SET /a _rand=(%RANDOM%*500/32768)+1

C:
cd \xampp\htdocs\wordpress\ && mkdir wp_test_%_rand% && cd wp_test_%_rand% && wp core download && create-db wp_test_%_rand% && wp core config --dbhost=localhost --dbname=wp_test_%_rand% --dbuser=root --dbpass= && chmod 644 wp-config.php && wp core install --url=wordpress.local/wp_test_%_rand% --title="WordPress Test %_rand%" --admin_name=admin --admin_password=admin --admin_email=dev@wordpress.local && ECHO Open URL http://wordpress.local/wp_test_%_rand%

Xampp Virtual host.conf

<VirtualHost *:80>
    DocumentRoot "C:/xampp/htdocs/wordpress"
    ServerName wordpress.local
    <Directory "C:/xampp/htdocs/wordpress">
        AllowOverride All
        Require all granted
    </Directory>
</VirtualHost>