Support for canonical abbreviations (db)

This release adds code updates and an alembic migration to add a boolean canonical column to the abbrevs table.

Maintenance release: bugfixes to v1.2.8 release

• Adjusts some logging messages
• Fixes an issue with bibstem/master deletion for records having refsource data

Adds delete bibstem to run.py command line options

If the user wants to delete a bibstem, you not only have to delete the bibstem from master, but also delete records from auxiliary tables (names, idents, etc) with the same masterid.

This code adds the -ds STEM option to run.py so that the user can delete a bibstem via the command line in the journalsdb container.

• It will take all records from auxiliary tables (like idents, abbrevs, whatever), write them to table_hist, and then delete them
• It will then copy the master record for STEM to master_hist, and then delete it from master

You will get error messages if:

• the bibstem you type on the command line is not an EXACT lexical match to a bibstem in journals.master, including capitalization; you will be given a suggested bibstem if there's a case-insensitive match, but it won't delete it.
• you have ANY tables checked out (master, idents, etc). You MUST check in all tables before running this command.

Modifies export to bibstems.dat

This update corrects the logic when exporting bibstems.dat; when the master data are exported to bibstems.dat, refereed conference proceedings will now be marked with pubtype R rather than C.

Export ISSN-identifier file for ADSIngestEnrichment/ADSManualParser

This update expands the ISSN exports to create a file with all ISSN identifiers from the idents table, not just the print ISSNs exported to issn2journal and journal2issn for classic backoffice's use. The issn_identifiers file is read by ADSManualParser. When manual parser attempts to create a bibcode from a parsed record; it obtains the bibstem for the bibcode by looking up the issn in a dict generated by loading this file.

The export task has also been updated so that updates to either master or idents will trigger an export; previously only master updates did this (to update bibstems.dat).

Export mapping of bibstem to publisher for ADSExports

Adds code to the --dump-classic/-dc option to export a formatted output file with:

• first row: integer, number of lines in the file
• second and subsequent rows: two-column, tab-separated lines with bibstem in column 1 and publisher abbreviation in column 2.

The code uses a multitable join to extract bibstem from master, publisher abbreviation from publisher, and the mapping itself from tablehistory joined via master.masterid and publisher.publisherid

Add publisher info to issn return body

When the user makes a query to the /issn endpoint, the return body will now include the publisher key. If the journals database has an entry for the publisher, its abbreviation will be returned (e.g. IOP).

API fix for 500 errors in Holdings queries

Merge pull request #55 from seasidesparrow/api_fix_2023May11

fix: catch missing esource fields in Holdings search

ISSN search endpoint added to journals API

Adds the ability to search the journals database on a user-supplied ISSN to return the ADS bibstem and Journal name if available.

Finishes integration of completeness data

• moves completeness_details from TitleHistory to Master
• adds task to tasks.py to load json report exported from ADSCompStat
• minor code cleanup for consistency & readability