package eu.dnetlib.openaire.user.queries;

/**
 * Created by sofia on 3/10/2017.
 */
public interface UserVerificationQueries {

    String FETCH_ALL                  = "SELECT * FROM user_verification";
    String FETCH_BY_ID                = "SELECT * FROM user_verification WHERE id = ?";
    String FETCH_BY_USERNAME          = "SELECT * FROM user_verification WHERE username = ?";
    String FETCH_BY_VERIFICATION_CODE = "SELECT * FROM user_verification WHERE verification_code = ?";
    String FETCH_BY_DATE              = "SELECT * FROM user_verification WHERE date = ?";

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

    String INSERT = "INSERT INTO user_verification (" +
            "username, " +
            "verification_code, " +
            "date " +
            ") VALUES (?,?,?)";

    String UPDATE = "UPDATE user_verification SET " +
            "username = ?, " +
            "verification_code = ?, " +
            "date = ? " +
            "WHERE id = ?";

    String DELETE = "DELETE FROM user_verification WHERE username = ?";

}