import "reflect-metadata"
import { DataSource } from "../../../src/data-source/DataSource"
import {
    closeTestingConnections,
    createTestingConnections,
} from "../../utils/test-utils"
import { ColumnMetadata } from "../../../src/metadata/ColumnMetadata"
import { ColumnMetadataArgs } from "../../../src/metadata-args/ColumnMetadataArgs"
import { User } from "./entity/User"

describe("github issues > #1623 NOT NULL constraint failed after a new column is added (SQLite)", () => {
    let connections: DataSource[]
    before(async () => {
        connections = await createTestingConnections({
            entities: [__dirname + "/entity/*{.js,.ts}"],
            schemaCreate: true,
            dropSchema: true,
        })
    })
    after(() => closeTestingConnections(connections))

    it("should correctly add new column", () =>
        Promise.all(
            connections.map(async (connection) => {
                // Spanner does not support adding new NOT NULL column to existing table
                if (connection.driver.options.type === "spanner") return

                const userMetadata = connection.getMetadata(User)
                const columnMetadata = new ColumnMetadata({
                    connection: connection,
                    entityMetadata: userMetadata,
                    args: <ColumnMetadataArgs>{
                        target: User,
                        propertyName: "userName",
                        mode: "regular",
                        options: {
                            type: "varchar",
                            name: "userName",
                        },
                    },
                })
                columnMetadata.build(connection)

                userMetadata.columns.push(columnMetadata)

                await connection.synchronize()

                const queryRunner = connection.createQueryRunner()
                const table = await queryRunner.getTable("user")
                const column1 = table!.findColumnByName("userName")!
                await queryRunner.release()

                column1.should.be.exist
            }),
        ))
})