README.md

In mrchypark/DBF: Provide Dummy DB Syntax in Namespace to Use Functions with dplyr

DBF

The goal of DBF is to provide dummy DB syntax in namespace to use functions with dplyr

Installation

You can install the developed version of DBF from github with:

# if you don't instatll remotes package, uncomment & run below line.
# install.packages("remotes")
remotes::install_github("mrchypark/DBF")

Example

This is a basic example which shows you how to solve a common problem:

library(DBI)
library(DBF)

conn <- dbConnect(
  RPostgres::Postgres(),
  host = HOST, # i.e. 'ec2-54-83-201-96.compute-1.amazonaws.com'
  port = 5432, # or any other port specified by your DBA
  user = 'postgres',
  password = 'password'
)

list_of_syntax <- get_function(conn)
set_function(list_of_syntax)

Usage

library(dplyr)
library(DBI)
library(DBF)

conn <- dbConnect(
  RPostgres::Postgres(),
  host = HOST, # i.e. 'ec2-54-83-201-96.compute-1.amazonaws.com'
  port = 5432, # or any other port specified by your DBA
  user = 'postgres',
  password = 'password'
)

copy_to(conn, test)

list_of_syntax <- get_function(conn)
set_function(list_of_syntax)

tbl(conn, "test") %>% 
  mutate(date = DATE_TRUCN("day", date))

Special Thanks

Tyler Morgan-Wall @tylermorganwall history

mrchypark/DBF documentation built on May 3, 2019, 8:05 p.m.