patilswapnilv / shortcodely

    /**

     * @ticket 34228

     */

    public function test_build_time_query_should_not_discard_hour_0() 

    {

        $q = new WP_Date_Query(array());

        $found = $q->build_time_query('post_date', '=', 0, 10);

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

    }

    public function test_build_time_query_compare_in() 

        $this->assertSame('HOUR( post_date ) = 5', $found);

    }

    public function test_build_time_query_minute_only() 

    {

        $q = new WP_Date_Query(array());

        $found = $q->build_time_query('post_date', '=', null, 5);

        $this->assertSame('MINUTE( post_date ) = 5', $found);

    }

    public function test_build_time_query_second_only() 

    {

        $this->assertSame('MINUTE( post_date ) = 5', $found);

    }

    public function test_build_time_query_second_only() 

    {

        $q = new WP_Date_Query(array());

        $found = $q->build_time_query('post_date', '=', null, null, 5);

        $this->assertSame('SECOND( post_date ) = 5', $found);

    }

    public function test_build_time_query_hour_and_second() 

    {

        $this->assertSame('SECOND( post_date ) = 5', $found);

    }

    public function test_build_time_query_hour_and_second() 

    {

        $q = new WP_Date_Query(array());

        $found = $q->build_time_query('post_date', '=', 5, null, 5);

        $this->assertFalse($found);

    }

    public function test_build_time_query_hour_minute() 

    {

        $this->assertFalse($found);

    }

    public function test_build_time_query_hour_minute() 

    {

        $q = new WP_Date_Query(array());

        $found = $q->build_time_query('post_date', '=', 5, 15);

        // $compare value is floating point - use regex to account for

        // varying precision on different PHP installations

        $this->assertRegExp("/DATE_FORMAT\( post_date, '%H\.%i' \) = 5\.150*/", $found);

    }

    public function test_build_time_query_hour_minute_second() 

        $this->assertRegExp("/DATE_FORMAT\( post_date, '%H\.%i' \) = 5\.150*/", $found);

    }

    public function test_build_time_query_hour_minute_second() 

    {

        $q = new WP_Date_Query(array());

        $found = $q->build_time_query('post_date', '=', 5, 15, 35);

        // $compare value is floating point - use regex to account for

        // varying precision on different PHP installations

        $this->assertRegExp("/DATE_FORMAT\( post_date, '%H\.%i%s' \) = 5\.15350*/", $found);

    }

    public function test_build_time_query_minute_second() 

        $this->assertRegExp("/DATE_FORMAT\( post_date, '%H\.%i%s' \) = 5\.15350*/", $found);

    }

    public function test_build_time_query_minute_second() 

    {

        $q = new WP_Date_Query(array());

        $found = $q->build_time_query('post_date', '=', null, 15, 35);

        // $compare value is floating point - use regex to account for

        // varying precision on different PHP installations

        $this->assertRegExp("/DATE_FORMAT\( post_date, '0\.%i%s' \) = 0\.15350*/", $found);

    }

    /**