Class NoteHistory

packages/core/src/collections/note-history.ts:28–246

import { SessionContent } from "./session-content.js";

export class NoteHistory implements ICollection {
  name = "notehistory";
  sessionContent;
  readonly collection: SQLCollection<"notehistory", HistorySession>;
  constructor(private readonly db: Database) {
    this.sessionContent = new SessionContent(db);
    this.collection = new SQLCollection(
      db.sql,
      db.transaction,
      "notehistory",
      db.eventManager,
      db.sanitizer
    );
  }

  async init() {
    await this.collection.init();
    await this.sessionContent.init();
  }

  // async get(noteId: string, order: "asc" | "desc" = "desc") {
  //   if (!noteId) return [];

  //   // const indices = this.collection.indexer.indices;
  //   // const sessionIds = indices.filter((id) => id.startsWith(noteId));
  //   // if (sessionIds.length === 0) return [];
  //   // const history = await this.getSessions(sessionIds);

  //   // return history.sort(function (a, b) {
  //   //   return b.dateModified - a.dateModified;
  //   // });
  // const history = await this.db
  //   .sql()
  //   .selectFrom("notehistory")
  //   .where("noteId", "==", noteId)
  //     .orderBy(`dateModified ${order}`)
  //     .selectAll()
  //     .execute();
  //   return history as HistorySession[];
  // }
  get(noteId: string) {
    return new FilteredSelector<HistorySession>(
      "notehistory",
      this.db.sql().selectFrom("notehistory").where("noteId", "==", noteId)
    );
  }

  async add(
    sessionId: string,
    content: Partial<NoteContent<boolean>> & {
      noteId: string;
      locked?: boolean;
      title?: string;
    }
  ) {
    const { noteId, locked } = content;
    sessionId = `${noteId}_${sessionId}`;