Relational database bug

1

There is a problem with one step in Relational Database → **Learn SQL by Building a Student Database: Part 1. In this step: Learn SQL by Building a Student Database: Part 1

Below that, use echo to print the variable so you can see if it’s working.

  1. Add echo $MAJOR_ID below the MAJOR_ID variable you just created

I did it but the test doesn’t pass.

This is my code:

#!/bin/bash

Script to insert data from courses.csv and students.csv into students database

PSQL=“psql -X --username=freecodecamp --dbname=students --no-align --tuples-only -c”
echo $($PSQL “TRUNCATE students, majors, courses, majors_courses”)

cat courses_test.csv | while IFS=“,” read MAJOR COURSE
do
if [[ $MAJOR != “major” ]]
then
# get major_id
MAJOR_ID=$($PSQL “SELECT major_id FROM majors WHERE major=‘$MAJOR’”)

# if not found
if [[ -z $MAJOR_ID ]]
then
  # insert major
  INSERT_MAJOR_RESULT=$($PSQL "INSERT INTO majors(major) VALUES('$MAJOR')")
  if [[ $INSERT_MAJOR_RESULT == "INSERT 0 1" ]]
  then
    echo Inserted into majors, $MAJOR
  fi

  # get new major_id
  MAJOR_ID=$($PSQL "SELECT major_id FROM majors WHERE major='$MAJOR'")
fi

# get course_id
COURSE_ID=$($PSQL "SELECT course_id FROM courses WHERE course='$COURSE'")

# if not found
if [[ -z $COURSE_ID ]]
then
  # insert course
  INSERT_COURSE_RESULT=$($PSQL "INSERT INTO courses(course) VALUES('$COURSE')")
  if [[ $INSERT_COURSE_RESULT == "INSERT 0 1" ]]
  then
    echo Inserted into courses, $COURSE
  fi

  # get new course_id
  COURSE_ID=$($PSQL "SELECT course_id FROM courses WHERE course='$COURSE'")
fi

# insert into majors_courses
INSERT_MAJORS_COURSES_RESULT=$($PSQL "INSERT INTO majors_courses(major_id, course_id) VALUES($MAJOR_ID, $COURSE_ID)")
if [[ $INSERT_MAJORS_COURSES_RESULT == "INSERT 0 1" ]]
then
  echo Inserted into majors_courses, $MAJOR : $COURSE
fi

fi
done

cat students_test.csv | while IFS=“,” read FIRST LAST MAJOR GPA
do
if [[ $FIRST != “first_name” ]]
then
# get major_id
MAJOR_ID=$($PSQL “SELECT major_id FROM majors WHERE major=‘$MAJOR’”)
echo $MAJOR_ID
# if not found

# set to null

# insert student

fi
done