MDB | R Documentation |
The class "MDB" provides general functions for handling modeled databases. The MDB classes implemented in the TKCat package are: fileMDB, memoMDB, chMDB and metaMDB. These classes provide additional functions.
## S3 method for class 'MDB'
names(x)
## S3 method for class 'MDB'
length(x)
## S3 method for class 'MDB'
lengths(x, use.names = TRUE)
## S3 method for class 'MDB'
as.list(x, ...)
## S3 method for class 'MDB'
select(.data, ...)
## S3 method for class 'MDB'
pull(.data, var = -1, name = NULL, ...)
## S3 method for class 'MDB'
c(...)
## S3 method for class 'MDB'
merge(
x,
y,
by = get_shared_collections(x, y),
dbInfo = list(name = paste(db_info(x)$name, db_info(y)$name, sep = "_")),
dmAutoLayout = TRUE,
rtColor = "yellow",
funs = list(),
...
)
x |
an MDB object |
use.names |
return the names of the tables |
... |
additional parameters |
.data |
an MDB object |
var |
a variable specified as in dplyr::pull |
name |
not used but kept for compatibility with the generic function |
y |
an MDB object |
by |
a tibble as returned by the |
dbInfo |
a list with DB information: "name" (only mandatory field), "title", "description", "url", "version", "maintainer". |
dmAutoLayout |
if TRUE (default) the layout of the merged data model is automatically adjusted. |
rtColor |
the color of the relational tables in the merged data model (default: "yellow") |
funs |
a named list of functions (default: list()). If there is
no function for mapping a collection in this list, it is taken
automatically using the |
names()
returns the table names.
length()
returns the number of tables in x.
lengths()
returns the number of fields for each table in x.
as.list.MDB()
returns a simple list of tibbles with all the
data from the tables in x.
A metaMDB object gathering x and y along
with relational tables between them created using collection members
and mapping functions automatically chosen or provided by
the funs
parameter. ...
can be used to send parameters to the mapper
functions.
MDB methods: db_info, data_model, data_tables, collection_members, count_records, filter_with_tables, as_fileMDB Additional documentation is provided for each specific class: fileMDB, memoMDB, chMDB and metaMDB.
Add the following code to your website.
For more information on customizing the embed code, read Embedding Snippets.