ezsystems / ezpublish-kernel

     *

     * @return int Number of affected rows.

     */

    public function deleteUrlAliasesWithoutParent(): int

    {

        $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();

    }

    /**

     * Attempt repairing data corruption for broken archived URL aliases for Location,

    /**

     * @throws \Doctrine\DBAL\DBALException

     */

    public function getAllChildrenAliases(int $parentId): array

    {

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

        $expressionBuilder = $queryBuilder->expr();

        $queryBuilder

            ->select('*')

            ->from($this->table)

            ->where(

                $expressionBuilder->eq(

                    'parent',

                    $queryBuilder->createPositionalParameter($parentId, ParameterType::INTEGER)

                )

            )->andWhere(

                $expressionBuilder->eq(

                    'is_alias',

                    $queryBuilder->createPositionalParameter(1, ParameterType::INTEGER)

                )

            );

        return $queryBuilder->execute()->fetchAll();

    }

    /**

     * Filter from the given result set original (current) only URL aliases and index them by language_mask.