import type { MigrationInterface, QueryRunner } from 'typeorm'

export class FixMigrations1683791266417 implements MigrationInterface {
  name = 'FixMigrations1683791266417'

  public async up (queryRunner: QueryRunner): Promise<void> {
    await queryRunner.query('ALTER TABLE "benefit_code_schema" ALTER COLUMN "values" TYPE numeric(11,4) array')
  }

  public async down (queryRunner: QueryRunner): Promise<void> {
    await queryRunner.query('ALTER TABLE "benefit_code_schema" ALTER COLUMN "values" TYPE numeric array')
  }
}

// test/github-issues/10043/entity/Receipt.ts

import { Column, Entity, PrimaryGeneratedColumn } from '../../../../src';

@Entity()
export class Receipt {
  @PrimaryGeneratedColumn()
  id: number

  @Column({ type: 'numeric', precision: 11, scale: 4, array: true })
  values: number[]
}

// test/github-issues/10043/issue-10043.ts

import "reflect-metadata";
import { createTestingConnections, closeTestingConnections, reloadTestingDatabases } from "../../utils/test-utils";
import { DataSource } from "../../../src/data-source/DataSource"

describe.only("github issues > #10043 Numeric array column type creates migration repeatedly", () => {

    let dataSources: DataSource[];
    before(async () => dataSources = await createTestingConnections({
        entities: [__dirname + "/entity/*{.js,.ts}"],
        schemaCreate: true,
        dropSchema: true,
    }));
    beforeEach(() => reloadTestingDatabases(dataSources));
    after(() => closeTestingConnections(dataSources));

    it("can recognize model changes", () => Promise.all(dataSources.map(async dataSource => {
      if (dataSource.driver.options.type !== "postgres") {
        return;
      }
      const sqlInMemory = await dataSource.driver.createSchemaBuilder().log();
      sqlInMemory.upQueries.length.should.be.greaterThan(0);
      sqlInMemory.downQueries.length.should.be.greaterThan(0);
    })));

    it("does not generate when no model changes", () => Promise.all(dataSources.map(async dataSource => {
      if (dataSource.driver.options.type !== "postgres") {
        return;
      }
      await dataSource.driver.createSchemaBuilder().build();

      const sqlInMemory = await dataSource.driver.createSchemaBuilder().log();

      sqlInMemory.upQueries.length.should.be.equal(0);
      sqlInMemory.downQueries.length.should.be.equal(0);
    })));
});