om-migrate-mikro-orm

Move decorator imports to @mikro-orm/decorators/legacy, replace persistAndFlush with persist().flush(), convert Knex queries to Kysely via em.getKysely(), and set metadataProvider to ReflectMetadataProvider in your ORM config. Then run type checks and tests to verify.

Replace await em.persistAndFlush(entity) with await em.persist(entity).flush(), and removeAndFlush with em.remove(entity).flush(). Update test mocks to cover persist, remove, and flush as separate mock functions.

Get the query builder with em.getKysely() and rewrite queries using selectFrom, insertInto, updateTable, or deleteFrom, always ending with .execute(). For raw SQL, use the sql template literal tag with parameter interpolation instead of knex.raw bindings.

v7 tightened generic constraints on FilterQuery and RequiredEntityData, so filters with null comparisons or mixed naming conventions no longer infer correctly. Add an explicit cast like { tenantId, deletedAt: null } as FilterQuery<MyEntity> to resolve the errors.

v7 removed the default ReflectMetadataProvider, so entity metadata inference fails without explicit configuration. Set metadataProvider: ReflectMetadataProvider from @mikro-orm/decorators/legacy in your MikroORM.init options.

v7 is ESM-only and uses import.meta internally, which breaks standard Jest. Use a custom transformer that replaces import.meta with CJS equivalents and set transformIgnorePatterns to node_modules/(?!(@mikro-orm)/) so the packages get transformed.