Varna Posts - Answer Overflow

Varna

Explore posts from servers

NNuxt CDCloudflare Developers DTDrizzle Team

•Created by Varna on 7/23/2024 in #help

Counting many-to-many items

Hello, any suggestions how should I query for item and count the numbers of times it is referenced via many-to-many table?

const items = await db.select({
  ...getTableColumns(A),
  countB: // count of B items on A
  countC: // count of C items on A
})
  .from(A)
  .groupBy(A.id)

const items = await db.select({
  ...getTableColumns(A),
  countB: // count of B items on A
  countC: // count of C items on A
})
  .from(A)
  .groupBy(A.id)

Given these tables:

export const A = mysqlTable(
  "A", {
    id: int("id").primaryKey().autoincrement(),
    name: varchar("name", { length: 191 }).notNull(),
  }
)

export const B = mysqlTable(
  "B", {
    id: int("id").primaryKey().autoincrement(),
    name: varchar("name", { length: 191 }).notNull(),
  }
)

export const C = mysqlTable(
  "C", {
    id: int("id").primaryKey().autoincrement(),
    name: varchar("name", { length: 191 }).notNull(),
  }
)

export const AB = mysqlTable(
  "AB", {
    A: int("A").notNull().references(() => A.id),
    B: int("B").notNull().references(() => B.id),
  }
)

export const AC = mysqlTable(
  "AC", {
    A: int("A").notNull().references(() => A.id),
    C: int("C").notNull().references(() => C.id),
  }
)

export const A = mysqlTable(
  "A", {
    id: int("id").primaryKey().autoincrement(),
    name: varchar("name", { length: 191 }).notNull(),
  }
)

export const B = mysqlTable(
  "B", {
    id: int("id").primaryKey().autoincrement(),
    name: varchar("name", { length: 191 }).notNull(),
  }
)

export const C = mysqlTable(
  "C", {
    id: int("id").primaryKey().autoincrement(),
    name: varchar("name", { length: 191 }).notNull(),
  }
)

export const AB = mysqlTable(
  "AB", {
    A: int("A").notNull().references(() => A.id),
    B: int("B").notNull().references(() => B.id),
  }
)

export const AC = mysqlTable(
  "AC", {
    A: int("A").notNull().references(() => A.id),
    C: int("C").notNull().references(() => C.id),
  }
)

4 replies

CDCloudflare Developers

•Created by Varna on 5/27/2024 in #workers-help

I renamed my Worker in Dash and wrangler.toml, but became unauthorized in wrangler and can't deploy

Hello, I deploy my worker via CLI. I renamed one of my workers in Cloudflare Dash. I updated the wrangler.toml. If I try to deploy via CLI with wrangler now, it fails with :

✘ [ERROR] A request to the Cloudflare API (/accounts/cfXXXXXXXXXXXXXXXX/workers/scripts/share-worker) failed.

  workers.api.error.unauthorized [code: 10023]
  
  If you think this is a bug, please open an issue at:
  https://github.com/cloudflare/workers-sdk/issues/new/choose

  workers.api.error.unauthorized [code: 10023]

✘ [ERROR] A request to the Cloudflare API (/accounts/cfXXXXXXXXXXXXXXXX/workers/scripts/share-worker) failed.

  workers.api.error.unauthorized [code: 10023]
  
  If you think this is a bug, please open an issue at:
  https://github.com/cloudflare/workers-sdk/issues/new/choose

  workers.api.error.unauthorized [code: 10023]

wrangler whoami still shows me. I did wrangler logout and logged in again. But it still fails.

3 replies

CDCloudflare Developers

•Created by Varna on 5/22/2024 in #workers-help

I'm looking for a way to replicate worker wrangler.toml/routes in local dev mode

# wrangler.toml
# ...

routes = [
  { pattern = "example.test/api*", zone_name = "example.test" },
  { pattern = "localhost:4321/api*", zone_name = "localhost" },
]

# wrangler.toml
# ...

routes = [
  { pattern = "example.test/api*", zone_name = "example.test" },
  { pattern = "localhost:4321/api*", zone_name = "localhost" },
]

Probably not possible with wrangler only. Maybe it's possible with miniflare, zero trust and/or WARP client?

7 replies

CDCloudflare Developers

•Created by Varna on 5/16/2024 in #workers-help

How to test RPC Workers?

4 replies

DTDrizzle Team

•Created by Varna on 4/16/2024 in #help

text mode json for sqlite Dq doesn't parse by default

I get SyntaxError: "undefined" is not valid JSON for json_string: text("json_string", { mode: "json" }) field. When I use methods like:

db.query.Issue.findMany();

db.query.Issue.findMany();

db.select().from(Issue)

db.select().from(Issue)

while it does work and return string, If I manually select it by:

db.select({
  json_string: Issue.json_string
}).from(Issue)

db.select({
  json_string: Issue.json_string
}).from(Issue)

I'm using D1 db.

3 replies

CDCloudflare Developers

•Created by Varna on 3/22/2024 in #general-help

Where can I see the answers to Community Call?

Hi, I see that there is a new Community Call planned. I asked a question in previous one, but I couldn't come on Friday because of personal issues. Is there a way to see "Answers" or transcript or smth like that? It is also pretty annoying, that Community Call chats are hidden by default, and get hidden when you leave to another active window. I'm talking about this question: https://discord.com/channels/595317990191398933/1067184198206640188/1208059432932745226 And I see that it was marked as answered

2 replies

DTDrizzle Team

•Created by Varna on 3/6/2024 in #help

How can I extend drizzle tables?

I noticed that I write a lot of boilerplate code. When I had to update one of such types, I refactored them a bit, into reusable thing:

// /__prefabs.ts
import { sql } from "drizzle-orm"
import { datetime, varchar, int } from "drizzle-orm/mysql-core"
import { User } from "./NextAuth"

export const id = int("id").primaryKey().autoincrement()
export const name = varchar("name", { length: 191 }).notNull()
export const slug = varchar("slug", { length: 191 }).notNull()

export const Updated = {
  updatedAt: datetime("updatedAt", { mode: "date", fsp: 3 })
    .default(sql`CURRENT_TIMESTAMP(3) ON UPDATE CURRENT_TIMESTAMP(3)`)
    .notNull(),
  updatedById: varchar("updatedById", { length: 191 }).references(
    () => User.id,
    { onDelete: "set null", onUpdate: "cascade" }
  )
}

// /__prefabs.ts
import { sql } from "drizzle-orm"
import { datetime, varchar, int } from "drizzle-orm/mysql-core"
import { User } from "./NextAuth"

export const id = int("id").primaryKey().autoincrement()
export const name = varchar("name", { length: 191 }).notNull()
export const slug = varchar("slug", { length: 191 }).notNull()

export const Updated = {
  updatedAt: datetime("updatedAt", { mode: "date", fsp: 3 })
    .default(sql`CURRENT_TIMESTAMP(3) ON UPDATE CURRENT_TIMESTAMP(3)`)
    .notNull(),
  updatedById: varchar("updatedById", { length: 191 }).references(
    () => User.id,
    { onDelete: "set null", onUpdate: "cascade" }
  )
}

// Category.ts
import { mysqlTable, unique } from "drizzle-orm/mysql-core"
import { id, name, slug, Updated } from "./__prefabs"

export const Category = mysqlTable(
  "Category",
  {
    id,
    name,
    slug,
    ...Updated
  },
  (table) => {
    return {
      Category_name_key: unique("Category_name_key").on(table.name),
      Category_slug_key: unique("Category_slug_key").on(table.slug)
    }
  }
)

// Category.ts
import { mysqlTable, unique } from "drizzle-orm/mysql-core"
import { id, name, slug, Updated } from "./__prefabs"

export const Category = mysqlTable(
  "Category",
  {
    id,
    name,
    slug,
    ...Updated
  },
  (table) => {
    return {
      Category_name_key: unique("Category_name_key").on(table.name),
      Category_slug_key: unique("Category_slug_key").on(table.slug)
    }
  }
)

This worked out pretty well for that time. But now, I keep writing tons of services, and I want to make some reusable functions, but I struggle with TS trying to do that. i.e. I want to make a service getItems:

// services/getItems.ts
import { db } from "@/app/(db)"
import { type Table } from "drizzle-orm"

type ItemTable = {
  id: number,
  name: string,
  slug: string
}

export async function getItems<T extends ItemTable>(table: Table<T>) {
  return db
    .select({
      id: table.id,
      name: table.name,
      slug: table.slug
    })
    .from(table)
}

// services/getItems.ts
import { db } from "@/app/(db)"
import { type Table } from "drizzle-orm"

type ItemTable = {
  id: number,
  name: string,
  slug: string
}

export async function getItems<T extends ItemTable>(table: Table<T>) {
  return db
    .select({
      id: table.id,
      name: table.name,
      slug: table.slug
    })
    .from(table)
}

But types on this thing are totally wrong, and I'm not sure where should I start to approach this problem. Another example, I have some subqueries like these:

const getProblemId = db
  .select({
    id: Problem.id
  })
  .from(Problem)
  .where(eq(Problem.slug, sql.placeholder("problemSlug")))
  .limit(1)

const getProblemId = db
  .select({
    id: Problem.id
  })
  .from(Problem)
  .where(eq(Problem.slug, sql.placeholder("problemSlug")))
  .limit(1)

It would be nice if I could refactor it into getID, that takes Table as prop:

const getID = (Table) => db
  .select({
    id: Table.id
  })
  .from(Table)
  .where(eq(Table.slug, sql.placeholder("slug")))
  .limit(1)

const getID = (Table) => db
  .select({
    id: Table.id
  })
  .from(Table)
  .where(eq(Table.slug, sql.placeholder("slug")))
  .limit(1)

But I just don't get how to define the Table type in TS.

1 replies

CDCloudflare Developers

•Created by Varna on 2/15/2024 in #pages-help

`wrangler pages dev -- astro dev` fails to follow Astro redirects

Astro project with wrangler pages dev -- astro dev and default adapter fails to properly execute an Astro redirect return context.redirect("/login", 302) with [wrangler] Could not proxy request: TypeError: fetch failed. Deployed version works. Only dev fails. Astro runs on localhost:3000, and Wrangler on localhost:8788 Node 18.18.2

5 replies

CDCloudflare Developers

•Created by Varna on 2/7/2024 in #workers-help

I have a subdomain.domain.com that I want to point to a worker. But domain.com is not in CF

I have a subdomain.domain.com that I want to point to a worker. But domain.com is managed by outside DNS provider. I can't migrate domain.com to cloudflare DNS. I tried adding CNAME, but it fails with ERR_SSL_VERSION_OR_CIPHER_MISMATCH. Any tips? I'm trying to migrate a cloud function (single handler, that takes colour from path and returns coloured png) from Vercel to CF.

1 replies

CDCloudflare Developers

•Created by Varna on 12/5/2023 in #general-help

How to make a Team and add an Accountant?

I don't really need Zero Trust, VPS or anything like that. I just want to: 1. Make team, with an app that would be assigned to that team, instead of my personal account. 2. Add my boss to the team, as owner and accountant, that would attach his credit card. I don't really understand how to do that.

4 replies

Gaming

Programming