Logan Comments - Answer Overflow

Logan

•Created by Logan on 3/23/2025 in #help-and-questions

Using prisma with two different databases.

I've tried both:

import { PrismaClient as PrismaClient1 } from "@prisma-repair/client";
import { PrismaClient as PrismaClient2 } from "@prisma-ip-management/client";

export const prisma = new PrismaClient1();
export const ipManamgement = new PrismaClient2();

import { PrismaClient as PrismaClient1 } from "@prisma-repair/client";
import { PrismaClient as PrismaClient2 } from "@prisma-ip-management/client";

export const prisma = new PrismaClient1();
export const ipManamgement = new PrismaClient2();

and

import { PrismaClient as PrismaClient1 } from "@prisma-repair/client";
import { PrismaClient as PrismaClient2 } from "@prisma-ip-management/client";

const globalForPrisma1 = global as unknown as { prisma?: PrismaClient1 };
const globalForPrisma2 = global as unknown as { prisma?: PrismaClient2 };

export const prisma = globalForPrisma1.prisma || new PrismaClient1();
export const ipManagement = globalForPrisma2.prisma || new PrismaClient2();

if (process.env.NODE_ENV !== "production") {
  globalForPrisma1.prisma = prisma;
  globalForPrisma2.prisma = ipManagement;
}

import { PrismaClient as PrismaClient1 } from "@prisma-repair/client";
import { PrismaClient as PrismaClient2 } from "@prisma-ip-management/client";

const globalForPrisma1 = global as unknown as { prisma?: PrismaClient1 };
const globalForPrisma2 = global as unknown as { prisma?: PrismaClient2 };

export const prisma = globalForPrisma1.prisma || new PrismaClient1();
export const ipManagement = globalForPrisma2.prisma || new PrismaClient2();

if (process.env.NODE_ENV !== "production") {
  globalForPrisma1.prisma = prisma;
  globalForPrisma2.prisma = ipManagement;
}

14 replies

PPrisma

•Created by Logan on 3/23/2025 in #help-and-questions

Using prisma with two different databases.

import { ipManamgement } from "@/lib/prisma";

export default async function IPManagementPage() {
  const test = await ipManamgement.iPAddresses.create({
    data: {
      IPAddress: "12345",
    },
  });
  return (
    <div>
      <h1>IP Management</h1>
    </div>
  );
}

import { ipManamgement } from "@/lib/prisma";

export default async function IPManagementPage() {
  const test = await ipManamgement.iPAddresses.create({
    data: {
      IPAddress: "12345",
    },
  });
  return (
    <div>
      <h1>IP Management</h1>
    </div>
  );
}

14 replies

PPrisma

•Created by Logan on 3/23/2025 in #help-and-questions

Using prisma with two different databases.

I've tried implementing and still getting same error

14 replies

PPrisma

•Created by Logan on 3/23/2025 in #help-and-questions

Using prisma with two different databases.

How should I properly export my clients to use the prisma clients throughout my application

14 replies

PPrisma

•Created by Logan on 3/23/2025 in #help-and-questions

Using prisma with two different databases.

14 replies

PPrisma

•Created by Logan on 3/23/2025 in #help-and-questions

Using prisma with two different databases.

Currently I'm using two different prisma folders, I've also tried under the same prisma folder. Always getting the same error.

14 replies

PPrisma

•Created by Logan on 3/23/2025 in #help-and-questions

Using prisma with two different databases.

import { PrismaClient as PrismaClient1 } from "../prisma/generated";
import { PrismaClient as PrismaClient2 } from "../prisma2/generated/";

const globalForPrisma1 = global as unknown as { prisma?: PrismaClient1 };
const globalForPrisma2 = global as unknown as { prisma?: PrismaClient2 };

export const prisma = globalForPrisma1.prisma || new PrismaClient1();
export const prisma2 = globalForPrisma2.prisma || new PrismaClient2();

if (process.env.NODE_ENV !== "production") {
  globalForPrisma1.prisma = prisma;
  globalForPrisma2.prisma = prisma2;
}

import { PrismaClient as PrismaClient1 } from "../prisma/generated";
import { PrismaClient as PrismaClient2 } from "../prisma2/generated/";

const globalForPrisma1 = global as unknown as { prisma?: PrismaClient1 };
const globalForPrisma2 = global as unknown as { prisma?: PrismaClient2 };

export const prisma = globalForPrisma1.prisma || new PrismaClient1();
export const prisma2 = globalForPrisma2.prisma || new PrismaClient2();

if (process.env.NODE_ENV !== "production") {
  globalForPrisma1.prisma = prisma;
  globalForPrisma2.prisma = prisma2;
}

14 replies

PPrisma

•Created by Logan on 3/23/2025 in #help-and-questions

Using prisma with two different databases.

generator client {
  provider = "prisma-client-js"
  output = "../prisma/generated"
}

datasource db {
  provider = "sqlserver"
  url      = env("DATABASE_URL")
}

... Existing models below

generator client {
  provider = "prisma-client-js"
  output = "../prisma/generated"
}

datasource db {
  provider = "sqlserver"
  url      = env("DATABASE_URL")
}

... Existing models below

generator client2 {
  provider = "prisma-client-js"
  output   = "../prisma2/generated"
}

datasource db2 {
  provider = "sqlserver"
  url      = env("DATABASE_URL2")
}

... Existing models below

generator client2 {
  provider = "prisma-client-js"
  output   = "../prisma2/generated"
}

datasource db2 {
  provider = "sqlserver"
  url      = env("DATABASE_URL2")
}

... Existing models below

14 replies

Gaming

Programming