as_mmsql_components: S3 Class constructors for objects defining SQL query...

View source: R/sqlclasses.R

as_mmsql_componentsR Documentation

S3 Class constructors for objects defining SQL query components and a collection of these parts (mmsql_components).

Description

The collection object has a defined set of components that match the multiMiR database and defined options in get_multimir(). Conceptually this is split into two parts, the relatively straightforward SELECT, FROM, and ON portion of the query and the more complex filtering and sorting operations: WHERE and ORDER BY. The latter have their own classes, the former are resolved as strings (or character vectors) in the functions defining handling of each sql table (sql_ prefix).

Usage

as_mmsql_components(.select = NULL, .from = NULL, .on = NULL,
  .where_list = NULL, .orderby = NULL, typeattr = NULL)

as_where_list(...)

as_where(.vars, .connect = NULL, .operator, .value = "%s")

is_where(x)

as_orderby(.vars, .order)

Value

as_mmsql_components: A collection of components that make up a SQL query. as_where_list, as_where, as_orderby: Individual components of a SQL query.


KechrisLab/multiMiR documentation built on Aug. 29, 2024, 2:36 a.m.