Try and test database for some option settings.

Source: R/db_ops.R

These settings are estimated by experiments. This is not the full set of options- but just the ones tested here.

rq_connection_tests(db, ..., overrides = NULL, use_advice = TRUE)

Arguments

db

database connection handle.
...

force later arguments to bind by name.
overrides

named character vector or list, options (just name, not DB qualification) to force
use_advice

logical if TRUE incorporate hard-coded advice.

Value

named list of options

Details

Note: tests are currently run in the default schema. Also it is normal to see some warning/error messages as different database capabilities are tested.

See also

rq_connection_advice

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_tests(my_db,
     overrides = c("use_DBI_dbExistsTable" = FALSE)))
  # the following would set options
  # print(options(rq_connection_tests(my_db)))
  DBI::dbDisconnect(my_db)
}

#> [1] "SQLiteConnection"
#> $rquery.SQLiteConnection.use_DBI_dbListFields
#> [1] TRUE
#> 
#> $rquery.SQLiteConnection.use_DBI_dbRemoveTable
#> [1] TRUE
#> 
#> $rquery.SQLiteConnection.use_DBI_dbExecute
#> [1] TRUE
#> 
#> $rquery.SQLiteConnection.create_temporary
#> [1] FALSE
#> 
#> $rquery.SQLiteConnection.control_temporary
#> [1] TRUE
#> 
#> $rquery.SQLiteConnection.control_temporary_view
#> [1] FALSE
#> 
#> $rquery.SQLiteConnection.control_rownames
#> [1] TRUE
#> 
#> $rquery.SQLiteConnection.use_DBI_dbExistsTable
#> [1] FALSE
#> 
#> $rquery.SQLiteConnection.check_logical_column_types
#> [1] TRUE
#> 
#> $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] ")"
#> 
#> 
#>