Difference between revisions of "User:Alvonruff/Python3 ModTests"

From ISFDB
Jump to navigation Jump to search
Line 12: Line 12:
  
 
===Python2 Results===
 
===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===
 
===Python3 Results===

Revision as of 16:08, 29 May 2023

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

Edit Tools Tested

  • edit/av_merge.cgi
  • edit/as_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

  • 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

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=663744"