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 { eq as siteEq } from 'drizzle-orm'
import { DEFAULT_SITE } from '@chronoframe/core'
import { toPhotoDto } from '../../utils/dto'
import { photos } from '~~/server/database/schema'
export default eventHandler(async (event) => {
await requireUserSession(event)
const method = getMethod(event)
if (method === 'GET') {
// 获取最新处理完成的照片
const recentPhotos = await useDB()
.select()
.from(photos)
.where(siteEq(photos.siteId, DEFAULT_SITE.id))
.orderBy(photos.lastModified)
.limit(10)
.all()
return {
recentPhotos: recentPhotos.map(toPhotoDto),
timestamp: new Date().toISOString(),
}
} else {
throw createError({
statusCode: 405,
statusMessage: 'Method not allowed',
})
}
})