Salon scheduled help needed

Backend Development
1

I have the same issue, the code works fine functionally but doesn’t pass all the tests for reference my code:

#!/bin/bash
PSQL="psql --username=freecodecamp --dbname=salon --tuples-only -c"
echo -e "\n~~~~~ MY SALON ~~~~~\n"

MAIN_MENU () 
{
    if [[ $1 ]]
    then
        echo -e "\n$1\n"
    fi
    echo -e "Welcome to My Salon how may I help you?\n"
    SERVICES=$($PSQL "SELECT service_id,name FROM services")
    echo "$SERVICES" | while IFS=" " read SERVICE_ID BAR SERVICE
    do
        echo -e "$SERVICE_ID) $SERVICE"
    done
    read SERVICE_ID_SELECTED
}
    
MAIN_MENU
if [[ ! $SERVICE_ID_SELECTED =~ ^[0-9]$ ]]
then
    MAIN_MENU "Enter a valid input"
else
    SERVICE_NAME=$($PSQL "SELECT name FROM services WHERE service_id=$SERVICE_ID_SELECTED")
    if [[ -z $SERVICE_NAME ]]
    then
        MAIN_MENU "Choose a valid service!"
    fi
    echo -e "\nEnter your phone number:"
    read CUSTOMER_PHONE
    CUSTOMER_NAME=$($PSQL "SELECT name FROM customers WHERE phone='$CUSTOMER_PHONE'")
    if [[ -z $CUSTOMER_NAME ]]
    then
        echo I don't have a record for that phone number, what's your name?
        read CUSTOMER_NAME
        CUSTOMER_INSERT_RES=$($PSQL "INSERT INTO customers(phone,name) VALUES ('$CUSTOMER_PHONE','$CUSTOMER_NAME')")
    fi

    echo What time would you like your appointment in military time, $CUSTOMER_NAME?
    read SERVICE_TIME
    CUSTOMER_ID=$($PSQL "SELECT customer_id FROM customers WHERE phone='$CUSTOMER_PHONE'")
    TIME_INSET_RES=$($PSQL "INSERT INTO appointments(customer_id,service_id,time) VALUES ($CUSTOMER_ID,$SERVICE_ID_SELECTED,'$SERVICE_TIME')")
    if [[ $TIME_INSET_RES == "INSERT 0 1" ]]
    then
        echo I have put you down for a $SERVICE_NAME at $TIME, $CUSTOMER_NAME.
    fi

fi

Here are some screen shots of output:

Screenshot 2024-07-16 122552
Screenshot 2024-07-16 122552773×496 8.27 KB

and the cases which I’m not passing:

  • You can create a row in the appointments table by running your script and entering 1, 555-555-5555, Fabio, 10:30 at each request for input if that phone number isn’t in the customers table. The row should have the customer_id for that customer, and the service_id for the service entered

  • You can create another row in the appointments table by running your script and entering 2, 555-555-5555, 11am at each request for input if that phone number is already in the customers table. The row should have the customer_id for that customer, and the service_id for the service entered

Thanks.

2

I have moved your post to its own topic as you may have a different issue than the other person and we like to keep each problem in its own thread.

Have you checked that your time field is at varchar 10?

3

Oh thanks that solved it!

1 Like