Provider of data for registries at Rapporteket

Generic to registries, provide reporting data obtained from sql databases Underlying this function is rapbase::RapporteketDbConnection

Usage

loadRegData(registryName, query, dbType = "mysql")

describeRegistryDb(registryName, tabs = c())

Arguments

registryName

String Name of the registry as defined in dbConfig.yml

query

String SQL query to obtain the data

dbType

String Type of db to query, currently "mysql" (default) and "mssql"

tabs

Character vector for optional definition of tables to describe. Defaults to an empty vector in which case all tables are used

Value

data frame containing registry data or a list with table names and corresponding fields with attributes