existing_intervals {regutools}R Documentation

Constructs a particular logical condition to query database

Description

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

Usage

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 with values considered as interval.

operator

A string indicading 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(s)

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

Examples


## Build the SQL query for existing interval partial matches for ara
existing_intervals(
    filters = list(
        name = "ara",
        strand = "for",
        posright = c("2000", "40000")
    ),
    interval = c("posright"),
    operator = "AND",
    partialmatch = c("name", "strand")
)

[Package regutools version 1.4.0 Index]