API to export citations

[kaplun]

We need a way to compute citations on legacy and export them into labs.

For this reason we need in labs to have corresponding models for:

-- a table for logging changes in the citation dict
CREATE TABLE IF NOT EXISTS rnkCITATIONLOG (
  id int(11) unsigned NOT NULL auto_increment,
  citee int(10) unsigned NOT NULL,
  citer int(10) unsigned NOT NULL,
  `type` ENUM('added', 'removed'),
  action_date datetime NOT NULL,
  PRIMARY KEY (id),
  KEY citee (citee),
  KEY citer (citer)
) ENGINE=MyISAM;

CREATE TABLE IF NOT EXISTS rnkCITATIONDICT (
  citee int(10) unsigned NOT NULL,
  citer int(10) unsigned NOT NULL,
  last_updated datetime NOT NULL,
  PRIMARY KEY id (citee, citer),
  KEY reverse (citer, citee)
) ENGINE=MyISAM;

A simpler handler could be built on prod to export the citation log.

E.g.

file citation.py:

from json import dumps

from invenio.dbquery import run_sql

def index(req, action_date="1970-01-01 00:00:00"):
    req.set_header("content-type", "application/json")
    res = run_sql("SELECT id, citee, citer, type, action_date 
                   FROM rnkCITATIONLOG WHERE action_date>=%s 
                   ORDER BY action_date ASC LIMIT 100000", (action_date, ))
    comma = ""
    req.write("{")
    for row in res:
        req.write("%s%s" % (comma, dumps(row))
        req.flush()
        comma = ","
    req.write("}")

Then a simple query to:

http://inspirehep.net/citations.py?action_date=2015-01-01

would do the trick :-)

[kaplun]

@Panos512 here is the corresponding ticket for the prod side :-)

Note the description above the interface has been modified to use directly the id of the row.