Menu

#298 Python3: Additional TEST_SQLparsing Tests - targeting CNX_PUBS_STAR functions

v1.0 (example)
open
None
5
2026-05-18
2026-05-18
Al von Ruff
No

1] Added unit tests to TEST_SQLparsing.py to complete coverage of testing functions that use CNX_PUBS_STAR. This adds:

  • SQLGetPubsByPublisherYear
  • SQLGetPubById
  • SQLGetPubSeriesPubs
  • SQLGetPubsNotInSeries
  • SQLFindPubsByCatalogId
  • SQLDuplicateImageURL

2] Added ISFDB_FullBackup checks to test_104_SQLWikiEditCount() and test_106_SQLwikiLinkExists()

3] test_025_SQLListAwardTypes and test_027_SQLGetAwardTypeByCode() both presumed that award codes rarely changed, and if a new one was added, it would be at the end of the returned list. This is not the case, causing false failures. Test were improved.

4] SQLparsing.py: SQLGetPubsNotInSeries() will crash if the sort_order is anything but 'ASC' or 'DESC'. Added a check to ensure that sort_order is one of those two options, otherwise it returns []

Discussion

Anonymous
Anonymous

Add attachments
Cancel





MongoDB Logo MongoDB