File: build-sql.md

package info (click to toggle)
r-cran-dbplyr 2.5.0%2Bdfsg-1
  • links: PTS, VCS
  • area: main
  • in suites: forky, sid, trixie
  • size: 2,644 kB
  • sloc: sh: 13; makefile: 2
file content (39 lines) | stat: -rw-r--r-- 1,026 bytes parent folder | download
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
# build_sql() requires connection

    Code
      build_sql("SELECT * FROM ", x)
    Condition
      Error in `build_sql()`:
      ! `con` must not be NULL.

# glue_sql() checks size

    Code
      glue_sql2("{.col x}", .con = con)
    Condition
      Error in `.transformer()`:
      ! `value` must have size 1, not 2.
    Code
      glue_sql2("{.col character()}", .con = con)
    Condition
      Error in `.transformer()`:
      ! `value` must have size 1, not 0.

# glue_sql() can collapse

    Code
      glue_sql2("{.tbl x*}", .con = con)
    Condition
      Error in `glue_check_collapse()`:
      ! Collapsing is only allowed for "col" and "val", not for "tbl".
    Code
      glue_sql2("{.name x*}", .con = con)
    Condition
      Error in `glue_check_collapse()`:
      ! Collapsing is only allowed for "col" and "val", not for "name".
    Code
      glue_sql2("{.from x*}", .con = con)
    Condition
      Error in `glue_check_collapse()`:
      ! Collapsing is only allowed for "col" and "val", not for "from".