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/RtmpKZFKM9/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    92
#>  2    77
#>  3    22
#>  4    20
#>  5    69
#>  6    71
#>  7    23
#>  8    74
#>  9    79
#> 10    35

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>