addValuesToDB: Add User's input to Postgres database

In aqlina/musicBox: musicBox runs Shiny App based on Postgres database

Add User's input to Postgres database

Description

Add User's input to database table imputing the missing id column with the next possible values

Usage

addValuesToDB(tableName, newValuesList, dbConnection)

Arguments

tableName	A character with the name of table to which the values will be inputted
newValuesList	A list of values to add; the length of the list must be the same as number of columns of the table minus 1 (except 'id' column)
dbConnection	A connection to the Postgres database

Details

This function add the input provided by the User in the App. The function assumes that primary key of the each table in database is named 'id' and cannot be added by the User. The 'id' column is being added inside the function after the next possible value of 'id' is taken from the database.

Value

nothing

Author(s)

Alina Tselinina [e-mail]

aqlina/musicBox documentation built on Jan. 20, 2024, 2:29 a.m.