schema.ts

// Models

import type { Dispatch, SetStateAction } from 'react'
import type { Counter } from './server/makeCounter'

export type Migration = {
  id: number
  applied: string // as ISO 8601 string
  name: string // Unique
}

export type File = {
  id: number
  nanoid: string
  path: string // Unique
  taken_at: string | null // as ISO 8601 string
  added_at: string // as ISO 8601 string
  updated_at: string // as ISO 8601 string
  bytes: number
  sha512: string
  extension: string
  type: 'photo' | 'video' | 'other'
  width: number | null
  height: number | null
  seconds: number | null
  metadata?: Record<string, unknown>
  version?: number // Added dynamically via editing methods
  tags?: Tag[] // Added dynamically for a selected file on the client
}

export type Tag = {
  id: number
  nanoid: string
  name: string // Unique
  shortcut?: string // Unique
  created_at: string // as ISO 8601 string
  updated_at: string // as ISO 8601 string
}

export type FileTag = {
  id: number
  nanoid: string
  created_at: string // As a date
  updated_at: string // as ISO 8601 string
  file_id: number // As foreign key to File
  tag_id: number // As foreign key to Tag
}

// Actions

export type Data = {
  files: Map<number, File>
  fileMapKeys: number[]
  fileKeyToIndex: Map<number, number>
  tags: Map<number, Tag>
  b2Endpoint: string
  folders: {
    thumbnails: string
    exports: string
    tags: string
  }
  selected: SelectedManifest
  lastSelected: [number, number] | null
}
export type SetData = Dispatch<SetStateAction<Data>>

export type MakeTag = Tag[]

export type UpdateTagPayload = {
  newName: string
  newShortcut: string
  oldName: string
}
export type UpdateTag = Tag[]

// Reports

export type MakeThumbnailsReport = {
  remaining: number
  total: number
  type: 'thumbnails'
}

export type MakeExportsReport = {
  remaining: number
  total: number
  type: 'exports'
}

export type MakeFilesReport = {
  toAddSize: number
  addedSize: number
  toRemoveSize: number
  type: 'files'
}

export type DeleteFilesReport = {
  toAddSize: number
  addedSize: number
  toRemoveSize: number
  type: 'delete-files'
}

export type SyncReport = {
  sync: string
  type: 'sync'
}

export type Report = (
  | MakeFilesReport
  | DeleteFilesReport
  | MakeThumbnailsReport
  | MakeExportsReport
  | SyncReport
) & { counter: Counter }

export type SelectedManifest = Map<number, { path: string; sha512: string }>

export type Electron = {
  // Actions
  getData: (
    directory: string,
    direction: string,
    field: string,
    showDuplicates: boolean,
    tag: string,
    search: string,
    type: string
  ) => Promise<Data>
  getSelectedTags: (fileId: number) => Promise<(FileTag & Tag)[]>
  makeTag: (name: string) => Promise<Tag[]>
  updateTag: (payload: UpdateTagPayload) => Promise<Tag[]>
  deleteTag: (tag: Tag, directory: string) => Promise<Tag[]>
  deleteFileTag: (file_tag_id: number) => Promise<boolean>
  openFile: (path: string) => Promise<void>
  openFileInFinder: (path: string) => Promise<void>
  getFile: (path: string) => Promise<File>
  deleteFiles: (directory: string, manifest: SelectedManifest) => Promise<void>
  rotatePhoto: (
    directory: string,
    path: string,
    sha512: string
  ) => Promise<{
    sha512: string
    updated_at: string
    width: number
    height: number
    metadata: Record<string, unknown>
  }>
  tagItems: (
    directory: string,
    file_ids: number[],
    tag_id: number
  ) => Promise<FileTag>
  sync: (directory: string) => Promise<void>
  publish: (directory: string) => Promise<void>

  // Reporter
  onReport: (callback: (payload: Report) => void) => void
}