sql_collect: Query and get data back into a data.frame

In ropenscilabs/taxizedb: Tools for Working with 'Taxonomic' Databases

Query and get data back into a data.frame

Description

Query and get data back into a data.frame

Usage

sql_collect(src, query, ...)

Arguments

src	(src) An src object, result of calling src_itis(), src_col(), or src_tpl()
query	(character) A SQL query
...	further args passed on to dplyr::tbl()

Details

we run dplyr::tbl(), then dplyr::collect()

Examples

## Not run: 
src <- src_itis()
sql_collect(src, "select * from hierarchy limit 5")
## or pipe the src to sql_collect
src %>% sql_collect("select * from hierarchy limit 5")

## End(Not run)

ropenscilabs/taxizedb documentation built on May 4, 2023, 7:05 a.m.