Connection “default” was not found with TypeORM when trying to request a repository

user_11331809 0
Viewed 7363

I'm building an API with Express+TypeORM. This is my ormconfig.json:

{
  "type": "postgres",
  "host": "localhost",
  "port": "5432",
  "username": "mdsp9070",
  "password": "mdsp9070",
  "database": "mesha",
  "entities": ["./src/entities/*.ts"],
  "migrations": ["./src/shared/infra/typeorm/migrations/*.ts"],
  "cli": {
    "migrationsDir": "./src/shared/infra/typeorm/migrations"
  }
}

And my entity is defined as:

import {
  Entity,
  Column,
  PrimaryGeneratedColumn,
} from "typeorm";

@Entity("users")
export class User {
  @PrimaryGeneratedColumn("uuid")
  id: string;

  @Column()
  name: string;

  @Column()
  email: string;

  @Column()
  birthYear: string;

  @Column()
  phoneNumber: string;

  @Column()
  photo: string;
}

On my CreateUserUseCase, I call this repository like:

...
private usersRepository: IUsersRepository;
  // receives ormRepository, that's users repository
  constructor() {
    this.usersRepository = getCustomRepository(UsersRepository);
  }
...

but I'm getting this error: [ERROR] 13:08:39 ConnectionNotFoundError: Connection "default" was not found.

No, connection is not being called after getCustomRepository as I call the file on the index of my server.

full github repo: https://github.com/Mdsp9070/mesha

typeorm typescript express node.js orm
1 Answers

Explanation: Express routes eas been called before connection being established! So I chose to use dynamic imports.

My application main entry was changed to typeorm/index.ts as:

import { createConnection } from "typeorm";
import { AppError } from "../../errors/AppError";

// finds ormconfig.json file and creates a connection. (magic!),
// it could be set up manually with parameters
// however an external file is the best practise
createConnection()
  .then(() => {
     console.log("Connected to the database")
     import("../../http/server.ts")
  })
  .catch(() => new AppError("Unable to connect to the database"));

That way worked like a charm!

user_113318090
Related