import {z} from 'zod'

export type DatabaseParameter = {name?: string | undefined, description?: string | undefined, dataType?: ('STRING' | 'CLOB' | 'BOOLEAN' | 'INTEGER' | 'LONG' | 'DOUBLE' | 'DATE' | 'DATETIME' | 'REF_CURSOR') | undefined, format?: string | undefined, paramType?: ('BODY' | 'PATH' | 'QUERY' | 'HEADER' | 'FORMDATA') | undefined, repetitionType?: ('SINGLE' | 'MULTIPLE') | undefined, paramDirection?: ('OUT' | 'IN') | undefined, booleanValue?: boolean | undefined, dateValue?: string | undefined, doubleValue?: number | undefined, longValue?: number | undefined, intValue?: number | undefined, stringValue?: string | undefined, clobValue?: string | undefined, indexList?: Array<number> | undefined};

export type DbToApiMethod = {id?: string | undefined, name?: string | undefined, description?: string | undefined, httpMethod?: ('GET' | 'POST' | 'PUT' | 'HEAD' | 'OPTIONS' | 'DELETE' | 'PATCH' | 'TRACE' | 'ALL' | 'QUERY') | undefined, sqlStatement?: string | undefined, connectionPoolDefId?: string | undefined, parameterList?: Array<DatabaseParameter> | undefined, reqIgnoreNull?: boolean | undefined, reqIgnoreEmpty?: boolean | undefined, reqNumbersAsStrings?: boolean | undefined, queryTimeout?: number | undefined, exampleResponse?: string | undefined, parsed?: boolean | undefined, operationType?: ('SELECT' | 'UPDATE' | 'INSERT' | 'DELETE' | 'PROCEDURE' | 'TRUNCATE' | 'BATCH_INSERT') | undefined, databaseType?: ('ORACLE' | 'MYSQL' | 'POSTGRES' | 'SQL_SERVER' | 'SYBASE' | 'DB2' | 'APACHE_HIVE' | 'APACHE_IMPALA' | 'MONGODB' | 'TRINO') | undefined, environmentSettingsId?: string | undefined};

export type DbToApi = {id?: string | undefined, name?: string | undefined, description?: string | undefined, projectId?: string | undefined, methodDefList?: Array<DbToApiMethod> | undefined};

export type CreateApiApiopsProjectsProjectNameDb2apisDb2ApiNameArgs = {projectName: string, db2ApiName: string, body: DbToApi};

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

export const deploymentResult = z.object({envName: z.string().optional(), podName: z.string().optional(), podIp: z.string().optional(), success: z.boolean().optional(), detail: z.string().optional(), responseTime: z.number().int().optional(), detailList: z.array(z.unknown()).optional(), firstFromApiResultList: z.unknown()});

export const apiOpsAdvisoryDTO = z.object({level: z.string().optional(), key: z.string().optional(), params: z.record(z.string(), z.unknown()).optional()});

export const apiOpsResponseSuccess = z.object({status: z.enum(["SUCCESS", "FAILURE"]).optional(), resultMessage: z.string().optional(), resultList: z.array(z.string()).optional(), resultCount: z.number().int().optional(), deploymentResult: deploymentResult.optional(), unresolvedReferences: z.array(z.string()).optional(), advisories: z.array(apiOpsAdvisoryDTO).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
};

/**
 * Creates or updates a DB2API creator (promotion)
 * 
 * POST /apiops/projects/{projectName}/db2apis/{db2ApiName}/
 */
export const createApiApiopsProjectsProjectNameDb2apisDb2ApiName = async (args: CreateApiApiopsProjectsProjectNameDb2apisDb2ApiNameArgs, options?: CreateApiApiopsProjectsProjectNameDb2apisDb2ApiNameOptions) => {
const {baseUrl = "http://167.86.118.166:32080", 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(/\/+$/, '')}/apiops/projects/${encodeURIComponent(String(args.projectName))}/db2apis/${encodeURIComponent(String(args.db2ApiName))}/${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(apiOpsResponseSuccess, await res.json())
};