public function getIdUrlMap(array $ids)
    {
        $map = [];

        if (!empty($ids)) {
            $query = $this->connection->createQueryBuilder();
            $query
                ->select(
                    $this->connection->quoteIdentifier('id'),
                    $this->connection->quoteIdentifier('url')
                )
                ->from(self::URL_TABLE)
                ->where('id IN (:ids)')
                ->setParameter(':ids', $ids, Connection::PARAM_INT_ARRAY);

            $statement = $query->execute();
            foreach ($statement->fetchAll(PDO::FETCH_ASSOC) as $row) {
                $map[$row['id']] = $row['url'];
            }
        }

        return $map;
    }
public function getIdUrlMap(array $ids)
    {
        $map = [];

        if (!empty($ids)) {
            $query = $this->connection->createQueryBuilder();
            $query
                ->select(
                    $this->connection->quoteIdentifier('id'),
                    $this->connection->quoteIdentifier('url')
                )
                ->from(self::URL_TABLE)
                ->where('id IN (:ids)')
                ->setParameter(':ids', $ids, Connection::PARAM_INT_ARRAY);

            $statement = $query->execute();
            foreach ($statement->fetchAll(PDO::FETCH_ASSOC) as $row) {
                $map[$row['id']] = $row['url'];
            }
        }

        return $map;
    }
public function getIdUrlMap ( array $ ids ) { $ map = [ ] ; if ( ! empty ( $ ids ) ) { $ query = $ this -> connection -> createQueryBuilder ( ) ; $ query -> select ( $ this -> connection -> quoteIdentifier ( 'id' ) , $ this -> connection -> quoteIdentifier ( 'url' ) ) -> from ( self :: URL_TABLE ) -> where ( 'id IN (:ids)' ) -> setParameter ( ':ids' , $ ids , Connection :: PARAM_INT_ARRAY ) ; $ statement = $ query -> execute ( ) ; foreach ( $ statement -> fetchAll ( PDO :: FETCH_ASSOC ) as $ row ) { $ map [ $ row [ 'id' ] ] = $ row [ 'url' ] ; } } return $ map ; }
Return a list of URLs for a list of URL ids.

Non-existent ids are ignored.

@param int[] $ids An array of URL ids

@return array An array of URLs, with ids as keys
Return a list of URLs for a list of URL ids .