tests/testthat/_snaps/verb-count.md

In dbplyr: A 'dplyr' Back End for Databases

generates expected SQL for common situations

Code
  db %>% count(g)
Output
  <SQL>
  SELECT `g`, COUNT(*) AS `n`
  FROM `df`
  GROUP BY `g`

Code
  db %>% count(g, wt = x)
Output
  <SQL>
  SELECT `g`, SUM(`x`) AS `n`
  FROM `df`
  GROUP BY `g`

Code
  db %>% count(g, sort = TRUE)
Output
  <SQL>
  SELECT `g`, COUNT(*) AS `n`
  FROM `df`
  GROUP BY `g`
  ORDER BY `n` DESC

Code
  db %>% add_count(g, sort = TRUE)
Output
  <SQL>
  SELECT `df`.*, COUNT(*) OVER (PARTITION BY `g`) AS `n`
  FROM `df`
  ORDER BY `n` DESC

Code
  db %>% group_by(g) %>% add_count()
Output
  <SQL>
  SELECT `df`.*, COUNT(*) OVER (PARTITION BY `g`) AS `n`
  FROM `df`

.drop is not supported

Code
  lazy_frame(g = 1) %>% add_count(.drop = TRUE)
Condition
  Error in `add_count()`:
  ! Argument `.drop` isn't supported on database backends.

dbplyr documentation built on Oct. 26, 2023, 9:06 a.m.