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

Description Usage Value

View source: R/sqlclasses.R

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

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
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.


multiMiR documentation built on Nov. 8, 2020, 5:46 p.m.