protected static final java.lang.String |
CHECK_ADMIN |
"SELECT isAdmin FROM Users WHERE userId=?" |
protected static final java.lang.String |
CHECK_LOGIN |
"SELECT * FROM Users WHERE email=?" |
protected static final java.lang.String |
CHECK_USER_EXIST |
"SELECT userId FROM Users WHERE userId=?" |
protected static final java.lang.String |
DELETE_AFFILIATION |
"DELETE FROM _Affiliations WHERE affiliationId=?" |
protected static final java.lang.String |
DELETE_AUTHOR_PAPERS |
"DELETE FROM PaperAuthors WHERE userId=?" |
protected static final java.lang.String |
DELETE_PAPER |
"DELETE FROM Papers WHERE paperId=?" |
protected static final java.lang.String |
DELETE_PAPER_AUTHORS |
"DELETE FROM PaperAuthors WHERE paperId=?" |
protected static final java.lang.String |
DELETE_PAPER_SUBJECTS |
"DELETE FROM PaperSubjects WHERE paperId=?" |
protected static final java.lang.String |
DELETE_SINGLE_PAPER_AUTHOR |
"DELETE FROM PaperAuthors WHERE paperId=? AND userId=?" |
protected static final java.lang.String |
DELETE_SINGLE_PAPER_SUBJECT |
"DELETE FROM papersubjects WHERE paperId=? AND subjectId=?" |
protected static final java.lang.String |
DELETE_SUBJECT |
"DELETE FROM _subjects WHERE subjectId=?" |
protected static final java.lang.String |
DELETE_SUBJECT_PAPERS |
"DELETE FROM papersubjects where subjectid=?" |
protected static final java.lang.String |
DELETE_TYPE |
"DELETE FROM _Types WHERE typeId=?" |
protected static final java.lang.String |
DELETE_USER_PAPERS |
"DELETE FROM Papers WHERE submitterId=?" |
protected static final java.lang.String |
DELETE_USERS |
"DELETE FROM Users WHERE userId=?" |
protected static final java.lang.String |
GET_AFFILIATION_WITH_ID |
"SELECT * FROM _Affiliations WHERE affiliationId=?" |
protected static final java.lang.String |
GET_ALL_AFFILIATIONS |
"SELECT * FROM _Affiliations" |
protected static final java.lang.String |
GET_ALL_SUBJECTS |
"SELECT * FROM _subjects" |
protected static final java.lang.String |
GET_ALL_TYPES |
"SELECT * FROM _Types" |
protected static final java.lang.String |
GET_ALL_USERS |
"SELECT * FROM Users limit 3" |
protected static final java.lang.String |
GET_AUTHOR_PAPERS |
"SELECT * FROM PaperAuthors WHERE userId=?" |
protected static final java.lang.String |
GET_DISPLAY_ORDER |
"SELECT displayOrder FROM PaperAuthors WHERE paperId=? AND userId=?" |
protected static final java.lang.String |
GET_LAST_AFFILIATION_ID |
"SELECT affiliationId FROM _Affiliations ORDER BY affiliationId DESC LIMIT 1" |
protected static final java.lang.String |
GET_LAST_SUBJECT_ID |
"SELECT subjectId FROM _subjects ORDER BY subjectId DESC LIMIT 1" |
protected static final java.lang.String |
GET_LAST_TYPE_ID |
"SELECT typeId FROM _Types ORDER BY typeId DESC LIMIT 1" |
protected static final java.lang.String |
GET_NEXT_PAPER_ID |
"SELECT paperId FROM papers ORDER BY paperId DESC LIMIT 1" |
protected static final java.lang.String |
GET_NEXT_USER_ID |
"SELECT userId FROM Users ORDER BY userId DESC LIMIT 1" |
protected static final java.lang.String |
GET_PAPER_AUTHORS |
"SELECT * FROM PaperAuthors WHERE paperId=? ORDER BY displayOrder ASC" |
protected static final java.lang.String |
GET_PAPER_SUBJECTS |
"SELECT * FROM PaperSubjects WHERE paperId=?" |
protected static final java.lang.String |
GET_PAPER_TYPE_ID |
"SELECT submissionType FROM Papers WHERE paperId=?" |
protected static final java.lang.String |
GET_PAPER_TYPE_WITH_ID |
"SELECT * FROM _Types WHERE typeId=?" |
protected static final java.lang.String |
GET_PAPER_WITH_PAPER_ID |
"SELECT * FROM Papers WHERE paperId=?" |
protected static final java.lang.String |
GET_SINGLE_USER |
"SELECT * FROM Users WHERE userId=?" |
protected static final java.lang.String |
GET_SUBJECT |
"SELECT * FROM _subjects WHERE subjectId=?" |
protected static final java.lang.String |
GET_USER_AFFILIATION |
"SELECT affiliationId FROM Users WHERE userId=?" |
protected static final java.lang.String |
GET_USER_PAPERS |
"SELECT * FROM Papers WHERE submitterId=?" |
protected static final java.lang.String |
HOST |
"jdbc:mysql://localhost:3306/CSM?useSSL=false" |
protected static final java.lang.String |
INSERT_AFFILIATION |
"INSERT INTO _Affiliations VALUES (?,?)" |
protected static final java.lang.String |
INSERT_NEW_PAPER |
"INSERT INTO Papers(paperId, title, abstract, track, submissionType, fileId, submitterId, status, tentativeStatus) VALUES(?,?,?,NULL,?,?,?,\'Undecided\',\'Undecided\')" |
protected static final java.lang.String |
INSERT_NEW_USER |
"INSERT INTO Users(userId, lastName, firstName, email, pswd, canReview, expiration, isAdmin, affiliationId) VALUES(?,?,?,?,?,\'0\',\'20250101000000\',0,?)" |
protected static final java.lang.String |
INSERT_PAPER_AUTHOR |
"INSERT INTO PaperAuthors VALUES (?,?,?)" |
protected static final java.lang.String |
INSERT_PAPER_SUBJECT |
"INSERT INTO PaperSubjects VALUES (?,?)" |
protected static final java.lang.String |
INSERT_SUBJECT |
"INSERT INTO _subjects VALUES (?,?)" |
protected static final java.lang.String |
INSERT_TYPE |
"INSERT INTO _Types VALUES (?,?)" |
protected static final java.lang.String |
INSERT_UPDATE_PAPER_AUTHOR |
"INSERT INTO paperauthors (paperId, userId, displayOrder) VALUES (?, ?, ?) ON DUPLICATE KEY UPDATE paperId = VALUES(paperId), userId = VALUES(userId),displayOrder = ?" |
protected static final java.lang.String |
INSERT_UPDATE_PAPER_SUBJECT |
"INSERT INTO papersubjects (paperId, subjectId) VALUES (?, ?) ON DUPLICATE KEY UPDATE paperId = VALUES(paperId), subjectId = VALUES(subjectId)" |
protected static final java.lang.String |
PASSWORD |
"root" |
protected static final java.lang.String |
SET_PAPER_TYPE_NULL |
"UPDATE Papers SET submissionType=NULL WHERE submissionType=?" |
protected static final java.lang.String |
SET_USER_AFFILIATION_NULL |
"UPDATE Users SET affiliationId=NULL WHERE affiliationId=?" |
protected static final java.lang.String |
SET_USER_AS_ADMIN |
"UPDATE Users SET isAdmin=? WHERE userId=?" |
protected static final java.lang.String |
SET_USER_CAN_REVIEW |
"UPDATE Users SET canReview=? WHERE userId=?" |
public static final java.lang.String |
UNABLE_TO_ADD_AFFILIATION |
"Unable to add affiliation" |
public static final java.lang.String |
UNABLE_TO_ADD_PAPER_AUTHORS |
"Unable to add paper\'s authors data" |
public static final java.lang.String |
UNABLE_TO_ADD_PAPER_SUBJECT |
"Unable to add paper\'s subject data" |
public static final java.lang.String |
UNABLE_TO_ADD_SUBJECT |
"Unable to add subject" |
public static final java.lang.String |
UNABLE_TO_ADD_TYPE |
"Unable to add type" |
public static final java.lang.String |
UNABLE_TO_CHANGE_ADMIN_STATUS |
"Unable to change admin status of a user" |
public static final java.lang.String |
UNABLE_TO_CHANGE_AFFILIATION |
"Unable to change affiliation" |
public static final java.lang.String |
UNABLE_TO_CHANGE_REVIEW_STATUS |
"Unable to change review status of a user" |
public static final java.lang.String |
UNABLE_TO_CHANGE_SUBJECT |
"Unable to change subject" |
public static final java.lang.String |
UNABLE_TO_CHANGE_TYPE |
"Unable to change type" |
public static final java.lang.String |
UNABLE_TO_CHECK_ADMIN |
"Unable to check if user is admin" |
public static final java.lang.String |
UNABLE_TO_DELETE_AFFILIATION |
"Unable to delete affiliation" |
public static final java.lang.String |
UNABLE_TO_DELETE_AUTHOR_PAPERS |
"Unable to delete author\'s papers" |
public static final java.lang.String |
UNABLE_TO_DELETE_PAPER |
"Unable to delete a single paper" |
public static final java.lang.String |
UNABLE_TO_DELETE_PAPER_AUTHORS |
"Unable to delete paper\'s authors data" |
public static final java.lang.String |
UNABLE_TO_DELETE_PAPER_SUBJECT |
"Unable to delete paper\'s subject data" |
public static final java.lang.String |
UNABLE_TO_DELETE_SINGLE_PAPER_AUTHOR |
"Unable to delete a single paper author entry" |
public static final java.lang.String |
UNABLE_TO_DELETE_SINGLE_PAPER_SUBJECT |
"Unable to delete a single paper subject entry" |
public static final java.lang.String |
UNABLE_TO_DELETE_SUBJECT |
"Unable to delete subject" |
public static final java.lang.String |
UNABLE_TO_DELETE_SUBJECT_PAPERS |
"Unable to delete subjects for the paper" |
public static final java.lang.String |
UNABLE_TO_DELETE_TYPE |
"Unable to delete type" |
public static final java.lang.String |
UNABLE_TO_DELETE_USER |
"Unable to delete user profiles" |
public static final java.lang.String |
UNABLE_TO_DELETE_USER_PAPER |
"Unable to delete user\'s papers" |
public static final java.lang.String |
UNABLE_TO_GET_AFFILIATION |
"Unable to retrieve affiliation data" |
public static final java.lang.String |
UNABLE_TO_GET_AFFILIATIONS |
"Unable to retrieve affiliations data" |
public static final java.lang.String |
UNABLE_TO_GET_ALL_USERS |
"Unable to retrieve all user profiles" |
public static final java.lang.String |
UNABLE_TO_GET_AUTHOR_PAPERS |
"Unable to retrieve author\'s papers data" |
public static final java.lang.String |
UNABLE_TO_GET_DISPLAY_ORDER |
"Unable to get display order" |
public static final java.lang.String |
UNABLE_TO_GET_PAPER |
"Unable to retrieve a single paper data" |
public static final java.lang.String |
UNABLE_TO_GET_PAPER_AUTHORS |
"Unable to retrieve paper\'s authors data" |
public static final java.lang.String |
UNABLE_TO_GET_PAPER_SUBJECTS |
"Unable to retrieve paper\'s subject data" |
public static final java.lang.String |
UNABLE_TO_GET_PAPERS |
"Unable to retrieve papers data" |
public static final java.lang.String |
UNABLE_TO_GET_SUBJECT |
"Unable to retrieve subject data" |
public static final java.lang.String |
UNABLE_TO_GET_SUBJECTS |
"Unable to retrieve subjects data" |
public static final java.lang.String |
UNABLE_TO_GET_TYPE |
"Unable to retrieve type data" |
public static final java.lang.String |
UNABLE_TO_GET_TYPES |
"Unable to retrieve types data" |
public static final java.lang.String |
UNABLE_TO_GET_USER |
"Unable to retrieve a particular user" |
public static final java.lang.String |
UNABLE_TO_GET_USER_PROFILE |
"Unable to retrieve users profile" |
public static final java.lang.String |
UNABLE_TO_LOGIN |
"Unable to Login" |
public static final java.lang.String |
UNABLE_TO_LOGIN_TRY_LATER |
"Unable to login. Please try again later" |
public static final java.lang.String |
UNABLE_TO_RESET_PASSWORD |
"Unable to reset users password" |
public static final java.lang.String |
UNABLE_TO_SET_PAPER |
"Unable to set paper" |
public static final java.lang.String |
UNABLE_TO_SET_USER_PROFILE |
"Unable to set users profile" |
public static final java.lang.String |
UNABLE_TO_UPDATE_PAPER_AUTHORS |
"Unable to update paper\'s authors data" |
public static final java.lang.String |
UNABLE_TO_UPDATE_PAPER_SUBJECT |
"Unable to update paper\'s subject data" |
protected static final java.lang.String |
UPDATE_AFFILIATION |
"UPDATE _Affiliations SET affiliationName=? WHERE affiliationId=?" |
protected static final java.lang.String |
UPDATE_PAPER |
"UPDATE Papers SET title=?, abstract=?, submissionType=?, fileId=? WHERE paperId=? AND submitterId=?" |
protected static final java.lang.String |
UPDATE_SUBJECT |
"UPDATE _subjects SET subjectName=? WHERE subjectId=?" |
protected static final java.lang.String |
UPDATE_TYPE |
"UPDATE _Types SET typeName=? WHERE typeId=?" |
protected static final java.lang.String |
UPDATE_USER_PROFILE |
"UPDATE Users SET lastName=?, firstName=?, email=?, affiliationId=?, pswd=? WHERE userId=?" |
protected static final java.lang.String |
USER_NAME |
"root" |