Constructs a logical condition to query database — non_existing

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%')"