Check Database structure

This function will examine a SQLite3 database to make sure it's consistent with the structure required for my Shiny applications.

check_db_structure(db.file, verbose = T)

Arguments

db.file

a character object that gives the file location of a SQLite3 database.

verbose

a logical value indicating if errors should be displayed. If set to FALSE, all messages will be suppressed.

Value

A logical value indicating if the database passes all required checks.

Examples

database_file <- "//AIBSData2/mct-t200/ShinyApps/linnarsson/linnarsson2.db"

check_db_structure(database_file)
#> Error: Could not connect to database:
#> unable to open database file

check_db_structure(database_file,verbose=F)
#> Error: Could not connect to database:
#> unable to open database file