skip_if_not_installed("RSQLite")
skip_if_not_installed("dbplyr")
iris_species <- data.frame(
species_id = 1:3,
species_name = levels(iris$Species),
type_id = c(1L, 1L, 2L)
)
iris_data <- iris %>%
dplyr::mutate(
id = seq_len(dplyr::n()),
species_id = as.integer(iris$Species),
Species = NULL
)
db <- tempfile(fileext = ".db")
con <- DBI::dbConnect(RSQLite::SQLite(), db)
on.exit({
DBI::dbDisconnect(con)
unlink(db)
})
DBI::dbWriteTable(con, "iris_species", iris_species)
DBI::dbWriteTable(con, "iris_data", iris_data)
DBI::dbWriteTable(
con, "iris_extra",
data.frame(
id = 1:2,
type = c("Fluffy", "Hard")
)
)
d <- inzdf(con,
"iris_linked",
schema = list(
iris_data = list(
links_to = list(
iris_species = "species_id"
)
),
iris_species = list(
links_to = list(
iris_extra = c("type_id" = "id")
)
)
),
keep_con = TRUE
)
test_that("Basic plots work", {
p <- inzplot(~Sepal.Width, data = d)
expect_is(p, "inzplotoutput")
})
Add the following code to your website.
For more information on customizing the embed code, read Embedding Snippets.