updateLastUpdatedTable: Inserts Target and current date into MySQL database

Description Usage Arguments Details Value See Also

View source: R/updateLastUpdatedTable.R

Description

'updateLastUpdatedTable' inserts targetIDs and the current date into the specified MySQL table

Usage

1
updateLastUpdatedTable(conMysql, targetIDs, tableName = "EdgeList_date")

Arguments

conMysql

a MySQL connection

targetIDs

the target IDs to add to the table

tableName

string with the name of the table used to store update dates, defaulting to 'EdgeList_date'#'

Details

The table will be created if it does not exist, with columns 'Target' and 'lastUpdated' Targets form 'targetIDs' that are in the table will be removed.

Value

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.

See Also

generateEdgeList for obtaining edgeList citation results


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