upsert: upsert

In JonasPipoz/retlstat: Update, Create, create MS SQL tables

upsert

Description

This function mets a jour les données dans une table si l'id existe dans la table sql server ou alors ajoute les données a partir d'un dataframe

Usage

upsert(df, conn, BDD, Schema, table_name, id)

Arguments

df	A dataframe containing the data. Default is null
conn	A DBI connection
BDD	The sql database name
Schema	The sql schema
table_name	The sql Table
id	a unique identifier per row.

Examples

upsert(df = mtcars, conn = conn, BDD = 'STATPRODTEMP',Schema = 'GEN',table_name = 'MTCARS',id = rownames(mtcars))
upsert()

JonasPipoz/retlstat documentation built on March 29, 2024, 7:43 p.m.