dbj/tests/testthat/test-DBItest-MySQL.R at master · hoesler/dbj · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
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
  )
)