for testing and deploying your application
for finding and fixing issues
for empowering human code reviews
<?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';
maurobonfietti /
api-rest-slimphp
