ezsystems / ezpublish-kernel

     * @param int $contentId

     * @param int $versionNo (optional) filter by versionNo

     */

    public function deleteTranslatedFields($languageCode, $contentId, $versionNo = null)

    {

        $query = $this->connection->createQueryBuilder();

        $query

            ->delete('ezcontentobject_attribute')

            ->where('contentobject_id = :contentId')

            ->andWhere('language_code = :languageCode')

            ->setParameters(

                [

                    ':contentId' => $contentId,

                    ':languageCode' => $languageCode,

                ]

            )

        ;

        if (null !== $versionNo) {

            $query

                ->andWhere('version = :versionNo')

                ->setParameter(':versionNo', $versionNo)

            ;

        }

        $query->execute();

    }

    /**

     * Delete translation from the ezcontentobject_name table.

     * @param string $languageCode

     * @param int $versionNo optional, if specified, apply to this Version only.

     */

    private function deleteTranslationFromContentNames($contentId, $languageCode, $versionNo = null)

    {

        $query = $this->connection->createQueryBuilder();

        $query

            ->delete('ezcontentobject_name')

            ->where('contentobject_id=:contentId')

            ->andWhere('real_translation=:languageCode')

            ->setParameters(

                [

                    ':languageCode' => $languageCode,

                    ':contentId' => $contentId,

                ]

            )

        ;

        if (null !== $versionNo) {

            $query

                ->andWhere('content_version = :versionNo')

                ->setParameter(':versionNo', $versionNo)

            ;

        }

        $query->execute();

    }

    /**

     * Remove language from language_mask of ezcontentobject.