DBI/_pkgdown.yml at main · kabijaoude/DBI · GitHub

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
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
url: https://dbi.r-dbi.org

template:
  params:
    bootswatch: flatly # https://bootswatch.com/flatly/

home:
  links:
  - text: Report a security vulnerability
    href: https://dbi.r-dbi.org/security.html
  - text: DBI project website
    href: https://r-dbi.org

reference:
- title: Connecting and disconnecting
  desc: Connecting to and disconnecting from databases.
  contents:
  - '`dbConnect`'
  - '`dbDisconnect`'
  - '`dbCanConnect`'
  - '`dbGetInfo`'
  - '`dbIsValid`'
  - '`dbIsReadOnly`'
  - '`DBIConnector-class`'
  - '`dbGetConnectArgs`'

- title: Tables
  desc: Reading and writing entire tables.
  contents:
  - '`dbReadTable`'
  - '`dbWriteTable`'
  - '`dbCreateTable`'
  - '`dbAppendTable`'
  - '`dbRemoveTable`'
  - '`dbListTables`'
  - '`dbListFields`'
  - '`dbExistsTable`'
  - '`dbListObjects`'
  - '`rownames`'

- title: Queries and statements
  desc: Sending queries and executing statements.
  contents:
  - '`dbGetQuery`'
  - '`dbExecute`'

- title: Results
  desc: More control for sending queries and executing statements.
  contents:
  - '`dbSendQuery`'
  - '`dbSendStatement`'
  - '`dbBind`'
  - '`dbFetch`'
  - '`dbGetRowCount`'
  - '`dbGetRowsAffected`'
  - '`dbGetStatement`'
  - '`dbHasCompleted`'
  - '`dbColumnInfo`'
  - '`dbClearResult`'

- title: Transactions
  desc: Ensuring multiple statements are executed together, or not at all.
  contents:
  - '`transactions`'
  - '`dbWithTransaction`'

- title: SQL
  desc: Tools for creating and parsing SQL queries.
  contents:
  - '`SQL`'
  - '`dbDataType`'
  - '`dbQuoteIdentifier`'
  - '`dbQuoteLiteral`'
  - '`dbQuoteString`'
  - '`sqlCreateTable`'
  - '`sqlAppendTable`'
  - '`sqlData`'
  - '`dbUnquoteIdentifier`'
  - '`sqlInterpolate`'

- title: Classes
  desc: S4 classes defined by DBI.
  contents:
  - '`DBI-package`'
  - '`DBIObject-class`'
  - '`DBIDriver-class`'
  - '`DBIConnection-class`'
  - '`DBIResult-class`'
  - '`DBIConnector-class`'
  - '`Id-class`'

articles:
- title: Tutorials
  contents:
  - '`DBI`'
  - '`DBI-advanced`'
  - '`DBI-arrow`'
  - '`backend`'
- title: Specification
  contents:
  - '`spec`'
- title: Historic
  contents:
  - '`DBI-proposal`'
  - '`DBI-history`'
  - '`DBI-1`'

development:
  mode: auto

authors:
  Kirill Müller:
    href: https://krlmlr.info

news:
  cran_dates: false