Skip to content

Instantly share code, notes, and snippets.

@cpsievert
Last active August 29, 2015 14:02
Show Gist options
  • Save cpsievert/fef5e5c77dc541aafaec to your computer and use it in GitHub Desktop.
Save cpsievert/fef5e5c77dc541aafaec to your computer and use it in GitHub Desktop.
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