Skip to content

High performance self-hosted photo and video management solution.

14.3 KB
Raw Blame
import { Selectable, ShallowDehydrateObject } from 'kysely';
import type { UserMetadataItem } from 'src/types.js';
import { MapAsset } from 'src/dtos/asset-response.dto.js';
import { PersonUserRole } from 'src/dtos/person.dto.js';
import {
  AlbumUserRole,
  AssetFileType,
  AssetType,
  AssetVisibility,
  ChecksumAlgorithm,
  MemoryType,
  Permission,
  SharedLinkType,
  SourceType,
  UserAvatarColor,
  UserStatus,
} from 'src/enum.js';
import { AlbumTable } from 'src/schema/tables/album.table.js';
import { AssetExifTable } from 'src/schema/tables/asset-exif.table.js';
import { AssetTable } from 'src/schema/tables/asset.table.js';
import { PluginTable } from 'src/schema/tables/plugin.table.js';

export type AuthUser = {
  id: string;
  isAdmin: boolean;
  name: string;
  email: string;
  quotaUsageInBytes: number;
  quotaSizeInBytes: number | null;
};

export type AlbumUser = {
  user: ShallowDehydrateObject<User>;
  role: AlbumUserRole;
};

export type AssetFile = {
  id: string;
  type: AssetFileType;
  path: string;
  isEdited: boolean;
};

export type Library = {
  id: string;
  ownerId: string;
  createdAt: Date;
  updatedAt: Date;
  updateId: string;
  name: string;
  importPaths: string[];
  exclusionPatterns: string[];
  deletedAt: Date | null;
  refreshedAt: Date | null;
  assets?: MapAsset[];
};

export type AuthApiKey = {
  id: string;
  permissions: Permission[];
};

export type Activity = {
  id: string;
  createdAt: Date;
  updatedAt: Date;
  albumId: string;
  userId: string;
  user: ShallowDehydrateObject<User>;
  assetId: string | null;
  comment: string | null;
  isLiked: boolean;
  updateId: string;
};

export type ApiKey = {
  id: string;
  name: string;
  userId: string;
  createdAt: Date;
  updatedAt: Date;
  permissions: Permission[];
};

export type Passkey = {
  id: string;
  name: string | null;
  userId: string;
  credentialId: string;
  transports: string[];
  createdAt: Date;
  updatedAt: Date;
  usedAt: Date | null;
};

export type Tag = {
  id: string;
  value: string;
  createdAt: Date;
  updatedAt: Date;
  color: string | null;
  parentId: string | null;
};

export type Memory = {
  id: string;
  createdAt: Date;
  updatedAt: Date;
  deletedAt: Date | null;
  memoryAt: Date;
  seenAt: Date | null;
  showAt: Date | null;
  hideAt: Date | null;
  type: MemoryType;
  data: Record<string, unknown>;
  ownerId: string;
  isSaved: boolean;
  assets: ShallowDehydrateObject<MapAsset>[];
};

export type Asset = {
  id: string;
  checksum: Buffer<ArrayBufferLike>;
  checksumAlgorithm: ChecksumAlgorithm;
  fileCreatedAt: Date;
  fileModifiedAt: Date;
  isExternal: boolean;
  visibility: AssetVisibility;
  libraryId: string | null;
  livePhotoVideoId: string | null;
  localDateTime: Date;
  originalFileName: string;
  originalPath: string;
  ownerId: string;
  type: AssetType;
};

export type User = {
  id: string;
  name: string;
  email: string;
  avatarColor: UserAvatarColor | null;
  profileImagePath: string;
  profileChangedAt: Date;
};

export type UserAdmin = User & {
  clusterGroupId: string;
  storageLabel: string | null;
  shouldChangePassword: boolean;
  isAdmin: boolean;
  createdAt: Date;
  updatedAt: Date;
  deletedAt: Date | null;
  oauthId: string | null;
  quotaSizeInBytes: number | null;
  quotaUsageInBytes: number;
  status: UserStatus;
  metadata: UserMetadataItem[];
};

export type StorageAsset = {
  id: string;
  ownerId: string;
  files: AssetFile[];
};

export type Stack = {
  id: string;
  primaryAssetId: string;
  owner?: ShallowDehydrateObject<User>;
  ownerId: string;
  assets: ShallowDehydrateObject<MapAsset>[];
  assetCount?: number;
};

export type AuthSharedLink = {
  id: string;
  expiresAt: Date | null;
  userId: string;
  albumId: string | null;
  showExif: boolean;
  allowUpload: boolean;
  allowDownload: boolean;
  password: string | null;
};

export type SharedLink = {
  id: string;
  album?: ShallowDehydrateObject<Album> | null;
  albumId: string | null;
  allowDownload: boolean;
  allowUpload: boolean;
  assets: ShallowDehydrateObject<MapAsset>[];
  createdAt: Date;
  description: string | null;
  expiresAt: Date | null;
  key: Buffer;
  password: string | null;
  showExif: boolean;
  type: SharedLinkType;
  userId: string;
  slug: string | null;
};

export type Album = Selectable<AlbumTable> & {
  assets: ShallowDehydrateObject<Selectable<AssetTable>>[];
};

export type AuthSession = {
  id: string;
  hasElevatedPermission: boolean;
};

export type Partner = {
  sharedById: string;
  sharedBy: ShallowDehydrateObject<User>;
  sharedWithId: string;
  sharedWith: ShallowDehydrateObject<User>;
  createdAt: Date;
  createId: string;
  updatedAt: Date;
  updateId: string;
  inTimeline: boolean;
};

export type Place = {
  admin1Code: string | null;
  admin1Name: string | null;
  admin2Code: string | null;
  admin2Name: string | null;
  alternateNames: string | null;
  countryCode: string;
  id: number;
  latitude: number;
  longitude: number;
  modificationDate: Date;
  name: string;
};

export type Session = {
  id: string;
  createdAt: Date;
  updatedAt: Date;
  expiresAt: Date | null;
  deviceOS: string;
  deviceType: string;
  appVersion: string | null;
  pinExpiresAt: Date | null;
  isPendingSyncReset: boolean;
};

export type Exif = Omit<Selectable<AssetExifTable>, 'updatedAt' | 'updateId' | 'lockedProperties'>;

export type Person = {
  createdAt: Date;
  personGroupId: string;
  ownerId: string;
  updatedAt: Date;
  updateId: string;
  isFavorite: boolean;
  name: string;
  birthDate: Date | null;
  color: string | null;
  faceAssetId: string | null;
  isHidden: boolean;
  thumbnailPath: string;
  otherPeople: { sharedById: string; name: string; birthDate: string | null; role: PersonUserRole }[];
  sharedBy: PersonUser[];
  sharedWith: PersonUser[];
};

export type PersonUser = User & { role: PersonUserRole };

export type AssetFace = {
  id: string;
  deletedAt: Date | null;
  assetId: string;
  boundingBoxX1: number;
  boundingBoxX2: number;
  boundingBoxY1: number;
  boundingBoxY2: number;
  imageHeight: number;
  imageWidth: number;
  personGroupId: string | null;
  sourceType: SourceType;
  person?: ShallowDehydrateObject<Person> | null;
  updatedAt: Date;
  updateId: string;
  isVisible: boolean;
  ownerId: string;
  assetVisibility: AssetVisibility;
  assetDeletedAt: Date | null;
};

export type Plugin = Selectable<PluginTable>;

const userColumns = ['id', 'name', 'email', 'avatarColor', 'profileImagePath', 'profileChangedAt'] as const;
const user2Columns = [
  'user2.id',
  'user2.name',
  'user2.email',
  'user2.avatarColor',
  'user2.profileImagePath',
  'user2.profileChangedAt',
] as const;

export const columns = {
  asset: [
    'asset.id',
    'asset.checksum',
    'asset.checksumAlgorithm',
    'asset.fileCreatedAt',
    'asset.fileModifiedAt',
    'asset.isExternal',
    'asset.visibility',
    'asset.libraryId',
    'asset.livePhotoVideoId',
    'asset.localDateTime',
    'asset.originalFileName',
    'asset.originalPath',
    'asset.ownerId',
    'asset.type',
    'asset.width',
    'asset.height',
    'asset.isEdited',
  ],
  searchAsset: [
    'asset.id',
    'asset.updateId',
    'asset.createdAt',
    'asset.updatedAt',
    'asset.deletedAt',
    'asset.status',
    'asset.checksum',
    'asset.checksumAlgorithm',
    'asset.duplicateId',
    'asset.duration',
    'asset.fileCreatedAt',
    'asset.fileModifiedAt',
    'asset.isExternal',
    'asset.isFavorite',
    'asset.isOffline',
    'asset.isEdited',
    'asset.visibility',
    'asset.libraryId',
    'asset.livePhotoVideoId',
    'asset.localDateTime',
    'asset.originalFileName',
    'asset.originalPath',
    'asset.ownerId',
    'asset.stackId',
    'asset.thumbhash',
    'asset.type',
    'asset.width',
    'asset.height',
  ],
  workflowAssetV1: [
    'asset.id',
    'asset.ownerId',
    'asset.stackId',
    'asset.livePhotoVideoId',
    'asset.libraryId',
    'asset.duplicateId',
    'asset.createdAt',
    'asset.updatedAt',
    'asset.deletedAt',
    'asset.fileCreatedAt',
    'asset.fileModifiedAt',
    'asset.localDateTime',
    'asset.type',
    'asset.status',
    'asset.visibility',
    'asset.duration',
    'asset.checksum',
    'asset.originalPath',
    'asset.originalFileName',
    'asset.isOffline',
    'asset.isFavorite',
    'asset.isExternal',
    'asset.isEdited',
    'asset.isFavorite',
  ],
  assetFiles: ['asset_file.id', 'asset_file.path', 'asset_file.type', 'asset_file.isEdited'],
  assetFilesForThumbnail: [
    'asset_file.id',
    'asset_file.path',
    'asset_file.type',
    'asset_file.isEdited',
    'asset_file.isProgressive',
    'asset_file.isTransparent',
  ],
  authUser: ['user.id', 'user.name', 'user.email', 'user.isAdmin', 'user.quotaUsageInBytes', 'user.quotaSizeInBytes'],
  authApiKey: ['api_key.id', 'api_key.permissions'],
  authSession: ['session.id', 'session.updatedAt', 'session.pinExpiresAt', 'session.appVersion'],
  user: userColumns,
  user2: user2Columns,
  userPrefix: [
    'user.id',
    'user.name',
    'user.email',
    'user.avatarColor',
    'user.profileImagePath',
    'user.profileChangedAt',
  ],
  userAdmin: [
    ...userColumns,
    'clusterGroupId',
    'createdAt',
    'updatedAt',
    'deletedAt',
    'isAdmin',
    'status',
    'oauthId',
    'profileImagePath',
    'shouldChangePassword',
    'storageLabel',
    'quotaSizeInBytes',
    'quotaUsageInBytes',
  ],
  tag: ['tag.id', 'tag.value', 'tag.createdAt', 'tag.updatedAt', 'tag.color', 'tag.parentId'],
  apiKey: ['id', 'name', 'userId', 'createdAt', 'updatedAt', 'permissions'],
  passkey: ['id', 'name', 'userId', 'credentialId', 'transports', 'createdAt', 'updatedAt', 'usedAt'],
  notification: ['id', 'createdAt', 'level', 'type', 'title', 'description', 'data', 'readAt'],
  pluginMethod: [
    'plugin_method.name',
    'plugin_method.title',
    'plugin_method.description',
    'plugin_method.types',
    'plugin_method.schema',
    'plugin_method.hostFunctions',
    'plugin_method.allowedHosts',
    'plugin_method.uiHints',
  ],
  syncAsset: [
    'asset.id',
    'asset.ownerId',
    'asset.originalFileName',
    'asset.thumbhash',
    'asset.checksum',
    'asset.fileCreatedAt',
    'asset.fileModifiedAt',
    'asset.createdAt',
    'asset.localDateTime',
    'asset.type',
    'asset.deletedAt',
    'asset.isFavorite',
    'asset.visibility',
    'asset.duration',
    'asset.livePhotoVideoId',
    'asset.stackId',
    'asset.libraryId',
    'asset.width',
    'asset.height',
    'asset.isEdited',
  ],
  syncAlbumAsset: [
    'asset.id',
    'asset.ownerId',
    'asset.originalFileName',
    'asset.thumbhash',
    'asset.checksum',
    'asset.fileCreatedAt',
    'asset.fileModifiedAt',
    'asset.createdAt',
    'asset.localDateTime',
    'asset.type',
    'asset.deletedAt',
    'asset.visibility',
    'asset.duration',
    'asset.livePhotoVideoId',
    'asset.stackId',
    'asset.libraryId',
    'asset.width',
    'asset.height',
    'asset.isEdited',
  ],
  syncPartnerAsset: [
    'asset.id',
    'asset.ownerId',
    'asset.originalFileName',
    'asset.thumbhash',
    'asset.checksum',
    'asset.fileCreatedAt',
    'asset.fileModifiedAt',
    'asset.localDateTime',
    'asset.createdAt',
    'asset.type',
    'asset.deletedAt',
    'asset.visibility',
    'asset.duration',
    'asset.livePhotoVideoId',
    'asset.stackId',
    'asset.libraryId',
    'asset.width',
    'asset.height',
    'asset.isEdited',
  ],
  syncAlbumUser: ['album_user.albumId as albumId', 'album_user.userId as userId', 'album_user.role'],
  syncStack: ['stack.id', 'stack.createdAt', 'stack.updatedAt', 'stack.primaryAssetId', 'stack.ownerId'],
  syncUser: ['id', 'name', 'email', 'avatarColor', 'deletedAt', 'updateId', 'profileImagePath', 'profileChangedAt'],
  stack: ['stack.id', 'stack.primaryAssetId', 'ownerId'],
  syncAssetFace: [
    'asset_face.id',
    'asset_face.assetId',
    'asset_face.personGroupId as personId',
    'asset_face.imageWidth',
    'asset_face.imageHeight',
    'asset_face.boundingBoxX1',
    'asset_face.boundingBoxY1',
    'asset_face.boundingBoxX2',
    'asset_face.boundingBoxY2',
    'asset_face.sourceType',
    'asset_face.isVisible',
    'asset_face.deletedAt',
  ],
  syncAssetExif: [
    'asset_exif.assetId',
    'asset_exif.description',
    'asset_exif.exifImageWidth',
    'asset_exif.exifImageHeight',
    'asset_exif.fileSizeInByte',
    'asset_exif.orientation',
    'asset_exif.dateTimeOriginal',
    'asset_exif.modifyDate',
    'asset_exif.timeZone',
    'asset_exif.latitude',
    'asset_exif.longitude',
    'asset_exif.projectionType',
    'asset_exif.city',
    'asset_exif.state',
    'asset_exif.country',
    'asset_exif.make',
    'asset_exif.model',
    'asset_exif.lensModel',
    'asset_exif.fNumber',
    'asset_exif.focalLength',
    'asset_exif.iso',
    'asset_exif.exposureTime',
    'asset_exif.profileDescription',
    'asset_exif.rating',
    'asset_exif.fps',
  ],
  syncAssetOcr: [
    'asset_ocr.id',
    'asset_ocr.assetId',
    'asset_ocr.x1',
    'asset_ocr.y1',
    'asset_ocr.x2',
    'asset_ocr.y2',
    'asset_ocr.x3',
    'asset_ocr.y3',
    'asset_ocr.x4',
    'asset_ocr.y4',
    'asset_ocr.text',
    'asset_ocr.boxScore',
    'asset_ocr.textScore',
    'asset_ocr.updateId',
    'asset_ocr.isVisible',
  ],
  syncAssetEdit: [
    'asset_edit.id',
    'asset_edit.assetId',
    'asset_edit.sequence',
    'asset_edit.action',
    'asset_edit.parameters',
  ],
  exif: [
    'asset_exif.assetId',
    'asset_exif.autoStackId',
    'asset_exif.bitsPerSample',
    'asset_exif.city',
    'asset_exif.colorspace',
    'asset_exif.country',
    'asset_exif.dateTimeOriginal',
    'asset_exif.description',
    'asset_exif.exifImageHeight',
    'asset_exif.exifImageWidth',
    'asset_exif.exposureTime',
    'asset_exif.fileSizeInByte',
    'asset_exif.fNumber',
    'asset_exif.focalLength',
    'asset_exif.fps',
    'asset_exif.iso',
    'asset_exif.latitude',
    'asset_exif.lensModel',
    'asset_exif.livePhotoCID',
    'asset_exif.longitude',
    'asset_exif.make',
    'asset_exif.model',
    'asset_exif.modifyDate',
    'asset_exif.orientation',
    'asset_exif.profileDescription',
    'asset_exif.projectionType',
    'asset_exif.rating',
    'asset_exif.state',
    'asset_exif.tags',
    'asset_exif.timeZone',
  ],
} as const;

export type LockableProperty = (typeof lockableProperties)[number];
export const lockableProperties = [
  'description',
  'dateTimeOriginal',
  'latitude',
  'longitude',
  'rating',
  'timeZone',
  'tags',
] as const;