Package: RSQL 0.2.2

Alejandro Baranek

RSQL: Database Agnostic Package to Generate and Process 'SQL' Queries in R

Allows the user to generate and execute select, insert, update and delete 'SQL' queries the underlying database without having to explicitly write 'SQL' code.

Authors:Alejandro Baranek [cre, aut], Leonardo Belen [aut]

RSQL_0.2.2.tar.gz
RSQL_0.2.2.zip(r-4.5)RSQL_0.2.2.zip(r-4.4)RSQL_0.2.2.zip(r-4.3)
RSQL_0.2.2.tgz(r-4.4-any)RSQL_0.2.2.tgz(r-4.3-any)
RSQL_0.2.2.tar.gz(r-4.5-noble)RSQL_0.2.2.tar.gz(r-4.4-noble)
RSQL_0.2.2.tgz(r-4.4-emscripten)RSQL_0.2.2.tgz(r-4.3-emscripten)
RSQL.pdf |RSQL.html
RSQL/json (API)
NEWS

# Install 'RSQL' in R:
install.packages('RSQL', repos = c('https://ropenstats.r-universe.dev', 'https://cloud.r-project.org'))

Peer review:

Bug tracker:https://github.com/ropenstats/rsql/issues

On CRAN:

5.23 score 8 stars 21 scripts 314 downloads 8 exports 3 dependencies

Last updated 1 years agofrom:e89b916a85. Checks:OK: 7. Indexed: yes.

TargetResultDate
Doc / VignettesOKNov 12 2024
R-4.5-winOKNov 12 2024
R-4.5-linuxOKNov 12 2024
R-4.4-winOKNov 12 2024
R-4.4-macOKNov 12 2024
R-4.3-winOKNov 12 2024
R-4.3-macOKNov 12 2024

Exports:add_quotescreateRSQLgenLoggergetLoggergetMtcarsdbPathgetPackageDirloggerSetupFileRSQL.class

Dependencies:DBIlgrR6

rsql

Rendered fromrsql.Rmdusingknitr::rmarkdownon Nov 12 2024.

Last update: 2020-01-08
Started: 2017-09-24

Readme and manuals

Help Manual

Help pageTopics
Operator IN for multiple columns%IN%
add_grep_exact_matchadd_grep_exact_match
add_quotesadd_quotes
assessRSqlDfassessRSqlDf
cbind_coercedcbind_coerced
Check fields and values are soundcheck_fields_values
Produces a RSQL objectcreateRSQL
Removes the quotes from the stringdequote
Checks that the columns are in the data.framedf_verify
genLoggergenLogger
getLoggergetLogger
getCarsdbPathgetMtcarsdbPath
Get package directorygetPackageDir
Determines if the string is quoted or notis_quoted
is.POSIXctis.POSIXct
loggerSetupFileloggerSetupFile
Determines string type which needs quotes in an SQL statementneeds_quotes
Parses a where clause.parse_where_clause
This functions remove original quotes and sets validated quotes for corresponding db. If it had no quotes, will only put corresponding quotes symbolsre_quote
This functions remove original quotes and sets validated quotes for corresponding db. If it had no quotes, will only put corresponding quotes symbolsre_quote_alt
rename_colrename_col
replaceNAwithNULLreplaceNAwithNULL
rm_quotesrm_quotes
rm_vector_quotesrm_vector_quotes
rsqlRSQL-package .onLoad RSQL
The class that provides the SQL functionality.RSQL.class
sql_execute_deletesql_execute_delete
sql_execute_get_insertsql_execute_get_insert
Executes a statement on the database.sql_execute_insert
sql_execute_selectsql_execute_select
Executes an update on the databasesql_execute_update
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
Retrieves Statementsql_retrieve
Retrieves or insert Statementsql_retrieve_insert
stuff_df_quotedstuff_df_quoted
Stuff quote symbol from textstuff_quote
times_to_utctimes_to_utc
Returns string w/o leading or trailing whitespacetrim
trim_leadingtrim_leading
trim_trailingtrim_trailing