import { MigrationInterface, QueryRunner } from 'typeorm';

export class linksInGameinfo1712275226450 implements MigrationInterface {
  public async up(queryRunner: QueryRunner): Promise<void> {
    await queryRunner.query(`
                INSERT INTO asset_block_keys(project_id, block_key, block_name, block_title, block_type)
                SELECT id, 12, 'links', '', 'linklist'
                FROM projects;
        `);

    await queryRunner.query(
      `
          INSERT INTO public.asset_blocks (project_id, block_key, asset_id, title, props, created_at, updated_at, index, has_formula) 
          VALUES (
              1, 
              12, 
              '00000000-0000-0000-0000-100000000000', 
              '[[t:Links]]', 
              '{}', 
              '2023-04-05 22:21:37.818253 +00:00', 
              '2023-04-05 22:22:24.629625 +00:00',
              3, 
              false);    
      `,
    );
    await queryRunner.query(
      `
          UPDATE public.asset_blocks
          SET index = 4 
          WHERE 
            asset_id =  '00000000-0000-0000-0000-100000000000'
            AND block_key = 3
      `,
    );
    await queryRunner.query(`
          INSERT INTO asset_comps(project_id, id)
          SELECT project_id, id
          FROM assets
          ON CONFLICT DO NOTHING;
          INSERT INTO asset_block_comps(project_id, asset_id, block_key)
          SELECT project_id, asset_id, block_key
          FROM asset_blocks
          ON CONFLICT DO NOTHING;
      `);
  }

  public async down(queryRunner: QueryRunner): Promise<void> {
    await queryRunner.query(`
                DELETE FROM asset_block_keys
                WHERE block_key = 12
        `);

    await queryRunner.query(
      `
            DELETE FROM public.asset_blocks
            WHERE 
              asset_id =  '00000000-0000-0000-0000-100000000000'
              AND block_key = 12
        `,
    );
    await queryRunner.query(
      `
            UPDATE public.asset_blocks
            SET index = 3
            WHERE 
              asset_id =  '00000000-0000-0000-0000-100000000000'
              AND block_key = 3
        `,
    );
  }
}