Add support for new src/tbl class in DB simulations

[move]

@edgararuiz commented on May 24, 2018, 4:00 PM UTC:

Adding support in the dbplyr::simulate_###() functions of the new src/tbl class that is being passed in the dev version of dbplyr will allow us to adds test to the customizations (ref: tidyverse/dbplyr@81419ca)

Using a PR's version of dbplyr, this should be using MINUS instead of EXCEPT:

library(dplyr, warn.conflicts = FALSE)
packageVersion("dbplyr")
#> [1] '1.2.1.9001'
lf1 <- dbplyr::lazy_frame(x = 1:4, src = dbplyr::simulate_oracle())
lf2 <- dbplyr::lazy_frame(x = 1:4, src = dbplyr::simulate_oracle())
lf1 %>% setdiff(lf2) %>% show_query()
#> <SQL> (SELECT *
#> FROM `df`)
#> EXCEPT
#> (SELECT *
#> FROM `df`)

This issue was moved by krlmlr from tidyverse/dplyr/issues/3598.

[hadley]

@edgararuiz do you remember what this is about?

[hadley]

Oh this is the problem:

lf1 <- dbplyr::lazy_frame(x = 1:4, src = dbplyr::simulate_oracle())
class(lf1)
#> [1] "tbl_lazy" "tbl"

^{Created on 2019-01-09 by the reprex package (v0.2.1.9000)}

[edgararuiz]

Sorry, I totally missed your message from last week. Yes, that's the issue