get_pmids_by_date: Query an pmids date from DB

In gdancik/pmc2nc: PubMed Central Citation Network Construction

Description

'get_pmids_by_date' query edgelist_date table for PMIDs that match.

Usage

get_pmids_by_date(conMysql, pmids, lastUpdate,
  tableName = "Edgelist_date")

Arguments

conMysql	a MySQL connection
pmids	a vector of pmids to look up
lastUpdate	string of the date used for comparison, in YYYY-MM-DD format
tableName	string with the name of the table that stores the target pmids and dates.

Details

'get_pmids_by_date' queries the edgelist_date table for target PMIDs, that optionally have been updated since 'lastUpdate'. The user can specify the 'tableName', but this table must have column names 'Target' and 'lastUpdated'. An error will be generated if 'tableName' does not exist.

Value

a data.frame with one column for Target and one column for lastUpdated

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