We have a draft of the database schema (see docs/database.md and utils/mermaid/schema.mmd), as we are not using an ORM we need to do manual database schema migration.
As we are at the beginning of the project, we can do this without risks, but in a real project it's a complex topic.
We will also need a seeding script, that will populate the database with existing data. This is useful for testing for example, you can directly test a feature with an existing login.
As the seeding script will need the schema, we can do both at the same time. The seeding script will do the migration, then populate the database, then test it.
Description
We have a draft of the database schema (see
docs/database.mdandutils/mermaid/schema.mmd), as we are not using an ORM we need to do manual database schema migration. As we are at the beginning of the project, we can do this without risks, but in a real project it's a complex topic.We will also need a seeding script, that will populate the database with existing data. This is useful for testing for example, you can directly test a feature with an existing login.
As the seeding script will need the schema, we can do both at the same time. The seeding script will do the migration, then populate the database, then test it.
To read and take inspiration of:
Contact me for credentials for the database.
ACs
utils/seed/index.ts