sqlx-ts/tests/demo/aggregate_functions/basic_aggregates.snapshot.ts at 1fb11d07e7ffca7d24330c71899bcf17a8fcdc25 · Leo5878/sqlx-ts · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
export type CountVariantsParams = [];

export interface ICountVariantsResult {
	distinctRarityCount: number;
	idCount: number;
	nonNullRarityCount: number;
	totalCount: number;
}

export interface ICountVariantsQuery {
	params: CountVariantsParams;
	result: ICountVariantsResult;
}

export type SumAndAvgParams = [];

export interface ISumAndAvgResult {
	avgId: number;
	avgIdRounded: number;
	rarity: string | null;
	sumId: number;
}

export interface ISumAndAvgQuery {
	params: SumAndAvgParams;
	result: ISumAndAvgResult;
}

export type MinAndMaxParams = [];

export interface IMinAndMaxResult {
	maxId: number;
	maxName: number;
	minId: number;
	minName: number;
	rarity: string | null;
}

export interface IMinAndMaxQuery {
	params: MinAndMaxParams;
	result: IMinAndMaxResult;
}

export type StddevAndVarianceParams = [];

export interface IStddevAndVarianceResult {
	rarity: string | null;
	stddevId: unknown;
	varianceId: unknown;
}

export interface IStddevAndVarianceQuery {
	params: StddevAndVarianceParams;
	result: IStddevAndVarianceResult;
}

export type MultipleAggregatesParams = [];

export interface IMultipleAggregatesResult {
	avgId: number;
	count: number;
	maxId: number;
	minId: number;
	rarity: string | null;
	sumId: number;
}

export interface IMultipleAggregatesQuery {
	params: MultipleAggregatesParams;
	result: IMultipleAggregatesResult;
}