data-raw/sql_query_test/app.R

In takewiki/tsui: user interface elements from shiny,H5,css,js in takewiki solutions

#
# 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)
library(tsui)
library(tsda)

# 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(
            mdl_sql_conn('conn')
        ),

        # Show a plot of the generated distribution
        mainPanel(
           mdl_sql_query('query')
        )
    )
)

# Define server logic required to draw a histogram
server <- function(input, output) {

    conn <-run_sql_common('conn');
    run_sql_query('query',conn())
}

# Run the application 
shinyApp(ui = ui, server = server)