create_date_table: Create edge list date table if not found.

In gdancik/pmc2nc: PubMed Central Citation Network Construction

Description

'create_date_table' create edge list date table in MySQL

Usage

create_date_table(conMysql, tableName = "EdgeList_date",
  targetName = "Target", dateName = "DatePMID")

Arguments

conMysql	an RMariaDB connection
tableName	string with the name of the table used to store the last update dates for pmids
targetName	string with the name of the column used to store the Target PMID of the edge list
dateName	string with the name of the column used to store the date of the update

Details

Default values for this table are: tableName = "EdgeList_date", targetName = "Target", dateName = "DatePMID" MySQL statment: CREATE TABLE Edgelist_date ( Target INT, DatePMID date, INDEX index_target(Target));

Value

create_date_table() always returns a scalar numeric that specifies the number of rows affected by the statement. An error is raised when issuing a statement over a closed or invalid connection, if the syntax of the statement is invalid

gdancik/pmc2nc documentation built on May 5, 2019, 7:09 a.m.