yfix/yf

File class_db_offline_query_builder_test.Test.php has 1711 lines of code (exceeds 250 allowed). Consider refactoring.

Open

<?php

require_once __DIR__ . '/db_offline_abstract.php';

/**

class_db_offline_query_builder_test has 58 functions (exceeds 20 allowed). Consider refactoring.

Open

class class_db_offline_query_builder_test extends db_offline_abstract
{
    public function test_select_star()
    {
        if ($this->_need_skip_test(__FUNCTION__)) {

Method test_whereid has 101 lines of code (exceeds 25 allowed). Consider refactoring.

Open

    public function test_whereid()
    {
        if ($this->_need_skip_test(__FUNCTION__)) {
            return;
        }

Method test_where_basic has 76 lines of code (exceeds 25 allowed). Consider refactoring.

Open

    public function test_where_basic()
    {
        if ($this->_need_skip_test(__FUNCTION__)) {
            return;
        }

Method test_where_in has 71 lines of code (exceeds 25 allowed). Consider refactoring.

Open

    public function test_where_in()
    {
        if ($this->_need_skip_test(__FUNCTION__)) {
            return;
        }

Method test_order_by has 65 lines of code (exceeds 25 allowed). Consider refactoring.

Open

    public function test_order_by()
    {
        if ($this->_need_skip_test(__FUNCTION__)) {
            return;
        }

Method test_decrement has 63 lines of code (exceeds 25 allowed). Consider refactoring.

Open

    public function test_decrement()
    {
        if ($this->_need_skip_test(__FUNCTION__)) {
            return;
        }

Method test_increment has 63 lines of code (exceeds 25 allowed). Consider refactoring.

Open

    public function test_increment()
    {
        if ($this->_need_skip_test(__FUNCTION__)) {
            return;
        }

Method test_join has 59 lines of code (exceeds 25 allowed). Consider refactoring.

Open

    public function test_join()
    {
        if ($this->_need_skip_test(__FUNCTION__)) {
            return;
        }

Method test_select_complex has 47 lines of code (exceeds 25 allowed). Consider refactoring.

Open

    public function test_select_complex()
    {
        if ($this->_need_skip_test(__FUNCTION__)) {
            return;
        }

Method test_where_like has 47 lines of code (exceeds 25 allowed). Consider refactoring.

Open

    public function test_where_like()
    {
        if ($this->_need_skip_test(__FUNCTION__)) {
            return;
        }

Method test_from has 45 lines of code (exceeds 25 allowed). Consider refactoring.

Open

    public function test_from()
    {
        if ($this->_need_skip_test(__FUNCTION__)) {
            return;
        }

Method test_where_simplified_syntax has 43 lines of code (exceeds 25 allowed). Consider refactoring.

Open

    public function test_where_simplified_syntax()
    {
        if ($this->_need_skip_test(__FUNCTION__)) {
            return;
        }

Method test_update_batch has 39 lines of code (exceeds 25 allowed). Consider refactoring.

Open

    public function test_update_batch()
    {
        if ($this->_need_skip_test(__FUNCTION__)) {
            return;
        }

Method test_select_aggregates has 34 lines of code (exceeds 25 allowed). Consider refactoring.

Open

    public function test_select_aggregates()
    {
        if ($this->_need_skip_test(__FUNCTION__)) {
            return;
        }

Method test_delete has 34 lines of code (exceeds 25 allowed). Consider refactoring.

Open

    public function test_delete()
    {
        if ($this->_need_skip_test(__FUNCTION__)) {
            return;
        }

Method test_min has 32 lines of code (exceeds 25 allowed). Consider refactoring.

Open

    public function test_min()
    {
        if ($this->_need_skip_test(__FUNCTION__)) {
            return;
        }

Method test_max has 32 lines of code (exceeds 25 allowed). Consider refactoring.

Open

    public function test_max()
    {
        if ($this->_need_skip_test(__FUNCTION__)) {
            return;
        }

Method test_sum has 32 lines of code (exceeds 25 allowed). Consider refactoring.

Open

    public function test_sum()
    {
        if ($this->_need_skip_test(__FUNCTION__)) {
            return;
        }

Method test_avg has 32 lines of code (exceeds 25 allowed). Consider refactoring.

Open

    public function test_avg()
    {
        if ($this->_need_skip_test(__FUNCTION__)) {
            return;
        }

Method test_select_check_wrong_input has 30 lines of code (exceeds 25 allowed). Consider refactoring.

Open

    public function test_select_check_wrong_input()
    {
        if ($this->_need_skip_test(__FUNCTION__)) {
            return;
        }

Method test_group_by has 29 lines of code (exceeds 25 allowed). Consider refactoring.

Open

    public function test_group_by()
    {
        if ($this->_need_skip_test(__FUNCTION__)) {
            return;
        }

Method test_select_star has 29 lines of code (exceeds 25 allowed). Consider refactoring.

Open

    public function test_select_star()
    {
        if ($this->_need_skip_test(__FUNCTION__)) {
            return;
        }

Method test_having has 29 lines of code (exceeds 25 allowed). Consider refactoring.

Open

    public function test_having()
    {
        if ($this->_need_skip_test(__FUNCTION__)) {
            return;
        }

Method test_count has 29 lines of code (exceeds 25 allowed). Consider refactoring.

Open

    public function test_count()
    {
        $this->assertFalse(
            self::qb()->count(null, $sql = true)
        );

Method test_limit has 28 lines of code (exceeds 25 allowed). Consider refactoring.

Open

    public function test_limit()
    {
        if ($this->_need_skip_test(__FUNCTION__)) {
            return;
        }

Method test_update has 28 lines of code (exceeds 25 allowed). Consider refactoring.

Open

    public function test_update()
    {
        if ($this->_need_skip_test(__FUNCTION__)) {
            return;
        }

Method test_where_or has 27 lines of code (exceeds 25 allowed). Consider refactoring.

Open

    public function test_where_or()
    {
        if ($this->_need_skip_test(__FUNCTION__)) {
            return;
        }

Similar blocks of code found in 2 locations. Consider refactoring.

Open

    public function test_decrement()
    {
        if ($this->_need_skip_test(__FUNCTION__)) {
            return;
        }

• Read up
  Read up

Similar blocks of code found in 2 locations. Consider refactoring.

Open

    public function test_increment()
    {
        if ($this->_need_skip_test(__FUNCTION__)) {
            return;
        }

• Read up
  Read up

Similar blocks of code found in 4 locations. Consider refactoring.

Open

    public function test_min()
    {
        if ($this->_need_skip_test(__FUNCTION__)) {
            return;
        }

• Read up
  Read up

Similar blocks of code found in 4 locations. Consider refactoring.

Open

    public function test_avg()
    {
        if ($this->_need_skip_test(__FUNCTION__)) {
            return;
        }

• Read up
  Read up

Similar blocks of code found in 4 locations. Consider refactoring.

Open

    public function test_sum()
    {
        if ($this->_need_skip_test(__FUNCTION__)) {
            return;
        }

• Read up
  Read up

Similar blocks of code found in 4 locations. Consider refactoring.

Open

    public function test_max()
    {
        if ($this->_need_skip_test(__FUNCTION__)) {
            return;
        }

• Read up
  Read up

Similar blocks of code found in 2 locations. Consider refactoring.

Open

    public function test_where_exists()
    {
        if ($this->_need_skip_test(__FUNCTION__)) {
            return;
        }

• Read up
  Read up

Similar blocks of code found in 2 locations. Consider refactoring.

Open

    public function test_union()
    {
        if ($this->_need_skip_test(__FUNCTION__)) {
            return;
        }

• Read up
  Read up

Similar blocks of code found in 2 locations. Consider refactoring.

Open

    public function test_union_all()
    {
        if ($this->_need_skip_test(__FUNCTION__)) {
            return;
        }

• Read up
  Read up

Similar blocks of code found in 2 locations. Consider refactoring.

Open

    public function test_where_not_exists()
    {
        if ($this->_need_skip_test(__FUNCTION__)) {
            return;
        }

• Read up
  Read up

Similar blocks of code found in 2 locations. Consider refactoring.

Open

        $this->assertEquals(
            'SELECT * FROM `' . DB_PREFIX . 'user` AS `u` , `' . DB_PREFIX . 'articles` AS `a` , `' . DB_PREFIX . 'products` AS `p` , `' . DB_PREFIX . 'orders` AS `o` , `' . DB_PREFIX . 'rating` AS `r`',
            self::qb()->select()->from('user as u, articles as a', ['products' => 'p', 'orders' => 'o'], 'rating as r')->sql()
        );

• Read up
  Read up

Similar blocks of code found in 2 locations. Consider refactoring.

Open

    public function test_where_null()
    {
        if ($this->_need_skip_test(__FUNCTION__)) {
            return;
        }

• Read up
  Read up

Similar blocks of code found in 2 locations. Consider refactoring.

Open

        $this->assertEquals(
            'SELECT * FROM `' . DB_PREFIX . 'user` AS `u` , `' . DB_PREFIX . 'articles` AS `a` , `' . DB_PREFIX . 'products` AS `p` , `' . DB_PREFIX . 'orders` AS `o` , `' . DB_PREFIX . 'rating` AS `r`',
            self::qb()->select()->table('user as u, articles as a', ['products' => 'p', 'orders' => 'o'], 'rating as r')->sql()
        );

• Read up
  Read up

Similar blocks of code found in 2 locations. Consider refactoring.

Open

    public function test_where_raw()
    {
        if ($this->_need_skip_test(__FUNCTION__)) {
            return;
        }

• Read up
  Read up

Identical blocks of code found in 3 locations. Consider refactoring.

Open

        $this->assertEquals(
            'SELECT * FROM `' . DB_PREFIX . 'user` AS `u` WHERE `u`.`id` = \'1\' GROUP BY `u`.`gid` HAVING `u`.`gid` = \'4\' ORDER BY `u`.`id` ASC LIMIT 20, 5',
            self::qb()->from(['user' => 'u'])->where(['u.id', '=', 1])->group_by('u.gid')->having(['u.gid', '=', 4])->order_by('u.id')->limit(5, 20)->sql()
        );

• Read up
  Read up

Identical blocks of code found in 3 locations. Consider refactoring.

Open

        $this->assertEquals(
            'SELECT * FROM `' . DB_PREFIX . 'user` AS `u` WHERE `u`.`id` = \'1\' GROUP BY `u`.`gid` HAVING `u`.`gid` = \'4\' ORDER BY `u`.`id` ASC LIMIT 20, 5',
            self::qb()->from(['user' => 'u'])->where(['u.id', '=', 1])->group_by('u.gid')->having(['u.gid', '=', 4])->order_by('u.id')->limit(5, 20)->sql()
        );

• Read up
  Read up

Identical blocks of code found in 3 locations. Consider refactoring.

Open

        $this->assertEquals(
            'SELECT * FROM `' . DB_PREFIX . 'user` AS `u` WHERE `u`.`id` = \'1\' GROUP BY `u`.`gid` HAVING `u`.`gid` = \'4\' ORDER BY `u`.`id` ASC LIMIT 20, 5',
            self::qb()->from(['user' => 'u'])->where(['u.id', '=', 1])->group_by('u.gid')->having(['u.gid', '=', 4])->order_by('u.id')->limit(5, 20)->sql()
        );

• Read up
  Read up

Similar blocks of code found in 2 locations. Consider refactoring.

Open

        $this->assertEquals(
            'SELECT * FROM `' . DB_PREFIX . 'user` WHERE `id` = \'2\' AND `gid` = \'1\' AND `sid` = \'3\' AND `pid` = \'4\' AND `hid` = \'5\' AND `mid` = \'6\' AND `rank` IS NULL',
            self::qb()->from('user')->where('id = 2', ['gid', 1], ['sid', '=', '3'], ['pid' => 4, 'hid' => 5, 'mid' => 6], ['rank', 'IS NULL'])->sql()
        );

• Read up
  Read up

Similar blocks of code found in 2 locations. Consider refactoring.

Open

        $this->assertEquals(
            'SELECT * FROM `' . DB_PREFIX . 'user` AS `u` WHERE `u`.`id` = \'1\' OR `u`.`gid` > \'2\' OR `u`.`name` LIKE \'%hello%\' OR `u`.`pid` = \'4\' OR `u`.`hid` = \'5\' OR `u`.`mid` = \'6\' OR `u`.`id` IS NULL',
            self::qb()->from('user as u')->where_or(['u.id', 1], 'u.gid > 2', ['u.name', 'like', '*hello*'], ['u.pid' => 4, 'u.hid' => 5, 'u.mid' => 6], ['u.id', 'IS NULL'])->sql()
        );

• Read up
  Read up

Similar blocks of code found in 2 locations. Consider refactoring.

Open

        $this->assertEquals(
            'SELECT * FROM `' . DB_PREFIX . 'user` AS `u` WHERE `u`.`id` = \'1\' AND `u`.`gid` > \'2\' AND `u`.`name` LIKE \'%hello%\' AND `u`.`pid` = \'4\' AND `u`.`hid` = \'5\' AND `u`.`mid` = \'6\' AND `u`.`id` IS NULL',
            self::qb()->from('user as u')->where(['u.id', 1], 'u.gid > 2', ['u.name', 'like', '*hello*'], ['u.pid' => 4, 'u.hid' => 5, 'u.mid' => 6], ['u.id', 'IS NULL'])->sql()
        );

• Read up
  Read up

Similar blocks of code found in 2 locations. Consider refactoring.

Open

        $this->assertEquals(
            'SELECT * FROM `' . DB_PREFIX . 'user` WHERE `id` = \'2\' OR `gid` = \'1\' OR `sid` = \'3\' OR `pid` = \'4\' OR `hid` = \'5\' OR `mid` = \'6\' OR `rank` IS NULL',
            self::qb()->from('user')->where_or('id = 2', ['gid', 1], ['sid', '=', '3'], ['pid' => 4, 'hid' => 5, 'mid' => 6], ['rank', 'IS NULL'])->sql()
        );

• Read up
  Read up