db_upsert_table: Create or overwrite table at connection source

In KTH-Library/bibliomatrix: Provide Functionality for Bibliometric Analytics

Create or overwrite table at connection source

Description

Utility that can be used to sync data against a connection.

Usage

db_upsert_table(tbl, df, con = con_bib())

Arguments

tbl	table name
df	data frame or tibble with the data
con	database connection, Default: con_bib()

Details

not all backend drivers support overwrite and append, therefore param overwrite for dbWriteTable (see docs) is not used

Value

invisibly TRUE on success

See Also

dbExistsTable,dbRemoveTable,dbWriteTable

Examples

## Not run: 
if(interactive()){
 db_upsert_table("divisions", abm_divisions(), con = con_bib(type = "mssql"))
 }

## End(Not run)

KTH-Library/bibliomatrix documentation built on Feb. 29, 2024, 5:54 a.m.