Method createBookmark

server/storage.ts:1664–1688

(bookmark: InsertBookmark)

  }

  async createBookmark(bookmark: InsertBookmark): Promise<Bookmark> {
    // Cast needed: drizzle-zod's InsertBookmark resolves to {} due to .omit() type issue
    const bk = bookmark as { userId?: string; entityType: string; entityId?: number | null; searchQuery?: string | null; label?: string | null };
    const [created] = await db.insert(bookmarks).values(bookmark)
      .onConflictDoNothing()
      .returning();
    if (!created) {
      // Duplicate bookmark — return the existing one
      const existing = await db.select().from(bookmarks).where(
        bk.searchQuery
          ? and(
              eq(bookmarks.userId, bk.userId ?? "anonymous"),
              eq(bookmarks.entityType, bk.entityType),
              eq(bookmarks.searchQuery, bk.searchQuery),
            )
          : and(
              eq(bookmarks.userId, bk.userId ?? "anonymous"),
              eq(bookmarks.entityType, bk.entityType),
              eq(bookmarks.entityId, bk.entityId!),
            )
      );
      return existing[0];
    }
    return created;
  }

  async deleteBookmark(id: number): Promise<boolean> {
    const result = await db.delete(bookmarks).where(eq(bookmarks.id, id)).returning();