Learn R Programming

dbWebForms (version 0.1.0)

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

Description

Offers meta programming style tools to generate configurable R functions that produce HTML forms based on table input and SQL meta data. Also generates functions for collecting the parameters of those HTML forms after they are submitted. Useful for quickly generating HTML forms based on existing SQL tables. To use the resultant functions, the output files containing those functions must be read into the R environment (perhaps using base::source()).

Copy Link

Version

Install

install.packages('dbWebForms')

Monthly Downloads

228

Version

0.1.0

License

GPL (>= 2)

Maintainer

Timothy Conwell

Last Published

January 28th, 2021

Functions in dbWebForms (0.1.0)

dbTypeToHTMLInputType

Convert SQL data types to likely HTML input types
dbTableInfo

Query INFORMATION_SCHEMA or equivalent SQL meta data to obtain column names and types for a table.
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.
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.