Function to extract a table from the pmird database
pm_get_table(x, .table_name)
x | A |
---|---|
.table_name | A character value with the name of the table in the pmird database from which to append new rows to a csv file. |
A tibble
representing the extracted table.
if (FALSE) { # connect to database con <- RMariaDB::dbConnect( # ---todo: change this drv = RMariaDB::MariaDB(), dbname = "pmird", default.file = "~/my.cnf" ) # get dm object dm_pmird <- pmird::pm_get_dm(con, learn_keys = TRUE) # get table datasets datasets <- pmird::pm_get_table(.table_name = "datasets") RMariaDB::dbDisconnect(con) }