Populating the Database with Initial Data

Let's add some initial data to the database.

Look for the file named seed.js in the scripts folder of the project. This script contains instructions for creating and seeding tables for invoices, sellers, users, and income.

Don't worry if you don't fully understand the code details. In essence, the script uses SQL to create the tables and populates them with data from the placeholder-data.js file.

To proceed, add the following line to your scripts in the package.json file:

To proceed, we need to access the terminal and execute the following command: npm run seed.

We should see the following messages in the terminal, indicating that the data was successfully populated.

Database Testing

Navigate to the "Query" tab to execute the SQL request. Let's attempt to run the following query.

We should get the following result:

In Practice