Single Connection Multiple Databases TypeORM

Question

I'm trying to connect to multiple databases from single connection using typeORM in javascript. There's a way doing it using typescript

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

@Entity({ database: "secondDB" })
export class User {

    @PrimaryGeneratedColumn()
    id: number;

    @Column()
    firstName: string;

    @Column()
    lastName: string;

}

I tried to replicate this in javascript like this:

const { EntitySchema } = require("typeorm");

const userSchema = {
   name: "User",
   database: "secondDB",
    columns: {
      id: { 
        primary: true, 
        type: "int", 
        generated: true 
     },
      firstName: { 
        type: "text"
     },
      lastName: { 
        type: "text"
     },

 }

 module.exports = new EntitySchema(userSchema);

This doesn't seem to switch databases, Is there an equivalent way of doing this in javascript. I'm connecting to a postgresDB

Lars Hendriks · Accepted Answer · 2022-06-21 06:56:35Z

0

It's been a while since I worked with type-orm, but I know that a single connection with multiple databases at the time was only supported for MySQL and MsSQL databases.

In this document: https://orkhan.gitbook.io/typeorm/docs/multiple-connections. It states that "Using multiple databases in a single connection" "this feature is supported only in mysql and mssql databases".

link to relevant github issue

answered Jun 21, 2022 at 6:56

Lars Hendriks

1,0587 silver badges22 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Single Connection Multiple Databases TypeORM

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related