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
Bedankt voor je feedback!
Vraag AI
Vraag AI
Vraag wat u wilt of probeer een van de voorgestelde vragen om onze chat te starten.
Awesome!
Completion rate improved to 2.08
Populating the Database with Initial Data
Veeg om het menu te tonen
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
Bedankt voor je feedback!