sql_manipulation: sql_manipulation

In 1Edtrujillo1/udeploy: Back-end & Front-end functions

Description

push or pull or watch the information of the database

Usage

sql_manipulation(
  dsn = NULL,
  server = NULL,
  database,
  uid,
  pwd,
  sql_choice = c("check_connection", "push", "pull", "tables_info"),
  df_identifier = NULL,
  table_name = NULL,
  df = NULL,
  attributes = NULL
)

Arguments

dsn	our server if is local
server	our server if is not local
database	database in the server
uid	Your username to enter to the server
pwd	your password to enter to the server
sql_choice	choice that we want to do with a table in a database
df_identifier	string name that identify a table in a database.
table_name	name of the table
df	dataset that we want to pull to the database
attributes	variables to select from the table

Details

This function allows you to push or pull or watch the information of the database

Value

"This function returns different results based on mongo_choice variable:"

• If sql_choice = "check_connection" then returns the SQL connection

• If sql_choice = "push" then you need to use the parameters df_identifier, table_name, df and if you want to select specific variables tu push in the table use the parameter attributes. All of these to push a table to the database.

• If sql_choice = "pull" then you need to use the parameters df_identifier and table_name (or use only table_name indicating the df_identifier and table_name together) and if you want to select specific variables tu pul from the table use the parameter attributes. All of these to pull to our R-studio session the table from the database.

• If sql_choice = "tables_info" then you need to use the parameter df_identifier to bring a list of all the tables names (with its variables).

Note

If there is something wrong with the connection will return a message string.

Author(s)

Eduardo Trujillo

1Edtrujillo1/udeploy documentation built on July 13, 2021, 9:12 p.m.