update_db: Update an existing PITCHf/x database

In cpsievert/pitchRx: Tools for Harnessing 'MLBAM' 'Gameday' Data and Visualizing 'pitchfx'

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

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

## End(Not run)

cpsievert/pitchRx documentation built on Aug. 19, 2023, 10:02 p.m.