Mike J Posts - Answer Overflow

Mike J

Explore posts from servers

•Created by Mike J on 10/26/2024 in #help

How would you write this SQL query using Drizzle?

Hey! This is my first time using Drizzle. I have the following SQL query, which returns the ID for "my_name" (which I expect to return most of the time). If the name doesn't exist, it will insert it into the table and return the new ID. It's one call to the database and avoids trying to INSERT only if the value doesn't exist. How do I write this using Drizzle?

WITH ins AS (
    INSERT INTO names (name)
    VALUES ('my_name')
    ON CONFLICT (name) DO NOTHING
    RETURNING id
)
SELECT COALESCE(
    (SELECT id FROM your_table WHERE name = 'your_name'),
    (SELECT id FROM ins)
);

WITH ins AS (
    INSERT INTO names (name)
    VALUES ('my_name')
    ON CONFLICT (name) DO NOTHING
    RETURNING id
)
SELECT COALESCE(
    (SELECT id FROM your_table WHERE name = 'your_name'),
    (SELECT id FROM ins)
);

2 replies

CDCloudflare Developers

•Created by Mike J on 11/23/2023 in #pages-help

Using 'pg' in an Astro API route

Hi. I think you can use Node's pg with Cloudflare workers according to https://developers.cloudflare.com/workers/tutorials/postgres I am trying to deploy an Astro API route like the following but the build is failing

The package "net" wasn't found on the file system but is built into node. Are you trying to bundle for node? You can use "platform: 'node'" to do that, which will remove this error.

It's not clear to me where I am supposed to specify the platform.

import { Client } from "pg";

export async function GET({ params, request }) {
  const DATABASE_URL = new URL(request.url).searchParams.get("database_url");
  const client = new Client({ DATABASE_URL });
  await client.connect();
  await client.query("SELECT pg_sleep(1);");
  await client.end();
  return new Response(
    JSON.stringify({
      DATABASE_URL: DATABASE_URL,
    })
  );
}

import { Client } from "pg";

export async function GET({ params, request }) {
  const DATABASE_URL = new URL(request.url).searchParams.get("database_url");
  const client = new Client({ DATABASE_URL });
  await client.connect();
  await client.query("SELECT pg_sleep(1);");
  await client.end();
  return new Response(
    JSON.stringify({
      DATABASE_URL: DATABASE_URL,
    })
  );
}

1 replies

Gaming

Programming