I am looking to automate the creation of a new table in MySQL and execute TypeORM migration when the application is running in production mode.
Important: The new table should not exist before starting the application in production mode.
The Migration Documentation specifies that the typeorm migration:run command needs to be used to run the migration.
My new table will only be created when the application calls CreateNewTableTimeStamp(inputTableName).up, which will trigger the creation of the table in the database.
However, I am struggling to find a way to automate this migration process since it's not feasible for me to manually run typeorm migration:run every time the application executes this method to create the new table.
Once the new table is created, I will proceed with adding data to this table.
Any assistance on this matter would be greatly appreciated.
Code for My New Table:
class CreateNewTableTimeStamp implements MigrationInterface {
tableName: string;
constructor (inputTableName: string) {
this.tableName = inputTableName
}
async up(queryRunner: QueryRunner): Promise<any> {
await queryRunner.createTable(new Table({
name: this.tableName,
columns: [
{
name: "id",
type: "int",
isPrimary: true
},
{
name: "email",
type: "varchar",
}
]
}), true)
}
async down(queryRunner: QueryRunner): Promise<any> {
const table = await queryRunner.getTable(this.tableName);
await queryRunner.dropTable(this.tableName);
}
}