How to check if an entry already exist?

I found this query to check if an entry in the table already exists:

      await db.execute(
        sql`select exists(select 1 from ${posts} where ${posts.slug} = ${slug})`,
      )

      await db.execute(
        sql`select exists(select 1 from ${posts} where ${posts.slug} = ${slug})`,
      )

      await db.execute(
        sql`select exists(select 1 from ${posts} where ${posts.slug} = ${slug})`,
      )

      await db.execute(
        sql`select exists(select 1 from ${posts} where ${posts.slug} = ${slug})`,
      )

Which returns the response:

Result(1) [ { exists: false } ]

Result(1) [ { exists: false } ]

Result(1) [ { exists: false } ]

Result(1) [ { exists: false } ]
but how do I use it in a typescript

if

if

statement to run conditional code?

TtextYash I found this query to check if an entry in the table already exists: ```ts ...

tzezar•3/25/24, 1:07 AM

Probably not the best solution, but I do

    let [s] = await tx
                .select()
                .from(settlement)
                .where(eq(settlement.id, settlementId))
            if (!s) {
                throw new Error("settlement not found")

    let [s] = await tx
                .select()
                .from(settlement)
                .where(eq(settlement.id, settlementId))
            if (!s) {
                throw new Error("settlement not found")

Mykhailo•3/25/24, 11:03 AM

Hello, @textYash! Your solution is good to check if an entry exists in the table. Could you please clarify what you want to achieve with

if

if

statement?

Ttzezar Probably not the best solution, but I do ``` let [s] = await tx ...

Mykhailo•3/25/24, 11:03 AM

this works too!

MMykhailo Hello, @textYash! Your solution is good to check if an entry exists in the table...

textYashOP•3/25/24, 11:04 AM

I'm not sure how to use the result returned by that query inside an if statement to take an action based on it

textYashOP•3/25/24, 11:06 AM

Which returns the response:
Result(1) [ { exists: false } ]
Result(1) [ { exists: false } ]

I'm using typescript so how can I use eq or === on this?

Mykhailo•3/25/24, 11:29 AM

@textYash you can do smth like this

const [{ exists }] = await db.execute<{ exists: boolean }>(
  sql`select exists(select 1 from ${posts} where ${posts.slug} = ${slug})`,
);

if (exists) {
  console.log('exists');
} else {
  console.log('does not exist');
}

const [{ exists }] = await db.execute<{ exists: boolean }>(
  sql`select exists(select 1 from ${posts} where ${posts.slug} = ${slug})`,
);

if (exists) {
  console.log('exists');
} else {
  console.log('does not exist');
}

MMykhailo @textYash you can do smth like this ```ts const [{ exists }] = await db.execute...

textYashOP•3/25/24, 11:30 AM

Oh twas easy

textYashOP•3/25/24, 11:31 AM

Thanks

textYashOP•3/25/24, 11:31 AM

SOLVED

How to check if an entry already exist?

Similar Threads

Similar Threads

Similar Threads