Error(s) in re-building vignettes:
  ...
--- re-building ‘DBI_objects_and_functions.Rmd’ using rmarkdown
# *DBI* objects

*rocker* class encapsulates the *DBI* objects driver, connection and result.
If required, these objects can be directly used with *DBI* functions.
__However, it is recommended to use this option with care!__ Direct usage of *DBI* functions, may disrupt proper function of *rocker* class. Many *DBI* functions are implemented in *rocker* class. Whenever possible, use the *rocker* class functions.

Prepare object


``` r
db <- rocker::newDB() # New database handling object
#> dctr | New object
```

``` r
db$.drv # Empty driver
#> NULL
```

``` r
db$.con # Empty connection
#> NULL
```

``` r
db$.res # Empty result
#> NULL
```

## DBIDriver-class


































Quitting from lines 19-21 [unnamed-chunk-6] (./../man/fragments/DBI.Rmd)

Quitting from lines 21-21 [unnamed-chunk-2] (DBI_objects_and_functions.Rmd)
Error: processing vignette 'DBI_objects_and_functions.Rmd' failed with diagnostics:
Package RSQLite not installed
--- failed re-building ‘DBI_objects_and_functions.Rmd’

--- re-building ‘Database_connections.Rmd’ using rmarkdown
# Database connection

There are different ways to open a connection and to get data.

Prepare database with a table











Quitting from lines 8-13 [unnamed-chunk-5] (./../man/fragments/Connection.Rmd)

Quitting from lines 21-21 [unnamed-chunk-2] (Database_connections.Rmd)
Error: processing vignette 'Database_connections.Rmd' failed with diagnostics:
Package RSQLite not installed
--- failed re-building ‘Database_connections.Rmd’

--- re-building ‘Installation_and_Object.Rmd’ using rmarkdown
# New *rocker* class object

Create new *rocker* database handling object

Option 1


``` r
db <- rocker::newDB() # New database handling object
#> dctr | New object
```

Option 2


``` r
db <- rocker::rocker$new() # New database handling object
#> dctr | New object
```

__Terminal output__

Controlling terminal output



































Quitting from lines 22-25 [unnamed-chunk-14] (./../man/fragments/Object.Rmd)

Quitting from lines 24-24 [unnamed-chunk-3] (Installation_and_Object.Rmd)
Error: processing vignette 'Installation_and_Object.Rmd' failed with diagnostics:
Package RPostgres not installed
--- failed re-building ‘Installation_and_Object.Rmd’

--- re-building ‘Packages_and_databases.Rmd’ using rmarkdown
# Additional packages and database types

The listed packages are required for some functions of *rocker*.

## *RSQLite* package

[*RSQLite*](https://github.com/r-dbi/RSQLite) package for handling of SQLite database connections.
It is required for the setupSQLite() function of *rocker* class.


``` r
install.packages("RSQLite")
```

__Setup database__

Option 1



















Quitting from lines 19-24 [unnamed-chunk-6] (./../man/fragments/Packages_Databases.Rmd)

Quitting from lines 21-21 [unnamed-chunk-2] (Packages_and_databases.Rmd)
Error: processing vignette 'Packages_and_databases.Rmd' failed with diagnostics:
Package RSQLite not installed
--- failed re-building ‘Packages_and_databases.Rmd’

--- re-building ‘Password_storage.Rmd’ using rmarkdown
--- finished re-building ‘Password_storage.Rmd’

--- re-building ‘S3_and_R6_functions.Rmd’ using rmarkdown
# Usage of S3 and R6 functions

Although *rocker* is a *R6* class, functions can be also accesses in classical S3 way.

__S3 example__





Quitting from lines 8-18 [unnamed-chunk-5] (./../man/fragments/S3.Rmd)

Quitting from lines 21-21 [unnamed-chunk-2] (S3_and_R6_functions.Rmd)
Error: processing vignette 'S3_and_R6_functions.Rmd' failed with diagnostics:
there is no package called 'RSQLite'
--- failed re-building ‘S3_and_R6_functions.Rmd’

--- re-building ‘Transactions.Rmd’ using rmarkdown
# Transaction

Setup database and a table with 32 rows.









Quitting from lines 6-12 [unnamed-chunk-5] (./../man/fragments/Transaction.Rmd)

Quitting from lines 21-21 [unnamed-chunk-2] (Transactions.Rmd)
Error: processing vignette 'Transactions.Rmd' failed with diagnostics:
Package RSQLite not installed
--- failed re-building ‘Transactions.Rmd’

SUMMARY: processing the following files failed:
  ‘DBI_objects_and_functions.Rmd’ ‘Database_connections.Rmd’
  ‘Installation_and_Object.Rmd’ ‘Packages_and_databases.Rmd’
  ‘S3_and_R6_functions.Rmd’ ‘Transactions.Rmd’

Error: Vignette re-building failed.
Execution halted