Unable to end the project - Build a World Cup Database

deux · May 25, 2022, 6:38pm

Continuing the discussion from Running the Relational Database Curriculum in your Browser:

Hi,
Thank you for your reply. I am still facing the issue and I think it is the project that won’t pass. Here is the link to the dump of my database :

github.com

drux31/worldcup-db/blob/main/worldcup.sql

--
-- PostgreSQL database dump
--

-- Dumped from database version 12.9 (Ubuntu 12.9-2.pgdg20.04+1)
-- Dumped by pg_dump version 12.9 (Ubuntu 12.9-2.pgdg20.04+1)

SET statement_timeout = 0;
SET lock_timeout = 0;
SET idle_in_transaction_session_timeout = 0;
SET client_encoding = 'UTF8';
SET standard_conforming_strings = on;
SELECT pg_catalog.set_config('search_path', '', false);
SET check_function_bodies = false;
SET xmloption = content;
SET client_min_messages = warning;
SET row_security = off;

DROP DATABASE worldcup;
--

This file has been truncated. show original

Thanks again.

moT01 · May 25, 2022, 7:47pm

The tests are quite picky, it needs to match the example exactly. Assuming I loaded up your files correctly, there’s at least one thing I see that’s off:
Screen Shot 2022-05-25 at 2.39.25 PM

^ The example is the top, the output is the bottom. There’s too many zero’s in the output. There was another person who had this same result, but I can’t quite find the conversation on here to know how they fixed it. Let me know if you can’t figure out how to fix it and I can try to help come up with a solution.

deux · May 26, 2022, 8:34am

Thank you for the tips. I solved the problem by adding a “round” to 16 decimals, in order to match the same number of expected zeros, and the project did pass this time .

Thanks again.