Fix test setup for wp-env.

After much reading I finally found the magic incantations, so now we can
run tests with real database access. This means we no longer need the
primitive $wpdb_stub.

The setup as now _requires_ wp-env, or an environment set up
sufficiently similar. Running in wp-env is the easiest, so aim for that.

I've added a `run-tests` script that will invoke the magic incantation
without having to remember it every time.

To set up for testing:

1. make sure you have composer[1] installed.
2. run `composer install`
3. make sure you have wp-env[2] installed
4. start the wordpress env: `wp-env start`
5. run the tests: `./run-tests`

Let the thousand tests bloom!

[1]: https://github.com/wp-phpunit/wp-phpunit
[2]: https://www.npmjs.com/package/@wordpress/env

3 files changed, 63 insertions, 65 deletions

diff --git a/tests/VenueTest.php b/tests/VenueTest.php
index bea6dc4..4278951 100644
--- a/tests/VenueTest.php
+++ b/tests/VenueTest.php
@@ -6,97 +6,76 @@
 
 declare(strict_types=1);
 
-use PHPUnit\Framework\TestCase;
+require __DIR__ . '/../includes/venue.php';
 
-require 'tests/stubs/wpdb_stub.php';
-require 'includes/venue.php';
-
-final class VenueTest extends TestCase
+final class VenueTest extends WP_UnitTestCase
 {
     public function testCreatingVenueWithName(): void
     {
+        $count = count(GiglogAdmin_Venue::all_venues());
+
         $venue = GiglogAdmin_Venue::create("Svene Samfunns- og Bedehus");
         $this->assertEquals("Svene Samfunns- og Bedehus", $venue->name());
-        $this->assertEquals(1, $venue->id());
+
+        $this->assertEquals($count + 1, count(GiglogAdmin_Venue::all_venues()));
     }
 
     public function testFindOrCreateNonExistingVenue() : void
     {
+        $count = count(GiglogAdmin_Venue::all_venues());
+
         $venue = GiglogAdmin_Venue::find_or_create("Svene Samfunns- og Bedehus");
         $this->assertEquals("Svene Samfunns- og Bedehus", $venue->name());
-        $this->assertEquals(1, $venue->id());
+
+        $this->assertEquals($count + 1, count(GiglogAdmin_Venue::all_venues()));
     }
 
     public function testFindOrCreateExistingVenue() : void
     {
         global $wpdb;
 
-        $results = array(
-            (object) [
-                'id' => 42,
-                'wpgvenue_name' => 'Slarkhaillen',
-                'wpgvenue_city' => 'Ofoten',
-                'wpgvenue_address' => 'Baillsvingen 4',
-                'wpgvenue_webpage' => 'https://slarkhaillen.no'
-            ]);
-
-        $wpdb = $this->createStub(wpdb::class);
-        $wpdb->method('get_results')->willReturn($results);
-
-        $venue = GiglogAdmin_Venue::find_or_create("Slarkhaillen");
+        $venue = GiglogAdmin_Venue::create("Svene Samfunns- og Bedehus");
+        $other = GiglogAdmin_Venue::find_or_create("Svene Samfunns- og Bedehus");
 
-        $this->assertEquals($results[0]->id, $venue->id());
-        $this->assertEquals($results[0]->wpgvenue_name, $venue->name());
+        $this->assertEquals($other->id(), $venue->id());
+        $this->assertEquals($other->name(), $venue->name());
     }
 
     public function testFindAllVenuesInCity() : void
     {
         global $wpdb;
 
-        $results = array();
         for ($i = 0; $i < 3; $i++) {
-            $results[$i] = (object) [
-                'id' => 42 + $i,
-                'wpgvenue_name' => "Venue #" . $i,
-                'wpgvenue_city' => "Osaka"
-            ];
+            GiglogAdmin_Venue::create("Venue in Osaka #" . $i, "Osaka");
         }
 
-        $wpdb = $this->createStub(wpdb::class);
-        $wpdb->method('prepare')->willReturn("prepared");
-        $wpdb->method('get_results')->willReturn($results);
-
-        $venues = GiglogAdmin_Venue::venues_in_city("Osaka");
+        for ($i = 0; $i < 5; $i++) {
+            GiglogAdmin_Venue::create("Venue in Berlin #" . $i, "Berlin");
+        }
 
-        for ($i = 0; $i < 3; $i++) {
-            $this->assertEquals("Osaka", $venues[$i]->city());
-            $this->assertEquals("Venue #" . $i, $venues[$i]->name());
-            $this->assertEquals(42 + $i, $venues[$i]->id());
+        for ($i = 0; $i < 2; $i++) {
+            GiglogAdmin_Venue::create("Venue in Svene #" . $i, "Svene");
         }
+
+        $venues_in_osaka = GiglogAdmin_Venue::venues_in_city("Osaka");
+        $venues_in_berlin = GiglogAdmin_Venue::venues_in_city("Berlin");
+        $venues_in_svene = GiglogAdmin_Venue::venues_in_city("Svene");
+
+        $this->assertEquals(3, count($venues_in_osaka));
+        $this->assertEquals(5, count($venues_in_berlin));
+        $this->assertEquals(2, count($venues_in_svene));
     }
 
     public function testFindAllVenues() : void
     {
         global $wpdb;
 
-        $results = array();
         for ($i = 0; $i < 3; $i++) {
-            $results[$i] = (object) [
-                'id' => 42 + $i,
-                'wpgvenue_name' => "Venue #" . $i,
-                'wpgvenue_city' => "City #" . $i
-            ];
+            GiglogAdmin_Venue::create("Venue #" . $i);
         }
 
-        $wpdb = $this->createStub(wpdb::class);
-        $wpdb->method('get_results')->willReturn($results);
-
         $venues = GiglogAdmin_Venue::all_venues();
+        $this->assertEquals(3, count($venues));
 
-        for ($i = 0; $i < 3; $i++) {
-            $this->assertEquals("City #" . $i, $venues[$i]->city());
-            $this->assertEquals("Venue #" . $i, $venues[$i]->name());
-            $this->assertEquals(42 + $i, $venues[$i]->id());
-        }
     }
 }
diff --git a/tests/bootstrap.php b/tests/bootstrap.php
new file mode 100644
index 0000000..0878ff7
--- /dev/null
+++ b/tests/bootstrap.php
@@ -0,0 +1,33 @@
+<?php
+/**
+ * PHPUnit bootstrap file
+ *
+ * @package Sample_Plugin
+ */
+
+//$_tests_dir = getenv( 'WP_TESTS_DIR' );
+require_once dirname( dirname( __FILE__ ) ) . '/vendor/autoload.php';
+$_tests_dir = getenv( 'WP_TESTS_DIR' ) ?: getenv( 'WP_PHPUNIT__DIR' );
+
+if ( ! $_tests_dir ) {
+	$_tests_dir = rtrim( sys_get_temp_dir(), '/\\' ) . '/wordpress-tests-lib';
+}
+
+if ( ! file_exists( $_tests_dir . '/includes/functions.php' ) ) {
+	echo "Could not find $_tests_dir/includes/functions.php, have you run bin/install-wp-tests.sh ?";
+	exit( 1 );
+}
+
+// Give access to tests_add_filter() function.
+require_once $_tests_dir . '/includes/functions.php';
+
+/**
+ * Manually load the plugin being tested.
+ */
+function _manually_load_plugin() {
+	require dirname( dirname( __FILE__ ) ) . '/giglogadmin.php';
+}
+tests_add_filter( 'muplugins_loaded', '_manually_load_plugin' );
+
+// Start up the WP testing environment.
+require $_tests_dir . '/includes/bootstrap.php';
diff --git a/tests/stubs/wpdb_stub.php b/tests/stubs/wpdb_stub.php
deleted file mode 100644
index 957c994..0000000
--- a/tests/stubs/wpdb_stub.php
+++ /dev/null
@@ -1,14 +0,0 @@
-<?php
-// SPDX-FileCopyrightText: 2021 Andrea Chirulescu <andrea.chirulescu@gmail.com>
-// SPDX-FileCopyrightText: 2021 Harald Eilertsen <haraldei@anduin.net>
-//
-// SPDX-License-Identifier: AGPL-3.0-or-later
-
-class wpdb {
-    public $insert_id = NULL;
-    public function insert(string $table, array $data) { $this->insert_id = 1; }
-    public function prepare(string $query, mixed $args) { return "prepared"; }
-    public function get_results(string $query) { return NULL; }
-}
-
-$wpdb = new wpdb();