Create or update database tables and possible indices from a simple yaml schema

Create or update database tables and possible indices from a simple yaml schema

dbCreateSchemaTables(
  db,
  schemas = get.db.schemas(db),
  schema.yaml = NULL,
  schema.file = NULL,
  overwrite = update,
  silent = FALSE,
  update = TRUE,
  verbose = 1
)

Arguments

db

dbi database connection
schemas

schemas as R list
schema.yaml

alternatively a schema as yaml text
schema.file

alternatively a file name of a schema yaml file
overwrite

shall existing tables be overwritten?
silent

if TRUE don't show messages
update

if TRUE (default) copy old data from existing tables.