eppo_names_tables: EPPO Data Services SQLite Database search tools

In mczyzj/pestr: Interface to Download Data on Pests and Hosts from 'EPPO'

EPPO Data Services SQLite Database search tools

Description

eppo_names_table checks if string (names or parts of the names) provided by user match any name in the EPPO database. If strings match any name in database, data frame with all names matching codeid, as well as preferred (binary), language and EPPOcode is returned.

Arguments

names_vector	A vector with organism or viruses names (or part of the names) to be checked for existence in EPPO SQLite Database.
sqlConnection	connection to SQLite EPPO Database. By default NULL; function will automatically connect to database with default credentials.

Value

Check if provided names are present in EPPO SQLite Database. Creates list which contains: data frame with matching names in database and their codeids, character vector of names from names_vector which do not match any entry in database, data frame with preferred names and their codeids, and data frame containing all names matching codeids of preferred names. Last data frame contains also column with preferred (binary), codelang (two letter character with language code), and EPPOcode.

Using with other functions

Output of the function might be passed to functions:

• eppo_tabletools_names

• eppo_tabletools_cat

• eppo_tabletools_hosts

• eppo_tabletools_distribution

Examples

## Not run: 
  ##This code needs SQLite dabatase in working directory
  test_names <- c("Xylella", "dog", "leafhopper")
  test_names_table <- eppo_names_table(test_names)

## End(Not run)

mczyzj/pestr documentation built on Feb. 27, 2024, 8:58 p.m.