Lecciones Prácticas

Posts Tagged ‘database’

I’ve been asked to export some stats related to the number of downloads of each record belonging to collection PhD’s of our cds invenio repository. This can be done in a pretty simple way: 1. MARC format stores the collection id in 980 fields. My PhD collection identifier is TESIS. So go to your bib98x [...]

MySQL rename database command was added in MySQL 5.1.7 but was found to be dangerous and was removed in MySQL 5.1.23. It was intended to enable upgrading pre-5.1 databases to use the encoding implemented in 5.1 for mapping database names to database directory names (see Section 8.2.3, “Mapping of Identifiers to File Names”). However, use [...]

Which is the quickest way to know the tag’s value of a record using CDS Invenio functions? Imagine you want to know the value for the 8564_u tag of record which sysno=4403 Easy! First, run python. Then: >>> from invenio.dbquery import run_sql >>> from invenio.websubmit_functions.Create_Modify_Interface_TAZ import Create_Modify_Interface_getfieldval_fromDBrec >>> value = Create_Modify_Interface_getfieldval_fromDBrec(’8564_u’,4403) >>> print value http://aneto.unizar.es/TAZ/CPS/2010/4403/TAZ-2010-077.pdf [...]