Create database table and possible indices from a simple yaml schema

Create database table and possible indices from a simple yaml schema

dbCreateSchemaTable(
  db,
  table,
  schema = schemas[[table]],
  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

shall old data be copied from existing tables?