import {z} from 'zod'

export type DbaasServiceName = string;

export type JsonSchemaMysql = {net_write_timeout?: number | undefined, internal_tmp_mem_storage_engine?: ('TempTable' | 'MEMORY') | undefined, sql_mode?: string | undefined, information_schema_stats_expiry?: number | undefined, sort_buffer_size?: number | undefined, innodb_thread_concurrency?: number | undefined, innodb_write_io_threads?: number | undefined, innodb_ft_min_token_size?: number | undefined, innodb_change_buffer_max_size?: number | undefined, innodb_flush_neighbors?: number | undefined, tmp_table_size?: number | undefined, slow_query_log?: boolean | undefined, connect_timeout?: number | undefined, log_output?: ('INSIGHTS' | 'INSIGHTS,TABLE' | 'NONE' | 'TABLE') | undefined, net_read_timeout?: number | undefined, innodb_lock_wait_timeout?: number | undefined, wait_timeout?: number | undefined, innodb_rollback_on_timeout?: boolean | undefined, group_concat_max_len?: number | undefined, net_buffer_length?: number | undefined, innodb_print_all_deadlocks?: boolean | undefined, innodb_online_alter_log_max_size?: number | undefined, interactive_timeout?: number | undefined, innodb_log_buffer_size?: number | undefined, max_allowed_packet?: number | undefined, max_heap_table_size?: number | undefined, innodb_ft_server_stopword_table?: (string | null) | undefined, innodb_read_io_threads?: number | undefined, sql_require_primary_key?: boolean | undefined, default_time_zone?: string | undefined, long_query_time?: number | undefined};

export type DbaasMysqlUserPassword = string;

export type EnumMigrationMethod = 'dump' | 'replication';

export type CreateApiDbaasMysqlNameArgs = {name: DbaasServiceName, body: {'backup-schedule'?: ({'backup-hour'?: (number | null) | undefined, 'backup-minute'?: (number | null) | undefined}) | undefined, integrations?: (Array<{type: 'read_replica', 'source-service'?: DbaasServiceName | undefined, 'dest-service'?: DbaasServiceName | undefined, settings?: Record<string, never> | undefined}>) | undefined, 'ip-filter'?: Array<string> | undefined, 'termination-protection'?: boolean | undefined, 'fork-from-service'?: DbaasServiceName | undefined, 'recovery-backup-time'?: string | undefined, 'mysql-settings'?: JsonSchemaMysql | undefined, maintenance?: ({dow: 'saturday' | 'tuesday' | 'never' | 'wednesday' | 'sunday' | 'friday' | 'monday' | 'thursday', time: string}) | undefined, 'admin-username'?: string | undefined, version?: string | undefined, plan: string, 'admin-password'?: DbaasMysqlUserPassword | undefined, migration?: ({host: string, port: number, password?: string | undefined, ssl?: boolean | undefined, username?: string | undefined, dbname?: string | undefined, 'ignore-dbs'?: string | undefined, method?: EnumMigrationMethod | undefined}) | undefined, 'binlog-retention-period'?: number | undefined}};

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

export const operation = z.object({id: z.string().optional(), reason: z.enum(["incorrect", "unknown", "unavailable", "forbidden", "busy", "fault", "partial", "not-found", "interrupted", "unsupported", "conflict"]).optional(), reference: z.object({id: z.string().optional(), link: z.string().optional(), command: z.string().optional()}).optional(), message: z.string().optional(), state: z.enum(["failure", "pending", "success", "timeout"]).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
};

/**
 * Create a DBaaS MySQL service
 * 
 * POST /dbaas-mysql/{name}
 */
export const createApiDbaasMysqlName = async (args: CreateApiDbaasMysqlNameArgs, options?: CreateApiDbaasMysqlNameOptions) => {
const {baseUrl = "https://api-ch-gva-2.exoscale.com/v2", 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(/\/+$/, '')}/dbaas-mysql/${encodeURIComponent(String(args.name))}${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(operation, await res.json())
};