query_prep: Prepare SQL Query

In warlicks/swimR: Gather College Swimming Results From USA Swimming Top Time Reports

Description

The function prepares a SQL query based on the parameters provided.

Usage

query_prep(conference = NULL, team_name = NULL, team_code = NULL,
  gender = "Both", athlete = NULL, event = "All")

Arguments

conference	a character vector with the name of an NCAA swimming conference. If not provided the results include all conferences.
team_name	A character vector with the name of an NCAA swimming conference. If not provided the results include all teams
gender	a character vector. Indicates the output should include men, women or both. Defaults to "Both". Other options are "M" for men and "F" for women.
athlete	a character vector with the name or athlete id of a swimmier. If not provided the results include all swimmers. The athlete id follows the USA Swimming standard.
event	a character vector with the name of swimming envent. If not provided the results include all events.
team_name	a character vector with the team code of an NCAA swimming team If not provided the results include all teams

warlicks/swimR documentation built on May 4, 2019, 12:59 a.m.