⚠️There's a newer version (0.1.2) of this package.Take me there.

sqlHelpers (version 0.1.0)

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

Description

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

Copy Link

Version

Install

install.packages('sqlHelpers')

Monthly Downloads

243

Version

0.1.0

License

GPL (>= 3)

Maintainer

Timothy Conwell

Last Published

May 25th, 2023

Functions in sqlHelpers (0.1.0)

insert_values

Generate a INSERT statement, optionally execute the statement if con is not NULL.

quoteText2

Add single quotes to strings using stringi::stri_join, useful for converting R strings into SQL formatted strings.

drop_table

Generate a DROP TABLE statement, optionally execute the statement if con is not NULL.

fetch_function_parameters

Retrieve the input parameters of a function/procedure.

fetch_function_output_parameters

Retrieve the output parameters of a function/procedure.

fetch_function_definition

Retrieve the definition of a function/procedure.

fetch_columns

Retrieve the columns/types in a table.

connect

Connect to a database using a connection string via DBI/odbc.

create_table_from_data_frame

Generate a CREATE TABLE statement based on a data.frame, optionally execute the statement if con is not NULL.

fetch_tables

Retrieve the tables in a schema

call_function

Call a SQL function/procedure.

insert_batch_chunker

Helper function for INSERT

t_sql_script_create_table

Generate a CREATE TABLE statement for an existing table in Microsoft SQL Server.

sqlizeNames

Convert a column name into a SQL compatible name.

truncate_table

Generate a TRUNCATE TABLE statement, optionally execute the statement if con is not NULL.

t_sql_bulk_insert

Generate a BULK INSERT statement, optionally execute the statement if con is not NULL.

t_sql_script_proc_definition

Fetch the object definition of a proc in Microsoft SQL Server.

sqlizeTypes

Get the equivalent SQL data type for a given R object.