dbplyr (version 0.0.0.9001)

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_odbc(type = NULL)

simulate_impala()

simulate_mssql()

tbl_lazy(df, src = NULL)

lazy_frame(..., src = NULL)

Arguments

Examples

Run this code
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 DataLab