import {z} from 'zod'

export type CreateApiDatamartSqlqueryArgs = {timeout?: string | undefined, body: {operationType?: string | undefined, startRow?: number | undefined, endRow?: number | undefined, data?: ({sources?: ({s0?: ({query?: ({source?: string | undefined, projections?: ({Month?: ({expression?: string | undefined}) | undefined, Quantity?: ({expression?: string | undefined, parameters?: ({field?: string | undefined}) | undefined, advancedProjection?: boolean | undefined}) | undefined}) | undefined, options?: ({currency?: string | undefined}) | undefined, filter?: Record<string, never> | undefined, aggregateFilter: unknown, dimensionFilters?: (Array<{Invoice_DateYear?: Array<string> | undefined}>) | undefined, rollup?: boolean | undefined}) | undefined}) | undefined, s1?: ({query?: ({source?: string | undefined, projections?: ({Month?: ({expression?: string | undefined}) | undefined, Quantity?: ({expression?: string | undefined, parameters?: ({field?: string | undefined}) | undefined, advancedProjection?: boolean | undefined}) | undefined}) | undefined, options?: ({currency?: string | undefined}) | undefined, filter?: Record<string, never> | undefined, aggregateFilter: unknown, dimensionFilters?: (Array<{Invoice_DateYear?: Array<string> | undefined}>) | undefined, rollup?: boolean | undefined}) | undefined}) | undefined}) | undefined, with?: ({w0?: string | undefined}) | undefined, sql?: string | undefined}) | undefined}};

export type CreateApiDatamartSqlqueryOptions = {baseUrl?: string | undefined, basic?: {username: string, password: string} | undefined, fetch?: typeof fetch | undefined};

export const createApiDatamartSqlqueryResponse = z.object({response: z.object({node: z.string().min(1).optional(), startRow: z.number().optional(), data: z.array(z.object({bandBy: z.string().min(1).optional(), bubbleSize: z.number().optional(), bubbleSize_n: z.number().optional(), groupBy: z.string().min(1).optional(), x: z.number().optional(), y: z.number().optional(), summary: z.string().min(1).optional()})).optional(), endRow: z.number().optional(), totalRows: z.number().optional(), status: z.number().optional()}).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
};

/**
 * SQL Query a Data Manager Object
 * 
 * POST /datamart.sqlquery
 * 
 * Also accepts auth: X-PriceFx-jwt
 */
export const createApiDatamartSqlquery = async (args: CreateApiDatamartSqlqueryArgs, options?: CreateApiDatamartSqlqueryOptions) => {
const {baseUrl = "https://companynode.pricefx.com/pricefx/companypartition", fetch: fetchFn = fetch, basic} = options ?? {}

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

if (args.timeout != null) query.append("timeout", String(args.timeout))
if (basic !== undefined) headers.set('authorization', `Basic ${btoa(`${basic.username}:${basic.password}`)}`)

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