Changeset 54530 for trunk/tests/phpunit/tests/term/taxQuery.php

Timestamp:

10/17/2022 11:47:41 AM (2 years ago)

Author:

audrasjb

Message:

Query: Validate relation in WP_Date_Query.

Props dd32, johnjamesjacoby, martinkrcho, ehtis, paulkevan, peterwilsoncc.

File:

• trunk/tests/phpunit/tests/term/taxQuery.php (modified) (5 diffs)

trunk/tests/phpunit/tests/term/taxQuery.php

@@ -336 +336 @@
     /**
      * @ticket 18105
+     * @covers WP_Tax_Query::get_sql
      */
     public function test_get_sql_relation_and_operator_in() {
@@ -382 +383 @@
         $this->assertSame( 3, substr_count( $sql['join'], 'JOIN' ) );
 
+        // Checking number of occurrences of AND while skipping the one at the beginning.
+        $this->assertSame( 2, substr_count( substr( $sql['where'], 5 ), 'AND' ), 'SQL query does not contain expected number conditions joined by operator AND.' );
+
+        $this->assertStringNotContainsString( 'OR', $sql['where'], 'SQL query contains conditions joined by operator OR.' );
+
         _unregister_taxonomy( 'wptests_tax' );
     }
@@ -387 +393 @@
     /**
      * @ticket 18105
+     * @covers WP_Tax_Query::get_sql
      */
     public function test_get_sql_nested_relation_or_operator_in() {
@@ -435 +442 @@
 
         $this->assertSame( 2, substr_count( $sql['join'], 'JOIN' ) );
+        $this->assertSame( 2, substr_count( $sql['where'], 'OR' ), 'SQL query does not contain expected number conditions joined by operator OR.' );
+        $this->assertStringNotContainsString( 'AND', substr( $sql['where'], 5 ), 'SQL query contains conditions joined by operator AND.' );
 
         _unregister_taxonomy( 'wptests_tax' );
@@ -496 +505 @@
         _unregister_taxonomy( 'wptests_tax' );
     }
+
+    /**
+     * @ticket 18105
+     * @covers WP_Tax_Query::get_sql
+     */
+    public function test_get_sql_relation_unsupported() {
+        register_taxonomy( 'wptests_tax', 'post' );
+
+        $t1 = self::factory()->term->create(
+            array(
+                'taxonomy' => 'wptests_tax',
+            )
+        );
+        $t2 = self::factory()->term->create(
+            array(
+                'taxonomy' => 'wptests_tax',
+            )
+        );
+        $t3 = self::factory()->term->create(
+            array(
+                'taxonomy' => 'wptests_tax',
+            )
+        );
+
+        $tq = new WP_Tax_Query(
+            array(
+                'relation' => 'UNSUPPORTED',
+                array(
+                    'taxonomy' => 'wptests_tax',
+                    'field'    => 'term_id',
+                    'terms'    => $t1,
+                ),
+                array(
+                    'taxonomy' => 'wptests_tax',
+                    'field'    => 'term_id',
+                    'terms'    => $t2,
+                ),
+                array(
+                    'taxonomy' => 'wptests_tax',
+                    'field'    => 'term_id',
+                    'terms'    => $t3,
+                ),
+            )
+        );
+
+        global $wpdb;
+        $sql = $tq->get_sql( $wpdb->posts, 'ID' );
+
+        // Checking number of occurrences of AND while skipping the one at the beginning.
+        $this->assertSame( 2, substr_count( substr( $sql['where'], 5 ), 'AND' ), 'SQL query does not contain expected number conditions joined by operator AND.' );
+
+        $this->assertStringNotContainsString( 'UNSUPPORTED', $sql['where'], 'SQL query contains unsupported relation operator.' );
+        $this->assertStringNotContainsString( 'OR', $sql['where'], 'SQL query contains conditions joined by operator OR.' );
+
+        _unregister_taxonomy( 'wptests_tax' );
+    }
 }