qry_insert: Insert a row into a table from the shinymgr.sqlite database

In shinymgr: A Framework for Building, Managing, and Stitching 'shiny' Modules into Reproducible Workflows

Insert a row into a table from the shinymgr.sqlite database

Description

Inserts a record(s) to a specified table in the shinymgr database. Used internally as all database tables are populated by shinymgr functions.

Usage

qry_insert(tableName, rowValues, shinyMgrPath)

Arguments

tableName	The name of a table from the shinymgr database to append.
rowValues	The values of a row to be inserted into the specified table. Note: this must be passed as a data frame whose columns match exactly the table being appended to.
shinyMgrPath	File path to the main shiny manager project directory

Value

integer, number of rows appended

Tutorials

The shinymgr learnr tutorials include, in order:

1. learnr::run_tutorial(name = "intro", package = "shinymgr")

2. learnr::run_tutorial(name = "shiny", package = "shinymgr")

3. learnr::run_tutorial(name = "modules", package = "shinymgr")

4. learnr::run_tutorial(name = "app_modules", package = "shinymgr")

5. learnr::run_tutorial(name = "tests", package = "shinymgr")

6. learnr::run_tutorial(name = "shinymgr", package = "shinymgr")

7. learnr::run_tutorial(name = "database", package = "shinymgr")

8. learnr::run_tutorial(name = "shinymgr_modules", package = "shinymgr")

9. learnr::run_tutorial(name = "apps", package = "shinymgr")

10. learnr::run_tutorial(name = "analyses", package = "shinymgr")

11. learnr::run_tutorial(name = "reports", package = "shinymgr")

12. learnr::run_tutorial(name = "deployment", package = "shinymgr")

References

https://code.usgs.gov/vtcfwru/shinymgr

See Also

Other qry: qry_app_flow(), qry_app_stitching(), qry_mod_info(), qry_row()

shinymgr documentation built on May 29, 2024, 1:17 a.m.