insertEdgeList: Insert edge lists to mysql database.
In gdancik/pmc2nc: PubMed Central Citation Network Construction

Description Usage Arguments Details Value See Also Examples

'insertEdgeList' insert the edge list from the results of 'generateEdgeList'

1 2	insertEdgeList(conMysql, edgeList, tableName = "EdgeList", dateTableName = "EdgeList_date")

`conMysql`	a MySQL connection
`edgeList`	an edge list, as obtained from 'generateEdgeList'
`tableName`	string with the name of the table used to store the edge list, defaulting to 'EdgeList'
`dateTableName`	string with the name of the table used to store the dates for pmids, defaulting to 'EdgeList_date'

'edgeList' must come from the result of generateEdgeList. The edge list will be stored in the specified table, which must include column names 'Source' and 'Target'. The table will be created if it does not exist. Edges in the table with matching targets are first deleted. The assumption is that the 'edgeList' is a complete up-to-date edge list, and previous records are removed.

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.

generateEdgeList for obtaining edgeList citation results

## Not run: 
# generate an edge list for a single article and then insert the data to the table called "edgelist"
res1 <- get_pmc_cited_in(21876761)
e2 <- generateEdgeList(res1)
insertEdgeList(conMysql, e2)

## End(Not run)