Constant Field Values

Contents

• com.fssa.*

com.fssa.*

com.fssa.librarymanagement.constants.BookConstants

Modifier and Type	Constant Field	Value
public static final String	AVAILABE_COPIES_CANNOT_BE_LESS_THAN_0	"Availabe copies cannot be less than 0"
public static final String	AVAILABLE_COPIES_CANNOT_BE_GREATER_THAN_TOTAL_COPIES	"Available copies cannot be greater than total copies"
public static final String	BOOK_AUTHOR_CANNOT_BE_EMPTY	"Book author cannot be empty"
public static final String	BOOK_AUTHOR_CANNOT_CONTAIN_NUMBERS	"Book author cannot contain Numbers"
public static final String	BOOK_DESCRIPTION_CANNOT_BE_EMPTY	"Book description cannot be empty"
public static final String	BOOK_GENRE_CANNOT_BE_EMPTY	"Book genre cannot be empty"
public static final String	BOOK_GENRE_CANNOT_CONTAIN_NUMBERS	"Book genre cannot contain Numbers"
public static final String	BOOK_LANGUAGE_CANNOT_BE_EMPTY	"Book language cannot be empty"
public static final String	BOOK_LANGUAGE_CANNOT_CONTAIN_NUMBERS	"Book language cannot contain Numbers"
public static final String	BOOK_NOT_FOUND	"Book not found."
public static final String	BOOK_PUBLISHER_CANNOT_BE_EMPTY	"Book publisher cannot be empty"
public static final String	BOOK_PUBLISHER_CANNOT_CONTAIN_NUMBERS	"Book publisher cannot contain Numbers"
public static final String	BOOK_TITLE_CANNOT_BE_EMPTY	"Book title cannot be empty"
public static final String	BOOK_TITLE_CANNOT_CONTAIN_NUMBERS	"Book title cannot contain Numbers"
public static final String	COVER_IMAGE_URL_CANNOT_BE_EMPTY	"Cover image URL cannot be empty"
public static final String	DIGITS_REGEX	".*[0-9].*"
public static final String	INVALID_COVER_IMAGE_URL	"Invalid Cover image URL. URL should be in the format \'http://www.example.com/index.html\'"
public static final String	LOANED_COPIES_CANNOT_BE_GREATER_THAN_TOTAL_COPIES	"Loaned copies cannot be greater than total copies"
public static final String	LOANED_COPIES_CANNOT_BE_LESS_THAN_0	"Loaned copies cannot be less than 0"
public static final String	TOTAL_COPIES_SHOULD_BE_GREATER_THAN_ZERO	"Total copies should be greater than zero"

com.fssa.librarymanagement.constants.BorrowConstants

Modifier and Type	Constant Field	Value
public static final int	BORROW_LIMIT	5
public static final String	BORROW_LIMIT_EXCEEDED_FOR_THE_USER	"Borrow limit exceeded for the user."
public static final String	BORROWS_NOT_FOUND	"Borrows not found."
public static final int	FINE_AMOUNT	10
public static final String	JOIN_QUERY	"SELECT b.*, u.user_name, u.user_id, u.email_id, u.profile_image, bk.book_id, bk.title, bk.cover_image FROM borrows b JOIN users u ON b.user_id = u.user_id JOIN books bk ON b.book_id = bk.book_id "
public static final String	NO_AVAILABLE_COPIES_OF_THE_BOOK	"No available copies of the book."
public static final String	SELECT_QUERY_PREFIX	"SELECT user_id, book_id, borrow_date, due_date, return_date FROM borrows "
public static final String	THIS_BOOK_HAS_ALREADY_BEEN_BORROWED_BY_YOU	"This Book has already been borrowed by you"

com.fssa.librarymanagement.constants.CommentConstants

Modifier and Type	Constant Field	Value
public static final String	BASE_COMMENT_QUERY	"SELECT c.comment_id, c.description, c.created_at, c.edited_at, c.is_active, c.is_edited,c.is_trusted, u.user_id, u.user_name, u.email_id, u.profile_image, b.book_id, b.title, b.cover_image FROM comments c JOIN users u ON c.user_id = u.user_id JOIN books b ON c.book_id = b.book_id "
public static final String	DELETE_COMMENT_QUERY	"UPDATE comments SET is_active = false WHERE comment_id = ?"
public static final String	INSERT_COMMENT_QUERY	"INSERT INTO comments (user_id, book_id, description, created_at, is_trusted) VALUES (?, ?, ?, ?, ?)"
public static final String	LIST_ALL_COMMENTS_QUERY	"SELECT c.comment_id, c.description, c.created_at, c.edited_at, c.is_active, c.is_edited,c.is_trusted, u.user_id, u.user_name, u.email_id, u.profile_image, b.book_id, b.title, b.cover_image FROM comments c JOIN users u ON c.user_id = u.user_id JOIN books b ON c.book_id = b.book_id WHERE c.is_active = true"
public static final String	LIST_COMMENTS_BY_BOOK_QUERY	"SELECT c.comment_id, c.description, c.created_at, c.edited_at, c.is_active, c.is_edited,c.is_trusted, u.user_id, u.user_name, u.email_id, u.profile_image, b.book_id, b.title, b.cover_image FROM comments c JOIN users u ON c.user_id = u.user_id JOIN books b ON c.book_id = b.book_id WHERE c.book_id = ? AND c.is_active = true"
public static final String	UPDATE_COMMENT_QUERY	"UPDATE comments SET description = ?, edited_at = ?, is_edited = TRUE WHERE comment_id = ?"

com.fssa.librarymanagement.constants.RatingConstants

Modifier and Type	Constant Field	Value
public static final String	GET_RATING_BY_BOOK_AND_USER_QUERY	"SELECT rating FROM ratings WHERE book_id = ? AND user_id = ?"
public static final String	GET_RATING_BY_BOOK_QUERY	"SELECT AVG(rating) AS average_rating, COUNT(*) AS rating_count FROM ratings WHERE book_id = ?"
public static final String	INSERT_OR_UPDATE_RATING_QUERY	"INSERT INTO ratings (user_id, book_id, rating) VALUES (?, ?, ?) ON DUPLICATE KEY UPDATE rating = VALUES(rating)"

com.fssa.librarymanagement.constants.UserConstants

Modifier and Type	Constant Field	Value
public static final String	DATE_OF_BIRTH_CANNOT_BE_EMPTY	"Date of birth cannot be empty"
public static final String	EMAIL_CANNOT_BE_EMPTY	"Email cannot be empty"
public static final String	INCORRECT_OLD_PASSWORD	"Incorrect old password."
public static final String	INVALID_DATE_OF_BIRTH_CANNOT_EXCEED_100_YEARS	"Invalid date of birth. Cannot exceed 100 years"
public static final String	INVALID_DATE_OF_BIRTH_MUST_BE_AT_LEAST_10_YEARS_OLD	"Invalid date of birth. Must be at least 10 years old."
public static final String	INVALID_EMAIL_FORMAT	"Invalid email format. Email should be in the format \'user@example.com\'"
public static final String	INVALID_GENDER_GENDER_MUST_BE_M_OR_F	"Invalid gender. Gender must be \'M\' or \'F\'."
public static final String	INVALID_LOGIN_CREDENTIALS	"Ivalid Login Credentials"
public static final String	INVALID_MOBILE_NUMBER_LENGTH	"Mobile number should be be 10 digits"
public static final String	INVALID_NAME_FORMAT	"Invalid name format. Name should start with a capital letter and may contain letters, spaces, hyphens, and apostrophes."
public static final String	INVALID_PASSWORD_FORMAT	"Password must contain at least one uppercase letter, one lowercase letter, and one digit"
public static final String	INVALID_PROFILE_IMAGE_URL	"Invalid profile image URL. URL should be in the format \'http://www.example.com/index.html\'"
public static final String	MOBILE_NUMBER_CANNOT_BE_EMPTY	"Mobile number cannot be empty"
public static final String	NAME_CANNOT_BE_EMPTY	"Name cannot be empty"
public static final String	PASSWORD_CANNOT_BE_EMPTY	"Password cannot be empty"
public static final String	PASSWORD_IS_LESS_THAN_THE_EXPECTED_LENGTH_OF_8_CHARACTERS	"Password is less than the expected length of 8 characters"
public static final String	PASSWORDS_CANNOT_BE_SAME	"Old Password and New Password Cannot be same"
public static final String	PROFILE_IMAGE_URL_CANNOT_BE_EMPTY	"Profile image URL cannot be empty"
public static final String	SELECT_QUERY	"SELECT * FROM users"
public static final String	USER_ALREADY_EXISTS	"User already exists."
public static final String	USER_DOES_NOT_EXIST_WITH_THE_GIVEN_EMAIL	"User does not exist with the given email"
public static final String	USER_NOT_FOUND	"User not found"