File: db-sql.md

package info (click to toggle)
r-cran-dbplyr 2.3.0%2Bdfsg-1
  • links: PTS, VCS
  • area: main
  • in suites: bookworm
  • size: 2,376 kB
  • sloc: sh: 13; makefile: 2
file content (53 lines) | stat: -rw-r--r-- 1,396 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
40
41
42
43
44
45
46
47
48
49
50
51
52
53
# 2nd edition uses sql methods

    Code
      expect_error(dbplyr_analyze(con), "db_method")
    Condition
      Warning:
      <Test> uses an old dbplyr interface
      i Please install a newer version of the package or contact the maintainer
      This warning is displayed once every 8 hours.

# handles DBI error

    Code
      (expect_error(db_analyze(con, "tbl")))
    Output
      <error/rlang_error>
      Error in `db_analyze()`:
      ! Can't analyze table "tbl".
      Caused by error:
      ! dummy DBI error
    Code
      (expect_error(db_create_index(con, "tbl", "col")))
    Output
      <error/rlang_error>
      Error in `db_create_index()`:
      ! Can't create index on "tbl".
      Caused by error:
      ! dummy DBI error
    Code
      (expect_error(db_explain(con, "invalid sql")))
    Output
      <error/rlang_error>
      Error in `db_explain()`:
      ! Can't explain query.
      Caused by error:
      ! dummy DBI error
    Code
      (expect_error(db_query_fields(con, "does not exist")))
    Output
      <error/rlang_error>
      Error in `db_query_fields()`:
      ! Can't query fields.
      Caused by error:
      ! dummy DBI error
    Code
      (expect_error(db_save_query(con, "invalid sql", "tbl")))
    Output
      <error/rlang_error>
      Error in `db_save_query()`:
      ! Can't save query to "tbl".
      Caused by error:
      ! dummy DBI error