Logan Posts - Answer Overflow

Logan

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

Using prisma with two different databases.

I have a NextJS project using Prisma ORM with Microsoft SQL Server. I am trying to setup Prisma to work with two different SQL Server databases in the same project. I cannot seem to get it working. I keep getting an error: TypeError: The "path" argument must be of type string. Recieved undefined. Anyone have any idea?

14 replies

PPrisma

•Created by Logan on 2/22/2025 in #help-and-questions

Prisma not getting past create function.

Hello, I'm using NextJS API routes and I'm having an issue creating record in the database. I am seeing the console.log("Test2") in the console but getting a 400 response code. I'm not sure what is causing this.

export async function POST(request) {
  const { uuid, product } = await request.json();

  console.log(uuid + " " + product);
  try {
    const findDevice = prisma.device.count({
      where: {
        uuid: uuid,
      },
    });

    if (findDevice > 0) {
      console.log("Test");
      const updateDevice = await prisma.device.update({
        where: {
          uuid: uuid,
        },
        data: {
          product: product,
          lastUpdated: Date.now(),
        },
      });
      console.log("Updated device");
    } else {
      console.log("Test 2");
      const createDevice = await prisma.device.create({
        data: {
          uuid: uuid,
          product: product,
        },
      });
      console.log("Create new device");
    }

    const response = {
      message: "Expiration date successfully programmmed on device.",
    };

    return new Response(JSON.stringify(response), {
      status: 200,
      headers: {
        "Content-Type": "application/json",
      },
    });
  } catch (error) {
    return new Response(
      JSON.stringify({
        message: "Error storing expiration data",
        error: error.message,
      }),
      {
        status: 400, // Bad Request status
        headers: {
          "Content-Type": "application/json",
        },
      }
    );
  }
}

export async function POST(request) {
  const { uuid, product } = await request.json();

  console.log(uuid + " " + product);
  try {
    const findDevice = prisma.device.count({
      where: {
        uuid: uuid,
      },
    });

    if (findDevice > 0) {
      console.log("Test");
      const updateDevice = await prisma.device.update({
        where: {
          uuid: uuid,
        },
        data: {
          product: product,
          lastUpdated: Date.now(),
        },
      });
      console.log("Updated device");
    } else {
      console.log("Test 2");
      const createDevice = await prisma.device.create({
        data: {
          uuid: uuid,
          product: product,
        },
      });
      console.log("Create new device");
    }

    const response = {
      message: "Expiration date successfully programmmed on device.",
    };

    return new Response(JSON.stringify(response), {
      status: 200,
      headers: {
        "Content-Type": "application/json",
      },
    });
  } catch (error) {
    return new Response(
      JSON.stringify({
        message: "Error storing expiration data",
        error: error.message,
      }),
      {
        status: 400, // Bad Request status
        headers: {
          "Content-Type": "application/json",
        },
      }
    );
  }
}

6 replies

Gaming

Programming