Learn R Programming

pitchRx (version 1.8.2)

update_db: Update an existing PITCHf/x database

Description

Data from games played starting the day after the most recent date in the database are appended to the appropriate tables.

Usage

update_db(connect, end = Sys.Date() - 1, ...)

Arguments

connect
Either an SQLite or MySQL database connection
end
date to stop data collection. The default value of 'yesterday' is recommended to ensure the update performs properly.
...
arguments passed onto scrape

Details

Using this function requires the DBI package

See Also

http://baseballwithr.wordpress.com/2014/04/13/modifying-and-querying-a-pitchfx-database-with-dplyr/

Examples

Run this code
## Not run: 
#  library(dplyr)
#  db <- src_sqlite("pitchRx.sqlite3")
#  update_db(db$con)
# ## End(Not run)

Run the code above in your browser using DataLab