(async () => {

    @Entity({
        schema: 'accounting',
        tableName: 'account'
    })
    class Account {
        constructor(iban: string) {
            this.iban = iban;
        }

        @PrimaryKey({
            nullable: true
        })
        id: string;

        @Property()
        iban!: string;

        @ManyToMany({ entity: () => Customer, mappedBy: (c: Customer) => c.accounts })
        customers: Collection<Customer> = new Collection<Customer>(this);

        @ManyToMany({ entity: () => Company, mappedBy: (c: Company) => c.accounts })
        companies: Collection<Company> = new Collection<Company>(this);
    }

    @Entity({
        schema: 'accounting',
        tableName: 'customer'
    })
    class Customer {
        @PrimaryKey({
            nullable: true
        })
        id: string;

        @Property()
        name!: string;

        @ManyToMany({
            entity: () => Account,
            pivotTable: 'accounting.customer_account',
            joinColumn: 'customer_id',
            inverseJoinColumn: 'account_id'
        })
        accounts: Collection<Account> = new Collection<Account>(this)
    }

    @Entity({
        schema: 'accounting',
        tableName: 'company'
    })
    class Company {
        @PrimaryKey({
            nullable: true
        })
        id: string;

        @Property()
        name!: string;

        @ManyToMany({
            entity: () => Account,
            pivotTable: 'accounting.company_account',
            joinColumn: 'company_id',
            inverseJoinColumn: 'account_id'
        })
        accounts: Collection<Account> = new Collection<Account>(this);
    }

    let orm: MikroORM<PostgreSqlDriver>;
    try {
        orm = await MikroORM.init({
            entities: [Account, Customer, Company],
            dbName: 'mikro-test',
            type: 'postgresql',
            host: '192.168.2.12',
            port: 5432,
            user: 'postgres',
            password: 'whatever',
            debug: true,
            metadataProvider: ReflectMetadataProvider
        });

        const em = orm.em.fork();

        const customer = new Customer();
        customer.name = 'Customer 1';
        customer.accounts.add(new Account('AAA-AAA-AAA'), new Account('BBB-BBB-BBB'));
        em.persist(customer);

        const company = new Company();
        company.name = 'Company 1';
        company.accounts.add(new Account('CCC-CCC-CCC'));
        em.persist(company);

        await em.commit();

        // I want to find all accounts from company 1
        const em2 = orm.em.fork();

        const companyAccounts = await em2.find(
            Account,
            {
                companies: {name: 'Company 1'}
            }
        );
        console.log(companyAccounts);
    } catch (e) {
        console.error(e);
    } finally {
        await orm.close();
    }
})();