Intersect: Intersect

In mRcSchwering/abacus: abacus

Description

Convenience function for comparing a data.frame with table entries of a database. This is used to see if certain entries already exist in the database.

Usage

Intersect(data, table, db)

Arguments

data	data.frame whose entries are compared to a database table
table	chr of database table name
db	chr full file name with path of database

Details

What columns exactly are compared depends on the table value.

• accounts the table is searched for equal values in both columns bic and iban. A bool vector indicating for each row in data whether it exists in table.

• storage or personalAccounts the table is searched for equal values in columns name and type respectively. A bool vector indicating for each row in data whether it exists in table.

Value

bool vector or list of bool vector and a data.frame

See Also

Other SQLite handler functions: InsertBLOB, Insert, SelectBLOB, Select, UpdateBLOB, Update

Examples

db <- "db/test.db"
Create_testDB(db)
df <- Select(
  "transactions", 
  "db/test.db", 
  le = list(payor_id = 2), 
  eq = list(type = c("food", "purchase"))
 )

mRcSchwering/abacus documentation built on May 21, 2019, 9:18 a.m.