Method get_rec_by_id

buku.py:652–668

Get a bookmark from database by its ID. Parameters ---------- index : int DB index of bookmark record. lock : bool Whether to restrict concurrent access (True by default). Returns ------- BookmarkVar or None

(self, index: int, *, lock: bool = True)

        return self._fetch(f'SELECT * FROM bookmarks ORDER BY {self._order(order, ignore_case)}', lock=lock)

    def get_rec_by_id(self, index: int, *, lock: bool = True) -> Optional[BookmarkVar]:
        """Get a bookmark from database by its ID.

        Parameters
        ----------
        index : int
            DB index of bookmark record.
        lock : bool
            Whether to restrict concurrent access (True by default).

        Returns
        -------
        BookmarkVar or None
            Bookmark data, or None if index is not found.
        """

        return self._fetch_first('SELECT * FROM bookmarks WHERE id = ?', index, lock=lock)

    def get_rec_all_by_ids(self, indices: Ints, *, lock: bool = True, order: List[str] = ['id']):
        """Get all the bookmarks in the database.