cas_read_from_db: Reads data from local database

In giocomai/castarter: Content Analysis Starter Toolkit

Reads data from local database

Description

Reads data from local database

Usage

cas_read_from_db(
  table,
  db_folder = NULL,
  db_connection = NULL,
  disconnect_db = FALSE,
  ...
)

Arguments

table	Name of the table. See readme for details.
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).
disconnect_db	Defaults to TRUE. If FALSE, leaves the connection to database open.
...	Passed to cas_get_db_file().

See Also

Other database functions: cas_check_db_folder(), cas_check_use_db(), cas_connect_to_db(), cas_create_db_folder(), cas_disable_db(), cas_disconnect_from_db(), cas_enable_db(), cas_get_db_settings(), cas_set_db(), cas_set_db_folder(), cas_write_to_db()

Examples

cas_set_options(
  base_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_to_db(
  df = urls_df,
  table = "index_id"
)

cas_read_from_db(table = "index_id")

giocomai/castarter documentation built on April 23, 2024, 11:14 p.m.