tests/testthat/_snaps/driver-sqlite.md

In rstats-db/odbc: Connect to ODBC Compatible Databases (using the DBI Interface)

unsupported types gives informative error

Code
  dbWriteTable(con, "df", df)
Condition
  Error in `odbcDataType()`:
  ! Can't determine type for column foo.
  Caused by error:
  ! Unsupported type

dbWriteTable() with field.types with append = TRUE

Code
  dbWriteTable(con, "boopery", data.frame(bop = 1), field.types = c(bop = "numeric"),
  append = TRUE)
Condition
  Error in `dbWriteTable()`:
  ! Cannot specify `field.types` with `append = TRUE`.

WriteTable() with overwrite = TRUE and append = TRUE

Code
  dbWriteTable(con, "boopery", data.frame(bop = 1), overwrite = TRUE, append = TRUE)
Condition
  Error in `dbWriteTable()`:
  ! `overwrite` and `append` cannot both be "TRUE".

dbWriteTable(), existing table, overwrite = FALSE, append = FALSE

Code
  dbWriteTable(con, "boopery", data.frame(bop = 1), overwrite = FALSE, append = FALSE)
Condition
  Error in `dbWriteTable()`:
  ! Table boopery exists in database, and both overwrite and append are `FALSE`.

rstats-db/odbc documentation built on May 15, 2024, 9:45 a.m.