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
{
const GET_TASK_QUERY = 'SELECT * FROM tasks WHERE id=:id';
const GET_TASKS_QUERY = 'SELECT * FROM tasks ORDER BY id';
const SEARCH_TASKS_QUERY = 'SELECT * FROM tasks WHERE UPPER(task) LIKE :query ORDER BY task';
const CREATE_TASK_QUERY = 'INSERT INTO tasks (task, status) VALUES (:task, :status)';
const UPDATE_TASK_QUERY = 'UPDATE tasks SET task=:task, status=:status WHERE id=:id';
const DELETE_TASK_QUERY = 'DELETE FROM tasks WHERE id=:id';
}
maurobonfietti /
api-rest-slimphp
