All files / src/Projection/migrations 1682519108368-tokens-table.ts

66.66% Statements 6/9
100% Branches 0/0
50% Functions 1/2
66.66% Lines 6/9

Press n or j to go to the next uncovered block, b, p or k for the previous block.

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  35x   35x 35x     1x     1x     1x                      
import { MigrationInterface, QueryRunner } from 'typeorm';
import { TokensEntity } from '@cardano-sdk/projection-typeorm';
 
export class TokensTableMigration1682519108368 implements MigrationInterface {
  static entity = TokensEntity;
 
  async up(queryRunner: QueryRunner): Promise<void> {
    await queryRunner.query(
      'CREATE TABLE "tokens" ("id" SERIAL NOT NULL, "quantity" bigint NOT NULL, "asset_id" character varying NOT NULL, "output_id" integer NOT NULL, CONSTRAINT "PK_tokens_id" PRIMARY KEY ("id"))'
    );
    await queryRunner.query(
      'ALTER TABLE "tokens" ADD CONSTRAINT "FK_tokens_asset_id" FOREIGN KEY ("asset_id") REFERENCES "asset"("id") ON DELETE CASCADE ON UPDATE NO ACTION'
    );
    await queryRunner.query(
      'ALTER TABLE "tokens" ADD CONSTRAINT "FK_tokens_output_id" FOREIGN KEY ("output_id") REFERENCES "output"("id") ON DELETE CASCADE ON UPDATE NO ACTION'
    );
  }
 
  async down(queryRunner: QueryRunner): Promise<void> {
    await queryRunner.query('ALTER TABLE "tokens" DROP CONSTRAINT "FK_tokens_output_id"');
    await queryRunner.query('ALTER TABLE "tokens" DROP CONSTRAINT "FK_tokens_asset_id"');
    await queryRunner.query('DROP TABLE "tokens"');
  }
}