write_db: write_db

View source: R/sqlite_write.R

write_dbR Documentation

write_db

Description

write_db

Usage

write_db(
  con,
  d,
  time,
  table_data = "runoff_hourly",
  table_info = "timeinfo",
  log = TRUE,
  check_time = TRUE,
  overwrite = FALSE,
  append = TRUE,
  mink = 10
)

write_db_char(con, file, overwrite = FALSE, append = TRUE, mink = 10)

write_db_batch(dbname = "chinawater.db", files, overwrite = TRUE)

read_db(dbname, tables = NULL)

Arguments

con

SQLite connection returned by dbConnect(), or the file path of SQLite.

d

data.frame or data.table object.

time

POSIXct or time character, e.g. "1998-01-01 01:00:00"

mink

minimum records

Examples

# write_db_batch("chinawater.db", files)

rpkgs/curlR documentation built on Jan. 30, 2023, 7:26 p.m.