Tell us what’s happening:
I was able to create tables games and teams with 32 rows and 24 rows respectively, yet the test did not pass.
-
I have passed everything else, including the tests for table forming, column namings and queries, so I don’t know what else could have gone wrong.
-
The script only took 3 seconds to run, so i doubt its the 20-second limit thing (?)
-
Please help thanks.
My code so far
#! /bin/bash
if [[ $1 == "test" ]]
then
PSQL="psql --username=postgres --dbname=worldcuptest -t --no-align -c"
else
PSQL="psql --username=freecodecamp --dbname=worldcup -t --no-align -c"
fi
# Do not change code above this line. Use the PSQL variable above to query your database.
PSQL="psql -X --username=freecodecamp --dbname=worldcup --no-align --tuples-only -c"
echo $($PSQL "TRUNCATE TABLE teams, games RESTART IDENTITY")
cat games.csv | while IFS="," read YEAR ROUND WINNER OPPONENT WINNERGOALS OPPONENTGOALS
do
if [[ $YEAR != year ]]
then
TEAM_ID=$($PSQL "SELECT team_id FROM teams WHERE name='$WINNER'")
if [[ -z $TEAM_ID ]]
then
INSERT_TEAM=$($PSQL "INSERT INTO teams(name) VALUES('$WINNER')")
if [[ $INSERT_TEAM == "INSERT 0 1" ]]
then
echo Inserted into teams, $WINNER
fi
fi
TEAM_ID=$($PSQL "SELECT team_id FROM teams WHERE name='$OPPONENT'")
if [[ -z $TEAM_ID ]]
then
INSERT_TEAM=$($PSQL "INSERT INTO teams(name) VALUES('$OPPONENT')")
if [[ $INSERT_TEAM == "INSERT 0 1" ]]
then
echo Inserted into teams, $OPPONENT
fi
fi
INSERT_GAME_RESULT=$($PSQL "INSERT INTO games(year, round, winner_id, opponent_id, winner_goals, opponent_goals) VALUES($YEAR, '$ROUND', (SELECT team_id FROM teams WHERE name='$WINNER'), (SELECT team_id FROM teams WHERE name='$OPPONENT'), $WINNERGOALS, $OPPONENTGOALS)")
if [[ $INSERT_GAME_RESULT == "INSERT 0 1" ]]
then
echo Inserted into games, $YEAR $ROUND
fi
fi
done
Your browser information:
User Agent is: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/134.0.0.0 Safari/537.36
Challenge Information:
World Cup Database - Build a World Cup Database