Self-hosted personal gallery application with online photo management and albums, supporting Live/Motion Photos, EXIF parsing, geolocation recognition, and an explore map.
TypeScript albumsexif-extractiongeocodinglive-photomotion-photophoto-galleryphoto-sharingwebgl-viewer
import { and as siteAnd, eq as siteEq } from 'drizzle-orm'
import { DEFAULT_SITE } from '@chronoframe/core'
import type { z } from 'zod'
import { eq } from 'drizzle-orm'
import * as tables from '../database/schema.ts'
import { useDB } from './db.ts'
export { queuePayloadSchema } from '@chronoframe/contracts/queue'
import { queuePayloadSchema } from '@chronoframe/contracts/queue'
export const queuePayloadRequiresAdmin = (
payload: z.infer<typeof queuePayloadSchema>,
): boolean =>
payload.type === 'location-migration' ||
(payload.type === 'photo' && payload.albumId !== undefined)
export const photoTaskAlbumExists = (
payload: z.infer<typeof queuePayloadSchema>,
db?: ReturnType<typeof useDB>,
): boolean => {
if (payload.type !== 'photo' || payload.albumId === undefined) return true
const album = (db ?? useDB())
.select({ id: tables.albums.id })
.from(tables.albums)
.where(
siteAnd(
eq(tables.albums.id, payload.albumId),
siteEq(tables.albums.siteId, DEFAULT_SITE.id),
),
)
.get()
return Boolean(album)
}
export const createPhotoTaskAlbumChecker = (db?: ReturnType<typeof useDB>) => {
const cache = new Map<number, boolean>()
return (payload: z.infer<typeof queuePayloadSchema>): boolean => {
if (payload.type !== 'photo' || payload.albumId === undefined) return true
const cached = cache.get(payload.albumId)
if (cached !== undefined) return cached
const exists = photoTaskAlbumExists(payload, db)
cache.set(payload.albumId, exists)
return exists
}
}