update_phf_db() updates or creates a database with fastRhockey
play by play data of all completed and available games since 2011.
Usage
update_phf_db(
dbdir = ".",
dbname = "fastRhockey_db",
tblname = "fastRhockey_phf_pbp",
force_rebuild = FALSE,
db_connection = NULL
)
Arguments
- dbdir
Directory in which the database is or shall be located
- dbname
File name of an existing or desired SQLite database within
dbdir
- tblname
The name of the play by play data table within the database
- force_rebuild
Hybrid parameter (logical or numeric) to rebuild parts of or the complete play by play data table within the database (please see details for further information)
- db_connection
A
DBIConnection
object, as returned byDBI::dbConnect()
(please see details for further information)
Details
This function creates and updates a data table with the name tblname
within a SQLite database (other drivers via db_connection
) located in
dbdir
and named dbname
.
The data table combines all play by play data for every available game back
to the 2016 season and adds the most recent completed games as soon as they
are available for fastRhockey
.
The argument force_rebuild
is of hybrid type. It can rebuild the play
by play data table either for the whole fastRhockey era (with force_rebuild = TRUE
)
or just for specified seasons (e.g. force_rebuild = c(2019, 2020)
).
Please note the following behavior:
force_rebuild = TRUE
: The data table with the nametblname
will be removed completely and rebuilt from scratch. This is helpful when new columns are added during the Off-Season.force_rebuild = c(2019, 2020)
: The data table with the nametblname
will be preserved and only rows from the 2019 and 2020 seasons will be deleted and re-added. This is intended to be used for ongoing seasons because ESPN's data provider can make changes to the underlying data during the week.
The parameter db_connection
is intended for advanced users who want
to use other DBI drivers, such as MariaDB, Postgres or odbc. Please note that
the arguments dbdir
and dbname
are dropped in case a db_connection
is provided but the argument tblname
will still be used to write the
data table into the database.