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.5)sqlHelpers_0.1.2.zip(r-4.4)sqlHelpers_0.1.2.zip(r-4.3)
sqlHelpers_0.1.2.tgz(r-4.4-any)sqlHelpers_0.1.2.tgz(r-4.3-any)
sqlHelpers_0.1.2.tar.gz(r-4.5-noble)sqlHelpers_0.1.2.tar.gz(r-4.4-noble)
sqlHelpers_0.1.2.tgz(r-4.4-emscripten)sqlHelpers_0.1.2.tgz(r-4.3-emscripten)
sqlHelpers.pdf |sqlHelpers.html
sqlHelpers/json (API)

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

Peer review:

On CRAN:

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

1.00 score 215 downloads 19 exports 16 dependencies

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

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

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