Insert rows for bulk data ingestion

Inserts rows into a database table. Use this for bulk inserts or when the higher-level functions like addArtwork() don't fit your use case.

Usage

dbArtAppend(value, table, schema = "app", cn = NULL)

Arguments

value

data.table or data.frame with rows to insert. Column names must match the target table schema.

table

Target table name (without schema prefix)

schema

Database schema (default "app"). Use "settings" for preference tables.

cn

Database connection. If NULL, opens and closes automatically.

Value

TRUE on success, FALSE on failure (with error logged)

See also

Other db-interface: dbArtGet(), dbArtUpdate()