|
create_schema()
|
Create a schema in the pantry |
|
date_code()
|
create date code of the form YYMMDD
inputs:
d (optional): date code in the format of Sys.Date() for which to generate the date code, defaulting to 'today' |
|
drop_schema()
|
Drop a schema from the pantry |
|
drop_table()
|
Drop a table |
|
get_pantry()
|
Attach to the pantry database, optionally using a schema. If the
specified schema doesn't exist, create it. |
|
get_pantry_config()
|
Get and check login information for Postgres database |
|
get_schema()
|
Alias for get_search_path |
|
get_schemas()
|
Get all available schemas |
|
get_search_path()
|
Get the search path for looking for namespaces |
|
get_staging_directory()
|
Get the staging directory for the given dataset |
|
get_tables()
|
Get all tables in the active schema or search path |
|
make_symmetric()
|
make a dataset symmetric |
|
schema_tbl()
|
Identify a table qualified by a schema. This works around issue 244 in dplyr |
|
set_schema()
|
Set a schema as the active schema |
|
summarize_map()
|
Diagnostics for messy joins |
|
test_distinct()
|
test distinct rows
e.g. for testing for network loops |
|
test_is_symmetric()
|
test if the columns names(ids) are symmetric to the columns ids
and for those that are symmetric, test equality over the value columns |
|
test_null_count()
|
test number null |
|
test_null_frac()
|
test fraction null |
|
uniprot_entry_web_lookup()
|
Get lookup info for given uniprot entries one at a time |
|
uniprot_taxa()
|
Get all taxa below a given ancestor taxa |
|
uniprot_web_lookup()
|
Get lookup info for given uniprot accessions one at a time |