db_direct_insert: Function to connect and insert directly into a database.

In skgrange/databaser: Tools to Keep Database Interaction Easy and Consistent

Function to connect and insert directly into a database.

Description

db_direct_insert has been designed so a database can be connected to, data inserted, and then disconnected with a single function call.

Usage

db_direct_insert(file, database = NA, table, df, replace = FALSE)

Arguments

file	JSON file or string containing database connection details. For SQLite databases, use the database's file path. See db_connect for more information.
database	The name of the database within file to use to create a database connection to. If only one entry is in file, this argument is not needed and will be ignored if used.
table	Table in, or to be created in con.
df	Data frame to be inserted into con.
replace	Should the database table be replaced? Default is FALSE. Be cautious using this argument because it will drop the database table if it exists.

Value

Invisible.

Author(s)

Stuart K. Grange

See Also

db_connect, db_insert, db_direct_read

skgrange/databaser documentation built on Sept. 26, 2024, 8:30 p.m.