7 replies

Insert returning api to match select columns

I have the following helpers to select the right columns and ensure I don't leak sensitive data:

export const userSelectPublicColumns = { id: true, firstName: true, lastName: true }
export const userSelectSensitiveColumns = {
  ...userSelectPublicColumns,
  email: true,
  mobileNumber: true,

export const userSelectPublicColumns = { id: true, firstName: true, lastName: true }
export const userSelectSensitiveColumns = {
  ...userSelectPublicColumns,
  email: true,
  mobileNumber: true,

However when I come to call

insert().returning()

insert().returning()

it seems the .returning() method takes a different shape and I'll need to duplicate my objects values above from boolean

true

true

table.columnKey

table.columnKey

Anyway around this duplication?

Drizzle Team•2y ago•

7 replies

Titan

Insert returning api to match select columns

I have the following helpers to select the right columns and ensure I don't leak sensitive data:

export const userSelectPublicColumns = { id: true, firstName: true, lastName: true }
export const userSelectSensitiveColumns = {
  ...userSelectPublicColumns,
  email: true,
  mobileNumber: true,

export const userSelectPublicColumns = { id: true, firstName: true, lastName: true }
export const userSelectSensitiveColumns = {
  ...userSelectPublicColumns,
  email: true,
  mobileNumber: true,

However when I come to call

insert().returning()

insert().returning()

it seems the .returning() method takes a different shape and I'll need to duplicate my objects values above from boolean

true

true

table.columnKey

table.columnKey

Anyway around this duplication?

Insert returning api to match select columns

Similar Threads

Insert returning api to match select columns

Similar Threads

Similar Threads

Similar Threads