tests/testthat/_snaps/backend-spark-sql.md

In tidyverse/dbplyr: A 'dplyr' Back End for Databases

custom clock functions translated correctly

Code
  test_translate_sql(date_count_between(date_column_1, date_column_2, "year"))
Condition
  Error in `date_count_between()`:
  ! `precision = "year"` isn't supported on database backends.
  i It must be "day" instead.

Code
  test_translate_sql(date_count_between(date_column_1, date_column_2, "day", n = 5))
Condition
  Error in `date_count_between()`:
  ! `n = 5` isn't supported on database backends.
  i It must be 1 instead.

difftime is translated correctly

Code
  test_translate_sql(difftime(start_date, end_date, units = "auto"))
Condition
  Error in `difftime()`:
  ! `units = "auto"` isn't supported on database backends.
  i It must be "days" instead.

Code
  test_translate_sql(difftime(start_date, end_date, tz = "UTC", units = "days"))
Condition
  Error in `difftime()`:
  ! Argument `tz` isn't supported on database backends.

tidyverse/dbplyr documentation built on Dec. 5, 2024, 6:31 a.m.