Advertisement
Guest User

Untitled

a guest
Oct 23rd, 2016
105
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.92 KB | None | 0 0
  1. #Extract Products from ArangoDB
  2. extractProducts <- function(urlCursor){
  3. queryProductAQL <- "for p in Product return p"
  4. result <- POST(url = urlCursor, body = paste('{"query":"', queryProductAQL, '", "count":true}'), authenticate(user = myuser, password = mypass))
  5. resulta <- content(result, "parsed", "application/json")
  6. n <- resulta[1]
  7. s <- n$result
  8. productsDF <- data.frame(id=integer(), type=character(), numberOfShares=integer(), rev=integer(), stringsAsFactors=FALSE)
  9.  
  10. #Extracts all the node names and place on a single list
  11. for(x in 1:length(s)){
  12. id <- s[x][[1]]$'_id'
  13. rev <- s[x][[1]]$'_rev'
  14. type <- if(is.character(s[x][[1]]$'type')) s[x][[1]]$'type' else 'Not Specified'
  15. numberOfShares <- if(is.integer(s[x][[1]]$'numberOfShares')) s[x][[1]]$'numberOfShares' else 0
  16. productsDF[nrow(productsDF) + 1, ] <- c(id, type, numberOfShares, rev)
  17. }
  18. productsDF$group <- productsDF$type
  19. productsDF
  20. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement