_dev/shrink_ri_db.r
In jstrunk001/RForInvt: Forest Inventory Data Compilation and FVS Growth Projections
dir_ri = "C:\\Users\\jstrunk\\Box\\sync\\R\\r_packages_dev\\my_packages\\RForInvt\\inst\\extdata\\FIADB_RI.db"
conSQL = DBI::dbConnect( RSQLite::SQLite() , dbname= dir_ri )
tbs_ri = dbListTables(conSQL)
sql_drp = paste0("drop table ", grep("^FVS",tbs_ri ,invert=T, value=T) )
mapply( dbExecute , statement= sql_drp , MoreArgs = list(conn=conSQL) )
dbExecute(conSQL,"vacuum")
dbDisconnect( conSQL )
jstrunk001/RForInvt documentation built on April 17, 2025, 5:02 p.m.
R Package Documentation
Browse R Packages
We want your feedback!
Note that we can't provide technical support on individual packages. You should contact the package authors for that.
dir_ri = "C:\\Users\\jstrunk\\Box\\sync\\R\\r_packages_dev\\my_packages\\RForInvt\\inst\\extdata\\FIADB_RI.db"
conSQL = DBI::dbConnect( RSQLite::SQLite() , dbname= dir_ri )
tbs_ri = dbListTables(conSQL)
sql_drp = paste0("drop table ", grep("^FVS",tbs_ri ,invert=T, value=T) )
mapply( dbExecute , statement= sql_drp , MoreArgs = list(conn=conSQL) )
dbExecute(conSQL,"vacuum")
dbDisconnect( conSQL )
R Package Documentation
Browse R Packages
We want your feedback!
Note that we can't provide technical support on individual packages. You should contact the package authors for that.
Embedding an R snippet on your website
Add the following code to your website.
For more information on customizing the embed code, read Embedding Snippets.