Constant Field Values

Contents

• eu.dnetlib.*

eu.dnetlib.*

eu.dnetlib.openaire.user.queries.RoleQueries

Modifier and Type	Constant Field	Value
public static final String	COUNT_ALL	"SELECT COUNT(*) FROM role"
public static final String	DELETE	"DELETE FROM roles WHERE id = ?"
public static final String	FETCH_ALL	"SELECT * FROM roles"
public static final String	FETCH_BY_ID	"SELECT * FROM roles WHERE id = ?"
public static final String	FETCH_BY_ROLE	"SELECT * FROM roles WHERE role = ?"
public static final String	INSERT	"INSERT INTO roles (role) VALUES (?)"
public static final String	UPDATE	"UPDATE roles SET role = ? WHERE id = ?"

eu.dnetlib.openaire.user.queries.RoleVerificationQueries

Modifier and Type	Constant Field	Value
public static final String	COUNT_ALL	"SELECT COUNT(*) FROM role_verification"
public static final String	DELETE	"DELETE FROM role_verification WHERE id = ?"
public static final String	FETCH_ALL	"SELECT * FROM role_verification"
public static final String	FETCH_BY_EMAIL_TYPE_ENTITY_VERIFICATION_TYPE	"SELECT * FROM role_verification WHERE email = ? AND type = ? AND entity = ? AND verification_type = ?"
public static final String	FETCH_BY_ID	"SELECT * FROM role_verification WHERE id = ?"
public static final String	FETCH_BY_TYPE_ENTITY_VERIFICATION_TYPE	"SELECT DISTINCT email FROM role_verification WHERE type = ? AND entity = ? AND verification_type = ?"
public static final String	INSERT	"INSERT INTO role_verification (id, email, verification_code, verification_type, type, entity, date ) VALUES (?,?,?,?,?,?,?)"
public static final String	UPDATE	"UPDATE role_verification SET id = ?, username = ?, verification_code = ?, verification_type = ?, type = ?, entity = ?, date = ? WHERE id = ?"

eu.dnetlib.openaire.user.queries.SQLMigrationUserQueries

Modifier and Type	Constant Field	Value
public static final String	COUNT_ALL	"SELECT COUNT(*) FROM users"
public static final String	DELETE	"DELETE FROM users WHERE id = ?"
public static final String	FETCH_ALL	"SELECT * FROM users"
public static final String	FETCH_BY_EMAIL	"SELECT * FROM users WHERE email = ?"
public static final String	FETCH_BY_FULLNAME	"SELECT * FROM users WHERE fullname = ?"
public static final String	FETCH_BY_ID	"SELECT * FROM users WHERE id = ?"
public static final String	FETCH_BY_ROLE_ID	"SELECT * FROM users WHERE role_id = ?"
public static final String	FETCH_BY_USERNAME	"SELECT * FROM users WHERE username = ?"
public static final String	INSERT	"INSERT INTO users (username, fullname, email, role_id) VALUES (?,?,?,?)"
public static final String	UPDATE	"UPDATE users SET username = ?, fullname = ?, email = ?, role_id = ? WHERE id = ?"

eu.dnetlib.openaire.user.queries.UserVerificationQueries

Modifier and Type	Constant Field	Value
public static final String	COUNT_ALL	"SELECT COUNT(*) FROM user_verification"
public static final String	DELETE	"DELETE FROM user_verification WHERE username = ?"
public static final String	FETCH_ALL	"SELECT * FROM user_verification"
public static final String	FETCH_BY_DATE	"SELECT * FROM user_verification WHERE date = ?"
public static final String	FETCH_BY_ID	"SELECT * FROM user_verification WHERE id = ?"
public static final String	FETCH_BY_USERNAME	"SELECT * FROM user_verification WHERE username = ?"
public static final String	FETCH_BY_VERIFICATION_CODE	"SELECT * FROM user_verification WHERE verification_code = ?"
public static final String	INSERT	"INSERT INTO user_verification (username, verification_code, date ) VALUES (?,?,?)"
public static final String	UPDATE	"UPDATE user_verification SET username = ?, verification_code = ?, date = ? WHERE id = ?"

eu.dnetlib.openaire.user.utils.VerifyRecaptcha

Modifier and Type	Constant Field	Value
public static final String	url	"https://www.google.com/recaptcha/api/siteverify"