Difference between revisions of "User:Alvonruff/ISFDB Tests"
Jump to navigation
Jump to search
(Created page with " These are formal tests using the unittest module. The tests are mostly concerned with: * Testing return types (int, string, float, etc) * Testing input arguments * Testing fo...") |
|||
Line 10: | Line 10: | ||
===Author-Related Methods=== | ===Author-Related Methods=== | ||
+ | These are mostly methods that perform a select on the authors table. | ||
{| border="1" cellpadding="2" style="border-collapse:collapse; text-align:left; width:30%;" | {| border="1" cellpadding="2" style="border-collapse:collapse; text-align:left; width:30%;" |
Revision as of 09:04, 12 May 2023
These are formal tests using the unittest module. The tests are mostly concerned with:
- Testing return types (int, string, float, etc)
- Testing input arguments
- Testing for NULL cases
Although non-destructive, these tests should probably not be run against the production server.
SQLparsing Tests
Author-Related Methods
These are mostly methods that perform a select on the authors table.
SQL Method | Status |
---|---|
SQLAuthorsBorn(date) | DONE |
SQLAuthorsDied(date) | DONE |
SQLFindAuthors(target, mode = 'contains') | DONE |
SQLFindReviewParent(title, author, referral_lang) | |
SQLgetActualFromPseudo(au_id) | DONE |
SQLGetAllAuthorsForPublisher(publisher_id, sort_by) | DONE |
SQLgetAuthorData(author) | DONE |
SQLGetAuthorDirectory() | DONE |
SQLgetBriefActualFromPseudo(au_id) | DONE |
SQLgetBriefPseudoFromActual(au_id) | DONE |
SQLGetCoverAuthorsForPubs(pub_list) | DONE |
SQLGetFrontPagePubs(front_page) | |
SQLInterviewAuthors(title_id) | |
SQLInterviewBriefAuthorRecords(title_id) | |
SQLIntervieweeAuthors(title_id, author_id = 0) | |
SQLloadAuthorData(author_id) | DONE |
SQLLoadTransAuthorNamesList(author_ids) | DONE |
SQLMultipleAuthors(name) | DONE |
SQLPubAuthors(pub_id) | |
SQLPubBriefAuthorRecords(pub_id) | |
SQLPubListBriefAuthorRecords(pub_list) | |
SQLReviewAuthors(title_id) | |
SQLReviewBriefAuthorRecords(title_id) | |
SQLReviewedAuthors(title_id) | |
SQLTitleAuthors(title_id) | |
SQLTitleBriefAuthorRecords(title_id) | DONE |
SQLTitleListBriefAuthorRecords(title_list, author_id = 0) | |
SQLtransLegalNames(author_ids) |