NestJS with TypeORM Migrations
OverView
- NestJS * TypeORM
- Adding table columns using CLI
- ts-node and typeorm are already installed
How to
(1. Create an entity)
2. Adding table columns
3. Create a new migration
4. Run migrations
Adding table columns / Edit entity file
import { Entity, Column } from "typeorm";
@Entity()
export class User{
@Column()
id: number;
@Column()
name: string;
// Add
@Column()
description: string;
}
Create a new migration
"scripts": {
...
"typeorm": "node --require ts-node/register ./node_modules/typeorm/cli.js"
}
npm run typeorm migration:generate -- -n AddDescriptionColumnToUser
it creates migration file
Run migrations
npm run typeorm migration:run
Done 👏
Other Commands
Revert migrations
npm run typeorm migration:revertShow migrations
npm run typeorm migration:showDrop database schema ※ To dompletely drop a database schema ☠️
npm run typeorm schema:drop
