World Cup Database - Build a World Cup Database

Tell us what’s happening:

I am only having 23 rows instead of 24 even though i did not make any change to the games.csv file

#! /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
echo $($PSQL “TRUNCATE TABLE teams, games;”)

Do not change code above this line. Use the PSQL variable above to query your database.

cat games.csv | while IFS=“,” read YEAR ROUND WINNER OPPONENT WINNER_

Your code so far

Your browser information:

User Agent is: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/125.0.0.0 Safari/537.36

Challenge Information:

World Cup Database - Build a World Cup Database

Make sure to have your code wrapped in triple backtick characters like so

```
<your code here>
```

when posting it into the forums. you can use the Preformatted Text option under the Gear Icon in the editor if you prefer.