import {z} from 'zod'

export type EdgeConnectionStatus = string;

export type GetApiDatabasesArgs = {parentSystemId?: string | undefined, edgeConnectionId?: string | undefined, databaseConnectionId?: string | undefined, edgeConnectionStatus?: EdgeConnectionStatus | undefined, offset?: number | undefined, limit?: number | undefined};

export type GetApiDatabasesOptions = {baseUrl: string, basicAuth?: {username: string, password: string} | undefined, fetch?: typeof fetch | undefined};

export const provider = z.string();

export const providerDetails = z.record(z.string(), z.string());

export const databaseColumnTag = z.object({id: z.string(), name: z.string()});

export const access = z.string();

export const maskingType = z.string();

export const noMasking = z.object({type: maskingType});

export const defaultMasking = z.object({type: maskingType});

export const constantMasking = z.object({type: maskingType, constant: z.string().optional()});

export const hashMasking = z.object({type: maskingType});

export const showLastMasking = z.object({type: maskingType, numberOfCharacters: z.number().int().optional()});

export const customMasking = z.object({type: maskingType, customMaskingId: z.string().optional(), customMaskingName: z.string().optional()});

export const masking = z.discriminatedUnion("type", [noMasking, defaultMasking, constantMasking, hashMasking, showLastMasking, customMasking]);

export const rowFilterOperator = z.string();

export const rowFilter = z.object({operator: rowFilterOperator.optional(), values: z.array(z.string()).optional()});

export const databaseColumnAccessRule = z.object({group: z.string(), access: access, masking: masking.optional(), rowFilter: rowFilter.optional()});

export const databaseColumn = z.object({id: z.string(), name: z.string(), dataType: z.string().optional(), precision: z.number().int().optional(), scale: z.number().int().optional(), tags: z.array(databaseColumnTag), accesses: z.array(databaseColumnAccessRule)});

export const databaseTableAccessRule = z.object({group: z.string(), access: access});

export const databaseTable = z.object({id: z.string(), name: z.string(), columns: z.array(databaseColumn), accesses: z.array(databaseTableAccessRule)});

export const databaseSchema = z.object({id: z.string(), name: z.string(), tables: z.array(databaseTable)});

export const groupMasking = z.object({group: z.string(), masking: masking});

export const databaseTag = z.object({id: z.string(), name: z.string().optional(), maskings: z.array(groupMasking)});

export const maskingMappings = z.object({dataType: z.string(), functionName: z.string()});

export const databaseCustomMasking = z.object({id: z.string().optional(), name: z.string().optional(), mappings: z.array(maskingMappings).optional()});

export const database = z.object({provider: provider, providerDetails: providerDetails.optional(), id: z.string(), name: z.string(), schemas: z.array(databaseSchema).optional(), tags: z.array(databaseTag), customMaskings: z.array(databaseCustomMasking)});

export const databasePagedResponse = z.object({results: z.array(database).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
};

/**
 * Find Database assets
 * 
 * GET /databases
 * 
 * Also accepts auth: jwtAuth, oauth2, oauth2
 */
export const getApiDatabases = async (args: GetApiDatabasesArgs, options: GetApiDatabasesOptions) => {
const {baseUrl, fetch: fetchFn = fetch, basicAuth} = options ?? {}

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

if (args.parentSystemId != null) query.append("parentSystemId", String(args.parentSystemId))
if (args.edgeConnectionId != null) query.append("edgeConnectionId", String(args.edgeConnectionId))
if (args.databaseConnectionId != null) query.append("databaseConnectionId", String(args.databaseConnectionId))
if (args.edgeConnectionStatus != null) query.append("edgeConnectionStatus", String(args.edgeConnectionStatus))
if (args.offset != null) query.append("offset", String(args.offset))
if (args.limit != null) query.append("limit", String(args.limit))
if (basicAuth !== undefined) headers.set('authorization', `Basic ${btoa(`${basicAuth.username}:${basicAuth.password}`)}`)

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