;
/**
* Disconnect from the database
*/
$disconnect(): Promise;
/**
* Add a middleware
*/
$use(cb: Prisma.Middleware): void
/**
* Allows the running of a sequence of read/write operations that are guaranteed to either succeed or fail as a whole.
* @example
* ```
* const [george, bob, alice] = await prisma.$transaction([
* prisma.user.create({ data: { name: 'George' } }),
* prisma.user.create({ data: { name: 'Bob' } }),
* prisma.user.create({ data: { name: 'Alice' } }),
* ])
* ```
*
* Read more in our [docs](https://www.prisma.io/docs/concepts/components/prisma-client/transactions).
*/
$transaction[]>(arg: [...P]): Promise>;
$transaction(fn: (prisma: Prisma.TransactionClient) => Promise, options?: {maxWait?: number, timeout?: number}): Promise;
/**
* Executes a raw MongoDB command and returns the result of it.
* @example
* ```
* const user = await prisma.$runCommandRaw({
* aggregate: 'User',
* pipeline: [{ $match: { name: 'Bob' } }, { $project: { email: true, _id: false } }],
* explain: false,
* })
* ```
*
* Read more in our [docs](https://www.prisma.io/docs/reference/tools-and-interfaces/prisma-client/raw-database-access).
*/
$runCommandRaw(command: Prisma.InputJsonObject): PrismaPromise;
/**
* `prisma.post`: Exposes CRUD operations for the **Post** model.
* Example usage:
* ```ts
* // Fetch zero or more Posts
* const posts = await prisma.post.findMany()
* ```
*/
get post(): Prisma.PostDelegate;
/**
* `prisma.comment`: Exposes CRUD operations for the **Comment** model.
* Example usage:
* ```ts
* // Fetch zero or more Comments
* const comments = await prisma.comment.findMany()
* ```
*/
get comment(): Prisma.CommentDelegate;
/**
* `prisma.user`: Exposes CRUD operations for the **User** model.
* Example usage:
* ```ts
* // Fetch zero or more Users
* const users = await prisma.user.findMany()
* ```
*/
get user(): Prisma.UserDelegate;
}
export namespace Prisma {
export import DMMF = runtime.DMMF
/**
* Prisma Errors
*/
export import PrismaClientKnownRequestError = runtime.PrismaClientKnownRequestError
export import PrismaClientUnknownRequestError = runtime.PrismaClientUnknownRequestError
export import PrismaClientRustPanicError = runtime.PrismaClientRustPanicError
export import PrismaClientInitializationError = runtime.PrismaClientInitializationError
export import PrismaClientValidationError = runtime.PrismaClientValidationError
export import NotFoundError = runtime.NotFoundError
/**
* Re-export of sql-template-tag
*/
export import sql = runtime.sqltag
export import empty = runtime.empty
export import join = runtime.join
export import raw = runtime.raw
export import Sql = runtime.Sql
/**
* Decimal.js
*/
export import Decimal = runtime.Decimal
export type DecimalJsLike = runtime.DecimalJsLike
/**
* Metrics
*/
export type Metrics = runtime.Metrics
export type Metric = runtime.Metric
export type MetricHistogram = runtime.MetricHistogram
export type MetricHistogramBucket = runtime.MetricHistogramBucket
/**
* Prisma Client JS version: 4.8.0
* Query Engine version: d6e67a83f971b175a593ccc12e15c4a757f93ffe
*/
export type PrismaVersion = {
client: string
}
export const prismaVersion: PrismaVersion
/**
* Utility Types
*/
/**
* From https://github.com/sindresorhus/type-fest/
* Matches a JSON object.
* This type can be useful to enforce some input to be JSON-compatible or as a super-type to be extended from.
*/
export type JsonObject = {[Key in string]?: JsonValue}
/**
* From https://github.com/sindresorhus/type-fest/
* Matches a JSON array.
*/
export interface JsonArray extends Array {}
/**
* From https://github.com/sindresorhus/type-fest/
* Matches any valid JSON value.
*/
export type JsonValue = string | number | boolean | JsonObject | JsonArray | null
/**
* Matches a JSON object.
* Unlike `JsonObject`, this type allows undefined and read-only properties.
*/
export type InputJsonObject = {readonly [Key in string]?: InputJsonValue | null}
/**
* Matches a JSON array.
* Unlike `JsonArray`, readonly arrays are assignable to this type.
*/
export interface InputJsonArray extends ReadonlyArray {}
/**
* Matches any valid value that can be used as an input for operations like
* create and update as the value of a JSON field. Unlike `JsonValue`, this
* type allows read-only arrays and read-only object properties and disallows
* `null` at the top level.
*
* `null` cannot be used as the value of a JSON field because its meaning
* would be ambiguous. Use `Prisma.JsonNull` to store the JSON null value or
* `Prisma.DbNull` to clear the JSON value and set the field to the database
* NULL value instead.
*
* @see https://www.prisma.io/docs/concepts/components/prisma-client/working-with-fields/working-with-json-fields#filtering-by-null-values
*/
export type InputJsonValue = string | number | boolean | InputJsonObject | InputJsonArray
/**
* Types of the values used to represent different kinds of `null` values when working with JSON fields.
*
* @see https://www.prisma.io/docs/concepts/components/prisma-client/working-with-fields/working-with-json-fields#filtering-on-a-json-field
*/
namespace NullTypes {
/**
* Type of `Prisma.DbNull`.
*
* You cannot use other instances of this class. Please use the `Prisma.DbNull` value.
*
* @see https://www.prisma.io/docs/concepts/components/prisma-client/working-with-fields/working-with-json-fields#filtering-on-a-json-field
*/
class DbNull {
private DbNull: never
private constructor()
}
/**
* Type of `Prisma.JsonNull`.
*
* You cannot use other instances of this class. Please use the `Prisma.JsonNull` value.
*
* @see https://www.prisma.io/docs/concepts/components/prisma-client/working-with-fields/working-with-json-fields#filtering-on-a-json-field
*/
class JsonNull {
private JsonNull: never
private constructor()
}
/**
* Type of `Prisma.AnyNull`.
*
* You cannot use other instances of this class. Please use the `Prisma.AnyNull` value.
*
* @see https://www.prisma.io/docs/concepts/components/prisma-client/working-with-fields/working-with-json-fields#filtering-on-a-json-field
*/
class AnyNull {
private AnyNull: never
private constructor()
}
}
/**
* Helper for filtering JSON entries that have `null` on the database (empty on the db)
*
* @see https://www.prisma.io/docs/concepts/components/prisma-client/working-with-fields/working-with-json-fields#filtering-on-a-json-field
*/
export const DbNull: NullTypes.DbNull
/**
* Helper for filtering JSON entries that have JSON `null` values (not empty on the db)
*
* @see https://www.prisma.io/docs/concepts/components/prisma-client/working-with-fields/working-with-json-fields#filtering-on-a-json-field
*/
export const JsonNull: NullTypes.JsonNull
/**
* Helper for filtering JSON entries that are `Prisma.DbNull` or `Prisma.JsonNull`
*
* @see https://www.prisma.io/docs/concepts/components/prisma-client/working-with-fields/working-with-json-fields#filtering-on-a-json-field
*/
export const AnyNull: NullTypes.AnyNull
type SelectAndInclude = {
select: any
include: any
}
type HasSelect = {
select: any
}
type HasInclude = {
include: any
}
type CheckSelect = T extends SelectAndInclude
? 'Please either choose `select` or `include`'
: T extends HasSelect
? U
: T extends HasInclude
? U
: S
/**
* Get the type of the value, that the Promise holds.
*/
export type PromiseType> = T extends PromiseLike ? U : T;
/**
* Get the return type of a function which returns a Promise.
*/
export type PromiseReturnType Promise> = PromiseType>
/**
* From T, pick a set of properties whose keys are in the union K
*/
type Prisma__Pick = {
[P in K]: T[P];
};
export type Enumerable = T | Array;
export type RequiredKeys = {
[K in keyof T]-?: {} extends Prisma__Pick ? never : K
}[keyof T]
export type TruthyKeys = keyof {
[K in keyof T as T[K] extends false | undefined | null ? never : K]: K
}
export type TrueKeys = TruthyKeys>>
/**
* Subset
* @desc From `T` pick properties that exist in `U`. Simple version of Intersection
*/
export type Subset = {
[key in keyof T]: key extends keyof U ? T[key] : never;
};
/**
* SelectSubset
* @desc From `T` pick properties that exist in `U`. Simple version of Intersection.
* Additionally, it validates, if both select and include are present. If the case, it errors.
*/
export type SelectSubset = {
[key in keyof T]: key extends keyof U ? T[key] : never
} &
(T extends SelectAndInclude
? 'Please either choose `select` or `include`.'
: {})
/**
* Subset + Intersection
* @desc From `T` pick properties that exist in `U` and intersect `K`
*/
export type SubsetIntersection = {
[key in keyof T]: key extends keyof U ? T[key] : never
} &
K
type Without = { [P in Exclude]?: never };
/**
* XOR is needed to have a real mutually exclusive union type
* https://stackoverflow.com/questions/42123407/does-typescript-support-mutually-exclusive-types
*/
type XOR =
T extends object ?
U extends object ?
(Without & U) | (Without & T)
: U : T
/**
* Is T a Record?
*/
type IsObject = T extends Array
? False
: T extends Date
? False
: T extends Uint8Array
? False
: T extends BigInt
? False
: T extends object
? True
: False
/**
* If it's T[], return T
*/
export type UnEnumerate = T extends Array ? U : T
/**
* From ts-toolbelt
*/
type __Either = Omit &
{
// Merge all but K
[P in K]: Prisma__Pick // With K possibilities
}[K]
type EitherStrict = Strict<__Either>
type EitherLoose = ComputeRaw<__Either>
type _Either<
O extends object,
K extends Key,
strict extends Boolean
> = {
1: EitherStrict
0: EitherLoose
}[strict]
type Either<
O extends object,
K extends Key,
strict extends Boolean = 1
> = O extends unknown ? _Either : never
export type Union = any
type PatchUndefined = {
[K in keyof O]: O[K] extends undefined ? At : O[K]
} & {}
/** Helper Types for "Merge" **/
export type IntersectOf = (
U extends unknown ? (k: U) => void : never
) extends (k: infer I) => void
? I
: never
export type Overwrite = {
[K in keyof O]: K extends keyof O1 ? O1[K] : O[K];
} & {};
type _Merge = IntersectOf;
}>>;
type Key = string | number | symbol;
type AtBasic = K extends keyof O ? O[K] : never;
type AtStrict = O[K & keyof O];
type AtLoose = O extends unknown ? AtStrict : never;
export type At = {
1: AtStrict;
0: AtLoose;
}[strict];
export type ComputeRaw = A extends Function ? A : {
[K in keyof A]: A[K];
} & {};
export type OptionalFlat = {
[K in keyof O]?: O[K];
} & {};
type _Record = {
[P in K]: T;
};
// cause typescript not to expand types and preserve names
type NoExpand = T extends unknown ? T : never;
// this type assumes the passed object is entirely optional
type AtLeast = NoExpand<
O extends unknown
? | (K extends keyof O ? { [P in K]: O[P] } & O : O)
| {[P in keyof O as P extends K ? K : never]-?: O[P]} & O
: never>;
type _Strict = U extends unknown ? U & OptionalFlat<_Record, keyof U>, never>> : never;
export type Strict = ComputeRaw<_Strict>;
/** End Helper Types for "Merge" **/
export type Merge = ComputeRaw<_Merge>>;
/**
A [[Boolean]]
*/
export type Boolean = True | False
// /**
// 1
// */
export type True = 1
/**
0
*/
export type False = 0
export type Not = {
0: 1
1: 0
}[B]
export type Extends = [A1] extends [never]
? 0 // anything `never` is false
: A1 extends A2
? 1
: 0
export type Has = Not<
Extends, U1>
>
export type Or = {
0: {
0: 0
1: 1
}
1: {
0: 1
1: 1
}
}[B1][B2]
export type Keys = U extends unknown ? keyof U : never
type Exact =
W extends unknown ? A extends Narrowable ? Cast : Cast<
{[K in keyof A]: K extends keyof W ? Exact : never},
{[K in keyof W]: K extends keyof A ? Exact : W[K]}>
: never;
type Narrowable = string | number | boolean | bigint;
type Cast = A extends B ? A : B;
export const type: unique symbol;
export function validator(): (select: Exact) => S;
/**
* Used by group by
*/
export type GetScalarType = O extends object ? {
[P in keyof T]: P extends keyof O
? O[P]
: never
} : never
type FieldPaths<
T,
U = Omit
> = IsObject extends True ? U : T
type GetHavingFields = {
[K in keyof T]: Or<
Or, Extends<'AND', K>>,
Extends<'NOT', K>
> extends True
? // infer is only needed to not hit TS limit
// based on the brilliant idea of Pierre-Antoine Mills
// https://github.com/microsoft/TypeScript/issues/30188#issuecomment-478938437
T[K] extends infer TK
? GetHavingFields extends object ? Merge> : never>
: never
: {} extends FieldPaths
? never
: K
}[keyof T]
/**
* Convert tuple to union
*/
type _TupleToUnion = T extends (infer E)[] ? E : never
type TupleToUnion = _TupleToUnion
type MaybeTupleToUnion = T extends any[] ? TupleToUnion : T
/**
* Like `Pick`, but with an array
*/
type PickArray> = Prisma__Pick>
/**
* Exclude all keys with underscores
*/
type ExcludeUnderscoreKeys = T extends `_${string}` ? never : T
export type FieldRef = runtime.FieldRef
type FieldRefInputType = Model extends never ? never : FieldRef
class PrismaClientFetcher {
private readonly prisma;
private readonly debug;
private readonly hooks?;
constructor(prisma: PrismaClient, debug?: boolean, hooks?: Hooks | undefined);
request(document: any, dataPath?: string[], rootField?: string, typeName?: string, isList?: boolean, callsite?: string): Promise;
sanitizeMessage(message: string): string;
protected unpack(document: any, data: any, path: string[], rootField?: string, isList?: boolean): any;
}
export const ModelName: {
Post: 'Post',
Comment: 'Comment',
User: 'User'
};
export type ModelName = (typeof ModelName)[keyof typeof ModelName]
export type Datasources = {
db?: Datasource
}
export type DefaultPrismaClient = PrismaClient
export type RejectOnNotFound = boolean | ((error: Error) => Error)
export type RejectPerModel = { [P in ModelName]?: RejectOnNotFound }
export type RejectPerOperation = { [P in "findUnique" | "findFirst"]?: RejectPerModel | RejectOnNotFound }
type IsReject = T extends true ? True : T extends (err: Error) => Error ? True : False
export type HasReject<
GlobalRejectSettings extends Prisma.PrismaClientOptions['rejectOnNotFound'],
LocalRejectSettings,
Action extends PrismaAction,
Model extends ModelName
> = LocalRejectSettings extends RejectOnNotFound
? IsReject
: GlobalRejectSettings extends RejectPerOperation
? Action extends keyof GlobalRejectSettings
? GlobalRejectSettings[Action] extends RejectOnNotFound
? IsReject
: GlobalRejectSettings[Action] extends RejectPerModel
? Model extends keyof GlobalRejectSettings[Action]
? IsReject
: False
: False
: False
: IsReject
export type ErrorFormat = 'pretty' | 'colorless' | 'minimal'
export interface PrismaClientOptions {
/**
* Configure findUnique/findFirst to throw an error if the query returns null.
* @deprecated since 4.0.0. Use `findUniqueOrThrow`/`findFirstOrThrow` methods instead.
* @example
* ```
* // Reject on both findUnique/findFirst
* rejectOnNotFound: true
* // Reject only on findFirst with a custom error
* rejectOnNotFound: { findFirst: (err) => new Error("Custom Error")}
* // Reject on user.findUnique with a custom error
* rejectOnNotFound: { findUnique: {User: (err) => new Error("User not found")}}
* ```
*/
rejectOnNotFound?: RejectOnNotFound | RejectPerOperation
/**
* Overwrites the datasource url from your schema.prisma file
*/
datasources?: Datasources
/**
* @default "colorless"
*/
errorFormat?: ErrorFormat
/**
* @example
* ```
* // Defaults to stdout
* log: ['query', 'info', 'warn', 'error']
*
* // Emit as events
* log: [
* { emit: 'stdout', level: 'query' },
* { emit: 'stdout', level: 'info' },
* { emit: 'stdout', level: 'warn' }
* { emit: 'stdout', level: 'error' }
* ]
* ```
* Read more in our [docs](https://www.prisma.io/docs/reference/tools-and-interfaces/prisma-client/logging#the-log-option).
*/
log?: Array
}
export type Hooks = {
beforeRequest?: (options: { query: string, path: string[], rootField?: string, typeName?: string, document: any }) => any
}
/* Types for Logging */
export type LogLevel = 'info' | 'query' | 'warn' | 'error'
export type LogDefinition = {
level: LogLevel
emit: 'stdout' | 'event'
}
export type GetLogType = T extends LogDefinition ? T['emit'] extends 'event' ? T['level'] : never : never
export type GetEvents = T extends Array ?
GetLogType | GetLogType | GetLogType | GetLogType
: never
export type QueryEvent = {
timestamp: Date
query: string
params: string
duration: number
target: string
}
export type LogEvent = {
timestamp: Date
message: string
target: string
}
/* End Types for Logging */
export type PrismaAction =
| 'findUnique'
| 'findMany'
| 'findFirst'
| 'create'
| 'createMany'
| 'update'
| 'updateMany'
| 'upsert'
| 'delete'
| 'deleteMany'
| 'executeRaw'
| 'queryRaw'
| 'aggregate'
| 'count'
| 'runCommandRaw'
| 'findRaw'
/**
* These options are being passed into the middleware as "params"
*/
export type MiddlewareParams = {
model?: ModelName
action: PrismaAction
args: any
dataPath: string[]
runInTransaction: boolean
}
/**
* The `T` type makes sure, that the `return proceed` is not forgotten in the middleware implementation
*/
export type Middleware = (
params: MiddlewareParams,
next: (params: MiddlewareParams) => Promise,
) => Promise
// tested in getLogLevel.test.ts
export function getLogLevel(log: Array): LogLevel | undefined;
/**
* `PrismaClient` proxy available in interactive transactions.
*/
export type TransactionClient = Omit
export type Datasource = {
url?: string
}
/**
* Count Types
*/
/**
* Count Type PostCountOutputType
*/
export type PostCountOutputType = {
comments: number
}
export type PostCountOutputTypeSelect = {
comments?: boolean
}
export type PostCountOutputTypeGetPayload =
S extends { select: any, include: any } ? 'Please either choose `select` or `include`' :
S extends true ? PostCountOutputType :
S extends undefined ? never :
S extends { include: any } & (PostCountOutputTypeArgs)
? PostCountOutputType
: S extends { select: any } & (PostCountOutputTypeArgs)
? {
[P in TruthyKeys]:
P extends keyof PostCountOutputType ? PostCountOutputType[P] : never
}
: PostCountOutputType
// Custom InputTypes
/**
* PostCountOutputType without action
*/
export type PostCountOutputTypeArgs = {
/**
* Select specific fields to fetch from the PostCountOutputType
*
**/
select?: PostCountOutputTypeSelect | null
}
/**
* Count Type UserCountOutputType
*/
export type UserCountOutputType = {
posts: number
}
export type UserCountOutputTypeSelect = {
posts?: boolean
}
export type UserCountOutputTypeGetPayload =
S extends { select: any, include: any } ? 'Please either choose `select` or `include`' :
S extends true ? UserCountOutputType :
S extends undefined ? never :
S extends { include: any } & (UserCountOutputTypeArgs)
? UserCountOutputType
: S extends { select: any } & (UserCountOutputTypeArgs)
? {
[P in TruthyKeys]:
P extends keyof UserCountOutputType ? UserCountOutputType[P] : never
}
: UserCountOutputType
// Custom InputTypes
/**
* UserCountOutputType without action
*/
export type UserCountOutputTypeArgs = {
/**
* Select specific fields to fetch from the UserCountOutputType
*
**/
select?: UserCountOutputTypeSelect | null
}
/**
* Models
*/
/**
* Model UserAddress
*/
export type UserAddressSelect = {
street?: boolean
number?: boolean
city?: boolean
}
export type UserAddressGetPayload =
S extends { select: any, include: any } ? 'Please either choose `select` or `include`' :
S extends true ? UserAddress :
S extends undefined ? never :
S extends { include: any } & (UserAddressArgs)
? UserAddress
: S extends { select: any } & (UserAddressArgs)
? {
[P in TruthyKeys]:
P extends keyof UserAddress ? UserAddress[P] : never
}
: UserAddress
export interface UserAddressDelegate {
}
/**
* The delegate class that acts as a "Promise-like" for UserAddress.
* Why is this prefixed with `Prisma__`?
* Because we want to prevent naming conflicts as mentioned in
* https://github.com/prisma/prisma-client-js/issues/707
*/
export class Prisma__UserAddressClient implements PrismaPromise {
[prisma]: true;
private readonly _dmmf;
private readonly _fetcher;
private readonly _queryType;
private readonly _rootField;
private readonly _clientMethod;
private readonly _args;
private readonly _dataPath;
private readonly _errorFormat;
private readonly _measurePerformance?;
private _isList;
private _callsite;
private _requestPromise?;
constructor(_dmmf: runtime.DMMFClass, _fetcher: PrismaClientFetcher, _queryType: 'query' | 'mutation', _rootField: string, _clientMethod: string, _args: any, _dataPath: string[], _errorFormat: ErrorFormat, _measurePerformance?: boolean | undefined, _isList?: boolean);
readonly [Symbol.toStringTag]: 'PrismaClientPromise';
private get _document();
/**
* Attaches callbacks for the resolution and/or rejection of the Promise.
* @param onfulfilled The callback to execute when the Promise is resolved.
* @param onrejected The callback to execute when the Promise is rejected.
* @returns A Promise for the completion of which ever callback is executed.
*/
then(onfulfilled?: ((value: T) => TResult1 | PromiseLike) | undefined | null, onrejected?: ((reason: any) => TResult2 | PromiseLike) | undefined | null): Promise;
/**
* Attaches a callback for only the rejection of the Promise.
* @param onrejected The callback to execute when the Promise is rejected.
* @returns A Promise for the completion of the callback.
*/
catch(onrejected?: ((reason: any) => TResult | PromiseLike) | undefined | null): Promise;
/**
* Attaches a callback that is invoked when the Promise is settled (fulfilled or rejected). The
* resolved value cannot be modified from the callback.
* @param onfinally The callback to execute when the Promise is settled (fulfilled or rejected).
* @returns A Promise for the completion of the callback.
*/
finally(onfinally?: (() => void) | undefined | null): Promise;
}
// Custom InputTypes
/**
* UserAddress without action
*/
export type UserAddressArgs = {
/**
* Select specific fields to fetch from the UserAddress
*
**/
select?: UserAddressSelect | null
}
/**
* Model Post
*/
export type AggregatePost = {
_count: PostCountAggregateOutputType | null
_min: PostMinAggregateOutputType | null
_max: PostMaxAggregateOutputType | null
}
export type PostMinAggregateOutputType = {
id: string | null
slug: string | null
title: string | null
body: string | null
authorId: string | null
}
export type PostMaxAggregateOutputType = {
id: string | null
slug: string | null
title: string | null
body: string | null
authorId: string | null
}
export type PostCountAggregateOutputType = {
id: number
slug: number
title: number
body: number
authorId: number
_all: number
}
export type PostMinAggregateInputType = {
id?: true
slug?: true
title?: true
body?: true
authorId?: true
}
export type PostMaxAggregateInputType = {
id?: true
slug?: true
title?: true
body?: true
authorId?: true
}
export type PostCountAggregateInputType = {
id?: true
slug?: true
title?: true
body?: true
authorId?: true
_all?: true
}
export type PostAggregateArgs = {
/**
* Filter which Post to aggregate.
*
**/
where?: PostWhereInput
/**
* {@link https://www.prisma.io/docs/concepts/components/prisma-client/sorting Sorting Docs}
*
* Determine the order of Posts to fetch.
*
**/
orderBy?: Enumerable
/**
* {@link https://www.prisma.io/docs/concepts/components/prisma-client/pagination#cursor-based-pagination Cursor Docs}
*
* Sets the start position
*
**/
cursor?: PostWhereUniqueInput
/**
* {@link https://www.prisma.io/docs/concepts/components/prisma-client/pagination Pagination Docs}
*
* Take `±n` Posts from the position of the cursor.
*
**/
take?: number
/**
* {@link https://www.prisma.io/docs/concepts/components/prisma-client/pagination Pagination Docs}
*
* Skip the first `n` Posts.
*
**/
skip?: number
/**
* {@link https://www.prisma.io/docs/concepts/components/prisma-client/aggregations Aggregation Docs}
*
* Count returned Posts
**/
_count?: true | PostCountAggregateInputType
/**
* {@link https://www.prisma.io/docs/concepts/components/prisma-client/aggregations Aggregation Docs}
*
* Select which fields to find the minimum value
**/
_min?: PostMinAggregateInputType
/**
* {@link https://www.prisma.io/docs/concepts/components/prisma-client/aggregations Aggregation Docs}
*
* Select which fields to find the maximum value
**/
_max?: PostMaxAggregateInputType
}
export type GetPostAggregateType = {
[P in keyof T & keyof AggregatePost]: P extends '_count' | 'count'
? T[P] extends true
? number
: GetScalarType
: GetScalarType
}
export type PostGroupByArgs = {
where?: PostWhereInput
orderBy?: Enumerable
by: Array
having?: PostScalarWhereWithAggregatesInput
take?: number
skip?: number
_count?: PostCountAggregateInputType | true
_min?: PostMinAggregateInputType
_max?: PostMaxAggregateInputType
}
export type PostGroupByOutputType = {
id: string
slug: string
title: string
body: string
authorId: string
_count: PostCountAggregateOutputType | null
_min: PostMinAggregateOutputType | null
_max: PostMaxAggregateOutputType | null
}
type GetPostGroupByPayload = PrismaPromise<
Array<
PickArray &
{
[P in ((keyof T) & (keyof PostGroupByOutputType))]: P extends '_count'
? T[P] extends boolean
? number
: GetScalarType
: GetScalarType
}
>
>
export type PostSelect = {
id?: boolean
slug?: boolean
title?: boolean
body?: boolean
comments?: boolean | PostCommentsArgs
author?: boolean | UserArgs
authorId?: boolean
_count?: boolean | PostCountOutputTypeArgs
}
export type PostInclude = {
comments?: boolean | PostCommentsArgs
author?: boolean | UserArgs
_count?: boolean | PostCountOutputTypeArgs
}
export type PostGetPayload =
S extends { select: any, include: any } ? 'Please either choose `select` or `include`' :
S extends true ? Post :
S extends undefined ? never :
S extends { include: any } & (PostArgs | PostFindManyArgs)
? Post & {
[P in TruthyKeys]:
P extends 'comments' ? Array < CommentGetPayload> :
P extends 'author' ? UserGetPayload :
P extends '_count' ? PostCountOutputTypeGetPayload : never
}
: S extends { select: any } & (PostArgs | PostFindManyArgs)
? {
[P in TruthyKeys]:
P extends 'comments' ? Array < CommentGetPayload> :
P extends 'author' ? UserGetPayload :
P extends '_count' ? PostCountOutputTypeGetPayload : P extends keyof Post ? Post[P] : never
}
: Post
type PostCountArgs = Merge<
Omit & {
select?: PostCountAggregateInputType | true
}
>
export interface PostDelegate {
/**
* Find zero or one Post that matches the filter.
* @param {PostFindUniqueArgs} args - Arguments to find a Post
* @example
* // Get one Post
* const post = await prisma.post.findUnique({
* where: {
* // ... provide filter here
* }
* })
**/
findUnique(
args: SelectSubset
): HasReject extends True ? Prisma__PostClient> : Prisma__PostClient | null, null>
/**
* Find one Post that matches the filter or throw an error with `error.code='P2025'`
* if no matches were found.
* @param {PostFindUniqueOrThrowArgs} args - Arguments to find a Post
* @example
* // Get one Post
* const post = await prisma.post.findUniqueOrThrow({
* where: {
* // ... provide filter here
* }
* })
**/
findUniqueOrThrow(
args?: SelectSubset
): Prisma__PostClient>
/**
* Find the first Post 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
* @param {PostFindFirstArgs} args - Arguments to find a Post
* @example
* // Get one Post
* const post = await prisma.post.findFirst({
* where: {
* // ... provide filter here
* }
* })
**/
findFirst(
args?: SelectSubset
): HasReject extends True ? Prisma__PostClient> : Prisma__PostClient | null, null>
/**
* Find the first Post that matches the filter or
* throw `NotFoundError` 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
* @param {PostFindFirstOrThrowArgs} args - Arguments to find a Post
* @example
* // Get one Post
* const post = await prisma.post.findFirstOrThrow({
* where: {
* // ... provide filter here
* }
* })
**/
findFirstOrThrow(
args?: SelectSubset
): Prisma__PostClient>
/**
* Find zero or more Posts 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
* @param {PostFindManyArgs=} args - Arguments to filter and select certain fields only.
* @example
* // Get all Posts
* const posts = await prisma.post.findMany()
*
* // Get first 10 Posts
* const posts = await prisma.post.findMany({ take: 10 })
*
* // Only select the `id`
* const postWithIdOnly = await prisma.post.findMany({ select: { id: true } })
*
**/
findMany(
args?: SelectSubset
): PrismaPromise>>
/**
* Create a Post.
* @param {PostCreateArgs} args - Arguments to create a Post.
* @example
* // Create one Post
* const Post = await prisma.post.create({
* data: {
* // ... data to create a Post
* }
* })
*
**/
create(
args: SelectSubset
): Prisma__PostClient>
/**
* Create many Posts.
* @param {PostCreateManyArgs} args - Arguments to create many Posts.
* @example
* // Create many Posts
* const post = await prisma.post.createMany({
* data: {
* // ... provide data here
* }
* })
*
**/
createMany(
args?: SelectSubset
): PrismaPromise
/**
* Delete a Post.
* @param {PostDeleteArgs} args - Arguments to delete one Post.
* @example
* // Delete one Post
* const Post = await prisma.post.delete({
* where: {
* // ... filter to delete one Post
* }
* })
*
**/
delete(
args: SelectSubset
): Prisma__PostClient>
/**
* Update one Post.
* @param {PostUpdateArgs} args - Arguments to update one Post.
* @example
* // Update one Post
* const post = await prisma.post.update({
* where: {
* // ... provide filter here
* },
* data: {
* // ... provide data here
* }
* })
*
**/
update(
args: SelectSubset
): Prisma__PostClient>
/**
* Delete zero or more Posts.
* @param {PostDeleteManyArgs} args - Arguments to filter Posts to delete.
* @example
* // Delete a few Posts
* const { count } = await prisma.post.deleteMany({
* where: {
* // ... provide filter here
* }
* })
*
**/
deleteMany(
args?: SelectSubset
): PrismaPromise
/**
* Update zero or more Posts.
* Note, that providing `undefined` is treated as the value not being there.
* Read more here: https://pris.ly/d/null-undefined
* @param {PostUpdateManyArgs} args - Arguments to update one or more rows.
* @example
* // Update many Posts
* const post = await prisma.post.updateMany({
* where: {
* // ... provide filter here
* },
* data: {
* // ... provide data here
* }
* })
*
**/
updateMany(
args: SelectSubset
): PrismaPromise
/**
* Create or update one Post.
* @param {PostUpsertArgs} args - Arguments to update or create a Post.
* @example
* // Update or create a Post
* const post = await prisma.post.upsert({
* create: {
* // ... data to create a Post
* },
* update: {
* // ... in case it already exists, update
* },
* where: {
* // ... the filter for the Post we want to update
* }
* })
**/
upsert(
args: SelectSubset
): Prisma__PostClient>
/**
* Find zero or more Posts that matches the filter.
* @param {PostFindRawArgs} args - Select which filters you would like to apply.
* @example
* const post = await prisma.post.findRaw({
* filter: { age: { $gt: 25 } }
* })
**/
findRaw(
args?: PostFindRawArgs
): PrismaPromise
/**
* Perform aggregation operations on a Post.
* @param {PostAggregateRawArgs} args - Select which aggregations you would like to apply.
* @example
* const post = await prisma.post.aggregateRaw({
* pipeline: [
* { $match: { status: "registered" } },
* { $group: { _id: "$country", total: { $sum: 1 } } }
* ]
* })
**/
aggregateRaw(
args?: PostAggregateRawArgs
): PrismaPromise
/**
* Count the number of Posts.
* Note, that providing `undefined` is treated as the value not being there.
* Read more here: https://pris.ly/d/null-undefined
* @param {PostCountArgs} args - Arguments to filter Posts to count.
* @example
* // Count the number of Posts
* const count = await prisma.post.count({
* where: {
* // ... the filter for the Posts we want to count
* }
* })
**/
count(
args?: Subset,
): PrismaPromise<
T extends _Record<'select', any>
? T['select'] extends true
? number
: GetScalarType
: number
>
/**
* Allows you to perform aggregations operations on a Post.
* Note, that providing `undefined` is treated as the value not being there.
* Read more here: https://pris.ly/d/null-undefined
* @param {PostAggregateArgs} args - Select which aggregations you would like to apply and on what fields.
* @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,
* })
**/
aggregate(args: Subset): PrismaPromise>
/**
* Group by Post.
* Note, that providing `undefined` is treated as the value not being there.
* Read more here: https://pris.ly/d/null-undefined
* @param {PostGroupByArgs} args - Group by arguments.
* @example
* // Group by city, order by createdAt, get count
* const result = await prisma.user.groupBy({
* by: ['city', 'createdAt'],
* orderBy: {
* createdAt: true
* },
* _count: {
* _all: true
* },
* })
*
**/
groupBy<
T extends PostGroupByArgs,
HasSelectOrTake extends Or<
Extends<'skip', Keys>,
Extends<'take', Keys>
>,
OrderByArg extends True extends HasSelectOrTake
? { orderBy: PostGroupByArgs['orderBy'] }
: { orderBy?: PostGroupByArgs['orderBy'] },
OrderFields extends ExcludeUnderscoreKeys>>,
ByFields extends TupleToUnion,
ByValid extends Has,
HavingFields extends GetHavingFields,
HavingValid extends Has,
ByEmpty extends T['by'] extends never[] ? True : False,
InputErrors extends ByEmpty extends True
? `Error: "by" must not be empty.`
: HavingValid extends False
? {
[P in HavingFields]: P extends ByFields
? never
: P extends string
? `Error: Field "${P}" used in "having" needs to be provided in "by".`
: [
Error,
'Field ',
P,
` in "having" needs to be provided in "by"`,
]
}[HavingFields]
: 'take' extends Keys
? 'orderBy' extends Keys
? ByValid extends True
? {}
: {
[P in OrderFields]: P extends ByFields
? never
: `Error: Field "${P}" in "orderBy" needs to be provided in "by"`
}[OrderFields]
: 'Error: If you provide "take", you also need to provide "orderBy"'
: 'skip' extends Keys
? 'orderBy' extends Keys
? ByValid extends True
? {}
: {
[P in OrderFields]: P extends ByFields
? never
: `Error: Field "${P}" in "orderBy" needs to be provided in "by"`
}[OrderFields]
: 'Error: If you provide "skip", you also need to provide "orderBy"'
: ByValid extends True
? {}
: {
[P in OrderFields]: P extends ByFields
? never
: `Error: Field "${P}" in "orderBy" needs to be provided in "by"`
}[OrderFields]
>(args: SubsetIntersection & InputErrors): {} extends InputErrors ? GetPostGroupByPayload : PrismaPromise
}
/**
* The delegate class that acts as a "Promise-like" for Post.
* Why is this prefixed with `Prisma__`?
* Because we want to prevent naming conflicts as mentioned in
* https://github.com/prisma/prisma-client-js/issues/707
*/
export class Prisma__PostClient implements PrismaPromise {
[prisma]: true;
private readonly _dmmf;
private readonly _fetcher;
private readonly _queryType;
private readonly _rootField;
private readonly _clientMethod;
private readonly _args;
private readonly _dataPath;
private readonly _errorFormat;
private readonly _measurePerformance?;
private _isList;
private _callsite;
private _requestPromise?;
constructor(_dmmf: runtime.DMMFClass, _fetcher: PrismaClientFetcher, _queryType: 'query' | 'mutation', _rootField: string, _clientMethod: string, _args: any, _dataPath: string[], _errorFormat: ErrorFormat, _measurePerformance?: boolean | undefined, _isList?: boolean);
readonly [Symbol.toStringTag]: 'PrismaClientPromise';
comments(args?: Subset): PrismaPromise>| Null>;
author(args?: Subset): Prisma__UserClient | Null>;
private get _document();
/**
* Attaches callbacks for the resolution and/or rejection of the Promise.
* @param onfulfilled The callback to execute when the Promise is resolved.
* @param onrejected The callback to execute when the Promise is rejected.
* @returns A Promise for the completion of which ever callback is executed.
*/
then(onfulfilled?: ((value: T) => TResult1 | PromiseLike) | undefined | null, onrejected?: ((reason: any) => TResult2 | PromiseLike) | undefined | null): Promise;
/**
* Attaches a callback for only the rejection of the Promise.
* @param onrejected The callback to execute when the Promise is rejected.
* @returns A Promise for the completion of the callback.
*/
catch(onrejected?: ((reason: any) => TResult | PromiseLike) | undefined | null): Promise;
/**
* Attaches a callback that is invoked when the Promise is settled (fulfilled or rejected). The
* resolved value cannot be modified from the callback.
* @param onfinally The callback to execute when the Promise is settled (fulfilled or rejected).
* @returns A Promise for the completion of the callback.
*/
finally(onfinally?: (() => void) | undefined | null): Promise;
}
// Custom InputTypes
/**
* Post base type for findUnique actions
*/
export type PostFindUniqueArgsBase = {
/**
* Select specific fields to fetch from the Post
*
**/
select?: PostSelect | null
/**
* Choose, which related nodes to fetch as well.
*
**/
include?: PostInclude | null
/**
* Filter, which Post to fetch.
*
**/
where: PostWhereUniqueInput
}
/**
* Post findUnique
*/
export interface PostFindUniqueArgs extends PostFindUniqueArgsBase {
/**
* Throw an Error if query returns no results
* @deprecated since 4.0.0: use `findUniqueOrThrow` method instead
*/
rejectOnNotFound?: RejectOnNotFound
}
/**
* Post findUniqueOrThrow
*/
export type PostFindUniqueOrThrowArgs = {
/**
* Select specific fields to fetch from the Post
*
**/
select?: PostSelect | null
/**
* Choose, which related nodes to fetch as well.
*
**/
include?: PostInclude | null
/**
* Filter, which Post to fetch.
*
**/
where: PostWhereUniqueInput
}
/**
* Post base type for findFirst actions
*/
export type PostFindFirstArgsBase = {
/**
* Select specific fields to fetch from the Post
*
**/
select?: PostSelect | null
/**
* Choose, which related nodes to fetch as well.
*
**/
include?: PostInclude | null
/**
* Filter, which Post to fetch.
*
**/
where?: PostWhereInput
/**
* {@link https://www.prisma.io/docs/concepts/components/prisma-client/sorting Sorting Docs}
*
* Determine the order of Posts to fetch.
*
**/
orderBy?: Enumerable