peachneo Posts - Answer Overflow

peachneo

Explore posts from servers

•Created by peachneo on 10/31/2024 in #help

Deprecated pgTable signature

I'm seeing this as deprecated, but not clear on what the correct / up to date usage should be:

export const providerServiceAreas = pgTable(
  "provider_service_areas",
  {
    providerId: uuid("provider_id")
      .notNull()
      .references(() => providers.id, { onDelete: "cascade" }), // Foreign key to providers
    serviceAreaId: uuid("service_area_id")
      .notNull()
      .references(() => serviceAreas.id, { onDelete: "cascade" }), // Foreign key to service areas
  },
  (t) => ({
    pk: primaryKey({ columns: [t.providerId, t.serviceAreaId] }), // Composite primary key for uniqueness
  })
);

export const providerServiceAreas = pgTable(
  "provider_service_areas",
  {
    providerId: uuid("provider_id")
      .notNull()
      .references(() => providers.id, { onDelete: "cascade" }), // Foreign key to providers
    serviceAreaId: uuid("service_area_id")
      .notNull()
      .references(() => serviceAreas.id, { onDelete: "cascade" }), // Foreign key to service areas
  },
  (t) => ({
    pk: primaryKey({ columns: [t.providerId, t.serviceAreaId] }), // Composite primary key for uniqueness
  })
);

1 replies

CDCloudflare Developers

•Created by peachneo on 10/22/2023 in #workers-help

Are there any limits on the number of custom caches I can open using the cache api?

let myCache = await caches.open('custom:cache');
await myCache.match(request);

let myCache = await caches.open('custom:cache');
await myCache.match(request);

1 replies

DTDrizzle Team

•Created by peachneo on 9/29/2023 in #help

Many-to-many relation "where" only allows selection of pk fields

1 replies

DTDrizzle Team

•Created by peachneo on 9/28/2023 in #help

UpdatedAt column - Postgres

What's the best practice way to achieve a standard "updatedAt" column with the pg wrapper? I've seen mysql has timestamp('updated_at').defaultNow().onUpdateNow().notNull() However onUpdateNow() doesn't appear to be there for pg.

3 replies

CDCloudflare Developers

•Created by peachneo on 9/21/2023 in #workers-help

Pages function not binding to worker

6 replies

CDCloudflare Developers

•Created by peachneo on 9/21/2023 in #workers-help

What's the appropriate typescript type (within Env) for a binding to another worker?

For instance, for a durable object it would be:

interface Env {
  MY_DO: DurableObjectNamespace
  MY_WORKER: ???
}

interface Env {
  MY_DO: DurableObjectNamespace
  MY_WORKER: ???
}

Guessing it could just be a fetch handler, but would be nice to know what TS type is expected specifically

4 replies

CDCloudflare Developers

•Created by peachneo on 9/19/2023 in #pages-help

Github integration after deploying with Wrangler

I deployed directly with wrangler, and would now like to deploy preview branches automatically. Cloudflare already has access to my gh account (I have the app). If I push the repo up it's not clear to me how cloudflare will identify and deploy it. I don't see a way to configure this in the CF dashboard.

3 replies

Gaming

Programming