Constructs a logical condition to query database

Source: R/non_existing_intervals.R

Given a list of filters, this function builds a logical condition to query database using intervals. The output is used in build_condition().

non_existing_intervals(filters, interval, operator, partialmatch)

Arguments

filters

List of filters to be used. The names should correspond to the attribute and the values correspond to the condition for selection.
interval

the filters whose values will be considered as interval
operator

A string indicating if all the filters (AND) or some of them (OR) should be met.
partialmatch

name of the condition(s) with a string pattern for full or partial match in the query.

Value

A character(1) with the sql logical condition to query the dataset.

Author

Carmina Barberena Jonás, Jesús Emiliano Sotelo Fonseca, José Alquicira Hernández

Examples

## Build the SQL query for finidng non-existing intervals for the gene ara
non_existing_intervals(
    filters = list(name = "ara", strand = "for"),
    interval = NULL,
    operator = "AND",
    partialmatch = c("name", "strand")
)
#> [1] "(name like  '%ara%') AND (strand like  '%for%')"