Build a database from a given SQL schema file

This is a generic database build function that can create a database file from any .sql schema. If you use a schema other than the default one, later functions in the pipeline may not work.

buildDBFromSchema(schemaFile = NULL, dbName, force = FALSE, silently = FALSE)

Arguments

schemaFile

a .sql schema file (if no value given, defaults to the base Covid-19 schema used in build_COVID_DB())

dbName

name of database (with file path)

force

if true, replace DB if already exists; if false, will not overwrite file

silently

whether or not to print tables made