App\Repository\Query\TaskQuery

Complexity

Total Complexity

6

Size/Duplication

Total Lines	37
Duplicated Lines	0 %

Coupling/Cohesion

Components	0
Dependencies	0

Importance

Changes	1
Bugs	0	Features	0

6 Methods

Rating	Name	Duplication	Size	Complexity
A	getTaskQuery()	0	4	1
A	getTasksQuery()	0	4	1
A	searchTasksQuery()	0	4	1
A	createTaskQuery()	0	4	1
A	updateTaskQuery()	0	4	1
A	deleteTaskQuery()	0	4	1

<?php

namespace App\Repository\Query;

/**
 * Tasks Query.
 */
abstract class TaskQuery
{
    /**
     * Get Task Sql Query.
     *
     * @return string
     */
    public static function getTaskQuery()
    {
        return 'SELECT * FROM tasks WHERE id=:id';
    }

    public static function getTasksQuery()
    {
        return 'SELECT * FROM tasks ORDER BY task';
    }

    public static function searchTasksQuery()
    {
        return 'SELECT * FROM tasks WHERE UPPER(task) LIKE :query ORDER BY task';
    }

    public static function createTaskQuery()
    {
        return 'INSERT INTO tasks (task, status) VALUES (:task, :status)';
    }

    public static function updateTaskQuery()
    {
        return 'UPDATE tasks SET task=:task, status=:status WHERE id=:id';
    }

    public static function deleteTaskQuery()
    {
        return 'DELETE FROM tasks WHERE id=:id';
    }
}