Gary, el Pingüino Artefacto Comments

export const usersTable = pgTable("users", {
  // Possible?
  id: uuid().primaryKey().transform((value) => `users_${value}`),
  createdAt: timestamp().notNull().defaultNow(),
  givenName: varchar({ length: 64 }).notNull(),
  familyName: varchar({ length: 64 }).notNull(),
})

export const usersTable = pgTable("users", {
  // Possible?
  id: uuid().primaryKey().transform((value) => `users_${value}`),
  createdAt: timestamp().notNull().defaultNow(),
  givenName: varchar({ length: 64 }).notNull(),
  familyName: varchar({ length: 64 }).notNull(),
})

9 replies

DTDrizzle Team

•Created by Gary, el Pingüino Artefacto on 10/14/2024 in #help

Applying drizzle migrations on Vercel with Hono

After some hours, I managed to solve it. For anyone with the same issue, use the path module.

    const folder = path.join(process.cwd(), "src", "databases", "tenants", "migrations")

    const folder = path.join(process.cwd(), "src", "databases", "tenants", "migrations")

I also added this on the next.conf, Idk if it is necesary but xd

experimental: {
  outputFileTracingIncludes: {
    "/api/hono/[[...routes]]": ["./src/databases/tenants/migrations/**/*"],
    "/api/hono/tenants/create": ["./src/databases/tenants/migrations/**/*"],
  },
},

experimental: {
  outputFileTracingIncludes: {
    "/api/hono/[[...routes]]": ["./src/databases/tenants/migrations/**/*"],
    "/api/hono/tenants/create": ["./src/databases/tenants/migrations/**/*"],
  },
},

and

webpack: (config, { isServer }) => {
  if (isServer) {
    if (process.env.VERCEL_ENV === "production") {
      execSync(`curl -X GET ${process.env.VERCEL_URL}/api/hono/tenant/create`)
    }
  }
  return config
},

webpack: (config, { isServer }) => {
  if (isServer) {
    if (process.env.VERCEL_ENV === "production") {
      execSync(`curl -X GET ${process.env.VERCEL_URL}/api/hono/tenant/create`)
    }
  }
  return config
},

2 replies

DTDrizzle Team

•Created by Gary, el Pingüino Artefacto on 6/3/2024 in #help

Helpers for querying in the new PostGIS Geometry type

they don't

3 replies

DTDrizzle Team

•Created by Gary, el Pingüino Artefacto on 4/30/2024 in #help

Filtering a jsonb with the shape Array<{id:string,name:string}>

I ended up using this workaround, may be there is a better way

async function getPostsByTagIds(tagIds: string[]) {
  const ids = z.string().uuid().array().parse(tagIds)
  const obj = JSON.stringify(ids.map((id) => ({ id })))
  return await db
  .with(postsQuery)
  .select()
  .from(postsQuery)
  .where(
    sql`${postsQuery.tags} @> '${sql.raw(obj)}'`
  )
}

async function getPostsByTagIds(tagIds: string[]) {
  const ids = z.string().uuid().array().parse(tagIds)
  const obj = JSON.stringify(ids.map((id) => ({ id })))
  return await db
  .with(postsQuery)
  .select()
  .from(postsQuery)
  .where(
    sql`${postsQuery.tags} @> '${sql.raw(obj)}'`
  )
}

4 replies

DTDrizzle Team

•Created by Gary, el Pingüino Artefacto on 4/30/2024 in #help

Filtering a jsonb with the shape Array<{id:string,name:string}>

This doesn't work btw

async function getPostsByTagIds(tagIds: string[]) {
  const ids = '[{"id": "098b9acb-694d-4c00-b87f-64f9811f8810"},{"id":"46bba9b2-9b50-4e70-9284-6cddb2fe32d4"}]'
  return await db
  .with(postsQuery)
  .select()
  .from(postsQuery)
  .where(
    sql`${postsQuery.tags} @> ${ids}`
  )
}

async function getPostsByTagIds(tagIds: string[]) {
  const ids = '[{"id": "098b9acb-694d-4c00-b87f-64f9811f8810"},{"id":"46bba9b2-9b50-4e70-9284-6cddb2fe32d4"}]'
  return await db
  .with(postsQuery)
  .select()
  .from(postsQuery)
  .where(
    sql`${postsQuery.tags} @> ${ids}`
  )
}

4 replies

DTDrizzle Team

•Created by Gary, el Pingüino Artefacto on 4/30/2024 in #help

Filtering a jsonb with the shape Array<{id:string,name:string}>

Idea:

async function getPostsByTagIds(tagIds: string[]) {

  /*
    Parameterize '[{"id": "098b9acb-694d-4c00-b87f-64f9811f8810"},{"id":"46bba9b2-9b50-4e70-9284-6cddb2fe32d4"}]'
    Into something like:  
    const filter = `[${tagIds.map(id => ({ id }))}]`
  */

  return await db
  .with(postsQuery)
  .select()
  .from(postsQuery)
  .where(
    sql`${postsQuery.tags} @> SOME MAGIC HERE`
  )
}

async function getPostsByTagIds(tagIds: string[]) {

  /*
    Parameterize '[{"id": "098b9acb-694d-4c00-b87f-64f9811f8810"},{"id":"46bba9b2-9b50-4e70-9284-6cddb2fe32d4"}]'
    Into something like:  
    const filter = `[${tagIds.map(id => ({ id }))}]`
  */

  return await db
  .with(postsQuery)
  .select()
  .from(postsQuery)
  .where(
    sql`${postsQuery.tags} @> SOME MAGIC HERE`
  )
}