Readme.md

In Rosalien/dataAccessApp: Data Access shiny app

dataAccessApp

Shiny app to visualize and extract data from SNO-Tourbières database : https://data-snot.cnrs.fr/data-access/

Installation

You can install the released version of dataAccessApp with:

devtools::install_github("Rosalien/dataAccessApp")

Database configuration

dataAccessApp works with a postgresql database build with data-snot.cnrs.fr. To test dataAccessApp, you can used a dump of database test with these parameters :

• dbname: "sno"
• host: "localhost"
• port: "5432"
• user : "snouser"
• password: "sno001"

Deploy

Deploy in local

language <- "en" #'en' or 'fr'
pool <- "dbconfProd.yaml" #yaml of database configuration 
dataAccessApp::run_app(language,pool)

Shiny-server

Copy/paste package folder into shiny-server folder

git clone https://github.com/Rosalien/dataAccessApp.git
cp -r dataAccessApp/* to/the/Shiny-server/folder/

Modify app.R for language and database configuration :

• language : 'en' or 'fr'
• pool : path of yaml database configuration. Example of yaml file database configuration

language <- "en"
pool <- "dbconfProd.yaml"
dataAccessApp::run_app(language,pool)

Docker

Build and run database test :

cd inst/extdata/
docker build -t snodb .
docker run -d --name snodbrun -p 5433:5432 snodb:latest
docker exec -i snodbrun pg_restore --clean --dbname sno -h localhost -p 5432 -U snouser < snotest.dump

Build dataAccessApp :

docker build -t dataaccessapp .

Deploy dataAccessApp :

docker run --net=host dataaccessapp

Rosalien/dataAccessApp documentation built on Aug. 22, 2020, 12:10 a.m.