import {z} from 'zod'

export type GetApiTablesArgs = {schemaName?: string | undefined, catalogName?: string | undefined, maxResults?: number | undefined, pageToken?: string | undefined, includeDeltaMetadata?: boolean | undefined, omitColumns?: boolean | undefined, omitProperties?: boolean | undefined, omitUsername?: boolean | undefined, includeBrowse?: boolean | undefined, includeManifestCapabilities?: boolean | undefined};

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

export const columnInfo = z.object({name: z.string().optional(), typeText: z.string().optional(), typeJson: z.string().optional(), typeName: z.number().int().optional(), typePrecision: z.number().int().optional(), typeScale: z.number().int().optional(), typeIntervalType: z.string().optional(), position: z.number().int().optional(), comment: z.string().optional(), nullable: z.boolean().optional(), partitionIndex: z.number().int().optional(), columnId: z.string().optional()});

export const tableInfo = z.object({name: z.string().optional(), schemaName: z.string().optional(), catalogName: z.string().optional(), tableType: z.number().int().optional(), dataSourceFormat: z.number().int().optional(), columns: z.array(columnInfo).optional(), storageLocation: z.string().optional(), owner: z.string().optional(), comment: z.string().optional(), properties: z.object({}).optional(), storageCredentialName: z.string().optional(), fullName: z.string().optional(), createdAt: z.string().optional(), createdBy: z.string().optional(), updatedAt: z.string().optional(), updatedBy: z.string().optional(), deletedAt: z.string().optional(), tableId: z.string().optional()});

export const listTablesResponse = z.object({tables: z.array(tableInfo).optional(), nextPageToken: z.string().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
};

/**
 * Gets an array of all tables for the current metastore under the parent catalog and schema.
 * 
 * GET /tables
 */
export const getApiTables = async (args: GetApiTablesArgs, options: GetApiTablesOptions) => {
const {baseUrl, fetch: fetchFn = fetch} = options ?? {}

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

if (args.schemaName != null) query.append("schemaName", String(args.schemaName))
if (args.catalogName != null) query.append("catalogName", String(args.catalogName))
if (args.maxResults != null) query.append("maxResults", String(args.maxResults))
if (args.pageToken != null) query.append("pageToken", String(args.pageToken))
if (args.includeDeltaMetadata != null) query.append("includeDeltaMetadata", String(args.includeDeltaMetadata))
if (args.omitColumns != null) query.append("omitColumns", String(args.omitColumns))
if (args.omitProperties != null) query.append("omitProperties", String(args.omitProperties))
if (args.omitUsername != null) query.append("omitUsername", String(args.omitUsername))
if (args.includeBrowse != null) query.append("includeBrowse", String(args.includeBrowse))
if (args.includeManifestCapabilities != null) query.append("includeManifestCapabilities", String(args.includeManifestCapabilities))

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