import {z} from 'zod'

export type CubeLeafFilter = {member: string, operator: string, values?: (Array<string> | null) | undefined};

export type CubeOrFilter = {or: Array<CubeLeafFilter | CubeAndFilter | CubeOrFilter>};

export type CubeAndFilter = {and: Array<CubeLeafFilter | CubeAndFilter | CubeOrFilter>};

export type CubeTimeDimension = {dimension: string, dateRange?: (string | Array<string> | null) | undefined, compareDateRange?: (Array<Array<string>> | null) | undefined, granularity?: (string | null) | undefined};

export type CubeOrderItem = {id?: (string | null) | undefined, member?: (string | null) | undefined, desc?: (boolean | null) | undefined, direction?: ('asc' | 'desc' | null) | undefined};

export type CubeLoadQuery = {measures?: Array<string> | undefined, dimensions?: Array<string> | undefined, segments?: Array<string> | undefined, filters?: (Array<CubeLeafFilter | CubeAndFilter | CubeOrFilter>) | undefined, timeDimensions?: Array<CubeTimeDimension> | undefined, order?: ({[key: string]: 'asc' | 'desc'} | Array<CubeOrderItem> | Array<Array<string>> | null) | undefined, limit?: (number | null) | undefined, offset?: (number | null) | undefined, timezone?: (string | null) | undefined, total?: (boolean | null) | undefined, renewQuery?: (boolean | null) | undefined, ungrouped?: (boolean | null) | undefined};

export type CreateApiInsightsQueryDbArgs = {'x-chift-datalayer-max-staleness'?: (string | null) | undefined, body: CubeLoadQuery};

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

export const executionResult = z.object({column: z.string(), title: z.string().nullable().optional(), data: z.array(z.unknown()), type: z.string()});

export const queryMeta = z.object({currency: z.array(z.string().nullable()).nullable().optional(), monetary_measures: z.array(z.string()).nullable().optional()});

export const queryResponse = z.object({results: z.array(executionResult), meta: queryMeta.nullable().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
};

/**
 * Query Db
 * 
 * POST /insights/query-db
 */
export const createApiInsightsQueryDb = async (args: CreateApiInsightsQueryDbArgs, options?: CreateApiInsightsQueryDbOptions) => {
const {baseUrl = "https://api.chift.eu", fetch: fetchFn = fetch, bearerAuth} = options ?? {}

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

if (args['x-chift-datalayer-max-staleness'] != null) headers.set("x-chift-datalayer-max-staleness", String(args['x-chift-datalayer-max-staleness']))
if (bearerAuth !== undefined) headers.set('authorization', `Bearer ${bearerAuth}`)

const url = `${baseUrl.replace(/\/+$/, '')}/insights/query-db${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(queryResponse, await res.json())
};