No applicable method for db_has_table

[andrew-schulman]

In dbplyr 2.0.0 with dplyr 1.0.2, db_has_table causes a no applicable method for 'db_has_table' error. It seems that db_has_table is no longer implemented, although it's still listed in the dplyr documentation. I hope it's going to be added back in?

With an ODBC back end:

library(dplyr)
#> 
#> Attaching package: 'dplyr'
#> The following objects are masked from 'package:stats':
#> 
#>     filter, lag
#> The following objects are masked from 'package:base':
#> 
#>     intersect, setdiff, setequal, union
dbpool <- pool::dbPool(odbc::odbc(), ...)
db_has_table(dbpool, 'table_name')
#> Error in UseMethod("db_has_table"): no applicable method for 'db_has_table' applied to an object of class "c('Oracle', 'OdbcConnection', 'DBIConnection', 'DBIObject')"

With a Postgres back end:

library(dplyr)
#> 
#> Attaching package: 'dplyr'
#> The following objects are masked from 'package:stats':
#> 
#>     filter, lag
#> The following objects are masked from 'package:base':
#> 
#>     intersect, setdiff, setequal, union
dbpool <- pool::dbPool(RPostgres::Postgres(), ...)
db_has_table(dbpool, 'table_name')
#> Error in UseMethod("db_has_table"): no applicable method for 'db_has_table' applied to an object of class "c('PqConnection', 'DBIConnection', 'DBIObject')"

Both of the above used to work in dbplyr 1.x.

[andrew-schulman]

I see also the same error for db_create_table, db_drop_table, and db_list_tables.

[Alternikaner]

The release notes for the latest version (under "Extensibility") mention a change involving these generics since db_write_table() no longer requires them.

DBI::dbExistsTable() should work as a drop-in replacement for db_has_table().
DBI also provides equivalents for your other use cases in dbCreateTable(), dbRemoveTable() and dbListTables() respectively.