import { MigrationInterface, QueryRunner } from "typeorm";

export class SuggestionsMetadataInsert1635230545838
  implements MigrationInterface
{
  public async up(queryRunner: QueryRunner): Promise<void> {
    await queryRunner.query(
      `INSERT INTO suggestions_metadata (
          id,
          suggestion_id,
          user,
          time,
          language,
          filename
        ) 
        SELECT 
          id,
          suggestion_id,
          user,
          time,
          language,
          filename 
        FROM suggestions`
    );
  }

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