I’m having an issue that appears identical to that in this thread from 2023. All of the tests are passing, except for the two near the end about inserting the row into the appointments table. The inserts are working when I check the table, so I can’t figure out why the tests won’t pass.
Code so far
salon.sh
#! /bin/bash
PSQL="psql -X --username=freecodecamp --dbname=salon --tuples-only -c"
SERVICES=$($PSQL "SELECT * FROM services;")
MAIN_MENU() {
# Print services
echo "$SERVICES" | while read SERVICE_ID BAR SERVICE_NAME
do
echo -e "$SERVICE_ID) $SERVICE_NAME"
done
# Get user input
echo -e "\nPick a service:"
read SERVICE_ID_SELECTED
# If selection not a number
if [[ ! $SERVICE_ID_SELECTED =~ ^[0-9]+$ ]]
then
# Send back to main menu
MAIN_MENU
return
fi
# If selection not a valid number
SERVICE_AVAILABLE=$($PSQL "SELECT service_id FROM services WHERE service_id='$SERVICE_ID_SELECTED';")
if [[ ! $SERVICE_AVAILABLE =~ $SERVICE_ID_SELECTED ]]
then
# Send back to main menu
MAIN_MENU
return
fi
BOOKING $SERVICE_ID_SELECTED
}
BOOKING() {
SERVICE_ID=$1
echo "You picked a $SERVICE_ID"
echo "Enter your phone: "
read CUSTOMER_PHONE
# If phone not already in db
EXISTING_PHONE=$($PSQL "SELECT phone FROM customers WHERE phone='$CUSTOMER_PHONE';")
if [[ ! $EXISTING_PHONE =~ $CUSTOMER_PHONE ]]
then
# Prompt name
echo "Enter your name: "
read CUSTOMER_NAME
# Add new customer to db
RESULT=$($PSQL "INSERT INTO customers(phone, name) VALUES('$CUSTOMER_PHONE', '$CUSTOMER_NAME');")
else
CUSTOMER_NAME=$($PSQL "SELECT name from customers where phone='$CUSTOMER_PHONE';")
# Strip whitespace from db query result
CUSTOMER_NAME=$(echo $CUSTOMER_NAME | sed -E 's/ *$|^ *//g')
fi
# Get customer ID
CUSTOMER_ID=$($PSQL "SELECT customer_id from customers where phone='$CUSTOMER_PHONE';")
# Strip whitespace from db query result
CUSTOMER_ID=$(echo $CUSTOMER_ID | sed -E 's/ *$|^ *//g')
# echo $CUSTOMER_IDS | while read CUSTOMER_ID
# echo $CUSTOMER_ID
# Prompt time
echo "What time for your appointment?"
read SERVICE_TIME
# Create new appointment
# echo "'$CUSTOMER_ID', '$SERVICE_TIME', '$SERVICE_ID'"
RESULT=$($PSQL "INSERT INTO appointments(customer_id, time, service_id) VALUES('$CUSTOMER_ID', '$SERVICE_TIME', '$SERVICE_ID');")
# Print message
SERVICE=$($PSQL "SELECT name from services where service_id='$SERVICE_ID';")
# Strip whitespace from db query result
SERVICE=$(echo $SERVICE | sed -E 's/ *$|^ *//g')
echo "I have put you down for a $SERVICE at $SERVICE_TIME, $CUSTOMER_NAME."
}
MAIN_MENU
Test status:
CodeRoad:
customers table after running script according to failing tests
salon=> SELECT * FROM customers;
customer_id | phone | name
-------------+--------------+-------
6 | 555-555-5555 | Fabio
(1 row)
appointments table after running script according to failing tests
salon=> SELECT * FROM appointments;
appointment_id | customer_id | time | service_id
----------------+-------------+-------+------------
1 | 6 | 10:30 | 1
2 | 6 | 11am | 2
(2 rows)
System info
Browser Chrome Version 122.0.6261.131 (Official Build) (64-bit)
OS
| Edition | Windows 10 Home |
|---|---|
| Version | 22H2 |
| OS build | 19045.4170 |
| Experience | Windows Feature Experience Pack 1000.19054.1000.0 |
Challenge
Build a Salon Appointment Scheduler