Package: sqlHelpers 0.1.2

sqlHelpers: Collection of 'SQL' Utilities for 'T-SQL' and 'Postgresql'

Includes functions for interacting with common meta data fields, writing insert statements, calling functions, and more for 'T-SQL' and 'Postgresql'.

Authors:Timothy Conwell [aut, cre]

sqlHelpers_0.1.2.tar.gz
sqlHelpers_0.1.2.zip(r-4.7)sqlHelpers_0.1.2.zip(r-4.6)sqlHelpers_0.1.2.zip(r-4.5)
sqlHelpers_0.1.2.tgz(r-4.6-any)sqlHelpers_0.1.2.tgz(r-4.5-any)
sqlHelpers_0.1.2.tar.gz(r-4.7-any)sqlHelpers_0.1.2.tar.gz(r-4.6-any)
sqlHelpers_0.1.2.tgz(r-4.6-emscripten)
manual.pdf |manual.html✨
card.svg |card.png
sqlHelpers/json (API)

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

On CRAN:

Conda:

This package does not link to any Github/Gitlab/R-forge repository. No issue tracker or development information is available.

1.00 score 5 scripts 188 downloads 19 exports 16 dependencies

Last updated from:72110c508b. Checks:9 OK. Indexed: yes.

TargetResultTimeFilesSyslog
linux-devel-x86_64OK110
source / vignettesOK140
linux-release-x86_64OK111
macos-release-arm64OK66
macos-oldrel-arm64OK79
windows-develOK108
windows-releaseOK68
windows-oldrelOK73
wasm-releaseOK93

Exports:call_functionconnectcreate_table_from_data_framedrop_tablefetch_columnsfetch_function_definitionfetch_function_output_parametersfetch_function_parametersfetch_tablesinsert_batch_chunkerinsert_valuesquoteText2sqlizeNamessqlizeTypest_sql_bulk_insertt_sql_script_create_tablet_sql_script_proc_definitiontruncate_tableupdate_values

Dependencies:bitbit64blobclidata.tableDBIgluehmslifecycleodbcpkgconfigRcpprlangstringitoolboxvctrs

Readme and manuals

Help Manual

Help pageTopics
Call a SQL function/procedure.call_function
Connect to a database using a connection string via DBI/odbc.connect
Generate a CREATE TABLE statement based on a data.frame, optionally execute the statement if con is not NULL.create_table_from_data_frame
Generate a DROP TABLE statement, optionally execute the statement if con is not NULL.drop_table
Retrieve the columns/types in a table.fetch_columns
Retrieve the definition of a function/procedure.fetch_function_definition
Retrieve the output parameters of a function/procedure.fetch_function_output_parameters
Retrieve the input parameters of a function/procedure.fetch_function_parameters
Retrieve the tables in a schemafetch_tables
Helper function for INSERTinsert_batch_chunker
Generate a INSERT statement, optionally execute the statement if con is not NULL.insert_values
Add single quotes to strings using stringi::stri_join, useful for converting R strings into SQL formatted strings.quoteText2
Convert a column name into a SQL compatible name.sqlizeNames
Get the equivalent SQL data type for a given R object.sqlizeTypes
Generate a BULK INSERT statement, optionally execute the statement if con is not NULL.t_sql_bulk_insert
Generate a CREATE TABLE statement for an existing table in Microsoft SQL Server.t_sql_script_create_table
Fetch the object definition of a proc in Microsoft SQL Server.t_sql_script_proc_definition
Generate a TRUNCATE TABLE statement, optionally execute the statement if con is not NULL.truncate_table
Generate a UPDATE statement, optionally execute the statement if con is not NULL.update_values