copyDBtoMemory: copies contents of a sqlite database to another one (default...

In BenBruyneel/BBPersonalR: BBPersonalR

copies contents of a sqlite database to another one (default is into :memory:)

Description

copies contents of a sqlite database to another one (default is into :memory:)

Usage

copyDBtoMemory(
  dbFrom,
  dbTo = ":memory:",
  noWarnings = TRUE,
  copyTables = NA,
  doNotCopyTables = "sqlite_sequence"
)

Arguments

dbFrom	database from which tables are to be copied, must be open when calling this function
dbTo	database to which tables are to be copied
noWarnings	suppress warnings while copying data, default = TRUE
copyTables	character vector specifying which tables to copy (default NA, copies all tables)
doNotCopyTables	character vector that specifies which tables are not to be copied (default = 'sqlite_sequence'). Overrules the copyTables argument. If NA then this parameter is ignored

Value

an in memory database database, note that this database is returned in an 'open state'

BenBruyneel/BBPersonalR documentation built on Aug. 23, 2024, 8:28 p.m.