update_nba_stats_db() writes one or more NBA Stats API
datasets into a database. Mirrors the NBA / MBB update_*_db() shape
but points at the load_nba_stats_* family. Each dataset is written
to its own table, named nba_stats_<dataset>.
Usage
update_nba_stats_db(
dbdir = tools::R_user_dir("hoopR", "data"),
dbname = "hoopR_db",
datasets = NULL,
seasons = TRUE,
db_connection = NULL
)Arguments
- dbdir
Directory in which the database is or shall be located. Defaults to the per-user data directory
tools::R_user_dir("hoopR", "data"), so nothing is written to the working directory unless you ask for it (dbdir = ".").- dbname
File name of an existing or desired SQLite database within
dbdir.- datasets
Character vector of dataset shortnames (see Details).
- seasons
Optional integer vector of seasons to load. Defaults to all available seasons (
seasons = TRUE).- db_connection
A
DBIConnectionobject. When supplied,dbdiranddbnameare ignored.
Details
Unlike update_nba_db(), there is no historical "play-by-play table"
default to preserve, so datasets is required.
Valid datasets values:
"coaches", "draft", "game_lineups", "game_rosters", "lineups",
"officials", "pbp", "player_boxscores", "player_game_logs",
"player_season_stats", "possessions", "rosters", "schedule",
"shots", "standings", "team_boxscores", "team_game_logs",
"team_season_stats".
A nba_stats_player_game_logs table written before hoopR 3.2.0 holds team
rows (the release held team rows until 2026-11-13). Drop it and rebuild it,
and add "team_game_logs" for those rows:
DBI::dbRemoveTable(con, "nba_stats_player_game_logs"), then
update_nba_stats_db(datasets = c("player_game_logs", "team_game_logs")).
