Skip to contents

Removes from the local database all identifiers included in the ignore list

Usage

cas_reset_db_ignore_id(db_connection = NULL, db_folder = NULL, ask = TRUE, ...)

Arguments

db_connection

Defaults to NULL. If NULL, uses local SQLite database. If given, must be a connection object or a list with relevant connection settings (see example).

ask

Logical, defaults to TRUE. If set to FALSE, the relevant table will be deleted without asking for confirmation from the user.

...

Passed to cas_get_db_file().

Examples

cas_set_options(
  base_folder = fs::path(tempdir(), "R", "cas_reset_db_ignore_id"),
  db_folder = fs::path(tempdir(), "R", "cas_reset_db_ignore_id"),
  project = "example_project",
  website = "example_website"
)
cas_enable_db()


cas_write_db_ignore_id(id = sample(x = 1:100, size = 10))
#>  Folder /tmp/Rtmp1QODEK/R/cas_reset_db_ignore_id for storing project and
#>   website files created.
#>  10 identifiers added to ignore table.

cas_read_db_ignore_id()
#> # A tibble: 10 × 1
#>       id
#>    <dbl>
#>  1     6
#>  2    22
#>  3    19
#>  4     2
#>  5    64
#>  6    40
#>  7    65
#>  8    28
#>  9    71
#> 10    12

cas_reset_db_ignore_id(ask = FALSE)
#>  The table ‘contents_ignore’ has been removed from the local database

cas_read_db_ignore_id()
#> # A tibble: 0 × 1
#> # ℹ 1 variable: id <dbl>