23 Mar 2021
Create the database scripts
- Part 1 - Introduction
- Part 2 - Getting Started
- Part 3 - Creating a basic design
- Part 4 - Upgrade to .NET Core 3.1
- Part 5 - Database test
- Part 6 - Create the database
- Part 7 - No architecture deep dive
- Part 8 - First API mockup
- Part 9 - A new start
- Part 10 - This Article
- Part 11 - Create the group controller and service
- Part 12 - Running SQL Server in Docker
- Part 13 - Being able to use two database engines
It has been a while since I spend some time on my Football Predictions Website. Today I created the scripts to create the database.
For the previous version of this project I decided to start the development using a SQLite database. I also created the database schema and filled it the fixture that where known at the time. And then corona came and the tournament was moved to 2021.
So I needed to update those scripts. The dates of the matches needed to be updated and all the countries are known now. Not the most difficult, but a bit boring, task that needs to be done.
Tonight I finally sat down and updated the scripts. They are commited to the repository, both the English and the Dutch variant.
The Dutch variant I need for my own site. The English variant I will use during development and is there for anybody to use. If you can to translate them to another language, feel free to do so.
The next step will be to create an API endpoint that can retrieve the group data from the database.