CVS commit: pkgsrc/databases/R-dbplyr

["Makoto Fujiwara" <mef%netbsd.org@localhost>]

Module Name:    pkgsrc
Committed By:   mef
Date:           Sun Feb 19 12:15:54 UTC 2023

Modified Files:
        pkgsrc/databases/R-dbplyr: Makefile distinfo

Log Message:
(databases/R-dbplyr) Updated 2.2.1 to 2.3.0

# dbplyr 2.3.0

* Compatibility with purrr 1.0.0 (@mgirlich, #1085).

## New features

* `stringr::str_like()` (new in 1.5.0) is translated to the closest `LIKE`
  equivalent (@rjpat, #509)

* In preparation for dplyr 1.1.0:

  * The `.by` argument is supported (@mgirlich, #1051).
  * Passing `...` to `across()` is deprecated because the evaluation timing
    of `...` is ambiguous. Now instead of (e.g.)
    `across(a:b, mean, na.rm = TRUE)` use
  * `pick()` is translated (@mgirlich, #1044).
  * `case_match()` is translated (@mgirlich, #1020).
  * `case_when()` now supports the `.default` argument (@mgirlich, #1017).

* Variables that aren't found in either the data or in the environment now
  produce an error (@mgirlich, #907).

## SQL optimisation

* dbplyr now produces fewer subqueries resulting in shorter, more readable, and,
  in some cases, faster SQL. The following combination of verbs now avoids a
  subquery if possible:

  * `*_join()` + `select()` (@mgirlich, #876).
  * `select()` + `*_join()` (@mgirlich, #875).
  * `mutate()` + `filter()` and `filter()` + `filter()` (@mgirlich, #792).
  * `distinct()` (@mgirlich, #880).
  * `summarise()` + `filter()` now translates to `HAVING` (@mgirlich, #877).
  * `left/inner_join()` + `left/inner_join()` (@mgirlich, #865).

* dbplyr now uses `SELECT *` after a join instead of explicitly selecting every
  column, where possible (@mgirlich, #898).

* Joins only use the table aliases ("LHS" and "RHS") if necessary (@mgirlich).

* When using common table expressions, the results of joins and set operations
  are now reused (@mgirlich, #978).

## Improved error messages

* Many errors have been improved and now show the function where the error
  happened instead of a helper function (@mgirlich, #907).

* Errors produced by the database, e.g. in `collect()` or `rows_*()`, now show
  the verb where the error happened (@mgirlich).

* `window_order()` now produces a better error message when applied to a data
  frame (@mgirlich, #947).

* Using a named `across()` now gives a clear error message (@mgirlich, #761).

## Minor improvements and bug fixes

* Keyword highlighting can now be customised via the option `dbplyr_highlight`.
  Turn it off via `options(dbplyr_highlight = FALSE)` or pass a custom ansi
  style, e.g. `options(dbplyr_highlight = cli::combine_ansi_styles("bold", "cyan"))`
  (@mgirlich, #974).

* The rank functions (`row_number()`, `min_rank()`, `rank()`, `dense_rank()`,
  `percent_rank()`, and `cume_dist()`) now give missing values the rank NA to
  match the behaviour of dplyr (@mgirlich, #991).

* `NA`s in `blob()`s are correctly translated to `NULL` (#983).

* `copy_inline()` gains a `types` argument to specify the SQL column types
  (@mgirlich, #963).

* `cur_column()` is now supported (@mgirlich, #951).

* `distinct()` returns columns ordered the way you request, not the same
  as the input data (@mgirlich).

* `fill()` can now fill "downup" and "updown" (@mgirlich, #1057), and
  now order by non-numeric columns also in the up direction (@mgirlich, #1057).

* `filter()` now works when using a window function and an external vector
  (#1048).

* `group_by()` + renamed columns works once again (@mgirlich, #928).

* `last()` is correctly translated when no window frame is specified
  (@mgirlich, #1063).

* `setOldClass()` uses a namespace, fixing an installation issue (@mgirlich, #927).

* `sql()` is now translated differently. The `...` are now evaluated locally
  instead of being translated with `translate_sql()` (@mgirlich, #952).

## Backend specific improvements

* HANA:
  * Correctly translates `as.character()` (#1027).
  * `copy_inline()` now works for Hana (#950)

* MySQL:
  * `str_flatten()` uses `collapse = ""` by default (@fh-afrachioni, #993)

* Oracle:
  * `slice_sample()` now works for Oracle (@mgirlich, #986).
  * `copy_inline()` now works for Oracle (#972)

* PostgreSQL:
  * Generates correct literals for Dates (#727).
  * `str_flatten()` uses `collapse = ""` by default (@fh-afrachioni, #993)
  * `rows_*()` use the column types of `x` when auto copying (@mgirlich, #909).

* Redshift:
  * `round()` now respects the `digits` argument (@owenjonesuob, #1033).
  * No longer tries to use named windows anymore (@owenjonesuob, #1035).
  * `copy_inline()` now works for Redshift (#949, thanks to @ejneer for an
    initial implementation).
  * `str_flatten()` uses `collapse = ""` by default (@fh-afrachioni, #993)

*  Snowflake:
  * numeric functions: `all()`, `any()`, `log10()`, `round()`, `cor()`, `cov()`
    and `sd()`.
  * date functions: `day()`, `mday()`, `wday()`, `yday()`, `week()`,
    `isoweek()`, `month()`, `quarter()`, `isoyear()`, `seconds()`, `minutes()`,
    `hours()`, `days()`, `weeks()`, `months()`, `years()` and `floor_date()`.
  * string functions: `grepl()`, `paste()`, `paste0()`, `str_c()`, `str_locate()`,
    `str_detect()`, `str_replace()`, `str_replace_all()`, `str_remove()`,
    `str_remove_all()`, `str_trim()`, `str_squish()` and `str_flatten()`
    (@fh-afrachioni, #860).
  * `str_flatten()` uses `collapse = ""` by default (@fh-afrachioni, #993)

* SQLite:
  * `quantile()` gives a better error saying that it is not supported
    (@mgirlich, #1000).

* SQL server:
  * `as.POSIXct()` now translated correctly (@krlmlr, #1011).
  * `median()` now translated correctly (#1008).
  * `pivot_wider()` works again for MS SQL (@mgirlich, #929).
  * Always use 1 and 0 as literals for logicals (@krlmlr, #934).

* Teradata:
  * Querying works again. Unfortunately, the fix requires every column to
    once again by explicitly selected (@mgirlich, #966).
  * New translations for `as.Date()`, `week()`, `quarter()`, `paste()`,
    `startsWith()`, `row_number()`, `weighted.mean()`, `lead()`, `lag()`, and
    `cumsum()` (@overmar, #913).


To generate a diff of this commit:
cvs rdiff -u -r1.2 -r1.3 pkgsrc/databases/R-dbplyr/Makefile \
    pkgsrc/databases/R-dbplyr/distinfo

Please note that diffs are not public domain; they are subject to the
copyright notices on the relevant files.

Modified files:

Index: pkgsrc/databases/R-dbplyr/Makefile
diff -u pkgsrc/databases/R-dbplyr/Makefile:1.2 pkgsrc/databases/R-dbplyr/Makefile:1.3
--- pkgsrc/databases/R-dbplyr/Makefile:1.2      Sun Jan  1 04:41:11 2023
+++ pkgsrc/databases/R-dbplyr/Makefile  Sun Feb 19 12:15:54 2023
@@ -1,7 +1,7 @@
-# $NetBSD: Makefile,v 1.2 2023/01/01 04:41:11 mef Exp $
+# $NetBSD: Makefile,v 1.3 2023/02/19 12:15:54 mef Exp $
 
 R_PKGNAME=     dbplyr
-R_PKGVER=      2.2.1
+R_PKGVER=      2.3.0
 
 MAINTAINER=    pkgsrc-users%NetBSD.org@localhost
 COMMENT=       Database backend for dplyr
Index: pkgsrc/databases/R-dbplyr/distinfo
diff -u pkgsrc/databases/R-dbplyr/distinfo:1.2 pkgsrc/databases/R-dbplyr/distinfo:1.3
--- pkgsrc/databases/R-dbplyr/distinfo:1.2      Sun Jan  1 04:41:11 2023
+++ pkgsrc/databases/R-dbplyr/distinfo  Sun Feb 19 12:15:54 2023
@@ -1,5 +1,5 @@
-$NetBSD: distinfo,v 1.2 2023/01/01 04:41:11 mef Exp $
+$NetBSD: distinfo,v 1.3 2023/02/19 12:15:54 mef Exp $
 
-BLAKE2s (R/dbplyr_2.2.1.tar.gz) = 67b5a2d65cafa0f895e322821d6be9b6ad6390827f52b407ee01cf18f5cb5fb7
-SHA512 (R/dbplyr_2.2.1.tar.gz) = 68953a399aca4d23dc58071293095e42efff0eb921dbdf5c67debc692bbc9d960df681ac7b8429780ee047e2330f8337a7e49d49722b2d3bdbad30ad38a753b9
-Size (R/dbplyr_2.2.1.tar.gz) = 670569 bytes
+BLAKE2s (R/dbplyr_2.3.0.tar.gz) = 930f6f826f4c98bd5c07d23df140cbcae3a50c42ce50e129ee18b6956b18f12d
+SHA512 (R/dbplyr_2.3.0.tar.gz) = 54f703148a461327c632c21056e02eb97b3d53a551426533c000a2e918815879b5f0d2bfde51f586bbe4132e399bbf0091d92afc630622f37b26c08977899a4c
+Size (R/dbplyr_2.3.0.tar.gz) = 704259 bytes