rero-ils-tools

RERO ILS misc tools for data manipulation.

Usage

For local machines

1. Clone the repository.
2. Set the environment variables:

export PYTHONPATH=~/rero-ils-tools
export PATH=${PATH}:${PYTHONPATH}/scripts/

For PODs

export PYTHONPATH=/network/nfs/data_ils/ils/rero-ils-tools
export PATH=${PATH}:${PYTHONPATH}/scripts/

Examples

poetry run tools.py tools update set_circulation_category --help
poetry run tools.py tools update items --help
poetry run tools.py tools replace items --help

To extract items based on query.txt search and using the given model

poetry run tools.py tools search  query -t item  query.txt -o items.json -v -m model.json
query.txt: organisation.pid:1 AND document.pid:4 AND item_type.pid:4
model.json: {
    "include": ["pid", "location"],
    "exclude": ["temporary_item_type"],
    "item_type": {
        "$ref": "https://bib.rero.ch/api/item_types/6"
      }
}

To list duplicate emails in database

poetry run tools.py tools patrons duplicate_emails
poetry run tools.py tools patrons fix_patron_emails

To manage desherbage for a library

poetry run tools.py tools desherbage vs  <item_barcodes_file> -l <library_pid> -c <library_code> -s <output_directory>