Relational database - build a bike rental shop

Hi, unable to proceed past this step despite adding the comments as instructed. What am I missing?? Do I need to do something else ref. the comment “And set the available column to false for the bike rented.” ?

Thanks,

Lewis

please give more context to the question. Please show the instructions you were attempting at least.

also try to click the Reset button.
Then retry.

and if that doesn’t work, I would copy the code (copy and paste) and show it to us here as well just in case there is something that is not obvious from the screenshot you took that is more obvious when we see the code
(highlight the code, then right-click and choose Copy, then right-click somewhere else like here and click Paste to paste it in)

Hi Hanaa,

Here’s further context to the problem:

image.png

These comments should be added below the insert customer variable:

image.png

Added to the script - exactly as the hint suggests:

image.png

But does not pass the test:

image.png

Regards,

Lewis

I can’t see any of the images you posted.

Can you try to copy and paste instead the actual text or code?

Here you go:

And set the available column to false for the bike rented. Below the end of the if statement that inserts a new customer, add five more comments; get customer_id , insert bike rental , set bike availability to false , get bike info , and send to main menu

    # if customer doesn't exist
    if [[ -z $CUSTOMER_NAME ]]
    then
      # get new customer name
      echo -e "\nWhat's your name?"
      read CUSTOMER_NAME

      # insert new customer
      INSERT_CUSTOMER_RESULT=$($PSQL "INSERT INTO customers(name, phone) VALUES('$CUSTOMER_NAME', '$PHONE_NUMBER')") 
      # get customer_id

      # insert bike rental

      # set bike availability to false

      # get bike info

      # send to main menu

fi
}

This section asks for the above comments to be added to the ‘bike-shop.sh’ script, but doesn’t pass the test.

the coderoad instruction says that you should put the new comments outside the scope of the if [[ -z $CUSTOMER_NAME ]] code
But your comments are within the scope of that if.
Move them below the fi line

    if [[ -z $CUSTOMER_NAME ]]
    then
      # get new customer name
      echo -e "\nWhat's your name?"
      read CUSTOMER_NAME

      # insert new customer
      INSERT_CUSTOMER_RESULT=$($PSQL "INSERT INTO customers(name, phone) VALUES('$CUSTOMER_NAME', '$PHONE_NUMBER')") 
    fi

     # get customer_id

     # insert bike rental

     # set bike availability to false

     # get bike info

     # send to main menu

I have added the comments as suggested outside of the IF statement, but still does not pass the test. “You should correctly add the suggested comments”

Have you changed anything else? I tried the exact same step this morning and it worked for me.
Perhaps try to reset and copy and paste the code in immediately after the fi and above any other code that was there (not overwriting anything).