import { MigrationInterface, QueryRunner } from "typeorm";

export class SuggestionsDataInsert1635230551853 implements MigrationInterface {
  public async up(queryRunner: QueryRunner): Promise<void> {
    await queryRunner.query(
      `INSERT INTO suggestions_data (
          id,
          original_prefix,
          original_suffix,
          snapshot_prefix,
          snapshot_suffix
        ) 
        SELECT 
            id,
            original_prefix,
            original_suffix,
            snapshot_prefix,
            snapshot_suffix 
        FROM suggestions`
    );
  }

  public async down(): Promise<void> {
    await Promise.resolve();
  }
}