ezsystems / ezpublish-kernel

     *

     * @return int Number of affected rows.

     */

    public function deleteUrlAliasesWithoutParent()

    {

        $existingAliasesQuery = $this->getAllUrlAliasesQuery();

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

        $query

            ->delete($this->table)

            ->where(

                $query->expr()->neq(

                    'parent',

                    $query->createPositionalParameter(0, \PDO::PARAM_INT)

                )

            )

            ->andWhere(

                $query->expr()->notIn(

                    'parent',

                    $existingAliasesQuery

                )

            )

        ;

        return $query->execute();

    }

    /**

     * Delete URL aliases which do not link to any existing URL alias node.

     *

     * Note: Typically link column value is used to determine original alias for an archived entries.

     */

    public function deleteUrlAliasesWithBrokenLink()

    {

        $existingAliasesQuery = $this->getAllUrlAliasesQuery();

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

        $query

            ->delete($this->table)

            ->where(

                $query->expr()->neq('id', 'link')

            )

            ->andWhere(

                $query->expr()->notIn(

                    'link',

                    $existingAliasesQuery

                )

            )

        ;

        return $query->execute();

    }

    /**

     * Get subquery for IDs of all URL aliases.