Change query typing to respect where null, or where not null

Hello!

I am wondering if there is a solution for my current case that would greatly improve my code. I have several tables that have 2 states: in

reservation

reservation

reservation

reservation, or not in

reservation

reservation

reservation

reservation. When a row is in reservation, it does not have the links (or relationships) to other tables as it does when not in

reservation

reservation

reservation

reservation. For this reason, multiple relationship must be nullable, see screenshot for an example.

I would love to be able to do something like this:

const payments = await ctx.prisma.$primary().payment.findMany({
  where: {
    relation: {
      isNot: null,
    },
  }
});

const payments = await ctx.prisma.$primary().payment.findMany({
  where: {
    relation: {
      isNot: null,
    },
  }
});

const payments = await ctx.prisma.$primary().payment.findMany({
  where: {
    relation: {
      isNot: null,
    },
  }
});

const payments = await ctx.prisma.$primary().payment.findMany({
  where: {
    relation: {
      isNot: null,
    },
  }
});

and have the typing of

payments

payments

payments

payments to have its key

relation

relation

relation

relation not nullable because I have validated in the

where

where

where

where that it cannot be null. So the typing would end up to be :

const payments: {
  id: number;
  relation: Relation;
}[]

const payments: {
  id: number;
  relation: Relation;
}[]

const payments: {
  id: number;
  relation: Relation;
}[]

const payments: {
  id: number;
  relation: Relation;
}[]

Change query typing to respect where null, or where not null

Similar Threads

Similar Threads

Similar Threads