import {
  Entity,
  ManyToOne,
  MikroORM,
  PrimaryKey,
  Property,
  SqliteDriver,
} from '@mikro-orm/sqlite';


@Entity()
class Metadata {

  @PrimaryKey()
  id!: number;

  @Property()
  createdAt!: Date;

}

@Entity()
class Book {

  @PrimaryKey()
  id!: number;

  @ManyToOne({
    entity: () => Metadata,
  })
  metadata!: Metadata;

}

let orm: MikroORM;

beforeAll(async () => {
  orm = await MikroORM.init({
    entities: [Metadata, Book],
    dbName: ':memory:',
    driver: SqliteDriver,
  });
  await orm.schema.refreshDatabase();
  for (let i = 0; i < 20; ++i) {
    const book = new Book();
    const metadata = new Metadata();
    book.metadata = metadata;
    const date = new Date('2024-01-01 00:00:00');
    date.setDate(date.getDate() + i);
    metadata.createdAt = date;
    orm.em.persist([book, metadata]);
  }
  await orm.em.flush();
  orm.em.clear();
});

afterAll(async () => {
  await orm.close(true);
});

test(`TypeError: Cannot read properties of null (reading 'metadata')`, async () => {
  await orm.em.findByCursor(Book, {}, {
    first: 5,
    after: {
      id: 16,
    },
    orderBy: {
      metadata: {
        createdAt: 'desc',
      },
    },
    populate: [
      'metadata',
    ],
  });
});