Man pages for rOpenStats/rsql
Database Agnostic Package to Generate and Process 'SQL' Queries in R

add_grep_exact_matchadd_grep_exact_match
add_quotesadd_quotes
assessRSqlDfassessRSqlDf
cbind_coercedcbind_coerced
check_fields_valuesCheck fields and values are sound
createRSQLProduces a RSQL object
dequoteRemoves the quotes from the string
df_verifyChecks that the columns are in the data.frame
genLoggergenLogger
getLoggergetLogger
getMtcarsdbPathgetCarsdbPath
getPackageDirGet package directory
grapes-IN-grapesOperator IN for multiple columns
is.POSIXctis.POSIXct
is_quotedDetermines if the string is quoted or not
loggerSetupFileloggerSetupFile
needs_quotesDetermines string type which needs quotes in an SQL statement
parse_where_clauseParses a where clause.
rename_colrename_col
replaceNAwithNULLreplaceNAwithNULL
re_quoteThis functions remove original quotes and sets validated...
re_quote_altThis functions remove original quotes and sets validated...
rm_quotesrm_quotes
rm_vector_quotesrm_vector_quotes
RSQLrsql
RSQL.classThe class that provides the SQL functionality.
sql_execute_deletesql_execute_delete
sql_execute_get_insertsql_execute_get_insert
sql_execute_insertExecutes a statement on the database.
sql_execute_selectsql_execute_select
sql_execute_updateExecutes an update on the database
sql_gen_deletesql_gen_delete
sql_gen_insertsql_gen_insert
sql_gen_selectsql_gen_select
sql_gen_updatesql_gen_update
sql_gen_wheresql_gen_where
sql_gen_where_listsql_gen_where_list
sql_gen_where_orsql_gen_where_or
sql_retrieveRetrieves Statement
sql_retrieve_insertRetrieves or insert Statement
stuff_df_quotedstuff_df_quoted
stuff_quoteStuff quote symbol from text
times_to_utctimes_to_utc
trimReturns string w/o leading or trailing whitespace
trim_leadingtrim_leading
trim_trailingtrim_trailing
rOpenStats/rsql documentation built on Aug. 22, 2023, 2:16 a.m.