dm (version 0.0.5.9000)

dm: Data model class

Description

The dm class holds a list of tables and their relationships. It is inspired by datamodelr, and extends the idea by offering operations to access the data in the tables.

dm() creates a dm object from one or multiple tbl objects (tibbles or lazy data objects).

dm_from_src() creates a dm from some or all tables in a src (a database or an environment).

new_dm() is a low-level constructor that creates a new dm object.

If called without arguments, it will create an empty dm.

If called with arguments, no validation checks will be made to ascertain that the inputs are of the expected class and internally consistent; use validate_dm() to double-check the returned object.

validate_dm() checks the internal consistency of a dm object.

cdm_get_src() returns the dplyr source for a dm object. All tables in a dm object must be from the same source, i.e. either they are all data frames, or they all are stored on the same database.

cdm_get_con() returns the DBI::DBIConnection for dm objects. This works only if the tables are stored on a database, otherwise an error is thrown.

cdm_get_tables() returns a named list of dplyr tbl objects of a dm object. Filtering expressions are NOT evaluated at this stage. To get filtered tables, use tbl.dm()

cdm_get_filter() returns the filter expressions that have been applied to a dm object. These filter expressions are not intended for evaluation, only for information.

is_dm() returns TRUE if the input is of class dm.

as_dm() coerces objects to the dm class

Usage

dm(..., .name_repair = c("check_unique", "unique", "universal", "minimal"))
dm_from_src(src, table_names = NULL)
new_dm(tables = list())
validate_dm(x)
cdm_get_src(x)
cdm_get_con(x)
cdm_get_tables(x)
cdm_get_filter(x)
is_dm(x)
as_dm(x)

Arguments

...

Tables to add to the dm object. If no names are provided, the tables are auto-named.

.name_repair

Options for name repair. Forwarded as repair to vctrs::vec_as_names().

src

A dplyr table source object.

table_names

A character vector of the names of the tables to include.

tables

A named list of the tables (tibble-objects, not names) . to be included in the dm object.

x

An object.

See Also

• cdm_add_pk() and cdm_add_fk() add primary and foreign keys

• cdm_copy_to() and cdm_learn_from_db() for DB interaction

• cdm_draw() for visualization

• cdm_join_to_tbl() for flattening

• cdm_filter() for filtering

• cdm_select_tbl() for creating a dm with only a subset of the tables

• decompose_table() as one example of the table surgery family

• check_key() and check_if_subset() for checking for key properties

• check_cardinality() for checking the cardinality of the relation between two tables

• cdm_nycflights13() for creating an example dm object

Examples

# NOT RUN {
library(dplyr)
dm(iris, mtcars)
dm_from_src(dplyr::src_df(pkg = "nycflights13"))
new_dm(list(iris = iris, mtcars = mtcars))
as_dm(list(iris = iris, mtcars = mtcars))

cdm_nycflights13() %>% tbl("airports")
cdm_nycflights13() %>% src_tbls()
cdm_nycflights13() %>% cdm_get_src()
cdm_nycflights13() %>% cdm_get_tables()

cdm_nycflights13() %>%
  cdm_rename_tbl(ap = airports)
cdm_nycflights13() %>%
  cdm_rename_tbl(ap = airports, fl = flights)
# }