Produce R Functions to Create HTML Forms Based on SQL Meta Data


[Up] [Top]

Documentation for package ‘dbWebForms’ version 0.1.0

Help Pages

createFetchParamsFunction Based on the columns in a table, produces a R function that returns a data.table of HTTP parameters extracted from a list of HTPP params. You can create such a list easily using serverUtils::paramList.
createHTMLFormFunction Based on the columns in a table, produces a R function with parameters for each column that produces a HTML form when called.
dbTableInfo Query INFORMATION_SCHEMA or equivalent SQL meta data to obtain column names and types for a table.
dbTypeToHTMLInputType Convert SQL data types to likely HTML input types
namesToLabels Convert strings to title case, splitting strings into separate words based on a separator.
quoteText Add single quotes to strings, useful for converting R strings into SQL formatted strings.