pkgsrc-Changes-HG archive
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index][Old Index]
[pkgsrc/trunk]: pkgsrc/databases/R-dbplyr (databases/R-dbplyr) Updated 2.1.1 ...
details: https://anonhg.NetBSD.org/pkgsrc/rev/efb9a1e26923
branches: trunk
changeset: 390911:efb9a1e26923
user: mef <mef%pkgsrc.org@localhost>
date: Sun Jan 01 04:41:11 2023 +0000
description:
(databases/R-dbplyr) Updated 2.1.1 to 2.2.1
# dbplyr 2.2.1
* Querying Oracle databases works again. Unfortunately, the fix requires every
column to be explicitly selected again (@mgirlich, #908).
* `semi_join()` and `anti_join()` work again for Spark (@mgirlich, #915).
* `str_c()` is now translated to `||` in Oracle (@mgirlich, #921).
* `sd()`, `var()`, `cor()` and `cov()` now give clear error messages on
databases that don't support them.
* `any()` and `all()` gain default translations for all backends.
# dbplyr 2.2.0
## New features
* SQL formatting has been considerably improved with new wrapping and indenting.
`show_query()` creates more readable queries by printing the keywords in blue
(@mgirlich, #644). When possible dbplyr now uses `SELECT *` instead of
explicitly selecting every column (@mgirlich).
* Added support for `rows_insert()`, `rows_append()`, `rows_update()`,
`rows_patch()`, `rows_upsert()`, and `rows_delete()` (@mgirlich, #736).
* Added `copy_inline()` as a `copy_to()` equivalent that does not need write
access (@mgirlich, #628).
* `remote_query()`, `show_query()`, `compute()` and `collect()` have an
experimental `cte` argument. If `TRUE` the SQL query will use common table
expressions instead of nested queries (@mgirlich, #638).
* New `in_catalog()`, which works like `in_schema()`, but allows creation of
table identifiers consisting of three components: catalog, schema, name
(#806, @krlmlr).
## Improvements to SQL generation
* When possible, dbplyr now uses `SELECT *` instead of explicitly selecting
every column (@mgirlich).
* New translation for `cut()` (@mgirlich, #697).
* Improved translations for specific backends:
* `as.Date()` for Oracle (@mgirlich, #661).
* `case_when()` with a final clause of the form `TRUE ~ ...` uses `ELSE ...`
for SQLite (@mgirlich, #754).
* `day()`, `week()`, `isoweek()`, and `isoyear()` for Postgres (@mgirlich, #675).
* `explain()` for ROracle (@mgirlich).
* `fill()` for SQL Server (#651, @mgirlich) and RPostgreSQL (@mgirlich).
* `quantile()` for SQL Server (@mgirlich, #620).
* `str_flatten()` for Redshift (@hdplsa, #804)
* `slice_sample()` for MySQL/MariaDB and SQL Server (@mgirlich, #617).
* `union()` for Hive (@mgirlich, #663).
* The backend function `dbplyr_fill0()` (used for databases that lack
`IGNORE NULLS` support) now respects database specific translations
(@rsund, #753).
* Calls of the form `stringr::foo()` or `lubridate::foo()` are now evaluated in
the database, rather than locally (#197).
* Unary plus (e.g. `db %>% filter(x == +1)`) now works (@mgirlich, #674).
* `is.na()`, `ifelse()`, `if_else()`, `case_when()`, and `if()`
generate slightly more compact SQL (@mgirlich, #738).
* `if_else()` now supports the `missing` argument (@mgirlich, #641).
* `n()` now respects the window frame (@mgirlich, #700).
* `quantile()` no longer errors when using the `na.rm` argument (@mgirlich, #600).
* `remote_name()` now returns a name in more cases where it makes sense
(@mgirlich, #850).
* The partial evaluation code is now more aligned with `dtplyr`. This makes it
easier to transfer bug fixes and new features from one package to the other.
In this process the second argument of `partial_eval()` was changed to a lazy
frame instead of a character vector of variables (@mgirlich, #766).
Partially evaluated expressions with infix operations are now correctly
translated. For example `translate_sql(!!expr(2 - 1) * x)` now works
(@mgirlich, #634).
## Minor improvements and bug fixes
* New `pillar::tbl_format_header()` method for lazy tables: Printing a lazy
table where all rows are displayed also shows the exact number of rows in the
header. The threshold is controlled by `getOption("pillar.print_min")`,
with a default of 10 (#796, @krlmlr).
* The 1st edition extension mechanism is formally deprecated (#507).
* `across()`, `if_any()` and `if_all()` now defaults to `.cols = everything()`
(@mgirlich, #760). If `.fns` is not provided `if_any()` and `if_all()` work
like a parallel version of `any()`/`any()` (@mgirlich, #734).
* `across()`, `if_any()`, and `if_all()` can now translate evaluated lists
and functions (@mgirlich, #796), and accept the name of a list of functions
(@mgirlich, #817).
* Multiple `across()` calls in `mutate()` and `transmute()` can now access
freshly created variables (@mgirlich, #802).
* `add_count()` now doesn't change the groups of the input (@mgirlich, #614).
* `compute()` can now handle when `name` is named by unnaming it first
(@mgirlich, #623), and now works when `temporary = TRUE` for Oracle
(@mgirlich, #621).
* `distinct()` now supports `.keep_all = TRUE` (@mgirlich, #756).
* `expand()` now works in DuckDB (@mgirlich, #712).
* `explain()` passes `...` to methods (@mgirlich, #783), and
works for Redshift (@mgirlich, #740).
* `filter()` throws an error if you supply a named argument (@mgirlich, #764).
* Joins disambiguates columns that only differ in case (@mgirlich, #702).
New arguments `x_as` and `y_as` allow you to control the table alias
used in SQL query (@mgirlich, #637). Joins with `na_matches = "na"` now work
for DuckDB (@mgirlich, #704).
* `mutate()` and `transmute()` use named windows if a window definition is
used at least twice and the backend supports named windows (@mgirlich, #624).
* `mutate()` now supports the arguments `.keep`, `.before`, and `.after`
(@mgirlich, #802).
* `na.rm = FALSE` only warns once every 8 hours across all functions (#899).
* `nesting()` now supports the `.name_repair` argument (@mgirlich, #654).
* `pivot_longer()` can now pivot a column named `name` (@mgirlich, #692),
can repair names (@mgirlich, #694), and can work with multiple `names_from`
columns (@mgirlich, #693).
* `pivot_wider(values_fn = )` and `pivot_longer(values_transform = )`
can now be formulas (@mgirlich, #745).
* `pivot_wider()` now supports the arguments `names_vary`, `names_expand`, and
`unused_fn` (@mgirlich, #774).
* `remote_name()` now returns a name in more cases where it makes sense
(@mgirlich, #850).
* `sql_random()` is now exported.
* `ungroup()` removes variables in `...` from grouping (@mgirlich, #689).
* `transmute()` now keeps grouping variables (@mgirlich, #802).
diffstat:
databases/R-dbplyr/Makefile | 15 +++++++++++++--
databases/R-dbplyr/distinfo | 8 ++++----
2 files changed, 17 insertions(+), 6 deletions(-)
diffs (45 lines):
diff -r a4b219dd9c29 -r efb9a1e26923 databases/R-dbplyr/Makefile
--- a/databases/R-dbplyr/Makefile Sun Jan 01 03:53:20 2023 +0000
+++ b/databases/R-dbplyr/Makefile Sun Jan 01 04:41:11 2023 +0000
@@ -1,7 +1,7 @@
-# $NetBSD: Makefile,v 1.1 2021/12/17 10:07:56 wiz Exp $
+# $NetBSD: Makefile,v 1.2 2023/01/01 04:41:11 mef Exp $
R_PKGNAME= dbplyr
-R_PKGVER= 2.1.1
+R_PKGVER= 2.2.1
MAINTAINER= pkgsrc-users%NetBSD.org@localhost
COMMENT= Database backend for dplyr
@@ -22,7 +22,18 @@
DEPENDS+= R-tidyselect-[0-9]*:../../devel/R-tidyselect
DEPENDS+= R-vctrs-[0-9]*:../../math/R-vctrs
DEPENDS+= R-withr-[0-9]*:../../devel/R-withr
+
+# Packages suggested but not available for checking:
+# 'Lahman', 'nycflights13', 'odbc', 'RMariaDB', 'RPostgres',
+# 'RPostgreSQL'
+TEST_DEPENDS+= R-bit64-[0-9]*:../../devel/R-bit64
+TEST_DEPENDS+= R-covr-[0-9]*:../../devel/R-covr
TEST_DEPENDS+= R-knitr-[0-9]*:../../print/R-knitr
+TEST_DEPENDS+= R-rmarkdown-[0-9]*:../../textproc/R-rmarkdown
+TEST_DEPENDS+= R-RSQLite-[0-9]*:../../databases/R-RSQLite
+TEST_DEPENDS+= R-testthat-[0-9]*:../../devel/R-testthat
+TEST_DEPENDS+= R-tidyr-[0-9]*:../../math/R-tidyr
+TEST_DEPENDS+= tex-texlive.infra-[0-9]*:../../print/tex-texlive.infra
USE_LANGUAGES= c c++
diff -r a4b219dd9c29 -r efb9a1e26923 databases/R-dbplyr/distinfo
--- a/databases/R-dbplyr/distinfo Sun Jan 01 03:53:20 2023 +0000
+++ b/databases/R-dbplyr/distinfo Sun Jan 01 04:41:11 2023 +0000
@@ -1,5 +1,5 @@
-$NetBSD: distinfo,v 1.1 2021/12/17 10:07:56 wiz Exp $
+$NetBSD: distinfo,v 1.2 2023/01/01 04:41:11 mef Exp $
-BLAKE2s (R/dbplyr_2.1.1.tar.gz) = 4f5f30d38d4da245a74d68cade9a9df55cedebe4bbffa0b95f145459c0f770aa
-SHA512 (R/dbplyr_2.1.1.tar.gz) = 857af5eaa2fce0cefcbfe772a6a259df4aa2eb1f14c231503d32f62cc25dd63713d60fd206da0700e3c27f0508a11c0f3efece1b15d0f3d471ea34a1b3771b7d
-Size (R/dbplyr_2.1.1.tar.gz) = 581845 bytes
+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
Home |
Main Index |
Thread Index |
Old Index