patilswapnilv / shortcodely

        $this->assertSame('HOUR( post_date ) NOT IN (1,2) AND MINUTE( post_date ) NOT IN (3,4,5) AND SECOND( post_date ) NOT IN (6)', $found);

    }

    public function test_build_time_query_compare_between() 

    {

        $q = new WP_Date_Query(array());

        // Just hour

        $found = $q->build_time_query('post_date', 'BETWEEN', array( 1, 2 ));

        $this->assertSame('HOUR( post_date ) BETWEEN 1 AND 2', $found);

        // Skip minute

        $found = $q->build_time_query('post_date', 'BETWEEN', array( 1, 2 ), null, array( 6, 7 ));

        $this->assertSame('HOUR( post_date ) BETWEEN 1 AND 2 AND SECOND( post_date ) BETWEEN 6 AND 7', $found);

        // All three

        $found = $q->build_time_query('post_date', 'BETWEEN', array( 1, 2 ), array( 3, 4 ), array( 6, 7 ));

        $this->assertSame('HOUR( post_date ) BETWEEN 1 AND 2 AND MINUTE( post_date ) BETWEEN 3 AND 4 AND SECOND( post_date ) BETWEEN 6 AND 7', $found);

    }

    public function test_build_time_query_compare_not_between() 

        $this->assertSame('HOUR( post_date ) BETWEEN 1 AND 2 AND MINUTE( post_date ) BETWEEN 3 AND 4 AND SECOND( post_date ) BETWEEN 6 AND 7', $found);

    }

    public function test_build_time_query_compare_not_between() 

    {

        $q = new WP_Date_Query(array());

        // Just hour

        $found = $q->build_time_query('post_date', 'NOT BETWEEN', array( 1, 2 ));

        $this->assertSame('HOUR( post_date ) NOT BETWEEN 1 AND 2', $found);

        // Skip minute

        $found = $q->build_time_query('post_date', 'NOT BETWEEN', array( 1, 2 ), null, array( 6, 7 ));

        $this->assertSame('HOUR( post_date ) NOT BETWEEN 1 AND 2 AND SECOND( post_date ) NOT BETWEEN 6 AND 7', $found);

        // All three

        $found = $q->build_time_query('post_date', 'NOT BETWEEN', array( 1, 2 ), array( 3, 4 ), array( 6, 7 ));

        $this->assertSame('HOUR( post_date ) NOT BETWEEN 1 AND 2 AND MINUTE( post_date ) NOT BETWEEN 3 AND 4 AND SECOND( post_date ) NOT BETWEEN 6 AND 7', $found);

    }

    public function test_build_time_query_hour_only()