jdbc_register_driver(
'org.apache.derby.jdbc.EmbeddedDriver',
resolve(
module('org.apache.derby:derby:10.12.1.1'),
repositories = list(maven_local, maven_central)
)
)
DBItest::make_context(
dbj::driver(),
list(url = "jdbc:derby:memory:dbi-test;create=true", user = 'sa'),
tweaks = DBItest::tweaks(constructor_name = "driver"),
name = "Derby"
)
DBItest::test_all(skip = c(
# Driver independent
dbj_skips_global,
# Derby specific
"temporary_table", # TODO: temporary tables must be accessed in the SESSSION schema (http://db.apache.org/derby/docs/10.2/ref/rrefdeclaretemptable.html)
# Not an error: Syntax not supported (WHERE clause is mandatory in SELECT expressions)
"quote_string",
"trivial_query",
"clear_result_return",
"command_query",
"fetch_.*",
"get_query_.*",
"data_.*",
"quote_identifier.*",
"is_valid_result",
"get_statement",
"row_count",
"get_info_result",
# Not an error: DBItest does not quote identifiers in select expressions. https://github.com/rstats-db/DBItest/issues/64
"write_table",
"read_table",
"table_visible_in_other_connection",
"roundtrip_numeric_special",
"rows_affected",
NULL
))
test_bdj_extras(skip = c()
)
Add the following code to your website.
For more information on customizing the embed code, read Embedding Snippets.