Add .values() typings - fixes porsager#385 (porsager#393)

Minigugus · web-flow · commit ac1bca41004c · 2022-06-06T20:06:05.000+02:00
diff --git a/types/index.d.ts b/types/index.d.ts
@@ -530,6 +530,7 @@ declare namespace postgres {
   }
 
   type ExecutionResult<T> = [] & ResultQueryMeta<number, keyof NonNullable<T>>;
+  type ValuesRowList<T extends readonly any[]> = T[number][keyof T[number]][][] & ResultQueryMeta<T['length'], keyof T[number]>;
   type RawRowList<T extends readonly any[]> = Buffer[][] & Iterable<Buffer[][]> & ResultQueryMeta<T['length'], keyof T[number]>;
   type RowList<T extends readonly any[]> = T & Iterable<NonNullable<T[number]>> & ResultQueryMeta<T['length'], keyof T[number]>;
 
@@ -555,11 +556,16 @@ declare namespace postgres {
   interface PendingDescribeQuery extends Promise<Statement> {
   }
 
+  interface PendingValuesQuery<TRow extends readonly MaybeRow[]> extends Promise<ValuesRowList<TRow>>, PendingQueryModifiers<TRow[number][keyof TRow[number]][][]> {
+    describe(): PendingDescribeQuery;
+  }
+
   interface PendingRawQuery<TRow extends readonly MaybeRow[]> extends Promise<RawRowList<TRow>>, PendingQueryModifiers<Buffer[][]> {
   }
 
   interface PendingQuery<TRow extends readonly MaybeRow[]> extends Promise<RowList<TRow>>, PendingQueryModifiers<TRow> {
     describe(): PendingDescribeQuery;
+    values(): PendingValuesQuery<TRow>;
     raw(): PendingRawQuery<TRow>;
   }
 

Original file line number	Diff line number	Diff line change
`@@ -530,6 +530,7 @@ declare namespace postgres {`
`530`	`530`	`}`
`531`	`531`
`532`	`532`	`type ExecutionResult<T> = [] & ResultQueryMeta<number, keyof NonNullable<T>>;`
	`533`	`+ type ValuesRowList<T extends readonly any[]> = T[number][keyof T[number]][][] & ResultQueryMeta<T['length'], keyof T[number]>;`
`533`	`534`	`type RawRowList<T extends readonly any[]> = Buffer[][] & Iterable<Buffer[][]> & ResultQueryMeta<T['length'], keyof T[number]>;`
`534`	`535`	`type RowList<T extends readonly any[]> = T & Iterable<NonNullable<T[number]>> & ResultQueryMeta<T['length'], keyof T[number]>;`
`535`	`536`
`@@ -555,11 +556,16 @@ declare namespace postgres {`
`555`	`556`	`interface PendingDescribeQuery extends Promise<Statement> {`
`556`	`557`	`}`
`557`	`558`
	`559`	`+ interface PendingValuesQuery<TRow extends readonly MaybeRow[]> extends Promise<ValuesRowList<TRow>>, PendingQueryModifiers<TRow[number][keyof TRow[number]][][]> {`
	`560`	`+ describe(): PendingDescribeQuery;`
	`561`	`+ }`
	`562`	`+`
`558`	`563`	`interface PendingRawQuery<TRow extends readonly MaybeRow[]> extends Promise<RawRowList<TRow>>, PendingQueryModifiers<Buffer[][]> {`
`559`	`564`	`}`
`560`	`565`
`561`	`566`	`interface PendingQuery<TRow extends readonly MaybeRow[]> extends Promise<RowList<TRow>>, PendingQueryModifiers<TRow> {`
`562`	`567`	`describe(): PendingDescribeQuery;`
	`568`	`+ values(): PendingValuesQuery<TRow>;`
`563`	`569`	`raw(): PendingRawQuery<TRow>;`
`564`	`570`	`}`
`565`	`571`