insert_into_crumb_table: Insert into Breadcrumb Database Table

In RoeLabWustl/roelabr: A collection of functions for the Drives Lab at Washington University

Insert into Breadcrumb Database Table

Description

Insert into Breadcrumb Database Table

Usage

insert_into_crumb_table(con, crumb_table, monthly_crumb_files)

Arguments

con	a DBIConnection object, as returned by dbConnect().
crumb_table	name of the database table for insertion
monthly_crumb_files	names of the monthly breadcrumb files

Value

number of records affected

Examples

## Not run: 
ris_storage_path("Reports") %>%
  collate_daily_crumb_metadata() %>%
  write_monthly_crumbs_for_year(2015) -> monthly_crumb_files

con <- DBI::dbConnect(
  RMariaDB::MariaDB(),
  default.file = normalizePath("~./.my.cnf"),
  group = "spark.myftp.org"
)

create_crumb_table(
  con, 2015
) -> crumb_table

insert_into_crumb_table(
  con, crumb_table, monthly_crumb_files
)

DBI::dbDisconnect(con)

## End(Not run)

RoeLabWustl/roelabr documentation built on Aug. 27, 2022, 9:57 a.m.