import "reflect-metadata";
import {closeTestingConnections, createTestingConnections, reloadTestingDatabases} from "../../utils/test-utils";
import {Connection} from "../../../src/connection/Connection";
import {expect} from "chai";
import {User} from "./entity/user";

describe("github issues > #953 MySQL 5.7 JSON column parse", () => {

    let connections: Connection[];
    before(async () => connections = await createTestingConnections({
        entities: [__dirname + "/entity/*{.js,.ts}"],
        enabledDrivers: ["mysql"],
    }));
    beforeEach(() => reloadTestingDatabases(connections));
    after(() => closeTestingConnections(connections));

    it("should retrieve record from mysql5.7 using driver mysql2", () => Promise.all(connections.map(async connection => {
        const repo = connection.getRepository(User);
        let user = repo.create({
            username: "admin",
            password: "admin",
            roles: ["ADMIN"],
            lastLoginAt: new Date()
        });
        await repo.save(user);

        let user1 = await repo.findOne({username: "admin"});
        expect(user1).has.property("roles").with.is.an("array").and.contains("ADMIN");
    })));

});