Creates a copy of the Eunomia database, and provides details for connecting to that copy.
getEunomiaConnectionDetails(databaseFile = tempfile(fileext = ".sqlite"))
The path where the database file will be copied to. By default, the database will be copied to a temporary folder, and will be deleted at the end of the R session.
A ConnectionDetails object, to be used with the DatabaseConnector
package.
connectionDetails <- getEunomiaConnectionDetails()
connection <- connect(connectionDetails)
querySql(connection, "SELECT COUNT(*) FROM person;")
disconnect(connection)