how-to-write-typeorm-migrations-in-packmind

Write TypeORM migrations in the Packmind monorepo to manage database schema changes effectively while ensuring proper logging and rollback capabilities. ## When to Use - When you need to create new database tables - When adding or modifying columns in existing tables - When creating or updating foreign key relationships - When making any database schema changes that need to be version controlled ## Context Validation Checkpoints * [ ] Have you identified the exact database schema changes needed? * [ ] Do you know the TypeORM column types for all fields? * [ ] Have you planned the rollback strategy (down method)? * [ ] Are you familiar with the shared migration utilities in @packmind/shared? ## Recipe Steps ### Step 1: Create Migration File Using TypeORM CLI IMPORTANT: Always create migration files using the TypeORM CLI command. Never create migration files manually. The CLI automatically generates a timestamp prefix and sets up the basic structure. ```bash # Create new migration file (TypeORM will automatically add timestamp) npx typeorm migration:create packages/migrations/src/migrations/DescriptiveName ``` ### Step 2: Set Up Basic Migration Structure with Logging Implement the migration class with PackmindLogger for comprehensive logging. Include try-catch blocks and log start, progress, completion, and any errors. ```typescript import { MigrationInterface, QueryRunner } from 'typeorm'; import { PackmindLogger, LogLevel } from '@packmind/shared'; export class Yo...