Completed
Push — master ( 2b5a5a...a3a238 )
by Mauro
02:35
created

UserRepository::updateUserQuery()   A

Complexity

Conditions 1
Paths 1

Size

Total Lines 4
Code Lines 2

Duplication

Lines 0
Ratio 0 %

Importance

Changes 1
Bugs 0 Features 0
Metric Value
c 1
b 0
f 0
dl 0
loc 4
rs 10
cc 1
eloc 2
nc 1
nop 0
1
<?php
2
3
namespace App\Repository;
4
5
/**
6
 * Users Repository.
7
 */
8
class UserRepository
9
{
10
    public function getUserQuery()
11
    {
12
        return 'SELECT * FROM users WHERE id=:id';
13
    }
14
15
    public function getUsersQuery()
16
    {
17
        return 'SELECT * FROM users ORDER BY id';
18
    }
19
20
    public function searchUsersQuery()
21
    {
22
        return 'SELECT * FROM users WHERE UPPER(name) LIKE :name ORDER BY id';
23
    }
24
25
    public function createUserQuery()
26
    {
27
        return 'INSERT INTO users (name, email) VALUES (:name, :email)';
28
    }
29
30
    public function updateUserQuery()
31
    {
32
        return 'UPDATE users SET name=:name, email=:email WHERE id=:id';
33
    }
34
35
    public function deleteUserQuery()
36
    {
37
        return 'DELETE FROM users WHERE id=:id';
38
    }
39
}
40