Read contents from local database

Usage

cas_read_db_contents_id(db_connection = NULL, db_folder = NULL, ...)

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).
...: Passed to cas_get_db_file().

Value

A data frame with three columns and data stored in the contents_id

table of the local database. The data frame has zero rows if the database does not exist or no data was previously stored there.

Examples

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


urls_df <- cas_build_urls(
  url = "https://www.example.com/news/",
  start_page = 1,
  end_page = 10
)

cas_write_db_contents(urls = urls_df)
#> Error in cas_write_db_contents(urls = urls_df): could not find function "cas_write_db_contents"

cas_read_db_contents_id()
#> ℹ Folder /tmp/RtmpKZFKM9/R/castarter_data for storing project and website files
#>   created.
#> # A tibble: 0 × 5
#> # ℹ 5 variables: id <dbl>, url <chr>, link_text <chr>, source_index_id <dbl>,
#> #   source_index_batch <dbl>