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

TaskRepository::getTasksQuery()   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
 * Tasks Repository.
7
 */
8
class TaskRepository
9
{
10
    public function getTaskQuery()
11
    {
12
        return 'SELECT * FROM tasks WHERE id=:id';
13
    }
14
15
    public function getTasksQuery()
16
    {
17
        return 'SELECT * FROM tasks ORDER BY task';
18
    }
19
20
    public function searchTasksQuery()
21
    {
22
        return 'SELECT * FROM tasks WHERE UPPER(task) LIKE :query ORDER BY task';
23
    }
24
25
    public function createTaskQuery()
26
    {
27
        return 'INSERT INTO tasks (task, status) VALUES (:task, :status)';
28
    }
29
30
    public function updateTaskQuery()
31
    {
32
        return 'UPDATE tasks SET task=:task, status=:status WHERE id=:id';
33
    }
34
35
    public function deleteTaskQuery()
36
    {
37
        return 'DELETE FROM tasks WHERE id=:id';
38
    }
39
}
40