Select specified records and fields from a table

Usage

sql_select_records_and_fields(
  table,
  base_url,
  user_name,
  password,
  dbms,
  driver_name,
  database_name,
  port,
  record = NULL,
  id_column_name = NULL,
  field = NULL,
  id_pos = NULL
)

Arguments

table: the table name
base_url: the host server name
user_name: the user name
password: the user's password
dbms: the database management system type
driver_name: the driver name
database_name: the database name
port: the server port ID
record: a vector or a comma-separated string of subset of subject IDs.
id_column_name: the column names that unique identify the records in the tables
field: a vector of strings where each string is a comma-separated list of column names.
id_pos: a vector of the column positions of the variable that unique identifies the subjects in each table

Value

an object of type data.frame that contains the dataset with the specified fields and records.

Examples

if (FALSE) {
result <- sql_select_records_and_fields(
  table          = "author",
  base_url       = "mysql-rfam-public.ebi.ac.uk",
  user_name      = "rfamro",
  password       = "",
  dbms           = "MySQL",
  driver_name    = "",
  database_name  = "Rfam",
  port           = 4497,
  record         = c("1", "20", "50"),
  id_column_name = "author_id",
  field          = c("author_id", "last_name"),
  id_pos         = NULL
)
}