Minimal reproduction: MikroORM 7.1.5 metadata cache ID collision

README.md

MikroORM metadata cache ID collision repro

This is a database-free reproduction for MikroORM 7.1.5. It starts three independent Node.js processes against one metadata cache directory:

1. Discover and cache Alpha only.
2. Discover and cache Beta only.
3. Discover both entities and build the target schema from the two cache files.

Each seeding process starts the process-local EntityMetadata counter at zero, so both cache files persist _id: 0.

pnpm install
pnpm repro

The command exits with status 1. The final process reports duplicate metadata IDs and only one target table:

{
  "ids": [
    { "className": "Beta", "collection": "beta", "id": 0 },
    { "className": "Alpha", "collection": "alpha", "id": 0 }
  ],
  "tables": ["alpha"]
}

No PostgreSQL server is required because the ORM uses connect: false.

The minimal workaround is to keep the freshly allocated process-local ID when cached metadata is loaded:

 loadFromCache(meta, cache) {
+  Reflect.deleteProperty(cache, '_id');
   // existing cache merge logic
 }

With that workaround, the final process has distinct IDs and target tables alpha and beta. It demonstrates where the bad value enters the runtime, but does not prescribe the final cache/runtime metadata design.

alpha.entity.ts

import { Entity, PrimaryKey } from '@mikro-orm/decorators/es';

@Entity({ tableName: 'alpha' })
export class Alpha {
  @PrimaryKey({ type: Number })
  id!: number;
}

beta.entity.ts

import { Entity, PrimaryKey } from '@mikro-orm/decorators/es';

@Entity({ tableName: 'beta' })
export class Beta {
  @PrimaryKey({ type: Number })
  id!: number;
}

orm-options.ts

import { resolve } from 'node:path';
import type { EntityClass } from '@mikro-orm/core';
import { defineConfig } from '@mikro-orm/postgresql';
import { TsMorphMetadataProvider } from '@mikro-orm/reflection';

export function createOptions(entities: EntityClass[]) {
  return defineConfig({
    entities,
    dbName: 'metadata-cache-repro',
    connect: false,
    metadataProvider: TsMorphMetadataProvider,
    metadataCache: {
      enabled: true,
      options: {
        cacheDir: resolve('.cache'),
      },
    },
  });
}

package.json

{
  "name": "mikro-orm-cache-id-repro",
  "private": true,
  "type": "module",
  "scripts": {
    "repro": "rm -rf .cache && tsx seed-alpha.ts && tsx seed-beta.ts && tsx verify.ts"
  },
  "dependencies": {
    "@mikro-orm/core": "7.1.5",
    "@mikro-orm/decorators": "7.1.5",
    "@mikro-orm/postgresql": "7.1.5",
    "@mikro-orm/reflection": "7.1.5",
    "reflect-metadata": "0.2.2",
    "tsx": "4.23.0",
    "typescript": "6.0.3"
  }
}

pnpm-lock.yaml

lockfileVersion: '9.0'

settings:
  autoInstallPeers: true
  excludeLinksFromLockfile: false

importers:

  .:
    dependencies:
      '@mikro-orm/core':
        specifier: 7.1.5
        version: 7.1.5
      '@mikro-orm/decorators':
        specifier: 7.1.5
        version: 7.1.5(@mikro-orm/core@7.1.5)(reflect-metadata@0.2.2)
      '@mikro-orm/postgresql':
        specifier: 7.1.5
        version: 7.1.5(@mikro-orm/core@7.1.5)
      '@mikro-orm/reflection':
        specifier: 7.1.5
        version: 7.1.5(@mikro-orm/core@7.1.5)
      reflect-metadata:
        specifier: 0.2.2
        version: 0.2.2
      tsx:
        specifier: 4.23.0
        version: 4.23.0
      typescript:
        specifier: 6.0.3
        version: 6.0.3

packages:

  '@esbuild/aix-ppc64@0.28.1':
    resolution: {integrity: sha512-Svl7tq8k/08+p6CXPpRjQ1fKX+1odH/BQbb48fV6fj3CWHhsoIOoY87w1oHXm0qEpkIK3ZfVgp0hed3XBXzXMQ==}
    engines: {node: '>=18'}
    cpu: [ppc64]
    os: [aix]

  '@esbuild/android-arm64@0.28.1':
    resolution: {integrity: sha512-34EGEbCIAgosYz6goLcopX6Mo7NyGv9tfwEM2/7Ce2VcVRk568iSvniGWcUXIy7wEDR1wzolcxcriFVrWYcwBg==}
    engines: {node: '>=18'}
    cpu: [arm64]
    os: [android]

  '@esbuild/android-arm@0.28.1':
    resolution: {integrity: sha512-0k2F129Xdio1TdJfzJ8sy1Q47vUD2NnwdhiAf7drUN1EBTfPf4hsFCtmMgu/6m8JSzsBrlmVjudMBQqOfG8usQ==}
    engines: {node: '>=18'}
    cpu: [arm]
    os: [android]

  '@esbuild/android-x64@0.28.1':
    resolution: {integrity: sha512-dbwY7ltSMDWsRatcRpCnES4F+im88OCUgGZjy52shC7GqHRE/cYlxNbB4Z4UpJswpcc4Qxd2oE/ufM0p61IKng==}
    engines: {node: '>=18'}
    cpu: [x64]
    os: [android]

  '@esbuild/darwin-arm64@0.28.1':
    resolution: {integrity: sha512-TZbWkQY7kvTAXbXUT7uVACR5cMHsDiSz9z7ZKAX/RTq/WJEk3QyRr0wZpNhBDX+/0CtdqUIJlOiodQcta6tY3Q==}
    engines: {node: '>=18'}
    cpu: [arm64]
    os: [darwin]

  '@esbuild/darwin-x64@0.28.1':
    resolution: {integrity: sha512-zfdzgK9ACBNZLI/CyHTOx81SyNbM6YXn7rxSgX97VjyiPl9W1i4Ka4fgKECEoFCKGpvBj5qArWIGgQjOwkgskQ==}
    engines: {node: '>=18'}
    cpu: [x64]
    os: [darwin]

  '@esbuild/freebsd-arm64@0.28.1':
    resolution: {integrity: sha512-wG2EA8ENdEI0qhkSZMjfqrdY+ziCYCPMmtZjjIwOmXFjmyzEHn+UUxk5of+SYsjtfs3VpnlC7QLzSI5hY/rOAw==}
    engines: {node: '>=18'}
    cpu: [arm64]
    os: [freebsd]

  '@esbuild/freebsd-x64@0.28.1':
    resolution: {integrity: sha512-i7dZ9vQgnvSCzi/rYCXNgtF/U+eKZNJBzu3eTQbRgHnM7tNSizLOkRFAl3qzVc/Op/u5YkHHa4pf/3DOYHthLQ==}
    engines: {node: '>=18'}
    cpu: [x64]
    os: [freebsd]

  '@esbuild/linux-arm64@0.28.1':
    resolution: {integrity: sha512-yHs+0uc8+nvEAfAfxrWQKK5peSNzBc4PegcMO0EJ2hT71uA7vB8Ihg2e77R2P7SG5uYjPbHlLLmve4LLLRCf0g==}
    engines: {node: '>=18'}
    cpu: [arm64]
    os: [linux]

  '@esbuild/linux-arm@0.28.1':
    resolution: {integrity: sha512-qVXBOHQS+d5Y722GwJzJUtOLlX7km3CraOaGormF1pDtPd2C/l1SHRPgjLunLGe51Sh5YYWKMFDyV4SxgMQYTQ==}
    engines: {node: '>=18'}
    cpu: [arm]
    os: [linux]

  '@esbuild/linux-ia32@0.28.1':
    resolution: {integrity: sha512-d1z4ZuP0ajrfz/FhGT4vv278rX8KnPPJx8i5+AtK7TYbx9Le9F1hyzurZpkEyjkGa9dUGhQow4C1NmeGvqxN2w==}
    engines: {node: '>=18'}
    cpu: [ia32]
    os: [linux]

  '@esbuild/linux-loong64@0.28.1':
    resolution: {integrity: sha512-M5sRjUVZrkm1OAPR3dlOYzNmN+loZKGVi1VUQGrwuqLcbR6qeAz+famMhjASeH3YVKvZz+zT1jlh/keC3Rj/lg==}
    engines: {node: '>=18'}
    cpu: [loong64]
    os: [linux]

  '@esbuild/linux-mips64el@0.28.1':
    resolution: {integrity: sha512-mRObBZeHh2OxcBFPWE/FjylkRgZdYuiTR3vaTozquCGOH14iP9oN4x4Ge81CoIDYQrXmIxpFumJBu5MtZpnQJQ==}
    engines: {node: '>=18'}
    cpu: [mips64el]
    os: [linux]

  '@esbuild/linux-ppc64@0.28.1':
    resolution: {integrity: sha512-slScBsMAb3GFDcdrCgLwZtPYRoH2H/youv10QiZyRjmsP48fznoveWytSgCI/R0ZcUgpc0ZhIUEx6LHts8yrfQ==}
    engines: {node: '>=18'}
    cpu: [ppc64]
    os: [linux]

  '@esbuild/linux-riscv64@0.28.1':
    resolution: {integrity: sha512-kw0owk1o0GFETUJyW0jc0G4Yzs0BHZn0JDZ8JRT088vjJYX777BAs1fDGxAC+q831qOs2DTC96mNsG2opdfyyQ==}
    engines: {node: '>=18'}
    cpu: [riscv64]
    os: [linux]

  '@esbuild/linux-s390x@0.28.1':
    resolution: {integrity: sha512-/lAIjX8aYFRByhh6L5rYtPEDRqa9de/4V/juOXcta5frjvzXO4/sqEtyytse0g3zZFuWu5cDN0MkLz2qRDD2Ag==}
    engines: {node: '>=18'}
    cpu: [s390x]
    os: [linux]

  '@esbuild/linux-x64@0.28.1':
    resolution: {integrity: sha512-u/anNYF2mmVOEDwLtnQ1wOr3EZ9sTNGLWrsYGYwHWzGA3Si84IOkHXlbWTD1NB+9/1lcnweYKO54uhxZydNzfA==}
    engines: {node: '>=18'}
    cpu: [x64]
    os: [linux]

  '@esbuild/netbsd-arm64@0.28.1':
    resolution: {integrity: sha512-oks0DYbLwWMmaakTsCb+zL4E+aHRVLom9IJZOAthMQEPiQmydXHkziYEsGYRx0uNV/IjEKGAV941JzH02pflqw==}
    engines: {node: '>=18'}
    cpu: [arm64]
    os: [netbsd]

  '@esbuild/netbsd-x64@0.28.1':
    resolution: {integrity: sha512-aeL6lAnN89Hz43Mlh1G8ARasbuoYvSITDEx0tHh5b7jJnHcssqgjy9Yx430GDpmCa6OyrKoS0aNRjKundRizGg==}
    engines: {node: '>=18'}
    cpu: [x64]
    os: [netbsd]

  '@esbuild/openbsd-arm64@0.28.1':
    resolution: {integrity: sha512-MEFJe5C3R8pwXdZ5Y21oo6m7ePiS0d9pWucn99O/wvyJZChoIQKrQDxKrGeW8F5+T0okTHesAmDeiHDTIq0V/Q==}
    engines: {node: '>=18'}
    cpu: [arm64]
    os: [openbsd]

  '@esbuild/openbsd-x64@0.28.1':
    resolution: {integrity: sha512-i/ZLIOafE0Z8cI/XANJAixoJL/uRAoS2xOA3rb0xN+KK0K177cMAsQYkzHtBrtMXAKuAc7HGgcWiZ/sRC1Nxgw==}
    engines: {node: '>=18'}
    cpu: [x64]
    os: [openbsd]

  '@esbuild/openharmony-arm64@0.28.1':
    resolution: {integrity: sha512-ge+Z7EXFNt2BO1oAMsVpiQ8EwndV9i1xXerAeTIK7AtPs3bKFXQM7nlRxDSIUIMeueR1CNXxqztLzdNeReKBJg==}
    engines: {node: '>=18'}
    cpu: [arm64]
    os: [openharmony]

  '@esbuild/sunos-x64@0.28.1':
    resolution: {integrity: sha512-BEjgtECkL3vY+SaSQ6nzVfiALUeFxpawyp8Jmf5PtYhf1Ug40N1h/hxlhts+f1FvSvarEigdxS3BlSMI2PJLcQ==}
    engines: {node: '>=18'}
    cpu: [x64]
    os: [sunos]

  '@esbuild/win32-arm64@0.28.1':
    resolution: {integrity: sha512-lCv9eK/H6ZJWbE7bh2nw54CZ9M2nupBxJcTsdk/QQnWkdSjKGuxmmH8/GWrlT1eMmZfn4dGcCjRte397WqfQXA==}
    engines: {node: '>=18'}
    cpu: [arm64]
    os: [win32]

  '@esbuild/win32-ia32@0.28.1':
    resolution: {integrity: sha512-zvb/mB2bSCoJOpoCBgYKKpX6YM6mJBlBUVUtVj41DlZJVEB6/0CKlRYxP5wWl1C1ILiCoAU5wZZ4q1P3qeS6Eg==}
    engines: {node: '>=18'}
    cpu: [ia32]
    os: [win32]

  '@esbuild/win32-x64@0.28.1':
    resolution: {integrity: sha512-bm4Mowrv+GXMlpWX++EcXw/iLyd1o3+bJkC2DkWXYVvgZCqD/bSj9ctZeAMC3cIxgjRVR2Dufaiu4YPxr5gW1A==}
    engines: {node: '>=18'}
    cpu: [x64]
    os: [win32]

  '@mikro-orm/core@7.1.5':
    resolution: {integrity: sha512-jYsR65PcFF+YKUlg/qytjP0PTyk558JvTKI1GzD6Vy/nshTkbcqMN5fDm2d5GJuxliPk0C8+M8tDn3GXeCAqow==}
    engines: {node: '>= 22.17.0'}
    peerDependencies:
      dataloader: 2.2.3
    peerDependenciesMeta:
      dataloader:
        optional: true

  '@mikro-orm/decorators@7.1.5':
    resolution: {integrity: sha512-CwK2n8hopvBmGJTKvb7P5iNYqEXln21AUUNUJG6BvS084V6lAB5PeluB2nCP2IomUcGaZZ80jbdg90hlOvprIg==}
    engines: {node: '>= 22.17.0'}
    peerDependencies:
      '@mikro-orm/core': 7.1.5
      reflect-metadata: ^0.1.0 || ^0.2.0
    peerDependenciesMeta:
      reflect-metadata:
        optional: true

  '@mikro-orm/postgresql@7.1.5':
    resolution: {integrity: sha512-UB57u6Pxgc5XIM+KdP9nYMDG3I7lPWBuFAGzLDwcSfvOJW1vvVM3J2Lqcj5Mv2V6ZPpqD9iQcE8kv0IpHfZwCw==}
    engines: {node: '>= 22.17.0'}
    peerDependencies:
      '@mikro-orm/core': 7.1.5

  '@mikro-orm/reflection@7.1.5':
    resolution: {integrity: sha512-9FuBPK2+uRW9gG0ZEJ3XGEvTEb+KJOGk+KIlr9sHWUM8YpFIBr+6ZND3upU0L5HyT4cqRWkcZYtayOxHUB2oLg==}
    engines: {node: '>= 22.17.0'}
    peerDependencies:
      '@mikro-orm/core': 7.1.5

  '@mikro-orm/sql@7.1.5':
    resolution: {integrity: sha512-WeiyjzVrxx2WHafCFmhbfbNphPSXqN9+7USet6iNcc9EzKqN0ULPvQd555m+5Nh0tmkX151FwPMLm9/a2wG0ng==}
    engines: {node: '>= 22.17.0'}
    peerDependencies:
      '@mikro-orm/core': 7.1.5

  '@ts-morph/common@0.29.0':
    resolution: {integrity: sha512-35oUmphHbJvQ/+UTwFNme/t2p3FoKiGJ5auTjjpNTop2dyREspirjMy82PLSC1pnDJ8ah1GU98hwpVt64YXQsg==}

  balanced-match@4.0.4:
    resolution: {integrity: sha512-BLrgEcRTwX2o6gGxGOCNyMvGSp35YofuYzw9h1IMTRmKqttAZZVU67bdb9Pr2vUHA8+j3i2tJfjO6C6+4myGTA==}
    engines: {node: 18 || 20 || >=22}

  brace-expansion@5.0.7:
    resolution: {integrity: sha512-7oFy703dxfY3/NLxC1fh2SUCQ0H9rmAY+5EpDVfXjUTTs+HEwR2nYaqLv+GWcTsumwxPfiz6CzCNkwXwBUwqCA==}
    engines: {node: 18 || 20 || >=22}

  code-block-writer@13.0.3:
    resolution: {integrity: sha512-Oofo0pq3IKnsFtuHqSF7TqBfr71aeyZDVJ0HpmqB7FBM2qEigL0iPONSCZSO9pE9dZTAxANe5XHG9Uy0YMv8cg==}

  esbuild@0.28.1:
    resolution: {integrity: sha512-HrJrvZv5ayxBzPfwphOoNzkzOIIlifzk0KJrGK2c8R4+LKpMtpYLQeUdjnwjWv/LZlkH2laZk+4w78pi99D4Vw==}
    engines: {node: '>=18'}
    hasBin: true

  fdir@6.5.0:
    resolution: {integrity: sha512-tIbYtZbucOs0BRGqPJkshJUYdL+SDH7dVM8gjy+ERp3WAUjLEFJE+02kanyHtwjWOnwrKYBiwAmM0p4kLJAnXg==}
    engines: {node: '>=12.0.0'}
    peerDependencies:
      picomatch: ^3 || ^4
    peerDependenciesMeta:
      picomatch:
        optional: true

  fsevents@2.3.3:
    resolution: {integrity: sha512-5xoDfX+fL7faATnagmWPpbFtwh/R77WmMMqqHGS65C3vvB0YHrgF+B1YmZ3441tMj5n63k0212XNoJwzlhffQw==}
    engines: {node: ^8.16.0 || ^10.6.0 || >=11.0.0}
    os: [darwin]

  kysely@0.29.2:
    resolution: {integrity: sha512-s6WVJyEZrbm6jhBpiKHsGHyePMrVQKJ85wZCFCr9W4QHv6WTjWIrdvTmO9hDEA3bNK0xkrE2DqrHsXMLWuZpQg==}
    engines: {node: '>=22.0.0'}

  minimatch@10.2.5:
    resolution: {integrity: sha512-MULkVLfKGYDFYejP07QOurDLLQpcjk7Fw+7jXS2R2czRQzR56yHRveU5NDJEOviH+hETZKSkIk5c+T23GjFUMg==}
    engines: {node: 18 || 20 || >=22}

  path-browserify@1.0.1:
    resolution: {integrity: sha512-b7uo2UCUOYZcnF/3ID0lulOJi/bafxa1xPe7ZPsammBSpjSWQkjNxlt635YGS2MiR9GjvuXCtz2emr3jbsz98g==}

  pg-cloudflare@1.4.0:
    resolution: {integrity: sha512-Vo7z/6rrQYxpNRylp4Tlob2elzbh+N/MOQbxFVWCxS7oEx6jF53GTJFxK2WWpKuBRkmiin4Mt+xofFDjx09R0A==}

  pg-connection-string@2.14.0:
    resolution: {integrity: sha512-XwWDGcLRGCXAR8F/AM5bG7Q+A3Wm2s6QeEjlOKZLlH3UYcguiqCWKyWXVag5TLTIjR7oOJUY8kcADaZgWPyLeg==}

  pg-cursor@2.20.0:
    resolution: {integrity: sha512-HP/EbUafheaUOs7DxlG6tda/rhmsX2hCTJJJ+gCnhljGyNEs6pBHddbNuomlW3DqEhP3zYD+GqBWkYnJPIZ4tA==}
    peerDependencies:
      pg: ^8

  pg-int8@1.0.1:
    resolution: {integrity: sha512-WCtabS6t3c8SkpDBUlb1kjOs7l66xsGdKpIPZsg4wR+B3+u9UAum2odSsF9tnvxg80h4ZxLWMy4pRjOsFIqQpw==}
    engines: {node: '>=4.0.0'}

  pg-pool@3.14.0:
    resolution: {integrity: sha512-gKtPkFdQPU3DksooVLi9LsjZxrsBUZIpa+7aVx+LV5pNh0KzP4Zleud2po+ConrxbuXGBJ6Hfer6hdgpIBpBaw==}
    peerDependencies:
      pg: '>=8.0'

  pg-protocol@1.15.0:
    resolution: {integrity: sha512-cq9sECI5s0+uPUXjbz8ioyPJni6RzsRib0US67i5IoTZKw8fNeYlVE7u8F4dG7vEJJtc5wdD1K189lCCUwqWTQ==}

  pg-types@2.2.0:
    resolution: {integrity: sha512-qTAAlrEsl8s4OiEQY69wDvcMIdQN6wdz5ojQiOy6YRMuynxenON0O5oCpJI6lshc6scgAY8qvJ2On/p+CXY0GA==}
    engines: {node: '>=4'}

  pg@8.21.0:
    resolution: {integrity: sha512-AUP1EYJuHraQGsVoCQVIcM7TEJVGtDzxWtGFZd8rds9d+CCXlU5Js1rYgfLNvxy9iJrpHjGrRjoi/3BT9fRyiA==}
    engines: {node: '>= 16.0.0'}
    peerDependencies:
      pg-native: '>=3.0.1'
    peerDependenciesMeta:
      pg-native:
        optional: true

  pgpass@1.0.5:
    resolution: {integrity: sha512-FdW9r/jQZhSeohs1Z3sI1yxFQNFvMcnmfuj4WBMUTxOrAyLMaTcE1aAMBiTlbMNaXvBCQuVi0R7hd8udDSP7ug==}

  picomatch@4.0.5:
    resolution: {integrity: sha512-RvwwcruNjI1ncT5xRakeyS9Lf8lcItv34KD+aif+VH9kduAyfYBipGh12274xtenIPZ119/R9BdTBa8gAwSh0A==}
    engines: {node: '>=12'}

  postgres-array@2.0.0:
    resolution: {integrity: sha512-VpZrUqU5A69eQyW2c5CA1jtLecCsN2U/bD6VilrFDWq5+5UIEVO7nazS3TEcHf1zuPYO/sqGvUvW62g86RXZuA==}
    engines: {node: '>=4'}

  postgres-array@3.0.4:
    resolution: {integrity: sha512-nAUSGfSDGOaOAEGwqsRY27GPOea7CNipJPOA7lPbdEpx5Kg3qzdP0AaWC5MlhTWV9s4hFX39nomVZ+C4tnGOJQ==}
    engines: {node: '>=12'}

  postgres-bytea@1.0.1:
    resolution: {integrity: sha512-5+5HqXnsZPE65IJZSMkZtURARZelel2oXUEO8rH83VS/hxH5vv1uHquPg5wZs8yMAfdv971IU+kcPUczi7NVBQ==}
    engines: {node: '>=0.10.0'}

  postgres-date@1.0.7:
    resolution: {integrity: sha512-suDmjLVQg78nMK2UZ454hAG+OAW+HQPZ6n++TNDUX+L0+uUlLywnoxJKDou51Zm+zTCjrCl0Nq6J9C5hP9vK/Q==}
    engines: {node: '>=0.10.0'}

  postgres-date@2.1.0:
    resolution: {integrity: sha512-K7Juri8gtgXVcDfZttFKVmhglp7epKb1K4pgrkLxehjqkrgPhfG6OO8LHLkfaqkbpjNRnra018XwAr1yQFWGcA==}
    engines: {node: '>=12'}

  postgres-interval@1.2.0:
    resolution: {integrity: sha512-9ZhXKM/rw350N1ovuWHbGxnGh/SNJ4cnxHiM0rxE4VN41wsg8P8zWn9hv/buK00RP4WvlOyr/RBDiptyxVbkZQ==}
    engines: {node: '>=0.10.0'}

  postgres-interval@4.0.2:
    resolution: {integrity: sha512-EMsphSQ1YkQqKZL2cuG0zHkmjCCzQqQ71l2GXITqRwjhRleCdv00bDk/ktaSi0LnlaPzAc3535KTrjXsTdtx7A==}
    engines: {node: '>=12'}

  reflect-metadata@0.2.2:
    resolution: {integrity: sha512-urBwgfrvVP/eAyXx4hluJivBKzuEbSQs9rKWCrCkbSxNv8mxPcUZKeuoF3Uy4mJl3Lwprp6yy5/39VWigZ4K6Q==}

  split2@4.2.0:
    resolution: {integrity: sha512-UcjcJOWknrNkF6PLX83qcHM6KHgVKNkV62Y8a5uYDVv9ydGQVwAHMKqHdJje1VTWpljG0WYpCDhrCdAOYH4TWg==}
    engines: {node: '>= 10.x'}

  tinyglobby@0.2.17:
    resolution: {integrity: sha512-wXR/dYpcqKmfWpEdZjiKJOwCNFndD0DMnrW/cYjVGttEkBfVgcLFHoNrlj47mjOVic9yyNu65alsgF4NQyTa2g==}
    engines: {node: '>=12.0.0'}

  ts-morph@28.0.0:
    resolution: {integrity: sha512-Wp3tnZ2bzwxyTZMtgWVzXDfm7lB1Drz+y9DmmYH/L702PQhPyVrp3pkou3yIz4qjS14GY9kcpmLiOOMvl8oG1g==}

  tsx@4.23.0:
    resolution: {integrity: sha512-eUdUIaCr963q2h5u3+QwvYp0+eqPvn+egeqZUm0hwERCqqx1E3kK5ehbGCvqSE5MQAULr67ww0cA3jKc3YkM1w==}
    engines: {node: '>=18.0.0'}
    hasBin: true

  typescript@6.0.3:
    resolution: {integrity: sha512-y2TvuxSZPDyQakkFRPZHKFm+KKVqIisdg9/CZwm9ftvKXLP8NRWj38/ODjNbr43SsoXqNuAisEf1GdCxqWcdBw==}
    engines: {node: '>=14.17'}
    hasBin: true

  xtend@4.0.2:
    resolution: {integrity: sha512-LKYU1iAXJXUgAXn9URjiu+MWhyUXHsvfp7mcuYm9dSUKK0/CjtrUwFAxD82/mCWbtLsGjFIad0wIsod4zrTAEQ==}
    engines: {node: '>=0.4'}

snapshots:

  '@esbuild/aix-ppc64@0.28.1':
    optional: true

  '@esbuild/android-arm64@0.28.1':
    optional: true

  '@esbuild/android-arm@0.28.1':
    optional: true

  '@esbuild/android-x64@0.28.1':
    optional: true

  '@esbuild/darwin-arm64@0.28.1':
    optional: true

  '@esbuild/darwin-x64@0.28.1':
    optional: true

  '@esbuild/freebsd-arm64@0.28.1':
    optional: true

  '@esbuild/freebsd-x64@0.28.1':
    optional: true

  '@esbuild/linux-arm64@0.28.1':
    optional: true

  '@esbuild/linux-arm@0.28.1':
    optional: true

  '@esbuild/linux-ia32@0.28.1':
    optional: true

  '@esbuild/linux-loong64@0.28.1':
    optional: true

  '@esbuild/linux-mips64el@0.28.1':
    optional: true

  '@esbuild/linux-ppc64@0.28.1':
    optional: true

  '@esbuild/linux-riscv64@0.28.1':
    optional: true

  '@esbuild/linux-s390x@0.28.1':
    optional: true

  '@esbuild/linux-x64@0.28.1':
    optional: true

  '@esbuild/netbsd-arm64@0.28.1':
    optional: true

  '@esbuild/netbsd-x64@0.28.1':
    optional: true

  '@esbuild/openbsd-arm64@0.28.1':
    optional: true

  '@esbuild/openbsd-x64@0.28.1':
    optional: true

  '@esbuild/openharmony-arm64@0.28.1':
    optional: true

  '@esbuild/sunos-x64@0.28.1':
    optional: true

  '@esbuild/win32-arm64@0.28.1':
    optional: true

  '@esbuild/win32-ia32@0.28.1':
    optional: true

  '@esbuild/win32-x64@0.28.1':
    optional: true

  '@mikro-orm/core@7.1.5': {}

  '@mikro-orm/decorators@7.1.5(@mikro-orm/core@7.1.5)(reflect-metadata@0.2.2)':
    dependencies:
      '@mikro-orm/core': 7.1.5
    optionalDependencies:
      reflect-metadata: 0.2.2

  '@mikro-orm/postgresql@7.1.5(@mikro-orm/core@7.1.5)':
    dependencies:
      '@mikro-orm/core': 7.1.5
      '@mikro-orm/sql': 7.1.5(@mikro-orm/core@7.1.5)
      kysely: 0.29.2
      pg: 8.21.0
      pg-cursor: 2.20.0(pg@8.21.0)
      postgres-array: 3.0.4
      postgres-date: 2.1.0
      postgres-interval: 4.0.2
    transitivePeerDependencies:
      - pg-native

  '@mikro-orm/reflection@7.1.5(@mikro-orm/core@7.1.5)':
    dependencies:
      '@mikro-orm/core': 7.1.5
      ts-morph: 28.0.0

  '@mikro-orm/sql@7.1.5(@mikro-orm/core@7.1.5)':
    dependencies:
      '@mikro-orm/core': 7.1.5
      kysely: 0.29.2

  '@ts-morph/common@0.29.0':
    dependencies:
      minimatch: 10.2.5
      path-browserify: 1.0.1
      tinyglobby: 0.2.17

  balanced-match@4.0.4: {}

  brace-expansion@5.0.7:
    dependencies:
      balanced-match: 4.0.4

  code-block-writer@13.0.3: {}

  esbuild@0.28.1:
    optionalDependencies:
      '@esbuild/aix-ppc64': 0.28.1
      '@esbuild/android-arm': 0.28.1
      '@esbuild/android-arm64': 0.28.1
      '@esbuild/android-x64': 0.28.1
      '@esbuild/darwin-arm64': 0.28.1
      '@esbuild/darwin-x64': 0.28.1
      '@esbuild/freebsd-arm64': 0.28.1
      '@esbuild/freebsd-x64': 0.28.1
      '@esbuild/linux-arm': 0.28.1
      '@esbuild/linux-arm64': 0.28.1
      '@esbuild/linux-ia32': 0.28.1
      '@esbuild/linux-loong64': 0.28.1
      '@esbuild/linux-mips64el': 0.28.1
      '@esbuild/linux-ppc64': 0.28.1
      '@esbuild/linux-riscv64': 0.28.1
      '@esbuild/linux-s390x': 0.28.1
      '@esbuild/linux-x64': 0.28.1
      '@esbuild/netbsd-arm64': 0.28.1
      '@esbuild/netbsd-x64': 0.28.1
      '@esbuild/openbsd-arm64': 0.28.1
      '@esbuild/openbsd-x64': 0.28.1
      '@esbuild/openharmony-arm64': 0.28.1
      '@esbuild/sunos-x64': 0.28.1
      '@esbuild/win32-arm64': 0.28.1
      '@esbuild/win32-ia32': 0.28.1
      '@esbuild/win32-x64': 0.28.1

  fdir@6.5.0(picomatch@4.0.5):
    optionalDependencies:
      picomatch: 4.0.5

  fsevents@2.3.3:
    optional: true

  kysely@0.29.2: {}

  minimatch@10.2.5:
    dependencies:
      brace-expansion: 5.0.7

  path-browserify@1.0.1: {}

  pg-cloudflare@1.4.0:
    optional: true

  pg-connection-string@2.14.0: {}

  pg-cursor@2.20.0(pg@8.21.0):
    dependencies:
      pg: 8.21.0

  pg-int8@1.0.1: {}

  pg-pool@3.14.0(pg@8.21.0):
    dependencies:
      pg: 8.21.0

  pg-protocol@1.15.0: {}

  pg-types@2.2.0:
    dependencies:
      pg-int8: 1.0.1
      postgres-array: 2.0.0
      postgres-bytea: 1.0.1
      postgres-date: 1.0.7
      postgres-interval: 1.2.0

  pg@8.21.0:
    dependencies:
      pg-connection-string: 2.14.0
      pg-pool: 3.14.0(pg@8.21.0)
      pg-protocol: 1.15.0
      pg-types: 2.2.0
      pgpass: 1.0.5
    optionalDependencies:
      pg-cloudflare: 1.4.0

  pgpass@1.0.5:
    dependencies:
      split2: 4.2.0

  picomatch@4.0.5: {}

  postgres-array@2.0.0: {}

  postgres-array@3.0.4: {}

  postgres-bytea@1.0.1: {}

  postgres-date@1.0.7: {}

  postgres-date@2.1.0: {}

  postgres-interval@1.2.0:
    dependencies:
      xtend: 4.0.2

  postgres-interval@4.0.2: {}

  reflect-metadata@0.2.2: {}

  split2@4.2.0: {}

  tinyglobby@0.2.17:
    dependencies:
      fdir: 6.5.0(picomatch@4.0.5)
      picomatch: 4.0.5

  ts-morph@28.0.0:
    dependencies:
      '@ts-morph/common': 0.29.0
      code-block-writer: 13.0.3

  tsx@4.23.0:
    dependencies:
      esbuild: 0.28.1
    optionalDependencies:
      fsevents: 2.3.3

  typescript@6.0.3: {}

  xtend@4.0.2: {}

seed-alpha.ts

import { MikroORM } from '@mikro-orm/postgresql';
import { Alpha } from './alpha.entity';
import { createOptions } from './orm-options';

const orm = await MikroORM.init(createOptions([Alpha]));
await orm.close(true);

seed-beta.ts

import { MikroORM } from '@mikro-orm/postgresql';
import { Beta } from './beta.entity';
import { createOptions } from './orm-options';

const orm = await MikroORM.init(createOptions([Beta]));
await orm.close(true);

verify.ts

import { MikroORM } from '@mikro-orm/postgresql';
import { createOptions } from './orm-options';

const { Alpha } = await import('./alpha.entity');
const { Beta } = await import('./beta.entity');
const orm = await MikroORM.init(createOptions([Alpha, Beta]));
const metadata = [...orm.getMetadata().getAll().values()];
const ids = metadata.map((meta) => ({
  className: meta.className,
  collection: meta.collection,
  embeddable: meta.embeddable ?? false,
  id: meta._id,
}));
const tables = orm.schema.getTargetSchema().getTables().map((table) => table.name).sort();

console.log(JSON.stringify({ ids, tables }, null, 2));
await orm.close(true);

if (new Set(ids.map((meta) => meta.id)).size !== ids.length || tables.length !== 2) {
  process.exitCode = 1;
}