wp/tests/phpunit/tests/comment/dateQuery.php

<?php

/**
 * Tests to make sure querying posts based on various date parameters
 * using "date_query" works as expected.
 *
 * No need to do a full repeat of all of the post tests again since
 * the query SQL is the same for both just with a different column.
 *
 * @ticket 18694
 *
 * @group comment
 * @group date
 * @group datequery
 */
class Tests_Comment_DateQuery extends WP_UnitTestCase {

	public $posts = array();

	public function setUp() {
		parent::setUp();

		// Just some dummy posts to use as parents for comments.
		for ( $i = 1; $i <= 2; $i++ ) {
			$this->posts[ $i ] = self::factory()->post->create();
		}

		// Be careful modifying this. Tests are coded to expect this exact sample data.
		// Format is 'datetime' => 'post number (not ID)'.
		$comment_dates = array(
			'2007-01-22 03:49:21' => 1,
			'2007-05-16 17:32:22' => 1,
			'2007-09-24 07:17:23' => 1,
			'2008-03-29 09:04:25' => 1,
			'2008-07-15 11:32:26' => 2, // This one should never be in the results.
			'2008-12-10 13:06:27' => 1,
			'2009-06-11 21:30:28' => 1,
			'2009-12-18 10:42:29' => 1,
		);

		foreach ( $comment_dates as $comment_date => $comment_parent ) {
			$result = self::factory()->comment->create(
				array(
					'comment_date'    => $comment_date,
					'comment_post_ID' => $this->posts[ $comment_parent ],
				)
			);
		}
	}

	public function _get_query_result( $args = array() ) {
		$args = wp_parse_args(
			$args,
			array(
				'post_id' => $this->posts[1],
				'orderby' => 'comment_ID',  // Same order they were created.
				'order'   => 'ASC',
			)
		);

		return get_comments( $args );
	}

	public function test_year() {
		$comments = $this->_get_query_result(
			array(
				'date_query' => array(
					array(
						'year' => 2008,
					),
				),
			)
		);

		$expected_dates = array(
			'2008-03-29 09:04:25',
			'2008-12-10 13:06:27',
		);

		$this->assertSame( $expected_dates, wp_list_pluck( $comments, 'comment_date' ) );
	}
}