Instantly share code, notes, and snippets.

@cpsievert /update.R
Last active Aug 29, 2015

Embed
What would you like to do?
Script to update a PITCHf/x database
library(dplyr)
library(pitchRx)
# This script requires pitchRx 1.5
if (packageVersion("pitchRx") < 1.5) { devtools::install_github("cpsievert/pitchRx"); library(pitchRx) }
# Be sure to specify the *entire* path to your database
db.file <- "~/pitchfx/pitchRx.sqlite3"
stopifnot(file.exists(db.file))
db <- src_sqlite(db.file)
update_db(db$con)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment