User:Alvonruff/Python3 ModTests
Jump to navigation
Jump to search
Detailed test plans and reults
aa_merge.cgi
aa_update.cgi
award_cat_delete_file.cgi
award_cat_new_file.cgi
award_cat_update_file.cgi
award_link_file.cgi
award_type_delete_file.cgi
award_type_new_file.cgi
award_type_update_file.cgi
bad_images.cgi
bureaucrat.cgi
ca_new.cgi
change_tag_status.cgi
cpanel.cgi
hardreject.cgi
hold.cgi
ka_new.cgi
library.cgi
list.cgi
list_templates.cgi
list_verification_sources.cgi
marque.cgi
new_language_file.cgi
pa_delete.cgi
Under Python2:
- Restore the database
- Go to the publication: https://www.isfdb2.org/cgi-bin/pl.cgi?932107
- Click on "Delete This Pub" in the left navbar.
- Submit.
- Go to moderator list, and approve the edit. Record the SQL results.
Repeat the steps under Python3.
Python2 Results
Python3 Results
Edit Tools Tested
- edit/deletepub.cgi
pa_new.cgi
pa_update.cgi
private_tags.cgi
ra_link.cgi
recent.cgi
reject.cgi
remove_secondary_verification.cgi
remove_tag.cgi
resolve_bad_url.cgi
resolve_cleanup.cgi
resolve_empty_containers.cgi
resolve_sfe3_url.cgi
sa_delete.cgi
sa_update.cgi
select_secondary_verification.cgi
self_approver_file.cgi
self_approvers.cgi
submission_review.cgi
submission_search.cgi
submission_search_results.cgi
submitcpanel.cgi
submitref.cgi
ta_delete.cgi
tag_breakdown.cgi
tag_status_changes.cgi
ta_merge.cgi
Under Python2:
- Restore the database
- Go to author Greer Woodward.
- Click on "Show All Titles" in the left navbar.
- Select:
- hunger moon casino
- iron in the dunes
- Submit.
- Go to moderator list, and approve the edit.
Repeat the steps under Python3.
Python2 Results
- delete from canonical_author where title_id='2749411'
- select COUNT(author_id) from canonical_author where author_id=118640
- select COUNT(author_id) from pub_authors where author_id=118640
- update pub_content set title_id=2419423 where title_id=2749411
- delete from titles where title_id='2749411'
- delete from title_views where title_id=2749411
- update title_awards set title_id=2419423 where title_id=2749411
- update titles set title_parent=2419423 where title_parent=2749411
- update votes set title_id=2419423 where title_id=2749411
- update tag_mapping set title_id=2419423 where title_id=2749411
- update title_relationships set title_id=2419423 where title_id=2749411
- delete from title_relationships where review_id=2749411
- update submissions\n set sub_state='I', sub_reviewer=2, sub_reviewed=NOW(), sub_holdid=0\n where sub_id=5660195
- update submissions set affected_record_id=2419423 where sub_id=5660195
Python3 Results
- delete from canonical_author where title_id='2749411'
- select COUNT(author_id) from canonical_author where author_id=118640
- select COUNT(author_id) from pub_authors where author_id=118640
- update pub_content set title_id=2419423 where title_id=2749411
- delete from titles where title_id='2749411'
- delete from title_views where title_id=2749411
- update title_awards set title_id=2419423 where title_id=2749411
- update titles set title_parent=2419423 where title_parent=2749411
- update votes set title_id=2419423 where title_id=2749411
- update tag_mapping set title_id=2419423 where title_id=2749411
- update title_relationships set title_id=2419423 where title_id=2749411
- delete from title_relationships where review_id=2749411
- update submissions\n set sub_state='I', sub_reviewer=2, sub_reviewed=NOW(), sub_holdid=0\n where sub_id=5677669
- update submissions set affected_record_id=2419423 where sub_id=5677669
Edit Tools Tested
ta_remove.cgi
Under Python2:
- Restore the database
- Go to Locus publication: https://www.isfdb2.org/cgi-bin/pl.cgi?323280
- Click on "Remove Titles From This Pub" in the left navbar.
- Select "Editorial Matters" (the first article)
- Submit.
- Go to moderator list, and approve the edit. Record the SQL results.
Repeat the steps under Python3.
Python2 Results
- delete from pub_content where pubc_id = '1614508' and pub_id = '323280'
- update submissions set sub_state='I', sub_reviewer=2, sub_reviewed=NOW(), sub_holdid=0 where sub_id=5677669
- update submissions set affected_record_id=323280 where sub_id=5677669
Python3 Results
- delete from pub_content where pubc_id = '1614508' and pub_id = '323280'
- update submissions set sub_state='I', sub_reviewer=2, sub_reviewed=NOW(), sub_holdid=0 where sub_id=5677669
- update submissions set affected_record_id=323280 where sub_id=5677669
Edit Tools Tested
- edit/rmtitles.cgi
- edit/submitrm.cgi