Function insert

src/controllers/UserBookmark.controller.ts:84–103

(bookmark: InsertBookmark)

const UserBookmarkController = {
  async insert(bookmark: InsertBookmark) {
    const userId = await getAuthedUserId()
    // 插入之前先检查当前用户是否有相同网址或名称的记录
    const count = await db.$count(
      userBookmarks,
      and(
        eq(userBookmarks.userId, userId),
        or(eq(userBookmarks.url, bookmark.url), eq(userBookmarks.name, bookmark.name))
      )
    )
    if (count > 0) throw new Error('已存在相同网址或名称的书签')
    bookmark.pinyin ||= getPinyin(bookmark.name)
    bookmark.hostKey = getBookmarkHostKey(bookmark.url)
    const rows = await db
      .insert(userBookmarks)
      .values({ ...bookmark, userId })
      .returning()
    await fullSetBookmarkToTag(rows[0].id, bookmark.relatedTagIds)
    return rows[0]
  },
  async query(bookmark: Pick<SelectUserBookmark, 'id'>) {
    const res = await db.query.userBookmarks.findFirst({
      where: userLimiter(await getAuthedUserId(), bookmark.id),