dbxDelete: Delete records

Description Usage Arguments Examples

View source: R/delete.R

Description

Delete records

Usage

1
dbxDelete(conn, table, where = NULL, batch_size = NULL)

Arguments

conn

A DBIConnection object

table

The table name to delete records from

where

A data frame of records to delete

batch_size

The number of records to delete in a single statement (defaults to all)

Examples

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
db <- dbxConnect(adapter="sqlite", dbname=":memory:")
table <- "forecasts"
DBI::dbCreateTable(db, table, data.frame(id=1:3, temperature=20:22))

# Delete specific records
bad_records <- data.frame(id=c(1, 2))
dbxDelete(db, table, where=bad_records)

# Delete all records
dbxDelete(db, table)

dbx documentation built on Jan. 17, 2021, 9:06 a.m.