patilswapnilv / shortcodely

        $this->assertContains('%H', $found);

    }

    public function test_build_time_query_compare_in() 

    {

        $q = new WP_Date_Query(array());

        // Just hour

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

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

        // Skip minute

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

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

        // All three

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

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

    }

    public function test_build_time_query_compare_not_in() 

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

    }

    public function test_build_time_query_compare_not_in() 

    {

        $q = new WP_Date_Query(array());

        // Just hour

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

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

        // Skip minute

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

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

        // All three

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

        $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()