Difference between revisions of "User:Alvonruff/Python3 ModTests"
Line 49: | Line 49: | ||
===Python3 Results=== | ===Python3 Results=== | ||
− | + | delete from notes where note_id=1087516 | |
+ | delete from pub_authors where author_id=213411 and pub_id=932107 | ||
+ | select COUNT(author_id) from canonical_author where author_id=213411 | ||
+ | delete from pub_content where pub_id=932107 | ||
+ | delete from primary_verifications where pub_id=932107 | ||
+ | delete from verification where pub_id=932107 | ||
+ | delete from trans_pubs where pub_id=932107 | ||
+ | delete from webpages where pub_id=932107 | ||
+ | delete from identifiers where pub_id=932107 | ||
+ | delete from pubs where pub_id=932107 | ||
+ | select COUNT(publisher_id) from pubs where publisher_id=53666 | ||
+ | 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=932107 where sub_id=5677669 | ||
===Edit Tools Tested=== | ===Edit Tools Tested=== |
Revision as of 15:22, 29 May 2023
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
- delete from notes where note_id=1087516
- delete from pub_authors where author_id=213411 and pub_id=932107
- select COUNT(author_id) from canonical_author where author_id=213411
- delete from pub_content where pub_id=932107
- delete from primary_verifications where pub_id=932107
- delete from verification where pub_id=932107
- delete from trans_pubs where pub_id=932107
- delete from webpages where pub_id=932107
- delete from identifiers where pub_id=932107
- delete from pubs where pub_id=932107
- select COUNT(publisher_id) from pubs where publisher_id=53666
- 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=932107 where sub_id=5677669
Python3 Results
delete from notes where note_id=1087516 delete from pub_authors where author_id=213411 and pub_id=932107 select COUNT(author_id) from canonical_author where author_id=213411 delete from pub_content where pub_id=932107 delete from primary_verifications where pub_id=932107 delete from verification where pub_id=932107 delete from trans_pubs where pub_id=932107 delete from webpages where pub_id=932107 delete from identifiers where pub_id=932107 delete from pubs where pub_id=932107 select COUNT(publisher_id) from pubs where publisher_id=53666 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=932107 where sub_id=5677669
Edit Tools Tested
- edit/deletepub.cgi
- edit/submitdelpub.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 at https://www.isfdb2.org/cgi-bin/ea.cgi?118640
- 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 set sub_state='I', sub_reviewer=2, sub_reviewed=NOW(), sub_holdid=0 where sub_id=5677669
- update submissions set affected_record_id=2419423 where sub_id=5677669
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
- edit/tv_merge.cgi
- edit/ts_merge.cgi
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