Nothing
library(testthat)
test_that("Dates are preserved", {
andromeda <- andromeda()
data <- data.frame(person_id = c(1, 2, 3),
startDate = as.Date(c("2000-01-01", "2001-01-31", "2004-12-31")),
someText = c("asdf", "asdf", "asdf"))
andromeda$data <- data
data2 <- andromeda$data %>% collect()
expect_is(data2$startDate, "Date")
expect_equal(data$startDate, data2$startDate)
# save and reload dates
filename <- tempfile()
saveAndromeda(andromeda, filename)
andromeda <- loadAndromeda(filename)
expect_is(pull(andromeda$data, startDate), "Date")
expect_equal(pull(andromeda$data, startDate), data$startDate)
close(andromeda)
})
test_that("Times are preserved", {
andromeda <- andromeda()
data <- data.frame(person_id = c(1, 2, 3),
startTime = as.POSIXct(c("2000-01-01 10:00:00", "2001-01-31 11:00:00", "2004-12-31 21:00:00"), tz = "UTC"),
someText = c("asdf", "asdf", "asdf"))
tibble::tibble(data)
andromeda$data <- data
data2 <- andromeda$data %>% collect()
expect_is(data2$startTime, "POSIXct")
expect_equal(data$startTime, data2$startTime)
# save and reload datetimes
filename <- tempfile()
saveAndromeda(andromeda, filename)
andromeda <- loadAndromeda(filename)
expect_is(pull(andromeda$data, startTime), "POSIXct")
expect_equal(pull(andromeda$data, startTime), data$startTime)
close(andromeda)
})
test_that("restore Dates works", {
df <- dplyr::tibble(todayDate = Sys.Date(),
anotherDate = Sys.Date())
a <- andromeda(df = df)
# creating a new table in the sqlite database will convert dates to numbers
a$df2 <- a$df %>%
select(todayDate, anotherDate)
df2 <- a$df2 %>%
collect() %>%
mutate_all(restoreDate)
expect_equal(df2, df)
})
test_that("restorePosixct works", {
df <- dplyr::tibble(now = Sys.time())
a <- andromeda(df = df)
# creating a new table in the sqlite database will convert datetimes to numbers
a$df2 <- a$df %>%
select(now)
df2 <- a$df2 %>%
collect() %>%
mutate_all(restorePosixct)
expect_equal(df2, df)
})
Any scripts or data that you put into this service are public.
Add the following code to your website.
For more information on customizing the embed code, read Embedding Snippets.