Salon Appointment Scheduler - Build a Salon Appointment Scheduler

Tell us what’s happening:
I am building the salon appointment scheduler, I have gotten every test to pass except a test that says “If you pick a service that doesn’t exist, you should be shown the same list of services again”. Well i understand what they are trying to say so i did that and it is not passing what do i do now. I have been stuck on this problem for an hour ironically this is supposed to be the easy part lol.

Your code so far
#!/bin/bash
PSQL=“psql -X --username=freecodecamp --dbname=salon --tuples-only -c”

DISPLAY_SERVICES () {

retreive salon services

SERVICES=$($PSQL “SELECT * FROM services”)

list services

echo “$SERVICES” | while read SERVICE_ID BAR SERVICE
do
echo “$SERVICE_ID) $SERVICE”
done
}

MAIN_MENU () {

if [[ $1 ]]
then
# print redirect message
echo -e “\n$1”
fi

DISPLAY_SERVICES

read service from user

read SERVICE_ID_SELECTED

SERVICE=$($PSQL “SELECT name FROM services WHERE service_id=$SERVICE_ID_SELECTED”)

if [[ -z $SERVICE ]]
then
# if service id result is null send to main menu
MAIN_MENU “I could not find that service. What would you like today?”
else
# read user phone number
echo -e “\nWhat’s your phone number?”
read CUSTOMER_PHONE
fi

CUSTOMER_NAME=$($PSQL “SELECT name FROM customers WHERE phone=‘$CUSTOMER_PHONE’”)

if [[ -z $CUSTOMER_NAME ]]
then
# read customer name if not in database
echo -e “\nI don’t have a record for that phone number, what’s your name?”
read CUSTOMER_NAME
CUSTOMER_INSERT_RESULT=$($PSQL “INSERT INTO customers(phone, name) VALUES(‘$CUSTOMER_PHONE’, ‘$CUSTOMER_NAME’)”)
fi

echo -e “\nWhat time would you like your cut, Fabio?”
read SERVICE_TIME

retreive customer id

CUSTOMER_ID=$($PSQL “SELECT customer_id FROM customers WHERE phone=‘$CUSTOMER_PHONE’”)

APPOINTMENT_INSERT_RESULT=$($PSQL “INSERT INTO appointments(customer_id, service_id, time) VALUES($CUSTOMER_ID, $SERVICE_ID_SELECTED, ‘$SERVICE_TIME’)”)

echo -e “I have put you down for a $SERVICE at $SERVICE_TIME, $CUSTOMER_NAME.”

}

welcome users

echo -e “\n~~~~~ MY SALON ~~~~~\n”
echo -e “Welcome to My Salon, how can I help you?\n”

MAIN_MENU

Your browser information:

User Agent is: Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/109.0.0.0 Safari/537.36

Challenge: Salon Appointment Scheduler - Build a Salon Appointment Scheduler

Link to the challenge:

thanks to moT01 i realized it was an input error and i was able to fix it

What was the input error you found? I’m still struggling with this issue.

Hello Pternbrown the test case ran on your code is ‘BadInput’, ‘1’, ‘555-5555’, ‘Test’, ‘FakeTime’, One of these inputs made my program continue running when it should not have. I suggest you entering these inputs and seeing which ones cause your program to not finish and maybe refactor your code a little bit.