Get advice for a DB connection (beyond tests).

These settings are set by the package maintainers based on experience with specific databases.

rq_connection_advice(db)

Arguments

db	database connection handle

Value

named list of options

See also

rq_connection_tests

Examples

if(requireNamespace("DBI", quietly = TRUE) && requireNamespace("RSQLite", quietly = TRUE)) {
  my_db <- DBI::dbConnect(RSQLite::SQLite(), ":memory:")
  print(rq_connection_name(my_db))
  print(rq_connection_advice(my_db))
  DBI::dbDisconnect(my_db)
}
#> [1] "SQLiteConnection"
#> $rquery.SQLiteConnection.use_DROP_TABLE_IF_EXISTS
#> [1] TRUE
#> 
#> $rquery.SQLiteConnection.expr_map
#> $rquery.SQLiteConnection.expr_map$MOD
#> $rquery.SQLiteConnection.expr_map$MOD[[1]]
#> [1] "("
#> 
#> $rquery.SQLiteConnection.expr_map$MOD[[2]]
#> [1] 3
#> 
#> $rquery.SQLiteConnection.expr_map$MOD[[3]]
#> [1] "%"
#> 
#> $rquery.SQLiteConnection.expr_map$MOD[[4]]
#> [1] 5
#> 
#> $rquery.SQLiteConnection.expr_map$MOD[[5]]
#> [1] ")"
#> 
#> 
#> $rquery.SQLiteConnection.expr_map$rand
#> $rquery.SQLiteConnection.expr_map$rand[[1]]
#> [1] "ABS"
#> 
#> $rquery.SQLiteConnection.expr_map$rand[[2]]
#> [1] "("
#> 
#> $rquery.SQLiteConnection.expr_map$rand[[3]]
#> [1] "("
#> 
#> $rquery.SQLiteConnection.expr_map$rand[[4]]
#> [1] "RANDOM"
#> 
#> $rquery.SQLiteConnection.expr_map$rand[[5]]
#> [1] "("
#> 
#> $rquery.SQLiteConnection.expr_map$rand[[6]]
#> [1] ")"
#> 
#> $rquery.SQLiteConnection.expr_map$rand[[7]]
#> [1] "%"
#> 
#> $rquery.SQLiteConnection.expr_map$rand[[8]]
#> [1] "268435456"
#> 
#> $rquery.SQLiteConnection.expr_map$rand[[9]]
#> [1] ")"
#> 
#> $rquery.SQLiteConnection.expr_map$rand[[10]]
#> [1] "/"
#> 
#> $rquery.SQLiteConnection.expr_map$rand[[11]]
#> [1] "268435455.0"
#> 
#> $rquery.SQLiteConnection.expr_map$rand[[12]]
#> [1] ")"
#> 
#> 
#>