import type { SqliteDb } from '@livestore/common'
import { prettyBytes } from '@livestore/utils'
import { Effect } from '@livestore/utils/effect'

declare global {
  var __debugLiveStoreUtils: any
}

export const downloadBlob = (
  data: Uint8Array<ArrayBuffer> | Blob | string,
  fileName: string,
  mimeType = 'application/octet-stream',
) => {
  const blob = data instanceof Blob ? data : new Blob([data], { type: mimeType })

  const url = window.URL.createObjectURL(blob)

  downloadURL(url, fileName)

  setTimeout(() => window.URL.revokeObjectURL(url), 1000)
}

export const downloadURL = (data: string, fileName: string) => {
  const a = document.createElement('a')
  a.href = data
  a.download = fileName
  document.body.append(a)
  a.style.display = 'none'
  a.click()
  a.remove()
}

export const exposeDebugUtils = () => {
  globalThis.__debugLiveStoreUtils = {
    downloadBlob,
    runSync: <A, E>(effect: Effect.Effect<A, E>) => Effect.runSync(effect),
    runFork: <A, E>(effect: Effect.Effect<A, E>) => Effect.runFork(effect),
    dumpDb: (db: SqliteDb) => {
      const tables = db.select<{ name: string }>(`SELECT name FROM sqlite_master WHERE type='table'`)
      for (const table of tables) {
        const rows = db.select<any>(`SELECT * FROM ${table.name}`)
        console.log(`Table: ${table.name} (${prettyBytes(table.name.length)}, ${rows.length} rows)`)
        console.table(rows)
      }
    },
  }
}