tests/testthat/test-DBItest-MySQL.R

In hoesler/dbj: Provides access to databases through the JDBC interface

jdbc_register_driver(
  'com.mysql.jdbc.Driver',
  resolve(
    module('mysql:mysql-connector-java:5.1.38'),
    repositories = list(maven_local, maven_central)
  )
)

DBItest::make_context(
  # DBItest isn't quoting identifiers with dbQuoteIdentifier().
  # So we have to use experimantal feature DATABASE_TO_UPPER=FALSE instead.
  dbj::driver(),
  list(url = "jdbc:mysql://localhost/dbi_test?useSSL=false&generateSimpleParameterMetadata=true", user = 'dbi_test', password = 'dbi_test'),
  tweaks = DBItest::tweaks(constructor_name = "driver"),
  name = "MySQL"
)

DBItest::test_all(skip = c(
  # Driver independent
  dbj_skips_global,

  # MySQL specific
  "get_query_empty_.*",                         # syntax not supported
  "data_logical",                               # not an error: no logical data type
  "data_logical_null_.*",                       # not an error: no logical data type
  "data_logical_int",                           # not an error: no logical data type
  "data_logical_int_null_.*",                   # not an error: no logical data type
  "data_raw",                                   # not an error: can't cast to blob type
  "data_raw_null_.*",                           # not an error: can't cast to blob type
  "data_timestamp_utc",                         # syntax not supported
  "data_timestamp_utc_null_.*",                 # syntax not supported
  "data_timestamp_parens",                      # syntax not supported
  "data_timestamp_parens_null_.*",              # syntax not supported
  "roundtrip_logical",                          # not an error: no logical data type

  "data_timestamp($|_.+)",                      # TIMESTAMP '...'' returns VARCAHR on some systems (at least on Travis CI). TIMESTAMP('...'') returns expected type. DBItest bug?

  # Not an error: Arithmetic operations are returned as BIGINT: 
  "data_integer($|_.+)",                        
  "fetch_single",
  "fetch_multi_row_single_column",
  "fetch_progressive",
  "fetch_more_rows",
  "fetch_premature_close",
  "get_query_single",
  "get_query_multi_row_single_column",
  "get_query_single_row_multi_column",
  "get_query_multi",
  "quote_identifier",
  "quote_identifier_special",

  "get_info_result", # rstats-db/DBI#55
  "roundtrip_numeric_special", # rstats-db/RMySQL#105

  "roundtrip_raw",  # TODO: java.lang.NullPointerException
  
  NULL
))

test_bdj_extras(skip = c(
  "test_truncate($|_.+)",
  "test_custom_conversion.*",

  NULL
  )
)