Update an existing PITCHf/x database

Share:

Description

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

Usage

1
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

1
2
3
4
5
6
## Not run: 
 library(dplyr)
 db <- src_sqlite("pitchRx.sqlite3")
 update_db(db$con)

## End(Not run)