import {z} from 'zod'

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

export const referenceDBSummarySchema = z.object({exists: z.boolean(), file_path: z.string(), file_size_bytes: z.number().int().optional(), file_size_human: z.string().optional(), last_modified: z.string().nullable().optional(), tables: z.array(z.string()).optional(), total_rows: z.number().int().optional()});

export const sourceStatusSchema = z.object({exists: z.boolean(), path: z.string(), files_found: z.number().int().optional(), files_expected: z.number().int().optional(), total_size_bytes: z.number().int().optional(), total_size_human: z.string().optional(), oldest_file_modified: z.string().nullable().optional(), newest_file_modified: z.string().nullable().optional()});

export const conversionMetadataSchema = z.object({start_time: z.string().nullable().optional(), elapsed_seconds: z.number().nullable().optional(), elapsed_human: z.string().nullable().optional(), successful_chromosomes: z.number().int().nullable().optional(), failed_chromosomes: z.number().int().nullable().optional()});

export const parquetStatusSchema = z.object({exists: z.boolean(), path: z.string(), partitions: z.number().int().optional(), partitions_expected: z.number().int().optional(), total_size_bytes: z.number().int().optional(), total_size_human: z.string().optional(), last_modified: z.string().nullable().optional(), row_count: z.number().int().nullable().optional(), conversion_metadata: conversionMetadataSchema.nullable().optional()});

export const referenceDBTableSchema = z.object({loaded: z.boolean(), table_name: z.string(), row_count: z.number().int().nullable().optional(), column_count: z.number().int().nullable().optional()});

export const freshnessSchema = z.object({status: z.string(), message: z.string(), source_age_days: z.number().int().nullable().optional(), parquet_age_days: z.number().int().nullable().optional(), cache_ttl_days: z.number().int().nullable().optional(), is_within_ttl: z.boolean().nullable().optional(), suggested_action: z.string().nullable().optional()});

export const validationSchema = z.object({passed: z.boolean(), checks: z.record(z.string(), z.unknown()).optional()});

export const databaseStatusSchema = z.object({name: z.string(), display_name: z.string(), version: z.string().nullable().optional(), description: z.string().nullable().optional(), priority: z.number().int(), enabled: z.boolean().optional(), license_required: z.boolean().optional(), vep_required: z.boolean().optional(), source_url: z.string().nullable().optional(), source: sourceStatusSchema, parquet: parquetStatusSchema, reference_db: referenceDBTableSchema, freshness: freshnessSchema, validation: validationSchema});

export const allDatabasesStatusResponse = z.object({reference_db: referenceDBSummarySchema, databases: z.array(databaseStatusSchema)});

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
};

/**
 * Get All Databases Status
 * 
 * GET /preprocessing/databases
 */
export const getApiPreprocessingDatabases = async (options: GetApiPreprocessingDatabasesOptions) => {
const {baseUrl, fetch: fetchFn = fetch} = options ?? {}

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

const url = `${baseUrl.replace(/\/+$/, '')}/preprocessing/databases${query.size > 0 ? `?${query}` : ''}`

const res = await fetchFn(url, {method: "GET", headers})

if (!res.ok) throw new Error(`Request failed with status ${res.status}`, {cause: {status: res.status, body: await res.text()}})

return validateResponse(allDatabasesStatusResponse, await res.json())
};