import {z} from 'zod'

export type RunSqlRequest = {sql: string};

export type CreateApiV1WorkspacesWorkspaceIdToolsRunSqlArgs = {workspace_id: string, 'Idempotency-Key'?: (string | null) | undefined, body: RunSqlRequest};

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

export const queryTableColumn = z.object({data_type: z.string(), name: z.string()});

export const queryTablePreview = z.object({columns: z.array(queryTableColumn).optional(), handle: z.string(), path: z.string().nullable().optional(), preview_truncated: z.boolean().optional(), row_count: z.number().int(), rows: z.array(z.record(z.string(), z.string())).optional()});

export const tableQueryColumn = z.object({data_type: z.string(), name: z.string()});

export const sheetQueryRegion = z.object({a1_range: z.string(), basis: z.enum(["verified", "inputs", "provenance"]).optional(), bounding: z.boolean().optional(), kind: z.literal("sheet").optional(), matched_rows: z.number().int().optional(), scan_index: z.number().int().nullable().optional(), scan_label: z.string().nullable().optional(), sheet_name: z.string().nullable().optional(), source_path: z.string()});

export const artifactRowRun = z.object({end: z.number().int(), start: z.number().int()});

export const rowRangeQueryRegion = z.object({basis: z.enum(["verified", "inputs", "provenance"]).optional(), bounding: z.boolean().optional(), columns: z.array(z.string()).optional(), derivative_path: z.string().nullable().optional(), end_row: z.number().int(), filter_columns: z.array(z.string()).optional(), kind: z.literal("row_range").optional(), matched_rows: z.number().int().optional(), read_columns: z.array(z.string()).optional(), region_id: z.string().nullable().optional(), runs: z.array(artifactRowRun).optional(), runs_replayable: z.boolean().optional(), runs_truncated: z.boolean().optional(), scan_index: z.number().int().nullable().optional(), scan_label: z.string().nullable().optional(), source_path: z.string(), start_row: z.number().int()});

export const tableQueryGrounding = z.object({columns: z.array(tableQueryColumn).optional(), grounding_reason: z.string().nullable().optional(), grounding_status: z.enum(["exact", "unavailable", "zero_result"]).nullable().optional(), preview_truncated: z.boolean().optional(), regions: z.array(z.discriminatedUnion("kind", [sheetQueryRegion, rowRangeQueryRegion])).optional(), result_id: z.string().nullable().optional(), row_count: z.number().int().optional(), rows: z.array(z.record(z.string(), z.string())).optional(), source_paths: z.array(z.string()).optional(), sql: z.string(), supports_answer: z.boolean().optional(), verified: z.boolean().optional()});

export const queryTableResultFile = z.object({download_url: z.string(), download_url_expires_at: z.string(), file_id: z.string(), file_name: z.string(), format: z.literal("parquet"), handle: z.string(), path: z.string(), preview_url: z.string(), row_count: z.number().int()});

export const queryTableCitation = z.object({grounding: tableQueryGrounding.nullable().optional(), result_file: queryTableResultFile, source_paths: z.array(z.string()), sql: z.string()});

export const runSqlResponse = z.object({credits: z.number().int().gte(0).nullable().optional(), duplicate: z.boolean().optional(), job_id: z.string().nullable().optional(), result: queryTablePreview, result_citation: queryTableCitation.nullable().optional(), result_materialization_error: z.string().nullable().optional(), source_paths: z.array(z.string()).optional(), sql: z.string(), waiver: z.enum(["repeat_of_job", "no_job"]).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
};

/**
 * run_sql
 * 
 * POST /v1/workspaces/{workspace_id}/tools/run-sql
 */
export const createApiV1WorkspacesWorkspaceIdToolsRunSql = async (args: CreateApiV1WorkspacesWorkspaceIdToolsRunSqlArgs, options?: CreateApiV1WorkspacesWorkspaceIdToolsRunSqlOptions) => {
const {baseUrl = "https://ndi-api.nace.ai", fetch: fetchFn = fetch, APIKeyHeader} = options ?? {}

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

if (args['Idempotency-Key'] != null) headers.set("Idempotency-Key", String(args['Idempotency-Key']))
if (APIKeyHeader !== undefined) headers.set("X-API-Key", APIKeyHeader)

const url = `${baseUrl.replace(/\/+$/, '')}/v1/workspaces/${encodeURIComponent(String(args.workspace_id))}/tools/run-sql${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(runSqlResponse, await res.json())
};