typeorm如何生成插入默认数据的migration?

Question

第一次上线，跑migration：generate生成建表语句。

create table...

但是表里的一些数据希望有默认值，比如一些常量。这个可以用generate生成sql的插入数据命令吗？
还是要自己去手写migration

export class Init1684122178932 implements MigrationInterface {
    name = 'Init1684122178932'

    public async up(queryRunner: QueryRunner): Promise<void> {
        await queryRunner.query(`CREATE TABLE \`role\` (\`id\` int NOT NULL AUTO_INCREMENT, \`roleName\` varchar(255) NOT NULL, PRIMARY KEY (\`id\`)) ENGINE=InnoDB`);

        // 手写插入语句
    }

    public async down(queryRunner: QueryRunner): Promise<void> {
        await queryRunner.query(`DROP TABLE \`role\``);
    }

}

如果要手写，有没有sql编辑器，能够生成像上面sql一样的带转义符号的语句，而不是自己全部手写

Answer 1

import { MigrationInterface, QueryRunner } from "typeorm";

export class Init1684122178932 implements MigrationInterface {
    name = 'Init1684122178932'

    public async up(queryRunner: QueryRunner): Promise<void> {
        await queryRunner.query(`CREATE TABLE \`role\` (\`id\` int NOT NULL AUTO_INCREMENT, \`roleName\` varchar(255) NOT NULL, PRIMARY KEY (\`id\`)) ENGINE=InnoDB`);

        // 手写插入语句
        await queryRunner.query(`INSERT INTO \`role\` (\`roleName\`) VALUES ('管理员')`);
        await queryRunner.query(`INSERT INTO \`role\` (\`roleName\`) VALUES ('用户')`);
    }

    public async down(queryRunner: QueryRunner): Promise<void> {
        await queryRunner.query(`DROP TABLE \`role\``);
    }
}