Add a list of users to the database
Arguments
- conn_handler
An R object obtained from SigRepo::newConnhandler() (required)
- user_tbl
A Data Frame; must contain the following column names: user_name, user_password, user_email, user_first, user_last, user_affiliation, user_role, active (required)
- verbose
Logical; whether to print diagnostic messages. Defaults to 'TRUE'
Examples
if (FALSE) { # \dontrun{
# Create users table
user_tbl <- base::data.frame(
user_name = "joe12343",
user_password = "ffgfd",
user_email = "joejoe@gmail.com",
user_first = "joe",
user_last = "joe",
user_affiliation = "Imaginary Tester"
)
# Create a connection handler
conn_handler <- SigRepo::newConnHandler(
dbname = "sigrepo",
host = "sigrepo.org",
port = 3306,
user = "your_username",
password = "your_password"
)
# Add users to database
SigRepo::addUser(
conn_handler = conn_handler,
user_tbl = user_tbl,
verbose = FALSE
)
} # }