insert_to_pelagic: Insert data from csv files into the database

Description Usage Arguments

View source: R/insert_to_pelagic.R

Description

Insert data from csv files into the database

Usage

1
2
3
4
5
  insert_to_pelagic(ref, material, extension = "csv",
    base_folder = "/home/pelagicDB/", data_folder = "data",
    sql_folder = "sql",
    inserted_data_folder = "data/datainDB",
    log_file = "insertToPelagicLog.txt")

Arguments

ref

The reference to insert (refcode). Must match file name.

Type

of data to insert. E.g. "Master" or "tab1". Must match file name.

File

extension for the data file. Defaults to csv.

base_folder

Absolute path in which all files are located. Could be left as "" if you want to use relative paths.

data_folder

Folder with the .csv files

sql_folder

Folder to store SQL commands

inserted_data_folder

Folder to move used .csv files to

log_file

Log file to store output messages


seananderson/sharkbase documentation built on May 29, 2019, 4:25 p.m.