Amur Comments - Answer Overflow

Amur

Explore posts from servers

RRailway TTCTheo's Typesafe Cult DTDrizzle Team

•Created by jakeleventhal on 1/7/2024 in #help

Is there a better way to access enum types?

coming back to this conversation as i feel like working with enums is still annoying as you mentioned above we can do this workaround to get the types but what if i have a function and i want to check if the maketPlaceIntegration is Amazon with a typescript enum i would have something like this but this is not possible with pgEnum

const isAmazon = (integration: MarketPlaceIntegrationTypes) => {
  if(integration === MarketPlaceIntegrationTypes.Amazon){
    // do something
  }
}

const isAmazon = (integration: MarketPlaceIntegrationTypes) => {
  if(integration === MarketPlaceIntegrationTypes.Amazon){
    // do something
  }
}

6 replies

DTDrizzle Team

•Created by Amur on 2/22/2024 in #help

Postgrest inserting json array results in stringified array

i ended up using a custom json field

export const customJsonb = <TData>(name: string) =>
  customType<{ data: TData; driverData: string }>({
    dataType() {
      return "jsonb";
    },
    // @ts-expect-error https://github.com/drizzle-team/drizzle-orm/issues/1511#issuecomment-1824687669
    toDriver(value: TData) {
      return value;
    },
  })(name);

// schema
notes: customJsonb<Array<RecipeNote>>("notes"),

export const customJsonb = <TData>(name: string) =>
  customType<{ data: TData; driverData: string }>({
    dataType() {
      return "jsonb";
    },
    // @ts-expect-error https://github.com/drizzle-team/drizzle-orm/issues/1511#issuecomment-1824687669
    toDriver(value: TData) {
      return value;
    },
  })(name);

// schema
notes: customJsonb<Array<RecipeNote>>("notes"),