library(testthat)
# most common expectations:
# equality: expect_equal() and expect_identical()
# regexp: expect_match()
# catch-all: expect_true() and expect_false()
# console output: expect_output()
# messages: expect_message()
# warning: expect_warning()
# errors: expect_error()
escapeString <- function(s) {
t <- gsub("(\\\\)", "\\\\\\\\", s)
t <- gsub("(\n)", "\\\\n", t)
t <- gsub("(\r)", "\\\\r", t)
t <- gsub("(\")", "\\\\\"", t)
return(t)
}
prepStr <- function(s) {
t <- escapeString(s)
u <- eval(parse(text=paste0("\"", t, "\"")))
if(s!=u) stop("Unable to escape string!")
t <- paste0("\thtml <- \"", t, "\"")
utils::writeClipboard(t)
return(invisible())
}
evaluationMode <- "sequential"
processingLibrary <- "dplyr"
description <- "test: sequential dplyr"
countFunction <- "n()"
isDevelopmentVersion <- (length(strsplit(packageDescription("pivottabler")$Version, "\\.")[[1]]) > 3)
testScenarios <- function(description="test", releaseEvaluationMode="batch", releaseProcessingLibrary="dplyr", runAllForReleaseVersion=FALSE) {
isDevelopmentVersion <- (length(strsplit(packageDescription("pivottabler")$Version, "\\.")[[1]]) > 3)
if(isDevelopmentVersion||runAllForReleaseVersion) {
evaluationModes <- c("sequential", "batch")
processingLibraries <- c("dplyr", "data.table")
}
else {
evaluationModes <- releaseEvaluationMode
processingLibraries <- releaseProcessingLibrary
}
testCount <- length(evaluationModes)*length(processingLibraries)
c1 <- character(testCount)
c2 <- character(testCount)
c3 <- character(testCount)
c4 <- character(testCount)
testCount <- 0
for(evaluationMode in evaluationModes)
for(processingLibrary in processingLibraries) {
testCount <- testCount + 1
c1[testCount] <- evaluationMode
c2[testCount] <- processingLibrary
c3[testCount] <- paste0(description, ": ", evaluationMode, " ", processingLibrary)
c4[testCount] <- ifelse(processingLibrary=="data.table", ".N", "n()")
}
df <- data.frame(evaluationMode=c1, processingLibrary=c2, description=c3, countFunction=c4, stringsAsFactors=FALSE)
return(df)
}
context("QUICK-PIVOT TESTS")
test_that("quick-pivot tests: qpvt pivot 1", {
skip_on_cran()
library(pivottabler)
pt <- qpvt(bhmtrains, "TOC", "TrainCategory", "n()", compatibility=list(totalStyleIsCellStyle=TRUE, explicitHeaderSpansOfOne=TRUE))
# pt$renderPivot()
# sum(pt$cells$asMatrix(), na.rm=TRUE)
# prepStr(as.character(pt$getHtml()))
html <- "\n \n \n | Express Passenger | \n Ordinary Passenger | \n Total | \n
\n \n \n | 3079 | \n 830 | \n 3909 | \n
\n \n \n | 22865 | \n 63 | \n 22928 | \n
\n \n \n | 14487 | \n 33792 | \n 48279 | \n
\n \n \n | 8594 | \n | \n 8594 | \n
\n \n \n | 49025 | \n 34685 | \n 83710 | \n
\n
"
expect_equal(sum(pt$cells$asMatrix(), na.rm=TRUE), 334840)
expect_identical(as.character(pt$getHtml()), html)
})
test_that("quick-pivot tests: qpvt pivot 2", {
library(pivottabler)
pt <- qpvt(bhmtrains, c("=", "TOC"), c("TrainCategory", "PowerType"),
c("Number of Trains"="n()", "Maximum Speed"="max(SchedSpeedMPH, na.rm=TRUE)"),
compatibility=list(totalStyleIsCellStyle=TRUE, explicitHeaderSpansOfOne=TRUE, noDataGroupNBSP=TRUE))
# pt$renderPivot()
# sum(pt$cells$asMatrix(), na.rm=TRUE)
# prepStr(as.character(pt$getHtml()))
html <- "\n \n \n | Express Passenger | \n Ordinary Passenger | \n Total | \n
\n \n | DMU | \n EMU | \n HST | \n Total | \n DMU | \n EMU | \n Total | \n | \n
\n \n \n \n | 3079 | \n | \n | \n 3079 | \n 830 | \n | \n 830 | \n 3909 | \n
\n \n \n | 22133 | \n | \n 732 | \n 22865 | \n 63 | \n | \n 63 | \n 22928 | \n
\n \n \n | 5638 | \n 8849 | \n | \n 14487 | \n 5591 | \n 28201 | \n 33792 | \n 48279 | \n
\n \n \n | 2137 | \n 6457 | \n | \n 8594 | \n | \n | \n | \n 8594 | \n
\n \n \n | 32987 | \n 15306 | \n 732 | \n 49025 | \n 6484 | \n 28201 | \n 34685 | \n 83710 | \n
\n \n \n \n | 90 | \n | \n | \n 90 | \n 90 | \n | \n 90 | \n 90 | \n
\n \n \n | 125 | \n | \n 125 | \n 125 | \n 100 | \n | \n 100 | \n 125 | \n
\n \n \n | 100 | \n 110 | \n | \n 110 | \n 100 | \n 100 | \n 100 | \n 110 | \n
\n \n \n | 125 | \n 125 | \n | \n 125 | \n | \n | \n | \n 125 | \n
\n \n \n | 125 | \n 125 | \n 125 | \n 125 | \n 100 | \n 100 | \n 100 | \n 125 | \n
\n
"
expect_equal(sum(pt$cells$asMatrix(), na.rm=TRUE), 505565)
expect_identical(as.character(pt$getHtml()), html)
})
if(isDevelopmentVersion) {
test_that("quick-pivot tests: qpvt pivot format 1 - single calc", {
library(pivottabler)
pt <- qpvt(bhmtrains, "TOC", "TrainCategory", "mean(SchedSpeedMPH, na.rm=TRUE)", format="%.0f",
compatibility=list(totalStyleIsCellStyle=TRUE, explicitHeaderSpansOfOne=TRUE))
# pt$renderPivot()
# sum(pt$cells$asMatrix(), na.rm=TRUE)
# prepStr(as.character(pt$getHtml()))
html <- "\n \n \n | Express Passenger | \n Ordinary Passenger | \n Total | \n
\n \n \n | 90 | \n 89 | \n 90 | \n
\n \n \n | 113 | \n 100 | \n 113 | \n
\n \n \n | 98 | \n 91 | \n 93 | \n
\n \n \n | 125 | \n | \n 125 | \n
\n \n \n | 109 | \n 91 | \n 101 | \n
\n
"
expect_equal(sum(pt$cells$asMatrix(), na.rm=TRUE), 1426.677, tolerance=1e-2)
expect_identical(as.character(pt$getHtml()), html)
})
}
if(isDevelopmentVersion) {
test_that("quick-pivot tests: qpvt pivot format 2 - two calcs basic", {
library(pivottabler)
pt <- qpvt(bhmtrains, "TOC", "TrainCategory",
c("Mean Speed"="mean(SchedSpeedMPH, na.rm=TRUE)", "Std Dev Speed"="sd(SchedSpeedMPH, na.rm=TRUE)"),
formats=list("%.0f", "%.1f"), compatibility=list(totalStyleIsCellStyle=TRUE, explicitHeaderSpansOfOne=TRUE))
# pt$renderPivot()
# sum(pt$cells$asMatrix(), na.rm=TRUE)
# prepStr(as.character(pt$getHtml()))
html <- "\n \n \n | Express Passenger | \n Ordinary Passenger | \n Total | \n
\n \n | Mean Speed | \n Std Dev Speed | \n Mean Speed | \n Std Dev Speed | \n Mean Speed | \n Std Dev Speed | \n
\n \n \n | 90 | \n 2.1 | \n 89 | \n 3.8 | \n 90 | \n 2.6 | \n
\n \n \n | 113 | \n 12.5 | \n 100 | \n 0.0 | \n 113 | \n 12.5 | \n
\n \n \n | 98 | \n 7.4 | \n 91 | \n 8.1 | \n 93 | \n 8.5 | \n
\n \n \n | 125 | \n 0.0 | \n | \n | \n 125 | \n 0.0 | \n
\n \n \n | 109 | \n 14.2 | \n 91 | \n 8.1 | \n 101 | \n 15.1 | \n
\n
"
expect_equal(sum(pt$cells$asMatrix(), na.rm=TRUE), 1521.537, tolerance=1e-2)
expect_identical(as.character(pt$getHtml()), html)
})
}
if(isDevelopmentVersion) {
test_that("quick-pivot tests: qpvt pivot format 3 - two calcs list", {
library(pivottabler)
pt <- qpvt(bhmtrains, "TOC", "TrainCategory",
c("Mean Speed"="mean(SchedSpeedMPH, na.rm=TRUE)", "Std Dev Speed"="sd(SchedSpeedMPH, na.rm=TRUE)"),
formats=list(list(digits = 3, nsmall=1), "%.1f"), compatibility=list(totalStyleIsCellStyle=TRUE, explicitHeaderSpansOfOne=TRUE))
# pt$renderPivot()
# sum(pt$cells$asMatrix(), na.rm=TRUE)
# prepStr(as.character(pt$getHtml()))
html <- "\n \n \n | Express Passenger | \n Ordinary Passenger | \n Total | \n
\n \n | Mean Speed | \n Std Dev Speed | \n Mean Speed | \n Std Dev Speed | \n Mean Speed | \n Std Dev Speed | \n
\n \n \n | 89.7 | \n 2.1 | \n 89.0 | \n 3.8 | \n 89.5 | \n 2.6 | \n
\n \n \n | 112.9 | \n 12.5 | \n 100.0 | \n 0.0 | \n 112.9 | \n 12.5 | \n
\n \n \n | 97.6 | \n 7.4 | \n 90.8 | \n 8.1 | \n 92.9 | \n 8.5 | \n
\n \n \n | 125.0 | \n 0.0 | \n | \n | \n 125.0 | \n 0.0 | \n
\n \n \n | 109.1 | \n 14.2 | \n 90.8 | \n 8.1 | \n 101.5 | \n 15.1 | \n
\n
"
expect_equal(sum(pt$cells$asMatrix(), na.rm=TRUE), 1521.537, tolerance=1e-2)
expect_identical(as.character(pt$getHtml()), html)
})
}
if(isDevelopmentVersion) {
test_that("quick-pivot tests: qpvt pivot format 3 - two calcs function", {
library(pivottabler)
qf <- function(x) { return(paste0("**", sprintf("%.0f", x), "**"))}
pt <- qpvt(bhmtrains, "TOC", "TrainCategory",
c("Mean Speed"="mean(SchedSpeedMPH, na.rm=TRUE)", "Std Dev Speed"="sd(SchedSpeedMPH, na.rm=TRUE)"),
formats=list(qf, "%.1f"), compatibility=list(totalStyleIsCellStyle=TRUE, explicitHeaderSpansOfOne=TRUE))
# pt$renderPivot()
# sum(pt$cells$asMatrix(), na.rm=TRUE)
# prepStr(as.character(pt$getHtml()))
html <- "\n \n \n | Express Passenger | \n Ordinary Passenger | \n Total | \n
\n \n | Mean Speed | \n Std Dev Speed | \n Mean Speed | \n Std Dev Speed | \n Mean Speed | \n Std Dev Speed | \n
\n \n \n | **90** | \n 2.1 | \n **89** | \n 3.8 | \n **90** | \n 2.6 | \n
\n \n \n | **113** | \n 12.5 | \n **100** | \n 0.0 | \n **113** | \n 12.5 | \n
\n \n \n | **98** | \n 7.4 | \n **91** | \n 8.1 | \n **93** | \n 8.5 | \n
\n \n \n | **125** | \n 0.0 | \n | \n | \n **125** | \n 0.0 | \n
\n \n \n | **109** | \n 14.2 | \n **91** | \n 8.1 | \n **101** | \n 15.1 | \n
\n
"
expect_equal(sum(pt$cells$asMatrix(), na.rm=TRUE), 1521.537, tolerance=1e-2)
expect_identical(as.character(pt$getHtml()), html)
})
}
if(isDevelopmentVersion) {
test_that("quick-pivot tests: qlpvt pivot 1", {
library(pivottabler)
lchr <- qlpvt(bhmtrains, "TOC", "TrainCategory", "n()", caption="my caption", label="mylabel",
compatibility=list(totalStyleIsCellStyle=TRUE, explicitHeaderSpansOfOne=TRUE))
# prepStr(lchr)
latex <- "\\begin{table}[h!]\n \\centering\n \\caption{my caption}\n \\label{tab:mylabel}\n \\begin{tabular}{|l|rrr|}\n \\hline\n & Express Passenger & Ordinary Passenger & Total\\\\\n \\hline\n Arriva Trains Wales & 3079 & 830 & 3909\\\\\n CrossCountry & 22865 & 63 & 22928\\\\\n London Midland & 14487 & 33792 & 48279\\\\\n Virgin Trains & 8594 & & 8594\\\\\n Total & 49025 & 34685 & 83710\\\\\n \\hline\n \\end{tabular}\n\\end{table}"
expect_identical(lchr, latex)
})
}
if(isDevelopmentVersion) {
test_that("quick-pivot tests: totals base", {
library(pivottabler)
pt <- qpvt(bhmtrains, c("TOC", "PowerType"), "TrainCategory", "n()",
compatibility=list(totalStyleIsCellStyle=TRUE, explicitHeaderSpansOfOne=TRUE, noDataGroupNBSP=TRUE))
# pt$renderPivot()
# sum(pt$cells$asMatrix(), na.rm=TRUE)
# prepStr(as.character(pt$getHtml()))
html <- "\n \n \n | Express Passenger | \n Ordinary Passenger | \n Total | \n
\n \n \n \n | 3079 | \n 830 | \n 3909 | \n
\n \n \n | 3079 | \n 830 | \n 3909 | \n
\n \n \n \n | 22133 | \n 63 | \n 22196 | \n
\n \n \n | 732 | \n | \n 732 | \n
\n \n \n | 22865 | \n 63 | \n 22928 | \n
\n \n \n \n | 5638 | \n 5591 | \n 11229 | \n
\n \n \n | 8849 | \n 28201 | \n 37050 | \n
\n \n \n | 14487 | \n 33792 | \n 48279 | \n
\n \n \n \n | 2137 | \n | \n 2137 | \n
\n \n \n | 6457 | \n | \n 6457 | \n
\n \n \n | 8594 | \n | \n 8594 | \n
\n \n \n \n | 49025 | \n 34685 | \n 83710 | \n
\n
"
expect_equal(sum(pt$cells$asMatrix(), na.rm=TRUE), 502260)
expect_identical(as.character(pt$getHtml()), html)
})
}
if(isDevelopmentVersion) {
test_that("quick-pivot tests: no totals", {
library(pivottabler)
pt <- qpvt(bhmtrains, c("TOC", "PowerType"), "TrainCategory", "n()", totals=NULL,
compatibility=list(totalStyleIsCellStyle=TRUE, explicitHeaderSpansOfOne=TRUE))
# pt$renderPivot()
# sum(pt$cells$asMatrix(), na.rm=TRUE)
# prepStr(as.character(pt$getHtml()))
html <- "\n \n \n | Express Passenger | \n Ordinary Passenger | \n
\n \n \n \n | 3079 | \n 830 | \n
\n \n \n \n | 22133 | \n 63 | \n
\n \n \n | 732 | \n | \n
\n \n \n \n | 5638 | \n 5591 | \n
\n \n \n | 8849 | \n 28201 | \n
\n \n \n \n | 2137 | \n | \n
\n \n \n | 6457 | \n | \n
\n
"
expect_equal(sum(pt$cells$asMatrix(), na.rm=TRUE), 83710)
expect_identical(as.character(pt$getHtml()), html)
})
}
if(isDevelopmentVersion) {
test_that("quick-pivot tests: 1 total out of 3 (chr)", {
library(pivottabler)
pt <- qpvt(bhmtrains, c("TOC", "PowerType"), "TrainCategory", "n()", totals="TOC",
compatibility=list(totalStyleIsCellStyle=TRUE, explicitHeaderSpansOfOne=TRUE, noDataGroupNBSP=TRUE))
# pt$renderPivot()
# sum(pt$cells$asMatrix(), na.rm=TRUE)
# prepStr(as.character(pt$getHtml()))
html <- "\n \n \n | Express Passenger | \n Ordinary Passenger | \n
\n \n \n \n | 3079 | \n 830 | \n
\n \n \n \n | 22133 | \n 63 | \n
\n \n \n | 732 | \n | \n
\n \n \n \n | 5638 | \n 5591 | \n
\n \n \n | 8849 | \n 28201 | \n
\n \n \n \n | 2137 | \n | \n
\n \n \n | 6457 | \n | \n
\n \n \n \n | 49025 | \n 34685 | \n
\n
"
expect_equal(sum(pt$cells$asMatrix(), na.rm=TRUE), 167420)
expect_identical(as.character(pt$getHtml()), html)
})
}
if(isDevelopmentVersion) {
test_that("quick-pivot tests: 2 totals out of 3 (chr)", {
library(pivottabler)
pt <- qpvt(bhmtrains, c("TOC", "PowerType"), "TrainCategory", "n()", totals=c("TOC", "TrainCategory"),
compatibility=list(totalStyleIsCellStyle=TRUE, explicitHeaderSpansOfOne=TRUE, noDataGroupNBSP=TRUE))
# pt$renderPivot()
# sum(pt$cells$asMatrix(), na.rm=TRUE)
# prepStr(as.character(pt$getHtml()))
html <- "\n \n \n | Express Passenger | \n Ordinary Passenger | \n Total | \n
\n \n \n \n | 3079 | \n 830 | \n 3909 | \n
\n \n \n \n | 22133 | \n 63 | \n 22196 | \n
\n \n \n | 732 | \n | \n 732 | \n
\n \n \n \n | 5638 | \n 5591 | \n 11229 | \n
\n \n \n | 8849 | \n 28201 | \n 37050 | \n
\n \n \n \n | 2137 | \n | \n 2137 | \n
\n \n \n | 6457 | \n | \n 6457 | \n
\n \n \n \n | 49025 | \n 34685 | \n 83710 | \n
\n
"
expect_equal(sum(pt$cells$asMatrix(), na.rm=TRUE), 334840)
expect_identical(as.character(pt$getHtml()), html)
})
}
if(isDevelopmentVersion) {
test_that("quick-pivot tests: 1 total out of 3 (list)", {
library(pivottabler)
pt <- qpvt(bhmtrains, c("TOC", "PowerType"), "TrainCategory", "n()", totals=list("TOC"="All TOCs"),
compatibility=list(totalStyleIsCellStyle=TRUE, explicitHeaderSpansOfOne=TRUE, noDataGroupNBSP=TRUE))
# pt$renderPivot()
# sum(pt$cells$asMatrix(), na.rm=TRUE)
# prepStr(as.character(pt$getHtml()))
html <- "\n \n \n | Express Passenger | \n Ordinary Passenger | \n
\n \n \n \n | 3079 | \n 830 | \n
\n \n \n \n | 22133 | \n 63 | \n
\n \n \n | 732 | \n | \n
\n \n \n \n | 5638 | \n 5591 | \n
\n \n \n | 8849 | \n 28201 | \n
\n \n \n \n | 2137 | \n | \n
\n \n \n | 6457 | \n | \n
\n \n \n \n | 49025 | \n 34685 | \n
\n
"
expect_equal(sum(pt$cells$asMatrix(), na.rm=TRUE), 167420)
expect_identical(as.character(pt$getHtml()), html)
})
}
if(isDevelopmentVersion) {
test_that("quick-pivot tests: 2 totals out of 3 (list)", {
library(pivottabler)
pt <- qpvt(bhmtrains, c("TOC", "PowerType"), "TrainCategory", "n()",
totals=list("TOC"="All TOCs", "TrainCategory"="All Categories"),
compatibility=list(totalStyleIsCellStyle=TRUE, explicitHeaderSpansOfOne=TRUE, noDataGroupNBSP=TRUE))
# pt$renderPivot()
# sum(pt$cells$asMatrix(), na.rm=TRUE)
# prepStr(as.character(pt$getHtml()))
html <- "\n \n \n | Express Passenger | \n Ordinary Passenger | \n All Categories | \n
\n \n \n \n | 3079 | \n 830 | \n 3909 | \n
\n \n \n \n | 22133 | \n 63 | \n 22196 | \n
\n \n \n | 732 | \n | \n 732 | \n
\n \n \n \n | 5638 | \n 5591 | \n 11229 | \n
\n \n \n | 8849 | \n 28201 | \n 37050 | \n
\n \n \n \n | 2137 | \n | \n 2137 | \n
\n \n \n | 6457 | \n | \n 6457 | \n
\n \n \n \n | 49025 | \n 34685 | \n 83710 | \n
\n
"
expect_equal(sum(pt$cells$asMatrix(), na.rm=TRUE), 334840)
expect_identical(as.character(pt$getHtml()), html)
})
}