dbplyr (version 1.2.2)

simulate_dbi: Create a local lazy tibble

Description

These functions are useful for testing SQL generation without having to have an active database connection.

Usage

simulate_dbi()
simulate_sqlite()
simulate_postgres()
simulate_mysql()
simulate_odbc(type = NULL)
simulate_impala()
simulate_mssql()
simulate_oracle()
simulate_hive()
simulate_odbc_postgresql()
simulate_teradata()
simulate_odbc_access()
tbl_lazy(df, src = NULL)
lazy_frame(..., src = NULL)

Examples

# NOT RUN {
library(dplyr)
df <- data.frame(x = 1, y = 2)

df_sqlite <- tbl_lazy(df, src = simulate_sqlite())
df_sqlite %>% summarise(x = sd(x)) %>% show_query()
# }

Run the code above in your browser using DataCamp Workspace