insert row, got values back, but there's not data stored on the db

A

Angelelz•1/16/24, 4:26 AM

Two questions, what driver are you using and are you running in a transaction?

A

Angelelz•1/16/24, 4:27 AM

Are you using pool or single connection?

T

ThognOP•1/16/24, 8:29 AM

I'm using pg driver, im not running in a transaction?.

T

ThognOP•1/16/24, 8:30 AM

im using single connection

T

ThognOP•1/16/24, 8:32 AM

const messagess = await db.query.messages.findMany({
    where: (message, { eq }) => eq(message.conversationId, conversationId),
  });
  const mess = await db.select().from(messages).where(eq(messages.conversationId,conversationId))

const messagess = await db.query.messages.findMany({
    where: (message, { eq }) => eq(message.conversationId, conversationId),
  });
  const mess = await db.select().from(messages).where(eq(messages.conversationId,conversationId))

const messagess = await db.query.messages.findMany({
    where: (message, { eq }) => eq(message.conversationId, conversationId),
  });
  const mess = await db.select().from(messages).where(eq(messages.conversationId,conversationId))

const messagess = await db.query.messages.findMany({
    where: (message, { eq }) => eq(message.conversationId, conversationId),
  });
  const mess = await db.select().from(messages).where(eq(messages.conversationId,conversationId))

for these queris, they achieve the samething. But the first one I got nothing back,

A

Angelelz•1/16/24, 11:24 AM

You have to remember that uuids are not text columns

A

Angelelz•1/16/24, 11:24 AM

See here https://dba.stackexchange.com/questions/211692/in-postgres-how-to-select-by-a-column-of-type-uuid

Database Administrators Stack Exchange

In Postgres, how to select by a column of type UUID

I have a DB table that someone else created, its PK is a single column of type 'uuid'. I'm struggling to perform a simple select by that column. Examples I have tried with no success:

select from ...

insert row, got values back, but there's not data stored on the db

Similar Threads

Similar Threads

Similar Threads