Brokenwind
Brokenwind
Explore posts from servers
PPrismaDTDrizzle Team
PostsComments
PPrisma
Created by Brokenwind on 1/13/2025 in #help-and-questions
Prisma.skip on deeply nested objects
Hello, is there a way to Prisma.skip deeply nested objects? In this case: 
  const {
    _sum: { netSales = 0 },
  } = await prisma.returnsItem.aggregate({
    where: {
      inventory: {
        product: {
          categoryId: productCategoryId ?? Prisma.skip,
        },
      },
      returns: {
        transactionDate: {
          gte: start.toDate(),
          lte: end.toDate(),
        },
        salesChannelId: salesChannelId ?? Prisma.skip,
        territory: {
          id: territoryId ?? Prisma.skip,
          district: {
            id: districtId ?? Prisma.skip,
            region: {
              id: regionId ?? Prisma.skip,
            },
          },
        },
      },
    },
    _sum: {
      netSales: true,
    },
  });
  const {
    _sum: { netSales = 0 },
  } = await prisma.returnsItem.aggregate({
    where: {
      inventory: {
        product: {
          categoryId: productCategoryId ?? Prisma.skip,
        },
      },
      returns: {
        transactionDate: {
          gte: start.toDate(),
          lte: end.toDate(),
        },
        salesChannelId: salesChannelId ?? Prisma.skip,
        territory: {
          id: territoryId ?? Prisma.skip,
          district: {
            id: districtId ?? Prisma.skip,
            region: {
              id: regionId ?? Prisma.skip,
            },
          },
        },
      },
    },
    _sum: {
      netSales: true,
    },
  });
When territoryId, districtId, and regionId are all undefined, it gives out this as a result: 
territory: { id: dr {}, district: { id: dr {}, region: { id: dr {}, } } }
territory: { id: dr {}, district: { id: dr {}, region: { id: dr {}, } } }
Normally I would expect it to not consider the territory clause at all since all of it are skipped. For some reason, prisma doesn't skip this and returns null.
4 replies
DTDrizzle Team
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