Last active
April 3, 2021 05:58
-
-
Save nwstephens/813e3020d455667056e6638ebe8d5185 to your computer and use it in GitHub Desktop.
Configure a Shiny app to read encrypted passwords in build and run environments
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| # | |
| # This is a Shiny web application. You can run the application by clicking | |
| # the 'Run App' button above. | |
| # | |
| # Find out more about building applications with Shiny here: | |
| # | |
| # http://shiny.rstudio.com/ | |
| # | |
| # Set the keyring backend to file and initialize the system keyring: | |
| # options("keyring_backend" = "file") | |
| # keyring::keyring_create("system") | |
| # If running on RStudio Connect source the password as an environment variable that is encrypted | |
| # If running on the RStudio IDE, source the password from a file backedn that is encrypted | |
| if(Sys.getenv("R_CONFIG_ACTIVE")=="rsconnect") { | |
| pwd <- Sys.getenv("pwd") | |
| } else { | |
| pwd <- rstudioapi::askForSecret("psql") | |
| } | |
| library(DBI) | |
| con <- dbConnect( | |
| odbc::odbc(), | |
| Driver="postgresql", | |
| Server = "queenie.db.elephantsql.com", | |
| Port = "5432", | |
| Database = "edupiata", | |
| UID = "edupiata", | |
| PWD = pwd, | |
| BoolsAsChar = "0", | |
| timeout = 10 | |
| ) | |
| faithful_data <- dbReadTable(con, "faithful") | |
| library(shiny) | |
| # Define UI for application that draws a histogram | |
| ui <- fluidPage( | |
| # Application title | |
| titlePanel("Old Faithful Geyser Data"), | |
| # Sidebar with a slider input for number of bins | |
| sidebarLayout( | |
| sidebarPanel( | |
| sliderInput("bins", | |
| "Number of bins:", | |
| min = 1, | |
| max = 50, | |
| value = 30) | |
| ), | |
| # Show a plot of the generated distribution | |
| mainPanel( | |
| plotOutput("distPlot") | |
| ) | |
| ) | |
| ) | |
| # Define server logic required to draw a histogram | |
| server <- function(input, output) { | |
| output$distPlot <- renderPlot({ | |
| # generate bins based on input$bins from ui.R | |
| x <- faithful_data[, 2] | |
| bins <- seq(min(x), max(x), length.out = input$bins + 1) | |
| # draw the histogram with the specified number of bins | |
| hist(x, breaks = bins, col = 'darkgray', border = 'white') | |
| }) | |
| } | |
| # Run the application | |
| shinyApp(ui = ui, server = server) | |
| # | |
| # This is a Shiny web application. You can run the application by clicking | |
| # the 'Run App' button above. | |
| # | |
| # Find out more about building applications with Shiny here: | |
| # | |
| # http://shiny.rstudio.com/ | |
| # | |
| library(shiny) | |
| # Define UI for application that draws a histogram | |
| ui <- fluidPage( | |
| # Application title | |
| titlePanel("Old Faithful Geyser Data"), | |
| # Sidebar with a slider input for number of bins | |
| sidebarLayout( | |
| sidebarPanel( | |
| sliderInput("bins", | |
| "Number of bins:", | |
| min = 1, | |
| max = 50, | |
| value = 30) | |
| ), | |
| # Show a plot of the generated distribution | |
| mainPanel( | |
| plotOutput("distPlot") | |
| ) | |
| ) | |
| ) | |
| # Define server logic required to draw a histogram | |
| server <- function(input, output) { | |
| output$distPlot <- renderPlot({ | |
| # generate bins based on input$bins from ui.R | |
| x <- faithful[, 2] | |
| bins <- seq(min(x), max(x), length.out = input$bins + 1) | |
| # draw the histogram with the specified number of bins | |
| hist(x, breaks = bins, col = 'darkgray', border = 'white') | |
| }) | |
| } | |
| # Run the application | |
| shinyApp(ui = ui, server = server) |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment