import {z} from 'zod'

export type CustomFormatType = 'default' | 'percent' | 'currency' | 'number' | 'id' | 'date' | 'timestamp' | 'bytes_si' | 'bytes_iec' | 'custom';

export type NumberSeparator = 'default' | 'commaPeriod' | 'spacePeriod' | 'periodComma' | 'noSeparatorPeriod' | 'apostrophePeriod';

export type Compact = 'auto' | 'thousands' | 'millions' | 'billions' | 'trillions' | 'kilobytes' | 'megabytes' | 'gigabytes' | 'terabytes' | 'petabytes' | 'kibibytes' | 'mebibytes' | 'gibibytes' | 'tebibytes' | 'pebibytes';

export type CompactOrAlias = Compact | 'K' | 'thousand' | 'M' | 'million' | 'B' | 'billion' | 'T' | 'trillion' | 'KB' | 'kilobyte' | 'MB' | 'megabyte' | 'GB' | 'gigabyte' | 'TB' | 'terabyte' | 'PB' | 'petabyte' | 'KiB' | 'kibibyte' | 'MiB' | 'mebibyte' | 'GiB' | 'gibibyte' | 'TiB' | 'tebibyte' | 'PiB' | 'pebibyte';

export type TimeFrames = 'RAW' | 'YEAR' | 'QUARTER' | 'MONTH' | 'WEEK' | 'DAY' | 'HOUR' | 'MINUTE' | 'SECOND' | 'MILLISECOND' | 'DAY_OF_WEEK_INDEX' | 'DAY_OF_MONTH_NUM' | 'DAY_OF_YEAR_NUM' | 'WEEK_NUM' | 'MONTH_NUM' | 'QUARTER_NUM' | 'YEAR_NUM' | 'DAY_OF_WEEK_NAME' | 'MONTH_NAME' | 'QUARTER_NAME' | 'HOUR_OF_DAY_NUM' | 'MINUTE_OF_HOUR_NUM';

export type CustomFormat = {type: CustomFormatType, round?: number | undefined, separator?: NumberSeparator | undefined, currency?: string | undefined, compact?: CompactOrAlias | undefined, prefix?: string | undefined, suffix?: string | undefined, timeInterval?: TimeFrames | undefined, custom?: string | undefined} | {[key: string]: unknown};

export type PickDimensionFormatOptions = {formatOptions?: CustomFormat | undefined};

export type DimensionOverrides = {[key: string]: PickDimensionFormatOptions};

export type PickMetricFormatOptions = {formatOptions?: CustomFormat | undefined};

export type MetricOverrides = {[key: string]: PickMetricFormatOptions};

export type FieldId = string;

export type PickCompiledDimensionLabelOrNameOrTable = {name: string, label: string, table: string};

export type DateGranularity = 'Second' | 'Minute' | 'Hour' | 'Day' | 'Week' | 'Month' | 'Quarter' | 'Year';

export type DateZoom = {xAxisFieldId?: string | undefined, granularity?: (DateGranularity | string) | undefined};

export type CustomDimensionTypeBIN = 'bin';

export type BinTypeFIXEDNUMBER = 'fixed_number';

export type FixedNumberBinDimension = {id: string, name: string, table: string, type: CustomDimensionTypeBIN, dimensionId: FieldId, binType: BinTypeFIXEDNUMBER, binNumber: number} | {[key: string]: unknown};

export type BinTypeFIXEDWIDTH = 'fixed_width';

export type FixedWidthBinDimension = {id: string, name: string, table: string, type: CustomDimensionTypeBIN, dimensionId: FieldId, binType: BinTypeFIXEDWIDTH, binWidth: number} | {[key: string]: unknown};

export type BinTypeCUSTOMRANGE = 'custom_range';

export type BinRange = {to?: number | undefined, from?: number | undefined};

export type CustomRangeBinDimension = {id: string, name: string, table: string, type: CustomDimensionTypeBIN, dimensionId: FieldId, binType: BinTypeCUSTOMRANGE, customRange: Array<BinRange>} | {[key: string]: unknown};

export type BinTypeCUSTOMGROUP = 'custom_group';

export type GroupValueMatchType = 'exact' | 'startsWith' | 'endsWith' | 'includes';

export type GroupValueRule = {value: string, matchType: GroupValueMatchType};

export type BinGroup = {values: Array<GroupValueRule>, name: string};

export type CustomGroupBinDimension = {id: string, name: string, table: string, type: CustomDimensionTypeBIN, dimensionId: FieldId, binType: BinTypeCUSTOMGROUP, customGroups: Array<BinGroup>} | {[key: string]: unknown};

export type CustomBinDimension = FixedNumberBinDimension | FixedWidthBinDimension | CustomRangeBinDimension | CustomGroupBinDimension;

export type CustomDimensionTypeSQL = 'sql';

export type DimensionType = 'string' | 'number' | 'timestamp' | 'date' | 'boolean';

export type CustomSqlDimension = {id: string, name: string, table: string, type: CustomDimensionTypeSQL, sql: string, dimensionType: DimensionType} | {[key: string]: unknown};

export type CustomDimension = CustomBinDimension | CustomSqlDimension;

export type MetricType = 'percentile' | 'average' | 'count' | 'count_distinct' | 'sum' | 'sum_distinct' | 'average_distinct' | 'min' | 'max' | 'percent_of_previous' | 'percent_of_total' | 'running_total' | 'number' | 'median' | 'string' | 'date' | 'timestamp' | 'boolean';

export type Format = 'km' | 'mi' | 'si' | 'usd' | 'gbp' | 'eur' | 'jpy' | 'dkk' | 'id' | 'percent';

export type AnyType = unknown;

export type FilterOperator = 'isNull' | 'notNull' | 'equals' | 'notEquals' | 'startsWith' | 'endsWith' | 'include' | 'doesNotInclude' | 'lessThan' | 'lessThanOrEqual' | 'greaterThan' | 'greaterThanOrEqual' | 'inThePast' | 'notInThePast' | 'inTheNext' | 'inTheCurrent' | 'notInTheCurrent' | 'inBetween' | 'notInBetween' | 'inPeriodToDate';

export type MetricFilterRule = {includeNull?: boolean | undefined, values?: Array<AnyType> | undefined, operator: FilterOperator, id: string, target: {fieldRef: string}, settings?: AnyType | undefined, disabled?: boolean | undefined, required?: boolean | undefined, caseSensitive?: boolean | undefined} | {[key: string]: unknown};

export type AdditionalMetric = {label?: string | undefined, type: MetricType, description?: string | undefined, sql: string, hidden?: boolean | undefined, round?: number | undefined, compact?: CompactOrAlias | undefined, format?: (Format | string) | undefined, separator?: NumberSeparator | undefined, table: string, name: string, index?: number | undefined, filters?: Array<MetricFilterRule> | undefined, baseDimensionName?: string | undefined, baseMetricName?: string | undefined, uuid?: (string | null) | undefined, percentile?: number | undefined, distinctKeys?: Array<string> | undefined, formatOptions?: CustomFormat | undefined, generationType?: 'periodOverPeriod' | undefined, baseMetricId?: FieldId | undefined, timeDimensionId?: FieldId | undefined, granularity?: TimeFrames | undefined, periodOffset?: number | undefined} | {[key: string]: unknown};

export type TableCalculationTotalMode = 'formula' | 'sum_of_rows' | 'none';

export type TableCalculationType = 'number' | 'string' | 'date' | 'timestamp' | 'boolean';

export type SqlTableCalculation = {totalMode?: TableCalculationTotalMode | undefined, type?: TableCalculationType | undefined, format?: CustomFormat | undefined, displayName: string, name: string, index?: number | undefined, sql: string};

export type TableCalculationTemplateTypePERCENTCHANGEFROMPREVIOUS = 'percent_change_from_previous';

export type TableCalculationTemplateTypePERCENTOFPREVIOUSVALUE = 'percent_of_previous_value';

export type TableCalculationTemplateTypePERCENTOFCOLUMNTOTAL = 'percent_of_column_total';

export type TableCalculationTemplateTypeRANKINCOLUMN = 'rank_in_column';

export type TableCalculationTemplateTypeRUNNINGTOTAL = 'running_total';

export type FrameBoundaryType = 'unbounded_preceding' | 'preceding' | 'current_row' | 'following' | 'unbounded_following';

export type FrameBoundary = {offset?: number | undefined, type: FrameBoundaryType};

export type FrameType = 'rows' | 'range';

export type FrameClause = {end: FrameBoundary, start?: FrameBoundary | undefined, frameType: FrameType};

export type WindowFunctionType = 'row_number' | 'percent_rank' | 'cume_dist' | 'rank' | 'sum' | 'avg' | 'count' | 'min' | 'max';

export type TableCalculationTemplateTypeWINDOWFUNCTION = 'window_function';

export type TableCalculationTemplate = {partitionBy?: Array<string> | undefined, orderBy: Array<{order: 'asc' | 'desc' | 'null' | null, fieldId: string}>, fieldId: string, type: TableCalculationTemplateTypePERCENTCHANGEFROMPREVIOUS} | {partitionBy?: Array<string> | undefined, orderBy: Array<{order: 'asc' | 'desc' | 'null' | null, fieldId: string}>, fieldId: string, type: TableCalculationTemplateTypePERCENTOFPREVIOUSVALUE} | {partitionBy?: Array<string> | undefined, fieldId: string, type: TableCalculationTemplateTypePERCENTOFCOLUMNTOTAL} | {fieldId: string, type: TableCalculationTemplateTypeRANKINCOLUMN} | {fieldId: string, type: TableCalculationTemplateTypeRUNNINGTOTAL} | {frame?: FrameClause | undefined, partitionBy: Array<string>, orderBy: Array<{order: 'asc' | 'desc' | 'null' | null, fieldId: string}>, fieldId: string | null, windowFunction: WindowFunctionType, type: TableCalculationTemplateTypeWINDOWFUNCTION};

export type TemplateTableCalculation = {totalMode?: TableCalculationTotalMode | undefined, type?: TableCalculationType | undefined, format?: CustomFormat | undefined, displayName: string, name: string, index?: number | undefined, template: TableCalculationTemplate};

export type FormulaTableCalculation = {totalMode?: TableCalculationTotalMode | undefined, type?: TableCalculationType | undefined, format?: CustomFormat | undefined, displayName: string, name: string, index?: number | undefined, formula: string};

export type TableCalculation = SqlTableCalculation | TemplateTableCalculation | FormulaTableCalculation;

export type PivotSortAnchor = {value: string | number | boolean | null, reference: string};

export type SortField = {pivotValues?: Array<PivotSortAnchor> | undefined, nullsFirst?: boolean | undefined, descending: boolean, fieldId: string};

export type MetricQueryRequest = {dimensionOverrides?: DimensionOverrides | undefined, metricOverrides?: MetricOverrides | undefined, pivotDimensions?: Array<FieldId> | undefined, timezone?: string | undefined, metadata?: {hasADateDimension: PickCompiledDimensionLabelOrNameOrTable} | undefined, dateZoom?: DateZoom | undefined, customDimensions?: Array<CustomDimension> | undefined, csvLimit?: number | undefined, additionalMetrics?: Array<AdditionalMetric> | undefined, tableCalculations: Array<TableCalculation>, limit: number, sorts: Array<SortField>, filters: {tableCalculations?: AnyType | undefined, metrics?: AnyType | undefined, dimensions?: AnyType | undefined}, metrics: Array<FieldId>, dimensions: Array<FieldId>, exploreName: string};

export type CreateApiApiV1ProjectsProjectUuidExploresExploreIdRunQueryArgs = {projectUuid: string, exploreId: string, body: MetricQueryRequest};

export type CreateApiApiV1ProjectsProjectUuidExploresExploreIdRunQueryOptions = {baseUrl: string, fetch?: typeof fetch | undefined};

export const tableCalculationTotalMode = z.enum(["formula", "sum_of_rows", "none"]);

export const tableCalculationType = z.enum(["number", "string", "date", "timestamp", "boolean"]);

export const customFormatType = z.enum(["default", "percent", "currency", "number", "id", "date", "timestamp", "bytes_si", "bytes_iec", "custom"]);

export const numberSeparator = z.enum(["default", "commaPeriod", "spacePeriod", "periodComma", "noSeparatorPeriod", "apostrophePeriod"]);

export const compact = z.enum(["auto", "thousands", "millions", "billions", "trillions", "kilobytes", "megabytes", "gigabytes", "terabytes", "petabytes", "kibibytes", "mebibytes", "gibibytes", "tebibytes", "pebibytes"]);

export const compactOrAlias = z.union([compact, z.enum(["K", "thousand", "M", "million", "B", "billion", "T", "trillion", "KB", "kilobyte", "MB", "megabyte", "GB", "gigabyte", "TB", "terabyte", "PB", "petabyte", "KiB", "kibibyte", "MiB", "mebibyte", "GiB", "gibibyte", "TiB", "tebibyte", "PiB", "pebibyte"])]);

export const timeFrames = z.enum(["RAW", "YEAR", "QUARTER", "MONTH", "WEEK", "DAY", "HOUR", "MINUTE", "SECOND", "MILLISECOND", "DAY_OF_WEEK_INDEX", "DAY_OF_MONTH_NUM", "DAY_OF_YEAR_NUM", "WEEK_NUM", "MONTH_NUM", "QUARTER_NUM", "YEAR_NUM", "DAY_OF_WEEK_NAME", "MONTH_NAME", "QUARTER_NAME", "HOUR_OF_DAY_NUM", "MINUTE_OF_HOUR_NUM"]);

export const customFormat = z.object({type: customFormatType, round: z.number().optional(), separator: numberSeparator.optional(), currency: z.string().optional(), compact: compactOrAlias.optional(), prefix: z.string().optional(), suffix: z.string().optional(), timeInterval: timeFrames.optional(), custom: z.string().optional()}).and(z.record(z.string(), z.unknown()));

export const sqlTableCalculation = z.object({totalMode: tableCalculationTotalMode.optional(), type: tableCalculationType.optional(), format: customFormat.optional(), displayName: z.string(), name: z.string(), index: z.number().optional(), sql: z.string()});

export const tableCalculationTemplateTypePERCENTCHANGEFROMPREVIOUS = z.literal("percent_change_from_previous");

export const tableCalculationTemplateTypePERCENTOFPREVIOUSVALUE = z.literal("percent_of_previous_value");

export const tableCalculationTemplateTypePERCENTOFCOLUMNTOTAL = z.literal("percent_of_column_total");

export const tableCalculationTemplateTypeRANKINCOLUMN = z.literal("rank_in_column");

export const tableCalculationTemplateTypeRUNNINGTOTAL = z.literal("running_total");

export const frameBoundaryType = z.enum(["unbounded_preceding", "preceding", "current_row", "following", "unbounded_following"]);

export const frameBoundary = z.object({offset: z.number().optional(), type: frameBoundaryType});

export const frameType = z.enum(["rows", "range"]);

export const frameClause = z.object({end: frameBoundary, start: frameBoundary.optional(), frameType: frameType});

export const windowFunctionType = z.enum(["row_number", "percent_rank", "cume_dist", "rank", "sum", "avg", "count", "min", "max"]);

export const tableCalculationTemplateTypeWINDOWFUNCTION = z.literal("window_function");

export const tableCalculationTemplate = z.union([z.object({partitionBy: z.array(z.string()).optional(), orderBy: z.array(z.object({order: z.enum(["asc", "desc", "null"]).nullable(), fieldId: z.string()})), fieldId: z.string(), type: tableCalculationTemplateTypePERCENTCHANGEFROMPREVIOUS}), z.object({partitionBy: z.array(z.string()).optional(), orderBy: z.array(z.object({order: z.enum(["asc", "desc", "null"]).nullable(), fieldId: z.string()})), fieldId: z.string(), type: tableCalculationTemplateTypePERCENTOFPREVIOUSVALUE}), z.object({partitionBy: z.array(z.string()).optional(), fieldId: z.string(), type: tableCalculationTemplateTypePERCENTOFCOLUMNTOTAL}), z.object({fieldId: z.string(), type: tableCalculationTemplateTypeRANKINCOLUMN}), z.object({fieldId: z.string(), type: tableCalculationTemplateTypeRUNNINGTOTAL}), z.object({frame: frameClause.optional(), partitionBy: z.array(z.string()), orderBy: z.array(z.object({order: z.enum(["asc", "desc", "null"]).nullable(), fieldId: z.string()})), fieldId: z.string().nullable(), windowFunction: windowFunctionType, type: tableCalculationTemplateTypeWINDOWFUNCTION})]);

export const templateTableCalculation = z.object({totalMode: tableCalculationTotalMode.optional(), type: tableCalculationType.optional(), format: customFormat.optional(), displayName: z.string(), name: z.string(), index: z.number().optional(), template: tableCalculationTemplate});

export const formulaTableCalculation = z.object({totalMode: tableCalculationTotalMode.optional(), type: tableCalculationType.optional(), format: customFormat.optional(), displayName: z.string(), name: z.string(), index: z.number().optional(), formula: z.string()});

export const tableCalculation = z.union([sqlTableCalculation, templateTableCalculation, formulaTableCalculation]);

export const metricType = z.enum(["percentile", "average", "count", "count_distinct", "sum", "sum_distinct", "average_distinct", "min", "max", "percent_of_previous", "percent_of_total", "running_total", "number", "median", "string", "date", "timestamp", "boolean"]);

export const format = z.enum(["km", "mi", "si", "usd", "gbp", "eur", "jpy", "dkk", "id", "percent"]);

export const anyType = z.unknown();

export const filterOperator = z.enum(["isNull", "notNull", "equals", "notEquals", "startsWith", "endsWith", "include", "doesNotInclude", "lessThan", "lessThanOrEqual", "greaterThan", "greaterThanOrEqual", "inThePast", "notInThePast", "inTheNext", "inTheCurrent", "notInTheCurrent", "inBetween", "notInBetween", "inPeriodToDate"]);

export const metricFilterRule = z.object({includeNull: z.boolean().optional(), values: z.array(anyType).optional(), operator: filterOperator, id: z.string(), target: z.object({fieldRef: z.string()}), settings: anyType.optional(), disabled: z.boolean().optional(), required: z.boolean().optional(), caseSensitive: z.boolean().optional()}).and(z.record(z.string(), z.unknown()));

export const fieldId = z.string();

export const additionalMetric = z.object({label: z.string().optional(), type: metricType, description: z.string().optional(), sql: z.string(), hidden: z.boolean().optional(), round: z.number().optional(), compact: compactOrAlias.optional(), format: z.union([format, z.string()]).optional(), separator: numberSeparator.optional(), table: z.string(), name: z.string(), index: z.number().optional(), filters: z.array(metricFilterRule).optional(), baseDimensionName: z.string().optional(), baseMetricName: z.string().optional(), uuid: z.string().nullable().optional(), percentile: z.number().optional(), distinctKeys: z.array(z.string()).optional(), formatOptions: customFormat.optional(), generationType: z.literal("periodOverPeriod").optional(), baseMetricId: fieldId.optional(), timeDimensionId: fieldId.optional(), granularity: timeFrames.optional(), periodOffset: z.number().optional()}).and(z.record(z.string(), z.unknown()));

export const customDimensionTypeBIN = z.literal("bin");

export const binTypeFIXEDNUMBER = z.literal("fixed_number");

export const fixedNumberBinDimension = z.object({id: z.string(), name: z.string(), table: z.string(), type: customDimensionTypeBIN, dimensionId: fieldId, binType: binTypeFIXEDNUMBER, binNumber: z.number()}).and(z.record(z.string(), z.unknown()));

export const binTypeFIXEDWIDTH = z.literal("fixed_width");

export const fixedWidthBinDimension = z.object({id: z.string(), name: z.string(), table: z.string(), type: customDimensionTypeBIN, dimensionId: fieldId, binType: binTypeFIXEDWIDTH, binWidth: z.number()}).and(z.record(z.string(), z.unknown()));

export const binTypeCUSTOMRANGE = z.literal("custom_range");

export const binRange = z.object({to: z.number().optional(), from: z.number().optional()});

export const customRangeBinDimension = z.object({id: z.string(), name: z.string(), table: z.string(), type: customDimensionTypeBIN, dimensionId: fieldId, binType: binTypeCUSTOMRANGE, customRange: z.array(binRange)}).and(z.record(z.string(), z.unknown()));

export const binTypeCUSTOMGROUP = z.literal("custom_group");

export const groupValueMatchType = z.enum(["exact", "startsWith", "endsWith", "includes"]);

export const groupValueRule = z.object({value: z.string(), matchType: groupValueMatchType});

export const binGroup = z.object({values: z.array(groupValueRule), name: z.string()});

export const customGroupBinDimension = z.object({id: z.string(), name: z.string(), table: z.string(), type: customDimensionTypeBIN, dimensionId: fieldId, binType: binTypeCUSTOMGROUP, customGroups: z.array(binGroup)}).and(z.record(z.string(), z.unknown()));

export const customBinDimension = z.union([fixedNumberBinDimension, fixedWidthBinDimension, customRangeBinDimension, customGroupBinDimension]);

export const customDimensionTypeSQL = z.literal("sql");

export const dimensionType = z.enum(["string", "number", "timestamp", "date", "boolean"]);

export const customSqlDimension = z.object({id: z.string(), name: z.string(), table: z.string(), type: customDimensionTypeSQL, sql: z.string(), dimensionType: dimensionType}).and(z.record(z.string(), z.unknown()));

export const customDimension = z.union([customBinDimension, customSqlDimension]);

export const fieldTypeMETRIC = z.literal("metric");

export const sourcePosition = z.object({character: z.number(), line: z.number()});

export const source = z.object({content: z.string(), highlight: z.object({end: sourcePosition, start: sourcePosition}).optional(), range: z.object({end: sourcePosition, start: sourcePosition}), path: z.string()});

export const fieldUrl = z.object({label: z.string(), url: z.string()});

export const recordStringStringOrStringArray = z.record(z.string(), z.union([z.string(), z.array(z.string())]));

export const defaultTimeDimension = z.object({interval: timeFrames, field: z.string()});

export const metric = z.object({fieldType: fieldTypeMETRIC, type: metricType, name: z.string(), label: z.string(), table: z.string(), tableLabel: z.string(), sql: z.string(), description: z.string().optional(), source: source.optional(), hidden: z.boolean(), compact: compactOrAlias.optional(), round: z.number().optional(), format: z.union([format, z.string()]).optional(), separator: numberSeparator.optional(), groupLabel: z.string().optional(), groups: z.array(z.string()).optional(), urls: z.array(fieldUrl).optional(), index: z.number().optional(), tags: z.array(z.string()).optional(), parameterReferences: z.array(z.string()).optional(), showUnderlyingValues: z.array(z.string()).optional(), filters: z.array(metricFilterRule).optional(), percentile: z.number().optional(), distinctKeys: z.array(z.string()).optional(), formatOptions: customFormat.optional(), dimensionReference: z.string().optional(), baseDimensionType: dimensionType.optional(), baseDimensionTimeInterval: timeFrames.optional(), requiredAttributes: recordStringStringOrStringArray.optional(), anyAttributes: recordStringStringOrStringArray.optional(), defaultTimeDimension: defaultTimeDimension.optional(), spotlight: z.object({owner: z.string().optional(), defaultFilter: metricFilterRule.optional(), defaultSegment: z.string().optional(), segmentBy: z.array(z.string()).optional(), filterBy: z.array(z.string()).optional(), categories: z.array(z.string()).optional(), visibility: z.enum(["show", "hide"])}).optional(), drivers: z.array(z.string()).optional(), aiHint: z.union([z.string(), z.array(z.string())]).optional(), richText: z.string().optional()}).and(z.record(z.string(), z.unknown()));

export const fieldType = z.enum(["metric", "dimension"]);

export const field = z.object({fieldType: fieldType, type: z.string(), name: z.string(), label: z.string(), table: z.string(), tableLabel: z.string(), sql: z.string(), description: z.string().optional(), source: source.optional(), hidden: z.boolean(), compact: compactOrAlias.optional(), round: z.number().optional(), format: z.union([format, z.string()]).optional(), separator: numberSeparator.optional(), groupLabel: z.string().optional(), groups: z.array(z.string()).optional(), urls: z.array(fieldUrl).optional(), index: z.number().optional(), tags: z.array(z.string()).optional(), parameterReferences: z.array(z.string()).optional()}).and(z.record(z.string(), z.unknown()));

export const recordStringItemOrAdditionalMetric = z.record(z.string(), z.union([tableCalculation, additionalMetric, customDimension, metric, field]));

export const preAggregateMissReasonNOPREAGGREGATESDEFINED = z.literal("no_pre_aggregates_defined");

export const preAggregateMissReasonDIMENSIONNOTINPREAGGREGATE = z.literal("dimension_not_in_pre_aggregate");

export const preAggregateMissReasonMETRICNOTINPREAGGREGATE = z.literal("metric_not_in_pre_aggregate");

export const preAggregateMissReasonNONADDITIVEMETRIC = z.literal("non_additive_metric");

export const preAggregateMissReasonCUSTOMSQLMETRIC = z.literal("custom_sql_metric");

export const preAggregateMissReasonFILTERDIMENSIONNOTINPREAGGREGATE = z.literal("filter_dimension_not_in_pre_aggregate");

export const preAggregateMissReasonPREAGGREGATEFILTERNOTSATISFIED = z.literal("pre_aggregate_filter_not_satisfied");

export const preAggregateMissReasonGRANULARITYTOOFINE = z.literal("granularity_too_fine");

export const preAggregateMissReasonCUSTOMDIMENSIONPRESENT = z.literal("custom_dimension_present");

export const preAggregateMissReasonCUSTOMMETRICPRESENT = z.literal("custom_metric_present");

export const preAggregateMissReasonTABLECALCULATIONPRESENT = z.literal("table_calculation_present");

export const preAggregateMissReasonUSERBYPASS = z.literal("user_bypass");

export const preAggregateMissReasonEXPLORERESOLUTIONERROR = z.literal("explore_resolution_error");

export const preAggregateMissReasonNOACTIVEMATERIALIZATION = z.literal("no_active_materialization");

export const preAggregateMatchMiss = z.union([z.object({reason: preAggregateMissReasonNOPREAGGREGATESDEFINED}), z.object({fieldId: fieldId, reason: preAggregateMissReasonDIMENSIONNOTINPREAGGREGATE}), z.object({fieldId: fieldId, reason: preAggregateMissReasonMETRICNOTINPREAGGREGATE}), z.object({fieldId: fieldId, reason: preAggregateMissReasonNONADDITIVEMETRIC}), z.object({fieldId: fieldId, reason: preAggregateMissReasonCUSTOMSQLMETRIC}), z.object({fieldId: fieldId, reason: preAggregateMissReasonFILTERDIMENSIONNOTINPREAGGREGATE}), z.object({fieldId: fieldId, reason: preAggregateMissReasonPREAGGREGATEFILTERNOTSATISFIED}), z.object({preAggregateTimeDimension: z.string(), preAggregateGranularity: timeFrames, queryGranularity: timeFrames, fieldId: fieldId, reason: preAggregateMissReasonGRANULARITYTOOFINE}), z.object({reason: preAggregateMissReasonCUSTOMDIMENSIONPRESENT}), z.object({fieldId: fieldId, reason: preAggregateMissReasonCUSTOMMETRICPRESENT}), z.object({fieldId: fieldId, reason: preAggregateMissReasonTABLECALCULATIONPRESENT}), z.object({preAggregateName: z.string(), reason: preAggregateMissReasonUSERBYPASS}), z.object({reason: preAggregateMissReasonEXPLORERESOLUTIONERROR}), z.object({reason: preAggregateMissReasonNOACTIVEMATERIALIZATION})]);

export const cacheMetadata = z.object({preAggregate: z.object({reason: preAggregateMatchMiss.optional(), name: z.string().optional(), hit: z.boolean()}).optional(), cacheHit: z.boolean(), cacheKey: z.string().optional(), cacheExpiresAt: z.string().optional(), cacheUpdatedTime: z.string().optional()});

export const pickCompiledDimensionLabelOrNameOrTable = z.object({name: z.string(), label: z.string(), table: z.string()});

export const pivotSortAnchor = z.object({value: z.union([z.string(), z.number(), z.boolean()]).nullable(), reference: z.string()});

export const sortField = z.object({pivotValues: z.array(pivotSortAnchor).optional(), nullsFirst: z.boolean().optional(), descending: z.boolean(), fieldId: z.string()});

export const filterGroupResponse = z.union([z.object({or: z.array(anyType), id: z.string()}), z.object({and: z.array(anyType), id: z.string()})]);

export const filtersResponse = z.object({tableCalculations: filterGroupResponse.optional(), metrics: filterGroupResponse.optional(), dimensions: filterGroupResponse.optional()});

export const metricQueryResponse = z.object({metadata: z.object({hasADateDimension: pickCompiledDimensionLabelOrNameOrTable}).optional(), customDimensions: z.array(customDimension).optional(), additionalMetrics: z.array(additionalMetric).optional(), tableCalculations: z.array(tableCalculation), limit: z.number(), sorts: z.array(sortField), filters: filtersResponse, metrics: z.array(fieldId), dimensions: z.array(fieldId), exploreName: z.string()});

export const apiRunQueryResponse = z.object({results: z.object({fields: recordStringItemOrAdditionalMetric.optional(), rows: z.array(anyType), cacheMetadata: cacheMetadata, metricQuery: metricQueryResponse}), status: z.literal("ok")});

export const validateResponse = async <Output>(
  schema: {
    readonly '~standard': {
      readonly validate: (value: unknown) => ({ readonly value: Output; readonly issues?: undefined } | { readonly issues: ReadonlyArray<{ readonly message: string; readonly path?: ReadonlyArray<PropertyKey | { readonly key: PropertyKey }> | undefined }> }) | Promise<{ readonly value: Output; readonly issues?: undefined } | { readonly issues: ReadonlyArray<{ readonly message: string; readonly path?: ReadonlyArray<PropertyKey | { readonly key: PropertyKey }> | undefined }> }>
    }
  },
  value: unknown
): Promise<Output> => {
  const result = await schema['~standard'].validate(value)

  if (result.issues !== undefined) {
    const detail = result.issues
      .map(({ message, path }) =>
        path?.length
          ? `${path.map((segment) => String(typeof segment === 'object' ? segment.key : segment)).join('.')}: ${message}`
          : message
      )
      .join('; ')

    throw new Error(`Response does not match the schema: ${detail}`, { cause: { issues: result.issues } })
  }

  return result.value
};

/**
 * Run metric query
 * 
 * POST /api/v1/projects/{projectUuid}/explores/{exploreId}/runQuery
 */
export const createApiApiV1ProjectsProjectUuidExploresExploreIdRunQuery = async (args: CreateApiApiV1ProjectsProjectUuidExploresExploreIdRunQueryArgs, options: CreateApiApiV1ProjectsProjectUuidExploresExploreIdRunQueryOptions) => {
const {baseUrl, fetch: fetchFn = fetch} = options ?? {}

const query = new URLSearchParams()
const headers = new Headers()
headers.set('content-type', "application/json")
headers.set('accept', "application/json")

const url = `${baseUrl.replace(/\/+$/, '')}/api/v1/projects/${encodeURIComponent(String(args.projectUuid))}/explores/${encodeURIComponent(String(args.exploreId))}/runQuery${query.size > 0 ? `?${query}` : ''}`

const res = await fetchFn(url, {method: "POST", headers, body: JSON.stringify(args.body)})

if (!res.ok) throw new Error(`Request failed with status ${res.status}`, {cause: {status: res.status, body: await res.text()}})

return validateResponse(apiRunQueryResponse, await res.json())
};