import {z} from 'zod'

export type ObjectIDFilter = string | {_type: 'EqualTo', value: string} | {_type: 'NotEqual', value: string} | {_type: 'IsNull'} | {_type: 'NotNull'} | {_type: 'EqualToOrNull', value: string} | {_type: 'Includes', value: Array<string>};

export type DateFilter = string | {_type: 'EqualTo', value: string} | {_type: 'NotEqual', value: string} | {_type: 'IsNull'} | {_type: 'NotNull'} | {_type: 'EqualToOrNull', value: string} | {_type: 'GreaterThan', value: string} | {_type: 'LessThan', value: string} | {_type: 'GreaterThanOrEqual', value: string} | {_type: 'LessThanOrEqual', value: string} | {_type: 'InBetween', startValue: string, endValue: string};

export type ShortTextFilter = string | {_type: 'EqualTo', value: string} | {_type: 'NotEqual', value: string} | {_type: 'IsNull'} | {_type: 'NotNull'} | {_type: 'EqualToOrNull', value: string} | {_type: 'Search', value: string} | {_type: 'Includes', value: Array<string>};

export type LongTextFilter = string | {_type: 'EqualTo', value: string} | {_type: 'NotEqual', value: string} | {_type: 'IsNull'} | {_type: 'NotNull'} | {_type: 'EqualToOrNull', value: string} | {_type: 'Search', value: string} | {_type: 'Includes', value: Array<string>};

export type JSONFilter = {_type: 'IsNull'} | {_type: 'NotNull'} | {[key: string]: string | number | boolean | {_type: 'EqualTo', value: string | number | boolean} | {_type: 'NotEqual', value: string | number | boolean} | {_type: 'IsNull'} | {_type: 'NotNull'} | {_type: 'EqualToOrNull', value: string | number | boolean} | {_type: 'Search', value: string} | {_type: 'Includes', value: Array<string | number | boolean>} | {_type: 'GreaterThan', value: string | number | boolean} | {_type: 'LessThan', value: string | number | boolean} | {_type: 'GreaterThanOrEqual', value: string | number | boolean} | {_type: 'LessThanOrEqual', value: string | number | boolean} | {_type: 'InBetween', startValue: string | number | boolean, endValue: string | number | boolean}};

export type NumberFilter = number | {_type: 'EqualTo', value: number} | {_type: 'NotEqual', value: number} | {_type: 'IsNull'} | {_type: 'NotNull'} | {_type: 'EqualToOrNull', value: number} | {_type: 'GreaterThan', value: number} | {_type: 'LessThan', value: number} | {_type: 'GreaterThanOrEqual', value: number} | {_type: 'LessThanOrEqual', value: number} | {_type: 'InBetween', startValue: number, endValue: number};

export type VeryLongTextFilter = string | {_type: 'EqualTo', value: string} | {_type: 'NotEqual', value: string} | {_type: 'IsNull'} | {_type: 'NotNull'} | {_type: 'EqualToOrNull', value: string} | {_type: 'Search', value: string} | {_type: 'Includes', value: Array<string>};

export type BooleanFilter = boolean | {_type: 'EqualTo', value: boolean} | {_type: 'NotEqual', value: boolean} | {_type: 'IsNull'} | {_type: 'NotNull'} | {_type: 'EqualToOrNull', value: boolean};

export type DataCheckQuerySchema = {_id?: ObjectIDFilter | undefined, createdAt?: DateFilter | undefined, updatedAt?: DateFilter | undefined, deletedAt?: DateFilter | undefined, projectId?: ObjectIDFilter | undefined, dataAssetId?: ObjectIDFilter | undefined, dataStoreId?: ObjectIDFilter | undefined, name?: ShortTextFilter | undefined, description?: LongTextFilter | undefined, checkType?: ShortTextFilter | undefined, columnName?: ShortTextFilter | undefined, segmentColumn?: ShortTextFilter | undefined, acceptedValues?: JSONFilter | undefined, pattern?: LongTextFilter | undefined, formatPreset?: ShortTextFilter | undefined, samplePercent?: NumberFilter | undefined, referenceTableKey?: ShortTextFilter | undefined, referenceColumnName?: ShortTextFilter | undefined, customSql?: VeryLongTextFilter | undefined, intervalInMinutes?: NumberFilter | undefined, isEnabled?: BooleanFilter | undefined, isManagedByFile?: BooleanFilter | undefined, alertCondition?: ShortTextFilter | undefined, alertThreshold?: NumberFilter | undefined, monitorId?: ObjectIDFilter | undefined, dataReconciliationId?: ObjectIDFilter | undefined, lastRunAt?: DateFilter | undefined, lastRunStatus?: ShortTextFilter | undefined, lastRunMessage?: LongTextFilter | undefined, lastValue?: NumberFilter | undefined, failingRowsSample?: JSONFilter | undefined, lastSegmentCount?: NumberFilter | undefined, externalId?: LongTextFilter | undefined, createdByUserId?: ObjectIDFilter | undefined};

export type DataCheckSelectSchema = {_id?: boolean | undefined, createdAt?: boolean | undefined, updatedAt?: boolean | undefined, deletedAt?: boolean | undefined, projectId?: boolean | undefined, dataAssetId?: boolean | undefined, dataStoreId?: boolean | undefined, name?: boolean | undefined, description?: boolean | undefined, checkType?: boolean | undefined, columnName?: boolean | undefined, segmentColumn?: boolean | undefined, acceptedValues?: boolean | undefined, pattern?: boolean | undefined, formatPreset?: boolean | undefined, samplePercent?: boolean | undefined, referenceTableKey?: boolean | undefined, referenceColumnName?: boolean | undefined, customSql?: boolean | undefined, intervalInMinutes?: boolean | undefined, isEnabled?: boolean | undefined, isManagedByFile?: boolean | undefined, alertCondition?: boolean | undefined, alertThreshold?: boolean | undefined, monitorId?: boolean | undefined, dataReconciliationId?: boolean | undefined, lastRunAt?: boolean | undefined, lastRunStatus?: boolean | undefined, lastRunMessage?: boolean | undefined, lastValue?: boolean | undefined, failingRowsSample?: boolean | undefined, lastSegmentCount?: boolean | undefined, externalId?: boolean | undefined, createdByUserId?: boolean | undefined};

export type SortOrder = 'ASC' | 'DESC';

export type DataCheckSortSchema = {_id?: SortOrder | undefined, createdAt?: SortOrder | undefined, updatedAt?: SortOrder | undefined, deletedAt?: SortOrder | undefined, projectId?: SortOrder | undefined, dataAssetId?: SortOrder | undefined, dataStoreId?: SortOrder | undefined, name?: SortOrder | undefined, description?: SortOrder | undefined, checkType?: SortOrder | undefined, columnName?: SortOrder | undefined, segmentColumn?: SortOrder | undefined, pattern?: SortOrder | undefined, formatPreset?: SortOrder | undefined, samplePercent?: SortOrder | undefined, referenceTableKey?: SortOrder | undefined, referenceColumnName?: SortOrder | undefined, customSql?: SortOrder | undefined, intervalInMinutes?: SortOrder | undefined, isEnabled?: SortOrder | undefined, isManagedByFile?: SortOrder | undefined, alertCondition?: SortOrder | undefined, alertThreshold?: SortOrder | undefined, monitorId?: SortOrder | undefined, dataReconciliationId?: SortOrder | undefined, lastRunAt?: SortOrder | undefined, lastRunStatus?: SortOrder | undefined, lastRunMessage?: SortOrder | undefined, lastValue?: SortOrder | undefined, lastSegmentCount?: SortOrder | undefined, externalId?: SortOrder | undefined, createdByUserId?: SortOrder | undefined};

export type CreateApiDataCheckGetListArgs = {body: {query?: DataCheckQuerySchema | undefined, select?: DataCheckSelectSchema | undefined, sort?: DataCheckSortSchema | undefined, limit?: number | undefined, skip?: number | undefined}};

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

export const dataCheck = z.object({_id: z.string().optional(), createdAt: z.object({}).optional(), updatedAt: z.object({}).optional(), deletedAt: z.object({}).optional(), version: z.number().optional(), projectId: z.string(), dataAssetId: z.string(), dataStoreId: z.string().optional(), name: z.string(), description: z.string().optional(), checkType: z.enum(["Null Percent", "Duplicate Percent", "Distinct Count", "Minimum", "Maximum", "Average", "Sum", "Invalid Percent", "Format Mismatch Percent", "Orphan Count", "Row Count", "Custom SQL", "Failing Rows", "dbt Test"]), columnName: z.string().optional(), segmentColumn: z.string().optional(), acceptedValues: z.object({}).optional(), pattern: z.string().optional(), formatPreset: z.string().optional(), samplePercent: z.number().optional(), referenceTableKey: z.string().optional(), referenceColumnName: z.string().optional(), customSql: z.string().optional(), intervalInMinutes: z.number(), isEnabled: z.boolean(), isManagedByFile: z.boolean(), alertCondition: z.enum(["Unusually High", "Unusually Low", "Above", "Below"]).optional(), alertThreshold: z.number().optional(), monitorId: z.string().optional(), dataReconciliationId: z.string().optional(), lastRunAt: z.object({}).optional(), lastRunStatus: z.string().optional(), lastRunMessage: z.string().optional(), lastValue: z.number().optional(), failingRowsSample: z.object({}).optional(), lastSegmentCount: z.number().optional(), externalId: z.string().optional(), createdByUserId: z.string().optional()});

export const createApiDataCheckGetListResponse = z.object({data: z.array(dataCheck).optional(), count: z.number().optional()});

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
};

/**
 * List Data Check
 * 
 * POST /data-check/get-list
 */
export const createApiDataCheckGetList = async (args: CreateApiDataCheckGetListArgs, options?: CreateApiDataCheckGetListOptions) => {
const {baseUrl = "https://oneuptime.com/api", fetch: fetchFn = fetch, ApiKey} = options ?? {}

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

if (ApiKey !== undefined) headers.set("APIKey", ApiKey)

const url = `${baseUrl.replace(/\/+$/, '')}/data-check/get-list${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(createApiDataCheckGetListResponse, await res.json())
};