ropensci / taxadb

:package: Taxonomic Database
https://docs.ropensci.org/taxadb
Other
43 stars 13 forks source link

Warning message when calling get_ids #118

Closed jasonO6359 closed 6 months ago

jasonO6359 commented 6 months ago
library(tidyverse)
library(taxadb)

lmb_itis <- get_ids("Micropterus salmoides",
                    provider = "itis", 
                    check_from = FALSE)
#> It looks like you tried to incorrectly use a table in a schema as source.
#> ℹ If you want to specify a schema use `in_schema()` or `in_catalog()`.
#> ℹ If your table actually contains "." in the name use `check_from = FALSE` to
#>   silence this message.
#> Joining with `by = join_by(scientificName)`

Created on 2024-02-29 with reprex v2.1.0

Session info ``` r sessionInfo() #> R version 4.3.0 (2023-04-21 ucrt) #> Platform: x86_64-w64-mingw32/x64 (64-bit) #> Running under: Windows 10 x64 (build 19045) #> #> Matrix products: default #> #> #> locale: #> [1] LC_COLLATE=English_United States.utf8 #> [2] LC_CTYPE=English_United States.utf8 #> [3] LC_MONETARY=English_United States.utf8 #> [4] LC_NUMERIC=C #> [5] LC_TIME=English_United States.utf8 #> #> time zone: America/New_York #> tzcode source: internal #> #> attached base packages: #> [1] stats graphics grDevices utils datasets methods base #> #> other attached packages: #> [1] taxadb_0.2.1 lubridate_1.9.3 forcats_1.0.0 stringr_1.5.1 #> [5] dplyr_1.1.4 purrr_1.0.2 readr_2.1.5 tidyr_1.3.1 #> [9] tibble_3.2.1 ggplot2_3.5.0 tidyverse_2.0.0 #> #> loaded via a namespace (and not attached): #> [1] styler_1.10.2 utf8_1.2.4 generics_0.1.3 stringi_1.8.3 #> [5] hms_1.1.3 digest_0.6.34 magrittr_2.0.3 evaluate_0.23 #> [9] grid_4.3.0 timechange_0.3.0 blob_1.2.4 contentid_0.0.18 #> [13] fastmap_1.1.1 jsonlite_1.8.8 R.oo_1.26.0 R.cache_0.16.0 #> [17] R.utils_2.12.3 DBI_1.2.2 httr_1.4.7 fansi_1.0.6 #> [21] scales_1.3.0 duckdb_0.9.2-1 cli_3.6.2 rlang_1.1.3 #> [25] dbplyr_2.4.0 R.methodsS3_1.8.2 munsell_0.5.0 reprex_2.1.0 #> [29] cachem_1.0.8 withr_3.0.0 yaml_2.3.8 tools_4.3.0 #> [33] tzdb_0.4.0 memoise_2.0.1 colorspace_2.1-0 curl_5.2.0 #> [37] vctrs_0.6.5 R6_2.5.1 lifecycle_1.0.4 fs_1.6.3 #> [41] pkgconfig_2.0.3 pillar_1.9.0 gtable_0.3.4 glue_1.7.0 #> [45] xfun_0.42 tidyselect_1.2.0 rstudioapi_0.15.0 knitr_1.45 #> [49] htmltools_0.5.7 rmarkdown_2.25 compiler_4.3.0 askpass_1.2.0 #> [53] openssl_2.1.1 ```
jasonO6359 commented 6 months ago

Issue appears to be caused by call to dplyr::tbl(db, tbl_name) within the call to taxa_tbl(). Warning message is the result of tbl_name having a "." which is due to the database version number "22.12". Can be resolved by modifying to dplyr::tbl(db, tbl_name, check_from = FALSE)