import { SchemaInstallationStatus, StripeSchemaComment } from 'stripe-experiment-sync/supabase'

import type {
  StripeSyncState,
  StripeSyncStateData,
} from '@/data/database-integrations/stripe/sync-state-query'
import type { Schema } from '@/data/database/schemas-query'

/**
 * Complete Stripe Sync status including schema, installation state, and sync state
 */
export interface StripeSyncStatusResult {
  /** The parsed schema with status, version and error */
  schemaComment: StripeSchemaComment

  /** Current sync run state (only available when installationStatus is installed) */
  syncState: StripeSyncState | undefined

  /** Whether the status is still being determined (schemas query is loading) */
  isLoading: boolean

  /** Latest version of stripe sync engine available for installation */
  latestAvailableVersion: string

  /** True when installation or uninstallation has timed out */
  timedOut: boolean
}

export function findStripeSchema(schemas: Schema[] | undefined): Schema | undefined {
  return schemas?.find((s) => s.name === 'stripe')
}

export function isInstalled(status: SchemaInstallationStatus): boolean {
  return status === 'installed'
}

export function isUninstalled(status: SchemaInstallationStatus): boolean {
  return status === 'uninstalled'
}

export function hasInstallError(status: SchemaInstallationStatus): boolean {
  return status === 'install error'
}

export function hasUninstallError(status: SchemaInstallationStatus): boolean {
  return status === 'uninstall error'
}

export function hasError(status: SchemaInstallationStatus): boolean {
  return hasInstallError(status) || hasUninstallError(status)
}

export function isInstalling(status: SchemaInstallationStatus): boolean {
  return status === 'installing'
}

export function isUninstalling(status: SchemaInstallationStatus): boolean {
  return status === 'uninstalling'
}

export function isInProgress(status: SchemaInstallationStatus): boolean {
  return isInstalling(status) || isUninstalling(status)
}

export function isInstallDone(status: SchemaInstallationStatus): boolean {
  return isInstalled(status) || hasInstallError(status)
}

export function isUninstallDone(status: SchemaInstallationStatus): boolean {
  return isUninstalled(status) || hasUninstallError(status)
}

export function canInstall(status: SchemaInstallationStatus): boolean {
  return isUninstalled(status) || hasError(status)
}

export function isSyncRunning(syncState: StripeSyncStateData | undefined): boolean {
  return !!syncState && !syncState.closed_at && syncState.status === 'running'
}