Brokenwind Posts - Answer Overflow

Brokenwind

•Created by Brokenwind on 11/25/2024 in #help

Unable to sort relational query

The docs says this should work:

await db.query.posts.findMany({
    orderBy: (posts, { asc }) => [asc(posts.id)],
    with: {
        comments: {
            orderBy: (comments, { desc }) => [desc(comments.id)],
        },
    },
});

await db.query.posts.findMany({
    orderBy: (posts, { asc }) => [asc(posts.id)],
    with: {
        comments: {
            orderBy: (comments, { desc }) => [desc(comments.id)],
        },
    },
});

But for some reason, this doesn't work out on my end. Is this still a bug or there's a workaround for this?

5 replies

DTDrizzle Team

•Created by Brokenwind on 11/13/2024 in #help

Optionally migrate a table.

Is there a way to tag a pg table to optionally migrate it when running either generate/migrate or push commands? There's a system generated table in my existing database and I know I can pull it to get the schema structure. What I don't want to do is change anything when I run the generate/migrate or push commands. Kinda like how managed=False works in Django.

3 replies

DTDrizzle Team

•Created by Brokenwind on 7/3/2024 in #help

Exclude table from migration

I have an existing table from another schema from supabase's auth.

const authSchema = pgSchema("auth");

export const users = authSchema.table("users", {
  id: uuid("id").primaryKey(),
  email: varchar("email", { length: 255 }),
  raw_user_meta_data: jsonb("raw_user_meta_data").$type<RawUserMetaData>(),
});

const authSchema = pgSchema("auth");

export const users = authSchema.table("users", {
  id: uuid("id").primaryKey(),
  email: varchar("email", { length: 255 }),
  raw_user_meta_data: jsonb("raw_user_meta_data").$type<RawUserMetaData>(),
});

I use this to access the data from the raw_user_meta_data of supabase. How do I exclude this users table from migrating?

3 replies

DTDrizzle Team

•Created by Brokenwind on 6/18/2024 in #help

Can't migrate on vercel postgres

Hello, I'm having issues connecting to Vercel Postgres at the moment. Does anyone else face the same issue?

 code: 'CONNECT_TIMEOUT',
  errno: 'CONNECT_TIMEOUT',

This is what I'm always getting

10 replies

Gaming

Programming