getMOVESOutputTable: getMOVESOutputTable

In hlinak/R-for-MOVES: R4MOVES

getMOVESOutputTable

Description

Gets the results of a table in a MOVES database and all associated lookup tables.

Usage

getMOVESOutputTable(
  dbconn,
  movesdb_name,
  outputdb_name,
  table_name,
  get_query_string = FALSE,
  moves_run_id = -1
)

Arguments

dbconn	MySQL db connection
movesdb_name	MySQL default database to be updated as string
outputdb_name	MySQL output database to be updated as string
table_name	MySQL table to be updated as string
get_query_string	TRUE/FALSE if TRUE the query string is returned instead of the results, defaults to FALSE#'

Value

Either a dataframe with the result from dbSendQuery() or FALSE

Examples

getMOVESOutputTable(dbconn, movesdb_name, outputdb_name, "movesoutput")
getMOVESOutputTable(dbconn, movesdb_name, outputdb_name, "rateperdistance", get_query_string = TRUE)
getMOVESOutputTable(dbconn, movesdb_name, outputdb_name, "movesoutput", moves_run_id = 3)

hlinak/R-for-MOVES documentation built on Jan. 31, 2023, 2:03 p.m.