tests/testthat/test-DBItest-H2.R

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

jdbc_register_driver(
	'org.h2.Driver',
	resolve(
		module('com.h2database:h2:1.3.176'),
	  repositories = list(maven_local, maven_central)
	)
)

DBItest::make_context(
	dbj::driver(),
	# DATABASE_TO_UPPER=FALSE is required because of https://github.com/rstats-db/DBItest/issues/64
	list(url = "jdbc:h2:mem:dbi-test;DATABASE_TO_UPPER=FALSE", user = 'sa'),
	tweaks = DBItest::tweaks(constructor_name = "driver"),
  name = "H2"
)

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

	# H2 specific
	"data_date($|_.+)",									# Not an error: date() function is undefined in H2.
	"data_timestamp_parens($|_.+)", 		# Not an error: datetime() is an unsupported function in H2
	"data_raw($|_.+)",									# Not an error: SELECT cast(1 as BLOB) is invalid sytax in H2	
	NULL
))

test_bdj_extras(skip = c()
)