{ "_id": "6a1f1754b401979e7341ea88", "Package": "dbWebForms", "Type": "Package", "Title": "Produce R Functions to Create HTML Forms Based on SQL Meta Data", "Version": "0.1.0", "Author": "Timothy Conwell", "Maintainer": "Timothy Conwell ", "Description": "Offers meta programming style tools to generate\nconfigurable R functions that produce HTML forms based on table\ninput and SQL meta data. Also generates functions for\ncollecting the parameters of those HTML forms after they are\nsubmitted. Useful for quickly generating HTML forms based on\nexisting SQL tables. To use the resultant functions, the output\nfiles containing those functions must be read into the R\nenvironment (perhaps using base::source()).", "License": "GPL (>= 2)", "Encoding": "UTF-8", "RoxygenNote": "7.1.1", "NeedsCompilation": "no", "Packaged": { "Date": "2026-05-17 06:04:08 UTC", "User": "root" }, "Config/pak/sysreqs": "libicu-dev", "Repository": "https://tconwell.r-universe.dev", "Date/Publication": "2021-01-28 12:00:03 UTC", "RemoteUrl": "https://github.com/cran/dbWebForms", "RemoteRef": "HEAD", "RemoteSha": "32671c58873365883030103a62d4bd2659ee97fc", "MD5sum": "42da80dea1df541995ad65a4bf3d05fd", "_user": "tconwell", "_type": "src", "_file": "dbWebForms_0.1.0.tar.gz", "_fileid": "fbf42a311c777842d16ddfd7639c9a813fb97a0cce21671c6572ceb4cc77c691", "_filesize": 98952, "_sha256": "fbf42a311c777842d16ddfd7639c9a813fb97a0cce21671c6572ceb4cc77c691", "_created": "2026-05-17T06:04:08.000Z", "_published": "2026-06-02T17:48:04.823Z", "_distro": "noble", "_jobs": [ { "job": 79135737154, "time": 106, "config": "linux-devel-x86_64", "r": "4.7.0", "check": "NOTE", "artifact": "7039853278" }, { "job": 79135737424, "time": 114, "config": "linux-release-x86_64", "r": "4.6.0", "check": "NOTE", "artifact": "7039854044" }, { "job": 79135737116, "time": 82, "config": "macos-oldrel-arm64", "r": "4.5.3", "check": "NOTE", "artifact": "7039850662" }, { "job": 79135736879, "time": 80, "config": "macos-release-arm64", "r": "4.6.0", "check": "NOTE", "artifact": "7039850301" }, { "job": 79135736620, "time": 136, "config": "source", "r": "4.6.0", "check": "OK", "artifact": "7039841970" }, { "job": 79135736918, "time": 91, "config": "wasm-release", "r": "4.6.0", "check": "OK", "artifact": "7365552241" }, { "job": 79135737347, "time": 83, "config": "windows-devel", "r": "4.7.0", "check": "NOTE", "artifact": "7039850581" }, { "job": 79135737253, "time": 68, "config": "windows-oldrel", "r": "4.5.3", "check": "NOTE", "artifact": "7039849267" }, { "job": 79135737057, "time": 78, "config": "windows-release", "r": "4.6.0", "check": "NOTE", "artifact": "7039850340" } ], "_buildurl": "https://github.com/r-universe/tconwell/actions/runs/25983000955", "_status": "success", "_host": "GitHub-Actions", "_upstream": "https://github.com/cran/dbWebForms", "_commit": { "id": "32671c58873365883030103a62d4bd2659ee97fc", "author": "Timothy Conwell ", "committer": "cran-robot ", "message": "version 0.1.0\n", "time": 1611835203 }, "_maintainer": { "name": "Timothy Conwell", "email": "timconwell@gmail.com", "login": "tconwell", "description": "", "uuid": 51293949 }, "_registered": true, "_dependencies": [ { "package": "DBI", "role": "Depends" }, { "package": "data.table", "role": "Depends" }, { "package": "stringi", "role": "Depends" }, { "package": "html5", "role": "Imports" } ], "_owner": "cran", "_selfowned": true, "_usedby": 0, "_updates": [], "_tags": [], "_stars": 0, "_contributors": [ { "user": "tconwell", "count": 1, "uuid": 51293949 } ], "_userbio": { "uuid": 51293949, "type": "user", "name": "Tim Conwell" }, "_downloads": { "count": 219, "source": "https://cranlogs.r-pkg.org/downloads/total/last-month/dbWebForms" }, "_searchresults": 0, "_rbuild": "4.6.0", "_assets": [ "extra/citation.cff", "extra/citation.html", "extra/citation.json", "extra/citation.txt", "extra/contents.json", "extra/dbWebForms.html", "manual.pdf" ], "_realowner": "tconwell", "_cranurl": false, "_releases": [ { "version": "0.1.0", "date": "2021-01-28" } ], "_exports": [ "createFetchParamsFunction", "createHTMLFormFunction", "dbTableInfo", "dbTypeToHTMLInputType", "namesToLabels", "quoteText" ], "_help": [ { "page": "createFetchParamsFunction", "title": "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.", "topics": [ "createFetchParamsFunction" ] }, { "page": "createHTMLFormFunction", "title": "Based on the columns in a table, produces a R function with parameters for each column that produces a HTML form when called.", "topics": [ "createHTMLFormFunction" ] }, { "page": "dbTableInfo", "title": "Query INFORMATION_SCHEMA or equivalent SQL meta data to obtain column names and types for a table.", "topics": [ "dbTableInfo" ] }, { "page": "dbTypeToHTMLInputType", "title": "Convert SQL data types to likely HTML input types", "topics": [ "dbTypeToHTMLInputType" ] }, { "page": "namesToLabels", "title": "Convert strings to title case, splitting strings into separate words based on a separator.", "topics": [ "namesToLabels" ] }, { "page": "quoteText", "title": "Add single quotes to strings, useful for converting R strings into SQL formatted strings.", "topics": [ "quoteText" ] } ], "_rundeps": [ "data.table", "DBI", "html5", "stringi" ], "_score": 1, "_indexed": true, "_nocasepkg": "dbwebforms", "_universes": [ "tconwell" ], "_binaries": [ { "r": "4.7.0", "os": "linux", "version": "0.1.0", "date": "2026-05-17T06:05:57.000Z", "distro": "noble", "commit": "32671c58873365883030103a62d4bd2659ee97fc", "fileid": "66712d736001093839506e0afce9f48863cf17b2d534786e404f5f6a6cc88102", "status": "success", "check": "NOTE", "buildurl": "https://github.com/r-universe/tconwell/actions/runs/25983000955" }, { "r": "4.6.0", "os": "linux", "version": "0.1.0", "date": "2026-05-17T06:06:03.000Z", "distro": "noble", "commit": "32671c58873365883030103a62d4bd2659ee97fc", "fileid": "0f4893218d0077c2fb33ce69d605be8ab839c2bc4b1a9d71b2daf3b5dacf4fc8", "status": "success", "check": "NOTE", "buildurl": "https://github.com/r-universe/tconwell/actions/runs/25983000955" }, { "r": "4.5.3", "os": "mac", "version": "0.1.0", "date": "2026-05-17T06:05:34.000Z", "commit": "32671c58873365883030103a62d4bd2659ee97fc", "fileid": "960cf8024a537023827bb12a35b75324fdbbfc2316cb69faa19d421aee150f0c", "status": "success", "check": "NOTE", "buildurl": "https://github.com/r-universe/tconwell/actions/runs/25983000955" }, { "r": "4.6.0", "os": "mac", "version": "0.1.0", "date": "2026-05-17T06:05:32.000Z", "commit": "32671c58873365883030103a62d4bd2659ee97fc", "fileid": "a4a8ab4b82658e0d2878a57f22c6b1fd9d53e342ad77867c08d937c87704ee3a", "status": "success", "check": "NOTE", "buildurl": "https://github.com/r-universe/tconwell/actions/runs/25983000955" }, { "r": "4.7.0", "os": "win", "version": "0.1.0", "date": "2026-05-17T06:05:27.000Z", "commit": "32671c58873365883030103a62d4bd2659ee97fc", "fileid": "ed124e31ed7e1ac107bd29a49eed73aa558269625753a19d1e439e41dd8e9d05", "status": "success", "check": "NOTE", "buildurl": "https://github.com/r-universe/tconwell/actions/runs/25983000955" }, { "r": "4.5.3", "os": "win", "version": "0.1.0", "date": "2026-05-17T06:05:16.000Z", "commit": "32671c58873365883030103a62d4bd2659ee97fc", "fileid": "e7f82fc1e2a9e1f71023bba1e419ec7a455343e7c2537de105baa166415c5fb5", "status": "success", "check": "NOTE", "buildurl": "https://github.com/r-universe/tconwell/actions/runs/25983000955" }, { "r": "4.6.0", "os": "win", "version": "0.1.0", "date": "2026-05-17T06:05:25.000Z", "commit": "32671c58873365883030103a62d4bd2659ee97fc", "fileid": "a1e1019a0adca8cd6f62615f0b0556116668c93839a2df3674910573471c8997", "status": "success", "check": "NOTE", "buildurl": "https://github.com/r-universe/tconwell/actions/runs/25983000955" }, { "r": "4.6.0", "os": "wasm", "version": "0.1.0", "date": "2026-06-02T17:47:52.000Z", "commit": "32671c58873365883030103a62d4bd2659ee97fc", "fileid": "1a72e32af5279f69e7e249d29dc49c72ace24f2f5ca41dcbe57b7da80ced391f", "status": "success", "buildurl": "https://github.com/r-universe/tconwell/actions/runs/25983000955" } ] }