User:Alvonruff/Python3 ModTests
Detailed test plans and reults
aa_merge.cgi
Under Python2:
- Restore the database
- From navbar click on "Advanced Search"
- Click on "Authors"
- Enter "robot" in first box, and select "contains", then "Get Results".
- Select 'Bad Robot Brain' and 'Bürobote Dr. Goltz', then press 'Merge'
- Press 'Complete Merge' (do not change the pre-selects)
- Go to moderator list, and approve the edit. Record the SQL results.
Repeat the steps under Python3.
Python2 Results
- update authors set author_canonical='Bad Robot Brain' where author_id='156504'
- update authors set author_lastname='Brain' where author_id='156504'
- update authors set author_language=NULL where author_id='156504'
- update canonical_author set author_id='156504' where author_id='245498'
- update pub_authors set author_id='156504' where author_id='245498'
- update pseudonyms set author_id = 156504 where author_id = 245498
- LASTNAME: [Brain]
- delete from authors where author_id='245498'
- delete from pseudonyms where author_id='245498'
- delete from pseudonyms where pseudonym='245498'
- delete from webpages where author_id='245498'
- delete from emails where author_id='245498'
- delete from trans_legal_names where author_id='245498'
- delete from trans_authors where author_id=245498
- delete from author_views where author_id=245498
- count 4569 for section [Br]
- Old bitmap: 05524b93
- New bitmap: 05524b93
- update directory set directory_mask='89279379' where directory_index='B'
- 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=156504 where sub_id=5677669
Python3 Results
- update authors set author_canonical='Bad Robot Brain' where author_id='156504'
- update authors set author_lastname='Brain' where author_id='156504'
- update authors set author_language=NULL where author_id='156504'
- update canonical_author set author_id='156504' where author_id='245498'
- update pub_authors set author_id='156504' where author_id='245498'
- update pseudonyms set author_id = 156504 where author_id = 245498
- LASTNAME: [Brain]
- delete from authors where author_id='245498'
- delete from pseudonyms where author_id='245498'
- delete from pseudonyms where pseudonym='245498'
- delete from webpages where author_id='245498'
- delete from emails where author_id='245498'
- delete from trans_legal_names where author_id='245498'
- delete from trans_authors where author_id=245498
- delete from author_views where author_id=245498
- count 4569 for section [Br]
- Old bitmap: 05524b93
- New bitmap: 05524b93
- update directory set directory_mask='89279379' where directory_index='B'
- update submissions set sub_state='I', sub_reviewer=2, sub_reviewed=NOW(), sub_holdid=0 where sub_id=5677670
- update submissions set affected_record_id=156504 where sub_id=5677670
Submitter ID on the Python3 run is +1 due to running just it after a previous test.
Edit Tools Tested
- edit/av_merge.cgi
- edit/as_merge.cgi
aa_update.cgi
Under Python2:
- Restore the database
- Go to the author page: https://www.isfdb2.org/cgi-bin/ea.cgi?219284
- Click on "Edit Author Data"
- Add the middle name George to the Canonical and Legal name fields
- Change birthplace to Austin, Texas
- Add one year to the Birth Date and Death Date
- Change nationality to English
Repeat the steps under Python3.
Python2 Results
- update authors set author_canonical='Auguste George Souze' where author_id=219284
- update authors set author_legalname='Souze, Auguste George' where author_id=219284
- update authors set author_birthplace='Austin, Texas' where author_id=219284
- update authors set author_birthdate='1830-05-29' where author_id=219284
- update authors set author_deathdate='1901-04-02' where author_id=219284
- update authors set author_language='17' where author_id=219284
- 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=219284 where sub_id=5677669
Python3 Results
- update authors set author_canonical='Auguste George Souze' where author_id=219284
- update authors set author_legalname='Souze, Auguste George' where author_id=219284
- update authors set author_birthplace='Austin, Texas' where author_id=219284
- update authors set author_birthdate='1830-05-29' where author_id=219284
- update authors set author_deathdate='1901-04-02' where author_id=219284
- update authors set author_language='17' where author_id=219284
- update submissions set sub_state='I', sub_reviewer=2, sub_reviewed=NOW(), sub_holdid=0 where sub_id=5677670
- update submissions set affected_record_id=219284 where sub_id=5677670
Submitter ID on the Python3 run is +1 due to running just it after a previous test.
Edit Tools Tested
- edit/editauth.cgi
- edit/submitauth.cgi
TBD; re-run with potential unicode issues:
- Make middle name: José
- Change birthplace to: Gießen, Hesse
award_cat_delete_file.cgi
Under Python2:
- Restore the database
- Go to the Hugos award page: https://www.isfdb2.org/cgi-bin/awardtype.cgi?23
- Click on "Add New Award Category"
- Make a new Category called "Bogus Category", with Display Order "23".
- Submit and Approve
- Go back to the Hugo url. At the bottom, under 'Empty Categories' click on 'Bogus Category'
- In the left navbar click on 'Delete This Award Category'
- Submit and Approve.
Repeat the steps under Python3.
Python2 Results
- delete from webpages where award_cat_id=1069
- delete from award_cats where award_cat_id=1069
- update submissions set sub_state='I', sub_reviewer=2, sub_reviewed=NOW(), sub_holdid=0 where sub_id=5677670
- update submissions set affected_record_id=1069 where sub_id=5677670
Python3 Results
- delete from webpages where award_cat_id=1069
- delete from award_cats where award_cat_id=1069
- update submissions set sub_state='I', sub_reviewer=2, sub_reviewed=NOW(), sub_holdid=0 where sub_id=5677671
- update submissions set affected_record_id=1069 where sub_id=5677671
Submitter ID on the Python3 run is +1 due to running just it after a previous test.
Edit Tools Tested
- edit/addawardcat.cgi.cgi
- edit/submitnewawardcat.cgi
- edit/deleteawardcat.cgi
- edit/submitdeleteawardcat.cgi
award_cat_new_file.cgi
Under Python2:
- Restore the database
- Go to the Hugos award page: https://www.isfdb2.org/cgi-bin/awardtype.cgi?23
- Click on "Add New Award Category"
- Make a new Category called "Bogus Category", with Display Order "23".
- Submit and Approve
Repeat the steps under Python3.
Python2 Results
- insert into award_cats(award_cat_name, award_cat_type_id, award_cat_order) values('Bogus Category', 23, 23)
- 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=1069 where sub_id=5677669
Python3 Results
- insert into award_cats(award_cat_name, award_cat_type_id, award_cat_order) values('Bogus Category', 23, 23)
- update submissions set sub_state='I', sub_reviewer=2, sub_reviewed=NOW(), sub_holdid=0 where sub_id=5677670
- update submissions set affected_record_id=1069 where sub_id=5677670
Submitter ID on the Python3 run is +1 due to running just it after a previous test.
Edit Tools Tested
- edit/addawardcat.cgi.cgi
- edit/submitnewawardcat.cgi
award_cat_update_file.cgi
Under Python2:
- Restore the database
- Go to this award category: https://www.isfdb2.org/cgi-bin/award_category.cgi?261+0
- Click on "Edit This Award Category"
- Change the Category to: "úrscéal is fearr"
- Change the Display Order to: 2
- Submit and Approve
Repeat the steps under Python3.
Python2 Results
- update award_cats set award_cat_name='úrscéal is fearr' where award_cat_id=261
- update award_cats set award_cat_order='2' where award_cat_id=261
- 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=261 where sub_id=5677669
Python3 Results
- update award_cats set award_cat_name='úrscéal is fearr' where award_cat_id=261
- update award_cats set award_cat_order='2' where award_cat_id=261
- 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=261 where sub_id=5677669
Edit Tools Tested
- edit/editawardcat.cgi
- edit/submitawardcat.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