Mikro ORM TypeScript: Rolling back the database changes on persist().flush()

0
votes

I don't know why is my mikro-orm entity manager em not saving to the database.

Here is my mikro-orm-config.ts looks as follows:

export default {
  entities: [User],
  migrations: {
    path: path.join(__dirname, "./migrations"),
    pattern: /^[\w-]+\d+\.[t|j]s$/,
  },
  dbName: "interaction",
  password: "root",
  user: "postgres",
  port: 5432,
  debug: process.env.NODE_ENV !== "production",
  type: "postgresql",
} as Parameters<typeof MikroORM.init>[0];

When i try to save the user in the database as follows:

 const user = await em.create(User, {
      username: username.trim().toLocaleLowerCase(),
      password: hashed,
      uid,
      gender,
});
await em.persistAndFlush(user);

Where em is the entity manager :

const {em} = await MikroORM.init(mikroOrmConfig);

Here are the logs:

[query] begin
[query] insert into "users" ("created_at", "gender", "password", "uid", "updated_at", "username") values ('2021-11-13T20:40:56.198Z', 'male', '$2a$10$ApTIOrSPE5/NAoTLEmx/GuALM0aKFE5xC959ZW10K7WFApqdXfnAC', '785b18e4-cddf-4a43-bf32-c517ab134137', '2021-11-13T20:40:56.198Z', 'username0') returning "id", "token_version" [took 66 ms]
[query] rollback

What may be possibly my problem?

typescripttypeormmikro-orm