Ticket #18694: test-wordpress-dates.2.php

<?php

require( 'wordpress-dev/wp-load.php' );

// An array of "date_query" arrays
$tests = array(

        // Between 8:45 AM and 5:12 PM on weekdays
        array(
                array(
                        'hour' => 8,
                        'minute' => 45,
                        'compare' => '>=',
                ),
                array(
                        'hour' => 17,
                        'minute' => 12,
                        'compare' => '<=',
                ),
                array(
                        'dayofweek' => array( 2, 6 ),
                        'compare' => 'BETWEEN',
                ),
        ),

        // Posted at least 30 minutes after the hour on a Tuesday
        array(
                array(
                        'minute' => 30,
                        'compare' => '>=',
                ),
                array(
                        'dayofweek' => 3,
                        //'compare' => '=', // Default
                ),
        ),

        array(
                'column' => 'post_date_gmt',
                'relation' => 'OR',
                array(
                        'hour' => array( 2, 12 ),
                        'minute' => array( 5, 16 ),
                        'compare' => 'BETWEEN',
                ),
                array(
                        'minute' => array( 45, 55 ),
                        'second' => 12,
                        'compare' => 'BETWEEN',
                ),
                array(
                        'dayofweek' => array( 2, 4, 7, 'foobar' ),
                        'compare' => 'IN',
                ),
        ),

        array(
                array(
                        'after' => '3 weeks ago',
                        'before' => '2 weeks ago',
                ),
        ),

        // Posted over a year ago but modified in the past month
        array(
                array(
                        'column' => 'post_date_gmt',
                        'before' => '1 year ago',
                ),
                array(
                        'column' => 'post_modified_gmt',
                        'after' => '1 month ago',
                )
        ),

        array(
                array(
                        'before' => array(
                                'year' => 2010,
                                'month' => 3,
                                'day' => 1,
                        ),
                ),
        ),

        array(
                'relation' => 'OR',
                array(
                        'hour' => 14,
                        'dayofweek' => 1,
                ),
                array(
                        'hour' => 18, // Will be cast to an array
                        'dayofweek' => array( 2, 3 ),
                        'compare' => 'IN',
                ),
        ),

        array(
                array(
                        'minute' => 0,
                )
        ),

        // Non-integer test
        array(
                array(
                        'hour' => 'foo',
                ),
        ),

        // Wrong format test (not an array of arrays)
        array(
                'w' => date( 'W' ),
        ),
);


// var_dump() the full SQL if WP_Query is called
add_filter( 'posts_request', 'debug_post_date_query' );
function debug_post_date_query( $var ) {
        var_dump( $var );
        return $var;
}

foreach ( $tests as $date_query ) {
        // Dump the "date_query" array
        var_dump( $date_query );
        echo '<hr>';

        // Dump just the date SQL
        $wp_date_query = new WP_Date_Query( $date_query );
        var_dump( $wp_date_query->get_sql() );
        echo '<hr>';

        /*
        $query = new WP_Query( array(
                'date_query' => $date_query,
        ) );
        echo '<hr>';
        /**/
}



// var_dump() the full SQL if WP_Comment_Query is called
add_filter( 'comments_clauses', 'debug_comment_date_query' );
function debug_comment_date_query( $pieces ) {
        global $wpdb;

        extract( $pieces );
        var_dump( "SELECT $fields FROM $wpdb->comments $join WHERE $where ORDER BY $orderby $order $limits" );

        return $pieces;
}

$comments = get_comments( array(
        'date_query' => array(
                array(
                        'before' => '1 week ago',
                ),
        ),
) );

?>