Interface UsersDelegate<ExtArgs, GlobalOmitOptions>

Readonlyfields

aggregate

• aggregate<T extends UsersAggregateArgs<DefaultArgs>>(
      args: Subset<T, UsersAggregateArgs>,
  ): Prisma.PrismaPromise<GetUsersAggregateType<T>>

  Allows you to perform aggregations operations on a 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 UsersAggregateArgs<DefaultArgs>

  Parameters

  • args: Subset<T, UsersAggregateArgs>

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

  Returns Prisma.PrismaPromise<GetUsersAggregateType<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 extends UsersCountArgs<DefaultArgs>>(
      args?: Subset<T, UsersCountArgs>,
  ): Prisma.PrismaPromise<
      T extends Record<"select", any>
          ? T<T>["select"] extends true
              ? number
              : {
                  [P in string | number | symbol]: P extends keyof UsersCountAggregateOutputType
                      ? UsersCountAggregateOutputType[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 UsersCountArgs<DefaultArgs>

  Parameters

  • Optionalargs: Subset<T, UsersCountArgs>

    Arguments to filter Users to count.

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

  Example

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

create

• create<T extends UsersCreateArgs<DefaultArgs>>(
      args: SelectSubset<T, UsersCreateArgs<ExtArgs>>,
  ): Prisma__UsersClient<
      GetFindResult<$UsersPayload<ExtArgs>, T, GlobalOmitOptions>,
      never,
      ExtArgs,
      GlobalOmitOptions,
  >

  Create a Users.

  Type Parameters

  • T extends UsersCreateArgs<DefaultArgs>

  Parameters

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

    Arguments to create a Users.

  Returns Prisma__UsersClient<
      GetFindResult<$UsersPayload<ExtArgs>, T, GlobalOmitOptions>,
      never,
      ExtArgs,
      GlobalOmitOptions,
  >

  Example

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

createMany

• createMany<T extends UsersCreateManyArgs<DefaultArgs>>(
      args?: SelectSubset<T, UsersCreateManyArgs<ExtArgs>>,
  ): Prisma.PrismaPromise<BatchPayload>

  Create many Users.

  Type Parameters

  • T extends UsersCreateManyArgs<DefaultArgs>

  Parameters

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

    Arguments to create many Users.

  Returns Prisma.PrismaPromise<BatchPayload>

  Example

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

createManyAndReturn

• createManyAndReturn<T extends UsersCreateManyAndReturnArgs<DefaultArgs>>(
      args?: SelectSubset<T, UsersCreateManyAndReturnArgs<ExtArgs>>,
  ): Prisma.PrismaPromise<
      GetFindResult<$UsersPayload<ExtArgs>, T, GlobalOmitOptions>[],
  >

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

  Type Parameters

  • T extends UsersCreateManyAndReturnArgs<DefaultArgs>

  Parameters

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

    Arguments to create many Users.

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

  Example

  // Create many Users
  const users = await prisma.users.createManyAndReturn({
    data: [
      // ... provide data here
    ]
  })
  
  // Create many Users and only return the `Id`
  const usersWithIdOnly = await prisma.users.createManyAndReturn({
    select: { Id: 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 extends UsersDeleteArgs<DefaultArgs>>(
      args: SelectSubset<T, UsersDeleteArgs<ExtArgs>>,
  ): Prisma__UsersClient<
      GetFindResult<$UsersPayload<ExtArgs>, T, GlobalOmitOptions>,
      never,
      ExtArgs,
      GlobalOmitOptions,
  >

  Delete a Users.

  Type Parameters

  • T extends UsersDeleteArgs<DefaultArgs>

  Parameters

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

    Arguments to delete one Users.

  Returns Prisma__UsersClient<
      GetFindResult<$UsersPayload<ExtArgs>, T, GlobalOmitOptions>,
      never,
      ExtArgs,
      GlobalOmitOptions,
  >

  Example

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

deleteMany

• deleteMany<T extends UsersDeleteManyArgs<DefaultArgs>>(
      args?: SelectSubset<T, UsersDeleteManyArgs<ExtArgs>>,
  ): Prisma.PrismaPromise<BatchPayload>

  Delete zero or more Users.

  Type Parameters

  • T extends UsersDeleteManyArgs<DefaultArgs>

  Parameters

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

    Arguments to filter Users to delete.

  Returns Prisma.PrismaPromise<BatchPayload>

  Example

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

findFirst

• findFirst<T extends UsersFindFirstArgs<DefaultArgs>>(
      args?: SelectSubset<T, UsersFindFirstArgs<ExtArgs>>,
  ): Prisma__UsersClient<
      GetFindResult<$UsersPayload<ExtArgs>, T, GlobalOmitOptions>,
      null,
      ExtArgs,
      GlobalOmitOptions,
  >

  Find the first 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 UsersFindFirstArgs<DefaultArgs>

  Parameters

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

    Arguments to find a Users

  Returns Prisma__UsersClient<
      GetFindResult<$UsersPayload<ExtArgs>, T, GlobalOmitOptions>,
      null,
      ExtArgs,
      GlobalOmitOptions,
  >

  Example

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

findFirstOrThrow

• findFirstOrThrow<T extends UsersFindFirstOrThrowArgs<DefaultArgs>>(
      args?: SelectSubset<T, UsersFindFirstOrThrowArgs<ExtArgs>>,
  ): Prisma__UsersClient<
      GetFindResult<$UsersPayload<ExtArgs>, T, GlobalOmitOptions>,
      never,
      ExtArgs,
      GlobalOmitOptions,
  >

  Find the first Users 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 UsersFindFirstOrThrowArgs<DefaultArgs>

  Parameters

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

    Arguments to find a Users

  Returns Prisma__UsersClient<
      GetFindResult<$UsersPayload<ExtArgs>, T, GlobalOmitOptions>,
      never,
      ExtArgs,
      GlobalOmitOptions,
  >

  Example

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

findMany

• findMany<T extends UsersFindManyArgs<DefaultArgs>>(
      args?: SelectSubset<T, UsersFindManyArgs<ExtArgs>>,
  ): Prisma.PrismaPromise<
      GetFindResult<$UsersPayload<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 UsersFindManyArgs<DefaultArgs>

  Parameters

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

    Arguments to filter and select certain fields only.

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

  Example

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

findUnique

• findUnique<T extends UsersFindUniqueArgs<DefaultArgs>>(
      args: SelectSubset<T, UsersFindUniqueArgs<ExtArgs>>,
  ): Prisma__UsersClient<
      GetFindResult<$UsersPayload<ExtArgs>, T, GlobalOmitOptions>,
      null,
      ExtArgs,
      GlobalOmitOptions,
  >

  Find zero or one Users that matches the filter.

  Type Parameters

  • T extends UsersFindUniqueArgs<DefaultArgs>

  Parameters

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

    Arguments to find a Users

  Returns Prisma__UsersClient<
      GetFindResult<$UsersPayload<ExtArgs>, T, GlobalOmitOptions>,
      null,
      ExtArgs,
      GlobalOmitOptions,
  >

  Example

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

findUniqueOrThrow

• findUniqueOrThrow<T extends UsersFindUniqueOrThrowArgs<DefaultArgs>>(
      args: SelectSubset<T, UsersFindUniqueOrThrowArgs<ExtArgs>>,
  ): Prisma__UsersClient<
      GetFindResult<$UsersPayload<ExtArgs>, T, GlobalOmitOptions>,
      never,
      ExtArgs,
      GlobalOmitOptions,
  >

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

  Type Parameters

  • T extends UsersFindUniqueOrThrowArgs<DefaultArgs>

  Parameters

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

    Arguments to find a Users

  Returns Prisma__UsersClient<
      GetFindResult<$UsersPayload<ExtArgs>, T, GlobalOmitOptions>,
      never,
      ExtArgs,
      GlobalOmitOptions,
  >

  Example

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

groupBy

• groupBy<
      T extends UsersGroupByArgs<DefaultArgs>,
      HasSelectOrTake extends 0 | 1,
      OrderByArg extends
      
              | {
                  orderBy: | UsersOrderByWithAggregationInput
                  | UsersOrderByWithAggregationInput[];
              }
              | {
                  orderBy?: | UsersOrderByWithAggregationInput
                  | UsersOrderByWithAggregationInput[];
              },
      OrderFields extends
          | "Id"
          | "UserId"
          | "Username"
          | "Votes"
          | "GloablVotes"
          | "LastVote"
          | "CustomerBots"
          | "BackupCount",
      ByFields extends Prisma.UsersScalarFieldEnum,
      ByValid extends 0 | 1,
      HavingFields extends string | number | symbol,
      HavingValid,
      ByEmpty extends 0 | 1,
      InputErrors,
  >(
      args: {
          [key in string | number | symbol]: key extends keyof UsersGroupByArgs<
              DefaultArgs,
          >
              ? T[key<key>]
              : never
      } & OrderByArg & InputErrors,
  ): {} extends InputErrors
      ? GetUsersGroupByPayload<T>
      : Prisma.PrismaPromise<InputErrors>

  Group by 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 UsersGroupByArgs<DefaultArgs>
  • HasSelectOrTake extends 0 | 1
  • OrderByArg extends
        | {
            orderBy: | UsersOrderByWithAggregationInput
            | UsersOrderByWithAggregationInput[];
        }
        | {
            orderBy?: | UsersOrderByWithAggregationInput
            | UsersOrderByWithAggregationInput[];
        }
  • OrderFields extends
        | "Id"
        | "UserId"
        | "Username"
        | "Votes"
        | "GloablVotes"
        | "LastVote"
        | "CustomerBots"
        | "BackupCount"
  • ByFields extends Prisma.UsersScalarFieldEnum
  • 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 UsersGroupByArgs<
            DefaultArgs,
        >
            ? T[key<key>]
            : never
    } & OrderByArg & InputErrors

    Group by arguments.

  Returns {} extends InputErrors
      ? GetUsersGroupByPayload<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 extends UsersUpdateArgs<DefaultArgs>>(
      args: SelectSubset<T, UsersUpdateArgs<ExtArgs>>,
  ): Prisma__UsersClient<
      GetFindResult<$UsersPayload<ExtArgs>, T, GlobalOmitOptions>,
      never,
      ExtArgs,
      GlobalOmitOptions,
  >

  Update one Users.

  Type Parameters

  • T extends UsersUpdateArgs<DefaultArgs>

  Parameters

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

    Arguments to update one Users.

  Returns Prisma__UsersClient<
      GetFindResult<$UsersPayload<ExtArgs>, T, GlobalOmitOptions>,
      never,
      ExtArgs,
      GlobalOmitOptions,
  >

  Example

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

updateMany

• updateMany<T extends UsersUpdateManyArgs<DefaultArgs>>(
      args: SelectSubset<T, UsersUpdateManyArgs<ExtArgs>>,
  ): 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 UsersUpdateManyArgs<DefaultArgs>

  Parameters

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

    Arguments to update one or more rows.

  Returns Prisma.PrismaPromise<BatchPayload>

  Example

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

updateManyAndReturn

• updateManyAndReturn<T extends UsersUpdateManyAndReturnArgs<DefaultArgs>>(
      args: SelectSubset<T, UsersUpdateManyAndReturnArgs<ExtArgs>>,
  ): Prisma.PrismaPromise<
      GetFindResult<$UsersPayload<ExtArgs>, T, GlobalOmitOptions>[],
  >

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

  Type Parameters

  • T extends UsersUpdateManyAndReturnArgs<DefaultArgs>

  Parameters

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

    Arguments to update many Users.

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

  Example

  // Update many Users
  const users = await prisma.users.updateManyAndReturn({
    where: {
      // ... provide filter here
    },
    data: [
      // ... provide data here
    ]
  })
  
  // Update zero or more Users and only return the `Id`
  const usersWithIdOnly = await prisma.users.updateManyAndReturn({
    select: { Id: 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 extends UsersUpsertArgs<DefaultArgs>>(
      args: SelectSubset<T, UsersUpsertArgs<ExtArgs>>,
  ): Prisma__UsersClient<
      GetFindResult<$UsersPayload<ExtArgs>, T, GlobalOmitOptions>,
      never,
      ExtArgs,
      GlobalOmitOptions,
  >

  Create or update one Users.

  Type Parameters

  • T extends UsersUpsertArgs<DefaultArgs>

  Parameters

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

    Arguments to update or create a Users.

  Returns Prisma__UsersClient<
      GetFindResult<$UsersPayload<ExtArgs>, T, GlobalOmitOptions>,
      never,
      ExtArgs,
      GlobalOmitOptions,
  >

  Example

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