Provides information about created connections.
Usageconnection_info(name_str = ".*", exact = TRUE)A regular expression to be used to identify connection names to include. The default ('.*') returns all of them.
TRUE or FALSE. Should name_str match the name of a connection exactly? TRUE will identify only 1 connection if name_str does not contain any metacharacters
Null, or a tibble with 1 row per identified connection and the following fields:
identifier (character)
a description of the connection, if found in the conf file (character)
is this connection valid and live? (logical)
the name of the driver function (character)
the string used to parameterize the connection (character)
is this a pool connection? (logical)
If no connection names matched name_str, the tibble will be empty. If no connections have been configured (e.g. connect() has not been called), NULL is returned.
library(sqlhelper)
connect(
system.file(
"examples/sqlhelper_db_conf.yml",
package="sqlhelper"
),
exclusive=TRUE
)
connection_info()
#> # A tibble: 2 × 7
#> name description live default driver conn_str pool
#> <chr> <chr> <lgl> <lgl> <glue> <chr> <lgl>
#> 1 pool_sqlite A pooled connection to an i… TRUE FALSE RSQLi… NA TRUE
#> 2 simple_sqlite A simple connection to an i… TRUE TRUE RSQLi… NA FALSE
connection_info("pool_sqlite")
#> # A tibble: 1 × 7
#> name description live default driver conn_str pool
#> <chr> <chr> <lgl> <lgl> <glue> <chr> <lgl>
#> 1 pool_sqlite A pooled connection to an in-… TRUE FALSE RSQLi… NA TRUE
RetroSearch is an open source project built by @garambo | Open a GitHub Issue
Search and Browse the WWW like it's 1997 | Search results from DuckDuckGo
HTML:
3.2
| Encoding:
UTF-8
| Version:
0.7.4