import {z} from 'zod'

export type DbaasServiceName = string;

export type GetApiDbaasMysqlNameArgs = {name: DbaasServiceName};

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

export const dbaasIntegration = z.object({description: z.string().optional(), settings: z.object({}).optional(), type: z.string().optional(), "is-enabled": z.boolean().optional(), source: z.string().optional(), "is-active": z.boolean().optional(), status: z.string().optional(), id: z.string().optional(), dest: z.string().optional()});

export const dbaasNodeStateProgressUpdate = z.object({completed: z.boolean(), current: z.number().int().gte(0).optional(), max: z.number().int().gte(0).optional(), min: z.number().int().gte(0).optional(), phase: z.enum(["stream", "basebackup", "prepare", "finalize"]), unit: z.string().optional()});

export const dbaasNodeState = z.object({name: z.string(), "progress-updates": z.array(dbaasNodeStateProgressUpdate).optional(), role: z.enum(["standby", "master", "read-replica"]).optional(), state: z.enum(["leaving", "running", "syncing_data", "setting_up_vm", "unknown"])});

export const dbaasServiceName = z.string().max(63);

export const dbaasServiceTypeName = z.string().max(64);

export const enumServiceState = z.enum(["running", "rebuilding", "rebalancing", "poweroff"]);

export const dbaasMysqlDatabaseName = z.string().min(1).max(64);

export const dbaasServiceBackup = z.object({"backup-name": z.string(), "backup-time": z.string(), "data-size": z.number().int().gte(0)});

export const dbaasServiceNotification = z.object({level: z.enum(["warning", "notice"]), message: z.string().min(1).max(1024), type: z.enum(["service_powered_off_removal", "service_end_of_life"]), metadata: z.object({})});

export const enumComponentRoute = z.enum(["dynamic", "private", "public", "privatelink"]);

export const enumComponentUsage = z.enum(["primary", "replica"]);

export const jsonSchemaMysql = z.object({net_write_timeout: z.number().int().gte(1).lte(3600).optional(), internal_tmp_mem_storage_engine: z.enum(["TempTable", "MEMORY"]).optional(), sql_mode: z.string().max(1024).optional(), information_schema_stats_expiry: z.number().int().gte(900).lte(31536000).optional(), sort_buffer_size: z.number().int().gte(32768).lte(1073741824).optional(), innodb_thread_concurrency: z.number().int().gte(0).lte(1000).optional(), innodb_write_io_threads: z.number().int().gte(1).lte(64).optional(), innodb_ft_min_token_size: z.number().int().gte(0).lte(16).optional(), innodb_change_buffer_max_size: z.number().int().gte(0).lte(50).optional(), innodb_flush_neighbors: z.number().int().gte(0).lte(2).optional(), tmp_table_size: z.number().int().gte(1048576).lte(1073741824).optional(), slow_query_log: z.boolean().optional(), connect_timeout: z.number().int().gte(2).lte(3600).optional(), log_output: z.enum(["INSIGHTS", "INSIGHTS,TABLE", "NONE", "TABLE"]).optional(), net_read_timeout: z.number().int().gte(1).lte(3600).optional(), innodb_lock_wait_timeout: z.number().int().gte(1).lte(3600).optional(), wait_timeout: z.number().int().gte(1).lte(2147483).optional(), innodb_rollback_on_timeout: z.boolean().optional(), group_concat_max_len: z.number().int().gte(4).lte(18446744073709552000).optional(), net_buffer_length: z.number().int().gte(1024).lte(1048576).optional(), innodb_print_all_deadlocks: z.boolean().optional(), innodb_online_alter_log_max_size: z.number().int().gte(65536).lte(1099511627776).optional(), interactive_timeout: z.number().int().gte(30).lte(604800).optional(), innodb_log_buffer_size: z.number().int().gte(1048576).lte(4294967295).optional(), max_allowed_packet: z.number().int().gte(102400).lte(1073741824).optional(), max_heap_table_size: z.number().int().gte(1048576).lte(1073741824).optional(), innodb_ft_server_stopword_table: z.string().max(1024).nullable().optional(), innodb_read_io_threads: z.number().int().gte(1).lte(64).optional(), sql_require_primary_key: z.boolean().optional(), default_time_zone: z.string().min(2).max(100).optional(), long_query_time: z.number().gte(0).lte(3600).optional()});

export const dbaasServiceUpdate = z.object({description: z.string().optional(), deadline: z.string().optional(), "start-after": z.string().optional(), "start-at": z.string().optional()});

export const dbaasServiceMaintenance = z.object({dow: z.enum(["saturday", "tuesday", "never", "wednesday", "sunday", "friday", "monday", "thursday"]), time: z.string().min(8).max(8), updates: z.array(dbaasServiceUpdate)});

export const dbaasServiceMysql = z.object({"updated-at": z.string().optional(), "node-count": z.number().int().gte(0).optional(), "connection-info": z.object({uri: z.array(z.string()).optional(), params: z.array(z.record(z.string(), z.string())).optional(), standby: z.array(z.string()).optional()}).optional(), "backup-schedule": z.object({"backup-hour": z.number().int().gte(0).lte(23).optional(), "backup-minute": z.number().int().gte(0).lte(59).optional()}).optional(), "node-cpu-count": z.number().int().gte(0).optional(), "prometheus-uri": z.object({host: z.string().optional(), port: z.number().int().gte(0).lte(65535).optional()}), integrations: z.array(dbaasIntegration).optional(), zone: z.string().optional(), "node-states": z.array(dbaasNodeState).optional(), name: dbaasServiceName, type: dbaasServiceTypeName, state: enumServiceState.optional(), databases: z.array(dbaasMysqlDatabaseName).optional(), "ip-filter": z.array(z.string()).optional(), backups: z.array(dbaasServiceBackup).optional(), "termination-protection": z.boolean().optional(), notifications: z.array(dbaasServiceNotification).optional(), components: z.array(z.object({component: z.string(), host: z.string(), port: z.number().int().gte(0).lte(65535), route: enumComponentRoute, usage: enumComponentUsage})).optional(), "mysql-settings": jsonSchemaMysql.optional(), maintenance: dbaasServiceMaintenance.optional(), "disk-size": z.number().int().gte(0).optional(), "node-memory": z.number().int().gte(0).optional(), uri: z.string().optional(), "uri-params": z.object({}).optional(), version: z.string().optional(), "created-at": z.string().optional(), plan: z.string(), users: z.array(z.object({type: z.string().optional(), username: z.string().optional(), password: z.string().optional(), authentication: z.string().optional()})).optional(), "binlog-retention-period": z.number().int().gt(0).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
};

/**
 * Get a DBaaS MySQL service
 * 
 * GET /dbaas-mysql/{name}
 */
export const getApiDbaasMysqlName = async (args: GetApiDbaasMysqlNameArgs, options?: GetApiDbaasMysqlNameOptions) => {
const {baseUrl = "https://api-ch-gva-2.exoscale.com/v2", fetch: fetchFn = fetch} = options ?? {}

const query = new URLSearchParams()
const headers = new Headers()
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: "GET", headers})

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

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