Interface UserDelegate<ExtArgs, GlobalOmitOptions>

Readonlyfields

aggregate

• aggregate<T>(args): Prisma.PrismaPromise<GetUserAggregateType<T>>

• Allows you to perform aggregations operations on a User. Note, that providing undefined is treated as the value not being there. Read more here: https://pris.ly/d/null-undefined

  Type Parameters

  • T extends UserAggregateArgs<DefaultArgs>

  Parameters

  • args: Subset<T, UserAggregateArgs<DefaultArgs>>

    Select which aggregations you would like to apply and on what fields.

  Returns Prisma.PrismaPromise<GetUserAggregateType<T>>

  Example

  // Ordered by age ascending
  // Where email contains prisma.io
  // Limited to the 10 users
  const aggregations = await prisma.user.aggregate({
    _avg: {
      age: true,
    },
    where: {
      email: {
        contains: "prisma.io",
      },
    },
    orderBy: {
      age: "asc",
    },
    take: 10,
  })
  Copy

count

• count<T>(args?): Prisma.PrismaPromise<T extends Record_2<"select", any>
      ? T<T>["select"] extends true
          ? number
          : {
              [P in string | number | symbol]: P extends keyof UserCountAggregateOutputType
                  ? UserCountAggregateOutputType[P<P>]
                  : never
          }
      : number>

• Count the number of Users. Note, that providing undefined is treated as the value not being there. Read more here: https://pris.ly/d/null-undefined

  Type Parameters

  • T extends UserCountArgs<DefaultArgs>

  Parameters

  • Optionalargs: Subset<T, UserCountArgs<DefaultArgs>>

    Arguments to filter Users to count.

  Returns Prisma.PrismaPromise<T extends Record_2<"select", any>
      ? T<T>["select"] extends true
          ? number
          : {
              [P in string | number | symbol]: P extends keyof UserCountAggregateOutputType
                  ? UserCountAggregateOutputType[P<P>]
                  : never
          }
      : number>

  Example

  // Count the number of Users
  const count = await prisma.user.count({
    where: {
      // ... the filter for the Users we want to count
    }
  })
  Copy

create

• create<T>(args): Prisma__UserClient<GetFindResult<$UserPayload<ExtArgs>, T, GlobalOmitOptions>, never, ExtArgs, GlobalOmitOptions>

• Create a User.

  Type Parameters

  • T extends UserCreateArgs<DefaultArgs>

  Parameters

  • args: SelectSubset<T, UserCreateArgs<ExtArgs>>

    Arguments to create a User.

  Returns Prisma__UserClient<GetFindResult<$UserPayload<ExtArgs>, T, GlobalOmitOptions>, never, ExtArgs, GlobalOmitOptions>

  Example

  // Create one User
  const User = await prisma.user.create({
    data: {
      // ... data to create a User
    }
  })
  Copy

createMany

• createMany<T>(args?): Prisma.PrismaPromise<BatchPayload>

• Create many Users.

  Type Parameters

  • T extends UserCreateManyArgs<DefaultArgs>

  Parameters

  • Optionalargs: SelectSubset<T, UserCreateManyArgs<ExtArgs>>

    Arguments to create many Users.

  Returns Prisma.PrismaPromise<BatchPayload>

  Example

  // Create many Users
  const user = await prisma.user.createMany({
    data: [
      // ... provide data here
    ]
  })
  Copy

createManyAndReturn

• createManyAndReturn<T>(args?): Prisma.PrismaPromise<GetFindResult<$UserPayload<ExtArgs>, T, GlobalOmitOptions>[]>

• Create many Users and returns the data saved in the database.

  Type Parameters

  • T extends UserCreateManyAndReturnArgs<DefaultArgs>

  Parameters

  • Optionalargs: SelectSubset<T, UserCreateManyAndReturnArgs<ExtArgs>>

    Arguments to create many Users.

  Returns Prisma.PrismaPromise<GetFindResult<$UserPayload<ExtArgs>, T, GlobalOmitOptions>[]>

  Example

  // Create many Users
  const user = await prisma.user.createManyAndReturn({
    data: [
      // ... provide data here
    ]
  })
  
  // Create many Users and only return the `dbId`
  const userWithDbIdOnly = await prisma.user.createManyAndReturn({
    select: { dbId: true },
    data: [
      // ... provide data here
    ]
  })
  Note, that providing `undefined` is treated as the value not being there.
  Read more here: https://pris.ly/d/null-undefined
  Copy

delete

• delete<T>(args): Prisma__UserClient<GetFindResult<$UserPayload<ExtArgs>, T, GlobalOmitOptions>, never, ExtArgs, GlobalOmitOptions>

• Delete a User.

  Type Parameters

  • T extends UserDeleteArgs<DefaultArgs>

  Parameters

  • args: SelectSubset<T, UserDeleteArgs<ExtArgs>>

    Arguments to delete one User.

  Returns Prisma__UserClient<GetFindResult<$UserPayload<ExtArgs>, T, GlobalOmitOptions>, never, ExtArgs, GlobalOmitOptions>

  Example

  // Delete one User
  const User = await prisma.user.delete({
    where: {
      // ... filter to delete one User
    }
  })
  Copy

deleteMany

• deleteMany<T>(args?): Prisma.PrismaPromise<BatchPayload>

• Delete zero or more Users.

  Type Parameters

  • T extends UserDeleteManyArgs<DefaultArgs>

  Parameters

  • Optionalargs: SelectSubset<T, UserDeleteManyArgs<ExtArgs>>

    Arguments to filter Users to delete.

  Returns Prisma.PrismaPromise<BatchPayload>

  Example

  // Delete a few Users
  const { count } = await prisma.user.deleteMany({
    where: {
      // ... provide filter here
    }
  })
  Copy

findFirst

• findFirst<T>(args?): Prisma__UserClient<null | GetFindResult<$UserPayload<ExtArgs>, T, GlobalOmitOptions>, null, ExtArgs, GlobalOmitOptions>

• Find the first User that matches the filter. Note, that providing undefined is treated as the value not being there. Read more here: https://pris.ly/d/null-undefined

  Type Parameters

  • T extends UserFindFirstArgs<DefaultArgs>

  Parameters

  • Optionalargs: SelectSubset<T, UserFindFirstArgs<ExtArgs>>

    Arguments to find a User

  Returns Prisma__UserClient<null | GetFindResult<$UserPayload<ExtArgs>, T, GlobalOmitOptions>, null, ExtArgs, GlobalOmitOptions>

  Example

  // Get one User
  const user = await prisma.user.findFirst({
    where: {
      // ... provide filter here
    }
  })
  Copy

findFirstOrThrow

• findFirstOrThrow<T>(args?): Prisma__UserClient<GetFindResult<$UserPayload<ExtArgs>, T, GlobalOmitOptions>, never, ExtArgs, GlobalOmitOptions>

• Find the first User that matches the filter or throw PrismaKnownClientError with P2025 code if no matches were found. Note, that providing undefined is treated as the value not being there. Read more here: https://pris.ly/d/null-undefined

  Type Parameters

  • T extends UserFindFirstOrThrowArgs<DefaultArgs>

  Parameters

  • Optionalargs: SelectSubset<T, UserFindFirstOrThrowArgs<ExtArgs>>

    Arguments to find a User

  Returns Prisma__UserClient<GetFindResult<$UserPayload<ExtArgs>, T, GlobalOmitOptions>, never, ExtArgs, GlobalOmitOptions>

  Example

  // Get one User
  const user = await prisma.user.findFirstOrThrow({
    where: {
      // ... provide filter here
    }
  })
  Copy

findMany

• findMany<T>(args?): Prisma.PrismaPromise<GetFindResult<$UserPayload<ExtArgs>, T, GlobalOmitOptions>[]>

• Find zero or more Users that matches the filter. Note, that providing undefined is treated as the value not being there. Read more here: https://pris.ly/d/null-undefined

  Type Parameters

  • T extends UserFindManyArgs<DefaultArgs>

  Parameters

  • Optionalargs: SelectSubset<T, UserFindManyArgs<ExtArgs>>

    Arguments to filter and select certain fields only.

  Returns Prisma.PrismaPromise<GetFindResult<$UserPayload<ExtArgs>, T, GlobalOmitOptions>[]>

  Example

  // Get all Users
  const users = await prisma.user.findMany()
  
  // Get first 10 Users
  const users = await prisma.user.findMany({ take: 10 })
  
  // Only select the `dbId`
  const userWithDbIdOnly = await prisma.user.findMany({ select: { dbId: true } })
  Copy

findUnique

• findUnique<T>(args): Prisma__UserClient<null | GetFindResult<$UserPayload<ExtArgs>, T, GlobalOmitOptions>, null, ExtArgs, GlobalOmitOptions>

• Find zero or one User that matches the filter.

  Type Parameters

  • T extends UserFindUniqueArgs<DefaultArgs>

  Parameters

  • args: SelectSubset<T, UserFindUniqueArgs<ExtArgs>>

    Arguments to find a User

  Returns Prisma__UserClient<null | GetFindResult<$UserPayload<ExtArgs>, T, GlobalOmitOptions>, null, ExtArgs, GlobalOmitOptions>

  Example

  // Get one User
  const user = await prisma.user.findUnique({
    where: {
      // ... provide filter here
    }
  })
  Copy

findUniqueOrThrow

• findUniqueOrThrow<T>(args): Prisma__UserClient<GetFindResult<$UserPayload<ExtArgs>, T, GlobalOmitOptions>, never, ExtArgs, GlobalOmitOptions>

• Find one User that matches the filter or throw an error with error.code='P2025' if no matches were found.

  Type Parameters

  • T extends UserFindUniqueOrThrowArgs<DefaultArgs>

  Parameters

  • args: SelectSubset<T, UserFindUniqueOrThrowArgs<ExtArgs>>

    Arguments to find a User

  Returns Prisma__UserClient<GetFindResult<$UserPayload<ExtArgs>, T, GlobalOmitOptions>, never, ExtArgs, GlobalOmitOptions>

  Example

  // Get one User
  const user = await prisma.user.findUniqueOrThrow({
    where: {
      // ... provide filter here
    }
  })
  Copy

groupBy

• groupBy<T, HasSelectOrTake, OrderByArg, OrderFields, ByFields, ByValid, HavingFields, HavingValid, ByEmpty, InputErrors>(args): {} extends InputErrors
      ? GetUserGroupByPayload<T>
      : Prisma.PrismaPromise<InputErrors>

• Group by User. Note, that providing undefined is treated as the value not being there. Read more here: https://pris.ly/d/null-undefined

  Type Parameters

  • T extends UserGroupByArgs<DefaultArgs>
  • HasSelectOrTake extends 0 | 1
  • OrderByArg extends {
        orderBy: undefined | UserOrderByWithAggregationInput | UserOrderByWithAggregationInput[];
    } | {
        orderBy?: UserOrderByWithAggregationInput | UserOrderByWithAggregationInput[];
    }
  • OrderFields extends
        | "username"
        | "dbId"
        | "locale"
        | "blacklisted"
        | "bitfield"
        | "userId"
        | "email"
        | "badges"
        | "oneServerPremium"
        | "serverPremiumCooldown"
        | "votes"
        | "lastVoted"
  • ByFields extends Prisma.UserScalarFieldEnum
  • ByValid extends 0 | 1
  • HavingFields extends string | number | symbol
  • HavingValid
  • ByEmpty extends 0 | 1
  • InputErrors

  Parameters

  • args: {
        [key in string | number | symbol]: key extends keyof UserGroupByArgs<DefaultArgs>
            ? T[key<key>]
            : never
    } & OrderByArg & InputErrors

    Group by arguments.

  Returns {} extends InputErrors
      ? GetUserGroupByPayload<T>
      : Prisma.PrismaPromise<InputErrors>

  Example

  // Group by city, order by createdAt, get count
  const result = await prisma.user.groupBy({
    by: ['city', 'createdAt'],
    orderBy: {
      createdAt: true
    },
    _count: {
      _all: true
    },
  })
  Copy

update

• update<T>(args): Prisma__UserClient<GetFindResult<$UserPayload<ExtArgs>, T, GlobalOmitOptions>, never, ExtArgs, GlobalOmitOptions>

• Update one User.

  Type Parameters

  • T extends UserUpdateArgs<DefaultArgs>

  Parameters

  • args: SelectSubset<T, UserUpdateArgs<ExtArgs>>

    Arguments to update one User.

  Returns Prisma__UserClient<GetFindResult<$UserPayload<ExtArgs>, T, GlobalOmitOptions>, never, ExtArgs, GlobalOmitOptions>

  Example

  // Update one User
  const user = await prisma.user.update({
    where: {
      // ... provide filter here
    },
    data: {
      // ... provide data here
    }
  })
  Copy

updateMany

• updateMany<T>(args): Prisma.PrismaPromise<BatchPayload>

• Update zero or more Users. Note, that providing undefined is treated as the value not being there. Read more here: https://pris.ly/d/null-undefined

  Type Parameters

  • T extends UserUpdateManyArgs<DefaultArgs>

  Parameters

  • args: SelectSubset<T, UserUpdateManyArgs<ExtArgs>>

    Arguments to update one or more rows.

  Returns Prisma.PrismaPromise<BatchPayload>

  Example

  // Update many Users
  const user = await prisma.user.updateMany({
    where: {
      // ... provide filter here
    },
    data: {
      // ... provide data here
    }
  })
  Copy

updateManyAndReturn

• updateManyAndReturn<T>(args): Prisma.PrismaPromise<GetFindResult<$UserPayload<ExtArgs>, T, GlobalOmitOptions>[]>

• Update zero or more Users and returns the data updated in the database.

  Type Parameters

  • T extends UserUpdateManyAndReturnArgs<DefaultArgs>

  Parameters

  • args: SelectSubset<T, UserUpdateManyAndReturnArgs<ExtArgs>>

    Arguments to update many Users.

  Returns Prisma.PrismaPromise<GetFindResult<$UserPayload<ExtArgs>, T, GlobalOmitOptions>[]>

  Example

  // Update many Users
  const user = await prisma.user.updateManyAndReturn({
    where: {
      // ... provide filter here
    },
    data: [
      // ... provide data here
    ]
  })
  
  // Update zero or more Users and only return the `dbId`
  const userWithDbIdOnly = await prisma.user.updateManyAndReturn({
    select: { dbId: true },
    where: {
      // ... provide filter here
    },
    data: [
      // ... provide data here
    ]
  })
  Note, that providing `undefined` is treated as the value not being there.
  Read more here: https://pris.ly/d/null-undefined
  Copy

upsert

• upsert<T>(args): Prisma__UserClient<GetFindResult<$UserPayload<ExtArgs>, T, GlobalOmitOptions>, never, ExtArgs, GlobalOmitOptions>

• Create or update one User.

  Type Parameters

  • T extends UserUpsertArgs<DefaultArgs>

  Parameters

  • args: SelectSubset<T, UserUpsertArgs<ExtArgs>>

    Arguments to update or create a User.

  Returns Prisma__UserClient<GetFindResult<$UserPayload<ExtArgs>, T, GlobalOmitOptions>, never, ExtArgs, GlobalOmitOptions>

  Example

  // Update or create a User
  const user = await prisma.user.upsert({
    create: {
      // ... data to create a User
    },
    update: {
      // ... in case it already exists, update
    },
    where: {
      // ... the filter for the User we want to update
    }
  })
  Copy