ezsystems / ezpublish-kernel

    /**

     * Delete words not related to any content object.

     */

    public function deleteWordsWithoutObjects()

    {

        $query = $this->dbHandler->createDeleteQuery();

        $query->deleteFrom($this->dbHandler->quoteTable('ezsearch_word'))

            ->where($query->expr->eq($this->dbHandler->quoteColumn('object_count'), ':c'));

        $stmt = $query->prepare();

        $stmt->execute(['c' => 0]);

    }

    /**

     * Delete relation between a word and a content object.

     *

     * @param $contentId

     */

    public function deleteObjectWordsLink($contentId)

    {

        $query = $this->dbHandler->createDeleteQuery();

        $query->deleteFrom($this->dbHandler->quoteTable('ezsearch_object_word_link'))

            ->where($query->expr->eq($this->dbHandler->quoteColumn('contentobject_id'), ':contentId'));

        $stmt = $query->prepare();

        $stmt->execute(['contentId' => $contentId]);

    }

    /**

     * Set query selecting word ids for content object (method was extracted to be reusable).