App\Repository\UserRepository

Complexity

Total Complexity

6

Size/Duplication

Total Lines	32
Duplicated Lines	0 %

Coupling/Cohesion

Components	0
Dependencies	0

Importance

Changes	1
Bugs	0	Features	0

6 Methods

Rating	Name	Duplication	Size	Complexity
A	getUserQuery()	0	4	1
A	getUsersQuery()	0	4	1
A	searchUsersQuery()	0	4	1
A	createUserQuery()	0	4	1
A	updateUserQuery()	0	4	1
A	deleteUserQuery()	0	4	1

<?php

namespace App\Repository;

/**
 * Users Repository.
 */
class UserRepository
{
    public function getUserQuery()
    {
        return 'SELECT * FROM users WHERE id=:id';
    }

    public function getUsersQuery()
    {
        return 'SELECT * FROM users ORDER BY id';
    }

    public function searchUsersQuery()
    {
        return 'SELECT * FROM users WHERE UPPER(name) LIKE :name ORDER BY id';
    }

    public function createUserQuery()
    {
        return 'INSERT INTO users (name, email) VALUES (:name, :email)';
    }

    public function updateUserQuery()
    {
        return 'UPDATE users SET name=:name, email=:email WHERE id=:id';
    }

    public function deleteUserQuery()
    {
        return 'DELETE FROM users WHERE id=:id';
    }
}