Last updated on 2024-06-13 05:59:48 CEST.
| Package | ERROR | OK |
|---|---|---|
| rocker | 1 | 12 |
Current CRAN status: ERROR: 1, OK: 12
Version: 0.3.1
Check: package dependencies
Result: NOTE
Packages suggested but not available for checking:
'RMariaDB', 'testthat', 'RPostgres', 'RSQLite'
Flavor: r-devel-linux-x86_64-debian-gcc
Version: 0.3.1
Check: examples
Result: ERROR
Running examples in ‘rocker-Ex.R’ failed
The error most likely occurred in:
> base::assign(".ptime", proc.time(), pos = "CheckExEnv")
> ### Name: appendTable
> ### Title: Append data to table.
> ### Aliases: appendTable
>
> ### ** Examples
>
> db <- rocker::newDB()
dctr | New object
> rocker::setupSQLite(db)
Error: Package RSQLite not installed
Execution halted
Flavor: r-devel-linux-x86_64-debian-gcc
Version: 0.3.1
Check: tests
Result: ERROR
Running ‘testthat.R’ [0s/1s]
Running the tests in ‘tests/testthat.R’ failed.
Complete output:
> library(testthat)
Error in library(testthat) : there is no package called 'testthat'
Execution halted
Flavor: r-devel-linux-x86_64-debian-gcc
Version: 0.3.1
Check: re-building of vignette outputs
Result: ERROR
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
Flavor: r-devel-linux-x86_64-debian-gcc