package eu.dnetlib.openaire.user.queries;

/**
 * Created by sofia on 8/11/2016.
 */
public interface RoleQueries {

    // Queries (as prepared statements to avoid SQL-injection)
    String FETCH_ALL     = "SELECT * FROM roles";
    String FETCH_BY_ID   = "SELECT * FROM roles WHERE id = ?";
    String FETCH_BY_ROLE = "SELECT * FROM roles WHERE role = ?";

    String COUNT_ALL = "SELECT COUNT(*) FROM role";

    String INSERT = "INSERT INTO roles (" +
            "role" +
            ") VALUES (?)";

    String UPDATE = "UPDATE roles SET " +
            "role = ? " +
            "WHERE id = ?";

    String DELETE = "DELETE FROM roles WHERE id = ?";
}