Spaces:
Sleeping
Sleeping
File size: 2,281 Bytes
ffd0171 | 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 | import { MigrationInterface, QueryRunner } from 'typeorm';
export class AddQuestionBankImageMetadata1780000000003
implements MigrationInterface
{
name = 'AddQuestionBankImageMetadata1780000000003';
public async up(queryRunner: QueryRunner): Promise<void> {
await this.addColumnIfMissing(
queryRunner,
'question_bank_questions',
'question_file_caption',
'`question_file_caption` varchar(500) NULL',
);
await this.addColumnIfMissing(
queryRunner,
'question_bank_questions',
'question_file_alt_text',
'`question_file_alt_text` varchar(500) NULL',
);
await this.addColumnIfMissing(
queryRunner,
'question_bank_question_groups',
'shared_file_caption',
'`shared_file_caption` varchar(500) NULL',
);
await this.addColumnIfMissing(
queryRunner,
'question_bank_question_groups',
'shared_file_alt_text',
'`shared_file_alt_text` varchar(500) NULL',
);
}
public async down(queryRunner: QueryRunner): Promise<void> {
await this.dropColumnIfExists(
queryRunner,
'question_bank_question_groups',
'shared_file_alt_text',
);
await this.dropColumnIfExists(
queryRunner,
'question_bank_question_groups',
'shared_file_caption',
);
await this.dropColumnIfExists(
queryRunner,
'question_bank_questions',
'question_file_alt_text',
);
await this.dropColumnIfExists(
queryRunner,
'question_bank_questions',
'question_file_caption',
);
}
private async addColumnIfMissing(
queryRunner: QueryRunner,
tableName: string,
columnName: string,
definition: string,
): Promise<void> {
const hasColumn = await queryRunner.hasColumn(tableName, columnName);
if (!hasColumn) {
await queryRunner.query(
`ALTER TABLE \`${tableName}\` ADD COLUMN ${definition}`,
);
}
}
private async dropColumnIfExists(
queryRunner: QueryRunner,
tableName: string,
columnName: string,
): Promise<void> {
const hasColumn = await queryRunner.hasColumn(tableName, columnName);
if (hasColumn) {
await queryRunner.query(
`ALTER TABLE \`${tableName}\` DROP COLUMN \`${columnName}\``,
);
}
}
}
|