Create a script to check dpblyr compliance

[tomuben]

Background

Some customers use dplyr/dpblyr with r-exasol. We don't current check if we eventually break the compatibility with those packages.

We can't add this check to the integration test because dbplyr requires DBI >= 1.0.0, but our tests run only with the custom DBI version (0.3.0), compare #89.

Acceptance Criteria

Create a simple script which can be used manually to verify the compliance.
Sample code

library(exasol)
library(dplyr)
library(dbplyr)
library(tidyverse)

exaconn <- function() { con <- exasol::dbConnect( drv = "exa", #
 
EXAdriver object exahost = "192.168.2.15:8563", # IP of database cluster

uid = "sys", # Username pwd = "exasol") # Password return(con) }

db_con <- exaconn()

# Using the function in_schema https://dbplyr.tidyverse.org/reference/in_schema.html) solved the wrong SQL query, however we didn't get data back, so we are now investigating the empty result set. Let us know, if you also get an empty result set or if it works.

bpm_cycle_data <- tbl(db_con, in_schema("TEST","TEST_TABLE"))

dbDisconnect(db_con)

(Of course need to fill table TEST,TEST_TABLE)