simulate_dbi

0th

Percentile

Create a local lazy tibble

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

Keywords
internal
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)

Aliases
  • simulate_dbi
  • simulate_sqlite
  • simulate_postgres
  • simulate_mysql
  • simulate_odbc
  • simulate_impala
  • simulate_mssql
  • simulate_oracle
  • simulate_hive
  • simulate_odbc_postgresql
  • simulate_teradata
  • simulate_odbc_access
  • tbl_lazy
  • lazy_frame
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()
# }
Documentation reproduced from package dbplyr, version 1.2.1, License: MIT + file LICENSE

Community examples

Looks like there are no examples yet.