Create or update a SQLite database from a schema file

Create or update a SQLite database from a schema file

dbCreateSQLiteFromSchema(
  schema.file,
  schema.dir = dirname(schema.file),
  db.name = NULL,
  db.dir = schema.dir,
  update = TRUE,
  verbose = 1
)

Arguments

schema.file

the dbmisc schema file in yaml format
schema.dir

the directory of the schema file (if schema.file does not contain a path)
db.name

the name of the database file
db.dir

the directory of the database file, by default the schema directory
update

if TRUE copy and update the existing data in the tables. If FALSE just generate empty tables.
verbose

if 0 don't show what is done. If 1 or larger show most of the run SQL commands.