# CHANGE THESE VARIABLES TO THE DETAILS OF YOUR RDS INSTANCE:
RDS_HOST = "THE_ENDPOINT_OF_YOUR_RDS_INSTANCE"
REGION = 'YOUR_REGION'
USER_NAME = "RDS_USERNAME"
PASSWORD = "RDS_PASSWORD"
DB_NAME = "DB_NAME"

# CRUD FUNCTIONS
CREATE_TABLE_IF_NOT_EXISTS = """create table if not exists test (id INT NOT NULL AUTO_INCREMENT, PRIMARY KEY(id), name VARCHAR(64));"""
INSERT_INTO = """insert into test  (name) values('%s')"""
GET_ENTRY_BY_NAME = """select id, name from test where name = '%s'"""
SELECT_ALL = """select * from test"""
GET_ENTRY_BY_ID = """select id, name from test where id = %s"""
UPDATE_SELECTED_ENTRY = """update test set name='%s' where id = %s"""
DELETE_SELECTED_ENTRY = """delete from test where id = %s"""

# MENU
MENU_PROMPT = "Please enter add/delete/update/view or exit:"
ADD = "add"
EXIT = "exit"
DELETE = "delete"
EDIT = "update"
VIEW = "view"

# MISC
RESULTS = "Results..."
ENTER_NAME = "Enter name: "
ENTER_ID = "Enter ID: "
ENTRY_SAVED = "Entry saved"
UPDATE = "Enter updated name: "
RESELECT = "Please enter either 'Y' or 'N'..."
CONFIRM_UPDATE = "Is this the entry you want to update? (Y/N)"
CONFIRM_DELETE = "Is this the entry you want to delete? (Y/N)"
CANCEL_UPDATE = "Selected entry will not be updated"
CANCEL_DELETE = "Selected entry will not be deleted"

