Changeset 54540 for branches/6.0/tests/phpunit/tests/date/query.php

Timestamp:

10/17/2022 12:36:06 PM (2 years ago)

Author:

audrasjb

Message:

Query: Validate relation in WP_Date_Query.

Props dd32, johnjamesjacoby, martinkrcho, ehtis, paulkevan, peterwilsoncc.
Merges [54530] to the 6.0 branch.

Location:

branches/6.0

Files:

• . (modified) (1 prop)
• tests/phpunit/tests/date/query.php (modified) (1 diff)

branches/6.0/tests/phpunit/tests/date/query.php

@@ -1136 +1136 @@
         $this->assertSame( array( $p1, $p2 ), $q->posts );
     }
+
+    /**
+     * @covers WP_Date_Query::get_sql
+     */
+    public function test_relation_in_query_and() {
+        $date_query = array(
+            'relation' => 'AND',
+            array(
+                'before'    => array(
+                    'year'  => 2021,
+                    'month' => 9,
+                    'day'   => 20,
+                ),
+                'after'     => array(
+                    'year'  => 2019,
+                    'month' => 2,
+                    'day'   => 25,
+                ),
+                'inclusive' => true,
+            ),
+            array(
+                'before'    => array(
+                    'year'  => 2016,
+                    'month' => 9,
+                    'day'   => 11,
+                ),
+                'after'     => array(
+                    'year'  => 2014,
+                    'month' => 5,
+                    'day'   => 12,
+                ),
+                'inclusive' => false,
+            ),
+        );
+
+        $q = new WP_Date_Query( $date_query );
+
+        $sql = $q->get_sql();
+
+        $parts = mb_split( '\)\s+AND\s+\(', $sql );
+        $this->assertIsArray( $parts, 'SQL query cannot be split into multiple parts using operator AND.' );
+        $this->assertEquals( 2, count( $parts ), 'SQL query does not contain correct number of AND operators.' );
+
+        $this->assertStringNotContainsString( 'OR', $sql, 'SQL query contains conditions joined by operator OR.' );
+    }
+
+    /**
+     * @covers WP_Date_Query::get_sql
+     */
+    public function test_relation_in_query_or() {
+        $date_query = array(
+            'relation' => 'OR',
+            array(
+                'before'    => array(
+                    'year'  => 2021,
+                    'month' => 9,
+                    'day'   => 20,
+                ),
+                'after'     => array(
+                    'year'  => 2019,
+                    'month' => 2,
+                    'day'   => 25,
+                ),
+                'inclusive' => true,
+            ),
+            array(
+                'before'    => array(
+                    'year'  => 2016,
+                    'month' => 9,
+                    'day'   => 11,
+                ),
+                'after'     => array(
+                    'year'  => 2014,
+                    'month' => 5,
+                    'day'   => 12,
+                ),
+                'inclusive' => false,
+            ),
+        );
+
+        $q = new WP_Date_Query( $date_query );
+
+        $sql = $q->get_sql();
+
+        $this->assertStringContainsString( 'OR', $sql, 'SQL query does not contain conditions joined by operator OR.' );
+
+        $parts = mb_split( '\)\s+OR\s+\(', $sql );
+        $this->assertIsArray( $parts, 'SQL query cannot be split into multiple parts using operator OR.' );
+        $this->assertEquals( 2, count( $parts ), 'SQL query does not contain correct number of OR operators.' );
+
+        // Checking number of occurrences of AND while skipping the one at the beginning.
+        $this->assertSame( 2, substr_count( substr( $sql, 5 ), 'AND' ), 'SQL query does not contain expected number conditions joined by operator AND.' );
+    }
+
+    /**
+     * @covers WP_Date_Query::get_sql
+     */
+    public function test_relation_in_query_unsupported() {
+        $date_query = array(
+            'relation' => 'UNSUPPORTED',
+            array(
+                'before'    => array(
+                    'year'  => 2021,
+                    'month' => 9,
+                    'day'   => 20,
+                ),
+                'after'     => array(
+                    'year'  => 2019,
+                    'month' => 2,
+                    'day'   => 25,
+                ),
+                'inclusive' => true,
+            ),
+            array(
+                'before'    => array(
+                    'year'  => 2016,
+                    'month' => 9,
+                    'day'   => 11,
+                ),
+                'after'     => array(
+                    'year'  => 2014,
+                    'month' => 5,
+                    'day'   => 12,
+                ),
+                'inclusive' => false,
+            ),
+        );
+
+        $q = new WP_Date_Query( $date_query );
+
+        $sql = $q->get_sql();
+
+        $parts = mb_split( '\)\s+AND\s+\(', $sql );
+        $this->assertIsArray( $parts, 'SQL query cannot be split into multiple parts using operator AND.' );
+        $this->assertEquals( 2, count( $parts ), 'SQL query does not contain correct number of AND operators.' );
+
+        $this->assertStringNotContainsString( 'OR', $sql, 'SQL query contains conditions joined by operator OR.' );
+    }
 }