import {z} from 'zod'

export type ComputeResourceRequest = {cpu?: string | undefined, memory?: string | undefined, timeoutSeconds?: number | undefined};

export type SubmitDuckDBJobRequest = {sql: string, resources?: ComputeResourceRequest | undefined, integrationId?: (string | string | null) | undefined, blockId?: (string | string | null) | undefined, queryType?: ('json' | 'arrow' | 'exec') | undefined};

export type CreateApiV4QueryJobsArgs = {body: SubmitDuckDBJobRequest};

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

export const duckDBJobStatus = z.enum(["pending", "running", "succeeded", "failed", "unknown"]);

export const duckDBQueryType = z.enum(["json", "arrow", "exec", "batch"]);

export const duckDBJobResponse = z.object({jobId: z.string(), status: duckDBJobStatus, teamId: z.union([z.string(), z.string()]).nullable().optional(), userId: z.union([z.string(), z.string()]).nullable().optional(), integrationId: z.union([z.string(), z.string()]).nullable().optional(), blockId: z.union([z.string(), z.string()]).nullable().optional(), queryType: duckDBQueryType.nullable().optional(), cpu: z.string().nullable().optional(), memory: z.string().nullable().optional(), timeoutSeconds: z.number().int().nullable().optional(), createdAt: z.string().nullable().optional()});

export const responseMeta = z.object({requestId: z.string().optional(), timestamp: z.string().optional(), durationMs: z.number().int().nullable().optional()});

export const successResponseDuckDBJobResponse = z.object({success: z.literal(true), data: duckDBJobResponse, meta: responseMeta.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
};

/**
 * Submit async DuckDB job - returns immediately with job ID for polling
 * 
 * POST /v4/query/jobs
 */
export const createApiV4QueryJobs = async (args: CreateApiV4QueryJobsArgs, options: CreateApiV4QueryJobsOptions) => {
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(/\/+$/, '')}/v4/query/jobs${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(successResponseDuckDBJobResponse, await res.json())
};