nhlscrape
Scrapes the 'NHL' API for Statistical Analysis

Package index
Search the nhlscrape package
Vignettes
Functions
38
Source code
7
Man pages
12
Home
/
CRAN
/
nhlscrape
/
QueryDb: Send query to database

QueryDb: Send query to database
In nhlscrape: Scrapes the 'NHL' API for Statistical Analysis

Description Usage Arguments Value Examples

View source: R/db_retrieval.R

Description

Send a SQL query to the database. Retruns the SQL result as a data.frame. Useful for seeing the structure of the database for construction of queries

Usage

1
QueryDb(query)

Arguments

query

A string containing the SQL query

Value

List, contains the SQL query result.

Examples

1
2
3
4
SetDbPath(example = TRUE)
AddGameEvents(2019020001)
QueryDb("SELECT * FROM events")
QueryDb("SELECT result_description FROM events WHERE game_id=2019020001 AND player_id=8475166")

nhlscrape documentation built on March 26, 2020, 5:29 p.m.

Related to QueryDb in nhlscrape...

nhlscrape index
README.md

R Package Documentation

rdrr.io home R language documentation Run R code online

Browse R Packages

CRAN packages Bioconductor packages R-Forge packages GitHub packages

We want your feedback!

Note that we can't provide technical support on individual packages. You should contact the package authors for that.
GitHub issue tracker
ian@mutexlabs.com
Personal blog

 
Embedding an R snippet on your website

Add the following code to your website.

For more information on customizing the embed code, read Embedding Snippets.

Close