Code Duplication    Length = 7-8 lines in 5 locations

tests/src/ResultSetTest.php 5 locations

@@ 38-44 (lines=7) @@
35
    }
36
    
37
    /** @test */
38
    public function addingOrderBy()
39
    {
40
        $this->resultSet->orderBy('id');
41
        $sql = 'SELECT * FROM ' . static::TABLE_NAME . ' ORDER BY id ASC';
42
        
43
        $this->assertEquals((string) $this->resultSet, $sql);
44
    }
45
    
46
    /** @test */
47
    public function addingWhere()
@@ 47-54 (lines=8) @@
44
    }
45
    
46
    /** @test */
47
    public function addingWhere()
48
    {
49
        $this->resultSet->where('id', 1);
50
        
51
        $sql = 'SELECT * FROM ' . static::TABLE_NAME . ' WHERE id = ?';
52
        
53
        $this->assertEquals((string) $this->resultSet, $sql);
54
    }
55
    
56
    /** @test */
57
    public function addingWhereInArray()
@@ 57-64 (lines=8) @@
54
    }
55
    
56
    /** @test */
57
    public function addingWhereInArray()
58
    {
59
        $this->resultSet->where(['id' => 1]);
60
        
61
        $sql = 'SELECT * FROM ' . static::TABLE_NAME . ' WHERE id = ?';
62
        
63
        $this->assertEquals((string) $this->resultSet, $sql);
64
    }
65
    
66
    /** @test */
67
    public function addingFullSyntax()
@@ 67-74 (lines=8) @@
64
    }
65
    
66
    /** @test */
67
    public function addingFullSyntax()
68
    {
69
        $this->resultSet->where('id = ?', 1);
70
        
71
        $sql = 'SELECT * FROM ' . static::TABLE_NAME . ' WHERE id = ?';
72
        
73
        $this->assertEquals((string) $this->resultSet, $sql);
74
    }
75
76
    /** @test */
77
    public function addingWhereWithoutValue()
@@ 77-84 (lines=8) @@
74
    }
75
76
    /** @test */
77
    public function addingWhereWithoutValue()
78
    {
79
        $this->resultSet->where('id IS NULL');
80
        
81
        $sql = 'SELECT * FROM ' . static::TABLE_NAME . ' WHERE id IS NULL';
82
        
83
        $this->assertEquals((string) $this->resultSet, $sql);
84
    }
85
}