7 replies

Zod - sort schema

Hi. I am adding sort option to prisma

findMany

findMany

query. Since I don't know zod very well, I could not think of any possible type-safe solution.

Sort format should be:

columnFieldName:orderType

columnFieldName:orderType

, so for example:

firstName:desc

firstName:desc

.
I made my types from

@prisma/client

@prisma/client

, but don't know how to add them to tRPC input.
Is it even possible?

type ColumnField = keyof Astronaut;
type Order = "desc" | "asc";

getAll: t.procedure
  .input(z.object({ sort: z.string().optional() }))
  .query(({ ctx, input }) => {
    const [col, order] = input.sort?.split(":") as any;

    return ctx.prisma.astronaut.findMany({
      orderBy: {
        [col]: order,
      },
    });
  })

type ColumnField = keyof Astronaut;
type Order = "desc" | "asc";

getAll: t.procedure
  .input(z.object({ sort: z.string().optional() }))
  .query(({ ctx, input }) => {
    const [col, order] = input.sort?.split(":") as any;

    return ctx.prisma.astronaut.findMany({
      orderBy: {
        [col]: order,
      },
    });
  })

TTC

Theo's Typesafe Cult•4y ago•

7 replies

JakubH

Zod - sort schema

Hi. I am adding sort option to prisma

findMany

findMany

query. Since I don't know zod very well, I could not think of any possible type-safe solution.

Sort format should be:

columnFieldName:orderType

columnFieldName:orderType

, so for example:

firstName:desc

firstName:desc

.
I made my types from

@prisma/client

@prisma/client

, but don't know how to add them to tRPC input.
Is it even possible?

type ColumnField = keyof Astronaut;
type Order = "desc" | "asc";

getAll: t.procedure
  .input(z.object({ sort: z.string().optional() }))
  .query(({ ctx, input }) => {
    const [col, order] = input.sort?.split(":") as any;

    return ctx.prisma.astronaut.findMany({
      orderBy: {
        [col]: order,
      },
    });
  })

type ColumnField = keyof Astronaut;
type Order = "desc" | "asc";

getAll: t.procedure
  .input(z.object({ sort: z.string().optional() }))
  .query(({ ctx, input }) => {
    const [col, order] = input.sort?.split(":") as any;

    return ctx.prisma.astronaut.findMany({
      orderBy: {
        [col]: order,
      },
    });
  })

Zod - sort schema

Similar Threads

Zod - sort schema

Similar Threads

Similar Threads

Similar Threads