Salon Appointment Scheduler - Build a Salon Appointment Scheduler

Backend Development
1

Tell us what’s happening:
Describe your issue in detail here.
I’m currently stuck on the Salon Appointment challenge in the Relational Databases course. Specifically at SUBTASKS 1.1 :17 You should read input into the correct variables. All other tasks are ticked and I made sure to read the user input into the specified Variables. Would greatly appreciate the help here.

Here’s my code so far

#! /bin/bash

PSQL="psql -X --username=freecodecamp --dbname=salon --tuples-only -c"

echo -e "\n~~~~~ MY SALON ~~~~~\n"

# Home menu
HOME_MENU (){

  # If function called with error message
  if [[ $1 ]]
  then
  echo -e "\n$1"
  fi

  # Get available services from database
  SERVICES=$($PSQL "SELECT service_id, name FROM services")

  # Read available services
  echo "$SERVICES" | while read SERVICE_ID BAR SERVICE_NAME
  do
    # Display available services
    echo "$SERVICE_ID) $SERVICE_NAME"
  done
  # Ask to pick service
  read -p "Your choice: " SERVICE_ID_SELECTED

  # If not a number
  if [[ ! $SERVICE_ID_SELECTED =~ ^[0-9]+$ ]]
  then
    # Return to home with message
    HOME_MENU "Please input a number"
  else
    # Check service in database
    SERVICE_NAME=$($PSQL "SELECT name FROM services WHERE service_id = $SERVICE_ID_SELECTED")
    
    # If service doesn't exist
    if [[ -z $SERVICE_NAME ]] 
    then
      # Return to home with message
      HOME_MENU "I could not find that service. What would you like today?"
    else
      REGISTERATION_MENU "$SERVICE_ID_SELECTED" "$SERVICE_NAME"
    fi
  fi

  
}

REGISTERATION_MENU (){
  SERVICE_ID_SELECTED=$1
  SERVICE_NAME=$2

  # Ask for phone number
  echo -e "What's your phone number?"
  read CUSTOMER_PHONE

  # Get customer name from database
  CUSTOMER_NAME=$($PSQL "SELECT name FROM customers WHERE phone = '$CUSTOMER_PHONE'")

  # If customer doesn't exist
  if [[ -z $CUSTOMER_NAME ]]
  then
    # Ask for customer name 
    echo -e "\nI don't have a record of that phone number, what's your name?"
    read CUSTOMER_NAME
    
    # Add customer to database
    INSERT_CUSTOMER_RESULT=$($PSQL "INSERT INTO customers(phone, name) VALUES('$CUSTOMER_PHONE', '$CUSTOMER_NAME')")
  fi

  # Get customer_id from database
  CUSTOMER_ID=$($PSQL "SELECT customer_id FROM customers WHERE phone = '$CUSTOMER_PHONE'")

  # Ask for service time
  echo -e "\nWhat time would you like your $(echo $SERVICE_NAME, $CUSTOMER_NAME? | sed -E 's/^ +| +$//g')"
  read SERVICE_TIME

  # Add appointment to database
  ADD_APPOINTMENT_RESULT=$($PSQL "INSERT INTO appointments(customer_id, service_id, time) VAlUES($CUSTOMER_ID, $SERVICE_ID_SELECTED, '$SERVICE_TIME')")
  
  # If appointment wasn't succesful
  if [[ $ADD_APPOINTMENT_RESULT != "INSERT 0 1" ]] 
  then
    # Return to home with message
    HOME_MENU "Could not schedule appointment, please schedule another service or try again later."
  else
    # Print success message
    echo -e "\nI have put you down for a $(echo $SERVICE_NAME at $SERVICE_TIME, $CUSTOMER_NAME | sed -E 's/^ +| +$//g')."
  fi
}

HOME_MENU "Welcome to My Salon, how can I help you?"

Edit: here’s a link to the Github repo in case you need the dump file.

Your browser information:

User Agent is: Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/103.0.0.0 Safari/537.36

Challenge: Salon Appointment Scheduler - Build a Salon Appointment Scheduler

Link to the challenge:

2

The tests might be a little rough on that one @eslamallam73. They are regexing your script for the variables and don’t expect any prompts with the read. Just change your read -p "Your choice: " SERVICE_ID_SELECTED to read SERVICE_ID_SELECTED. That passed for me. I will look into improving those tests so something like you have would pass.

1 Like
3

Thanks for the quick reply! I changed the read statement you mentioned and passed all tests.

1 Like