User:Alvonruff/Python3 ModTests

From ISFDB
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:

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

ta_unmerge.cgi

ta_update.cgi

template_add_file.cgi

template_update_file.cgi

ua_merge.cgi

unhold.cgi

unreject.cgi

va_new.cgi

verification_source_add_file.cgi

verification_source_file.cgi

wa_delete.cgi

wa_new.cgi

wa_update.cgi

xa_update.cgi

ya_new.cgi

ya_remove.cgi

za_update.cgi

Retrieved from "https://isfdb.org/wiki/index.php?title=User:Alvonruff/Python3_ModTests&oldid=663718"