How fix lint operator does not exist: uuid = text

[sergiohdljr]

I have the following code :

On this table the column id has a UUID type, wich i am comparing with a id send from the params, that is actually a UUID but as a string.

any ideias how i could fix that ? (i am open for database remodelation too)

[pokedotdev]

this is the way

sql`DELETE FROM farmacia WHERE id = ${id}::uuid`

[pokedotdev]

the syntax error may be because the UUID you are entering is invalid. On the other hand, I think that casting from uuid to text would give worse performance.

[Newbie012]

You could create a new TS type called UUID (a branded type) and tell SafeQL to treat it as UUID via overrides.types

[sergiohdljr]

not sure how do that, but i will try

[Newbie012]

@sergiohdljr there are many libraries which support branded types such as zod's brand.

First, define your UUID brand:

import { z } from "zod";

const UUID = z.string.brand<"UUID">();
type UUID = z.infer<typeof UUID>;

Second, tell SafeQL to treat uuid as your branded UUID (instead of the default string) using overrides.types:

{
  "connections": {
    "overrides": {
      "types": {
        "uuid": "UUID"
      }
    }
  }
}

Lastly, this is how you code should like:

import { UUID } from "./uuid";

function run(id: UUID) {
  return sql`DELETE FROM farmacia WHERE id = ${id}`
}