Database Agnostic Package to Generate and Process 'SQL' Queries in R
add_grep_exact_match
add_quotes
assessRSqlDf
cbind_coerced
Check fields and values are sound
Produces a RSQL object
Removes the quotes from the string
Checks that the columns are in the data.frame
genLogger
getLogger
getCarsdbPath
Get package directory
Operator IN for multiple columns
is.POSIXct
Determines if the string is quoted or not
loggerSetupFile
Determines string type which needs quotes in an SQL statement
Parses a where clause.
This functions remove original quotes and sets validated quotes for co...
This functions remove original quotes and sets validated quotes for co...
rename_col
replaceNAwithNULL
rm_quotes
rm_vector_quotes
The class that provides the SQL functionality.
rsql
sql_execute_delete
sql_execute_get_insert
Executes a statement on the database.
sql_execute_select
Executes an update on the database
sql_gen_delete
sql_gen_insert
sql_gen_select
sql_gen_update
sql_gen_where
sql_gen_where_list
sql_gen_where_or
Retrieves Statement
Retrieves or insert Statement
stuff_df_quoted
Stuff quote symbol from text
times_to_utc
Returns string w/o leading or trailing whitespace
trim_leading
trim_trailing
Allows the user to generate and execute select, insert, update and delete 'SQL' queries the underlying database without having to explicitly write 'SQL' code.