Skip to content

database.md

Latest commit

 

History

History
46 lines (29 loc) · 1.56 KB

database.md

File metadata and controls

46 lines (29 loc) · 1.56 KB

Database Schema

File: database.dbml

How to update the drizzle schema files

  1. Copy the new DBML file from (somewhere) to /docs/backend/database.dbml
  2. Run "Create Schema Files" Script: npm run drizzle-update-schema.
    Infos: createSchemaFiles/readme.md

How to run migrations

WHAT: Update a database after the schema in backend project was changed.

Create new migration files

  • is reading from /backend/.env.local
  • is reading drizzle config from /backend/drizzle.config.js
  • is writing the migrations to /backend/database/drizzle/migrations

Info: run from project root

  1. Create migrations according to schema changes: npm run drizzle-create-migration-files
  2. Create custom migrations (e.g. for data changes):
    a. npm run drizzle-create-migration-files -- --custom
    b. Write sql update queries into the newly created sql file in /backend/database/drizzle/migrations

Execute the migration files

  • is reading from /backend/.env.local
  • is reading drizzle config from /backend/drizzle.config.js
  • is reading the migrations from /backend/database/drizzle/migrations

Info: for tipcards.io and dev.tipcards.io the migration files are automatically executed in the gitlab pipeline. Just push main or develop branch!

Info: for manual execution run from project root

npm run drizzle-migrate

Additional info for for development

If you need to drop migration files

We commit all migrations into git. Just revert/reset the current file changes!