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

Revision as of 10:04, 2 June 2023

Detailed test plans and results. The idea is to create an specific test plan for each script, execute that plan on both python2 and python3, then compare the SQL query output to ensure they are doing the same thing. Since restoring the database takes 30 minutes, several unrelated tests may be run on a single restore, so the submission ids may differ.

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

Under Python2:

Restore the database
Go to this award entry: https://www.isfdb2.org/cgi-bin/award_details.cgi?7600
Click on "Link Award"
Entry the following Title #: 1672025
Submit via 'Link Award to Title' and Approve

Repeat the steps under Python3.

Python2 Results

delete from title_awards where award_id='7600';
insert into title_awards(title_id, award_id) values(1672025, 7600);
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=7600 where sub_id=5677670

Python3 Results

delete from title_awards where award_id='7600';
insert into title_awards(title_id, award_id) values(1672025, 7600);
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=7600 where sub_id=5677669

Edit Tools Tested

edit/linkaward.cgi
edit/submitlinkaward.cgi

award_type_delete_file.cgi

Under Python2:

Restore the database
Execute the steps for the award_type_new_file.cgi test.
Go to the award directory at: https://www.isfdb2.org/cgi-bin/award_directory.cgi
Click on 'Bogus'
Click on "Delete This Award Type" from the left navbar
Click on 'Delete' and Approve.

Repeat the steps under Python3.

Python2 Results

delete from webpages where award_type_id=105
delete from award_types where award_type_id=105
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=105 where sub_id=5677670

Python3 Results

delete from webpages where award_type_id=105
delete from award_types where award_type_id=105
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=105 where sub_id=5677671

Edit Tools Tested

edit/deleteawardtype.cgi
edit/submitdeleteawardtype.cgi

award_type_new_file.cgi

Under Python2:

Restore the database
Click on 'Moderator' in the left navbar
Click on 'Bureaucrat' in the left navbar
Click on 'Add New Award Type'
Enter the following:
- Short Name: 'Bogus'
- Full Name: 'The Bogus Awards'
- Awarded For: 'The Best SF Bogosities'
- Awarded By: "ISFDB"
- Poll: Yes
- Non-Genre: Yes
Submit and Approve

Repeat the steps under Python3.

Python2 Results

insert into award_types(award_type_name, award_type_by, award_type_for, award_type_short_name, award_type_poll, award_type_non_genre) values('The Bogus Awards', 'ISFDB', 'The Best SF Bogosities', 'Bogus', 'Yes', 'Yes')
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=105 where sub_id=5677669

Python3 Results

insert into award_types(award_type_name, award_type_by, award_type_for, award_type_short_name, award_type_poll, award_type_non_genre) values('The Bogus Awards', 'ISFDB', 'The Best SF Bogosities', 'Bogus', 'Yes', 'Yes')
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=105 where sub_id=5677670

Edit Tools Tested

edit/newawardtype.cgi
edit/submitnewawardtype.cgi

award_type_update_file.cgi

Under Python2:

Restore the database
Click on this award: https://www.isfdb2.org/cgi-bin/awardtype.cgi?13
Click on 'Edit This Award Type' in the left navbar
Enter the following:
- Short Name: 'Bogus'
- Full Name: 'The Bogus Awards'
- Awarded For: 'The Best SF Bogosities'
- Awarded By: "ISFDB"
- Poll: No
- Non-Genre: Yes
- Web Page 1: <blank>
- Web Page 2: <blank>
- Web Page 3: <blank>
- Note: <blank>
Submit and Approve

Repeat the steps under Python3.

Python2 Results

update award_types set award_type_short_name='Bogus' where award_type_id=13
update award_types set award_type_name='The Bogus Awards' where award_type_id=13
update award_types set award_type_by='ISFDB' where award_type_id=13
update award_types set award_type_for='The Best SF Bogosities' where award_type_id=13
update award_types set award_type_poll='No' where award_type_id=13
update award_types set award_type_non_genre='Yes' where award_type_id=13
delete from webpages where award_type_id=13
delete from notes where note_id=368381
update award_types set award_type_note_id=NULL where award_type_id=13
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=13 where sub_id=5677671

Python3 Results

update award_types set award_type_short_name='Bogus' where award_type_id=13
update award_types set award_type_name='The Bogus Awards' where award_type_id=13
update award_types set award_type_by='ISFDB' where award_type_id=13
update award_types set award_type_for='The Best SF Bogosities' where award_type_id=13
update award_types set award_type_poll='No' where award_type_id=13
update award_types set award_type_non_genre='Yes' where award_type_id=13
delete from webpages where award_type_id=13
delete from notes where note_id=368381
update award_types set award_type_note_id=NULL where award_type_id=13
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=13 where sub_id=5677669

Edit Tools Tested

edit/editawardtype.cgi
edit/submitawardtype.cgi

bad_images.cgi

ca_new.cgi

Under Python2:

Restore the database
Go to the publication: https://www.isfdb2.org/cgi-bin/pl.cgi?57273
Click on "Clone This Pub" in the left navbar.
Submit without modification.
Go to moderator list, and approve the edit. Record the SQL results.

Repeat the steps under Python3.

Python2 Results

insert into pubs(pub_title) values('xxx');
update pubs set pub_title='Asimov\'s Science Fiction, February 2001' where pub_id=953056
update pubs set pub_tag='SMVSSCNCFC2001' where pub_id=953056
update pubs set pub_year='2001-02-00' where pub_id=953056
update pubs set pub_pages='148' where pub_id=953056
update pubs set pub_ptype='digest' where pub_id=953056
update pubs set pub_ctype='MAGAZINE' where pub_id=953056
update pubs set pub_price='$3.50' where pub_id=953056
update pubs set pub_frontimage='http://www.isfdb.org/wiki/images/6/66/IAS_2001_02_Carroll.jpg' where pub_id=953056
insert into notes(note_note) values('\nJan. 2001←Feb. 2001→Mar. 2001\n\n\nVol 25, No 2, Whole No 301. Cover illustration untitled.');
update pubs set note_id='1114930' where pub_id=953056
select publisher_id from publishers where publisher_name='Dell Magazines';
update pubs set publisher_id='6754' where pub_id=953056
insert into pub_authors(pub_id, author_id) values('953056', '198');
insert into pub_content(pub_id, title_id) values(953056, 137093);
insert into pub_content(pub_id, title_id) values(953056, 147607);
insert into pub_content(pub_id, title_id, pubc_page) values(953056, 131311, '4');
insert into pub_content(pub_id, title_id, pubc_page) values(953056, 91946, '8');
insert into pub_content(pub_id, title_id, pubc_page) values(953056, 111958, '8');
insert into pub_content(pub_id, title_id, pubc_page) values(953056, 91949, '40');
insert into pub_content(pub_id, title_id, pubc_page) values(953056, 111961, '40');
insert into pub_content(pub_id, title_id, pubc_page) values(953056, 91950, '52');
insert into pub_content(pub_id, title_id, pubc_page) values(953056, 91947, '60');
insert into pub_content(pub_id, title_id, pubc_page) values(953056, 111959, '60');
insert into pub_content(pub_id, title_id, pubc_page) values(953056, 91951, '83');
insert into pub_content(pub_id, title_id, pubc_page) values(953056, 111962, '83');
insert into pub_content(pub_id, title_id, pubc_page) values(953056, 109181, '93');
insert into pub_content(pub_id, title_id, pubc_page) values(953056, 91952, '94');
insert into pub_content(pub_id, title_id, pubc_page) values(953056, 109182, '105');
insert into pub_content(pub_id, title_id, pubc_page) values(953056, 91948, '106');
insert into pub_content(pub_id, title_id, pubc_page) values(953056, 111960, '106');
insert into pub_content(pub_id, title_id, pubc_page) values(953056, 960829, '132');
insert into pub_content(pub_id, title_id, pubc_page) values(953056, 960830, '142');
insert into pub_content(pub_id, title_id, pubc_page) values(953056, 960831, '144');
insert into pub_content(pub_id, title_id, pubc_page) values(953056, 165281, '132');
insert into pub_content(pub_id, title_id, pubc_page) values(953056, 960833, '132');
insert into pub_content(pub_id, title_id, pubc_page) values(953056, 960834, '132');
insert into pub_content(pub_id, title_id, pubc_page) values(953056, 960835, '132');
insert into pub_content(pub_id, title_id, pubc_page) values(953056, 960836, '133');
insert into pub_content(pub_id, title_id, pubc_page) values(953056, 960837, '133');
insert into pub_content(pub_id, title_id, pubc_page) values(953056, 960838, '133');
insert into pub_content(pub_id, title_id, pubc_page) values(953056, 960839, '134');
insert into pub_content(pub_id, title_id, pubc_page) values(953056, 960840, '134');
insert into pub_content(pub_id, title_id, pubc_page) values(953056, 960841, '134');
insert into pub_content(pub_id, title_id, pubc_page) values(953056, 960853, '135');
insert into pub_content(pub_id, title_id, pubc_page) values(953056, 960854, '136');
insert into pub_content(pub_id, title_id, pubc_page) values(953056, 960855, '137');
insert into pub_content(pub_id, title_id, pubc_page) values(953056, 960856, '137');
insert into pub_content(pub_id, title_id, pubc_page) values(953056, 960857, '137');
insert into pub_content(pub_id, title_id, pubc_page) values(953056, 960858, '138');
insert into pub_content(pub_id, title_id, pubc_page) values(953056, 960859, '138');
insert into pub_content(pub_id, title_id, pubc_page) values(953056, 960864, '139');
insert into pub_content(pub_id, title_id, pubc_page) values(953056, 960865, '139');
insert into pub_content(pub_id, title_id, pubc_page) values(953056, 960866, '139');
insert into pub_content(pub_id, title_id, pubc_page) values(953056, 960867, '140');
insert into pub_content(pub_id, title_id, pubc_page) values(953056, 960868, '140');
insert into pub_content(pub_id, title_id, pubc_page) values(953056, 960869, '140');
insert into pub_content(pub_id, title_id, pubc_page) values(953056, 960874, '141');
insert into pub_content(pub_id, title_id, pubc_page) values(953056, 960875, '141');
insert into pub_content(pub_id, title_id, pubc_page) values(953056, 960876, '141');
insert into pub_content(pub_id, title_id, pubc_page) values(953056, 960877, '141');
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=953056 where sub_id=5677669

Python3 Results

insert into pubs(pub_title) values('xxx');
update pubs set pub_title='Asimov\'s Science Fiction, February 2001' where pub_id=953061
update pubs set pub_tag='SMVSSCNCFD2001' where pub_id=953061
update pubs set pub_year='2001-02-00' where pub_id=953061
update pubs set pub_pages='148' where pub_id=953061
update pubs set pub_ptype='digest' where pub_id=953061
update pubs set pub_ctype='MAGAZINE' where pub_id=953061
update pubs set pub_price='$3.50' where pub_id=953061
update pubs set pub_frontimage='http://www.isfdb.org/wiki/images/6/66/IAS_2001_02_Carroll.jpg' where pub_id=953061
insert into notes(note_note) values('\nJan. 2001←Feb. 2001→Mar. 2001\n\n\nVol 25, No 2, Whole No 301. Cover illustration untitled.');
update pubs set note_id='1114935' where pub_id=953061
select publisher_id from publishers where publisher_name='Dell Magazines';
update pubs set publisher_id='6754' where pub_id=953061
insert into pub_authors(pub_id, author_id) values('953061', '364255');
insert into pub_content(pub_id, title_id) values(953061, 137093);
insert into pub_content(pub_id, title_id) values(953061, 147607);
insert into pub_content(pub_id, title_id, pubc_page) values(953061, 131311, '4');
insert into pub_content(pub_id, title_id, pubc_page) values(953061, 91946, '8');
insert into pub_content(pub_id, title_id, pubc_page) values(953061, 111958, '8');
insert into pub_content(pub_id, title_id, pubc_page) values(953061, 91949, '40');
insert into pub_content(pub_id, title_id, pubc_page) values(953061, 111961, '40');
insert into pub_content(pub_id, title_id, pubc_page) values(953061, 91950, '52');
insert into pub_content(pub_id, title_id, pubc_page) values(953061, 91947, '60');
insert into pub_content(pub_id, title_id, pubc_page) values(953061, 111959, '60');
insert into pub_content(pub_id, title_id, pubc_page) values(953061, 91951, '83');
insert into pub_content(pub_id, title_id, pubc_page) values(953061, 111962, '83');
insert into pub_content(pub_id, title_id, pubc_page) values(953061, 109181, '93');
insert into pub_content(pub_id, title_id, pubc_page) values(953061, 91952, '94');
insert into pub_content(pub_id, title_id, pubc_page) values(953061, 109182, '105');
insert into pub_content(pub_id, title_id, pubc_page) values(953061, 91948, '106');
insert into pub_content(pub_id, title_id, pubc_page) values(953061, 111960, '106');
insert into pub_content(pub_id, title_id, pubc_page) values(953061, 960829, '132');
insert into pub_content(pub_id, title_id, pubc_page) values(953061, 960830, '142');
insert into pub_content(pub_id, title_id, pubc_page) values(953061, 960831, '144');
insert into pub_content(pub_id, title_id, pubc_page) values(953061, 165281, '132');
insert into pub_content(pub_id, title_id, pubc_page) values(953061, 960833, '132');
insert into pub_content(pub_id, title_id, pubc_page) values(953061, 960834, '132');
insert into pub_content(pub_id, title_id, pubc_page) values(953061, 960835, '132');
insert into pub_content(pub_id, title_id, pubc_page) values(953061, 960836, '133');
insert into pub_content(pub_id, title_id, pubc_page) values(953061, 960837, '133');
insert into pub_content(pub_id, title_id, pubc_page) values(953061, 960838, '133');
insert into pub_content(pub_id, title_id, pubc_page) values(953061, 960839, '134');
insert into pub_content(pub_id, title_id, pubc_page) values(953061, 960840, '134');
insert into pub_content(pub_id, title_id, pubc_page) values(953061, 960841, '134');
insert into pub_content(pub_id, title_id, pubc_page) values(953061, 960853, '135');
insert into pub_content(pub_id, title_id, pubc_page) values(953061, 960854, '136');
insert into pub_content(pub_id, title_id, pubc_page) values(953061, 960855, '137');
insert into pub_content(pub_id, title_id, pubc_page) values(953061, 960856, '137');
insert into pub_content(pub_id, title_id, pubc_page) values(953061, 960857, '137');
insert into pub_content(pub_id, title_id, pubc_page) values(953061, 960858, '138');
insert into pub_content(pub_id, title_id, pubc_page) values(953061, 960859, '138');
insert into pub_content(pub_id, title_id, pubc_page) values(953061, 960864, '139');
insert into pub_content(pub_id, title_id, pubc_page) values(953061, 960865, '139');
insert into pub_content(pub_id, title_id, pubc_page) values(953061, 960866, '139');
insert into pub_content(pub_id, title_id, pubc_page) values(953061, 960867, '140');
insert into pub_content(pub_id, title_id, pubc_page) values(953061, 960868, '140');
insert into pub_content(pub_id, title_id, pubc_page) values(953061, 960869, '140');
insert into pub_content(pub_id, title_id, pubc_page) values(953061, 960874, '141');
insert into pub_content(pub_id, title_id, pubc_page) values(953061, 960875, '141');
insert into pub_content(pub_id, title_id, pubc_page) values(953061, 960876, '141');
insert into pub_content(pub_id, title_id, pubc_page) values(953061, 960877, '141');
update submissions set sub_state='I', sub_reviewer=2, sub_reviewed=NOW(), sub_holdid=0 where sub_id=5677675
update submissions set affected_record_id=953061 where sub_id=5677675

Edit Tools Tested

edit/clone_intermediate.cgi
edit/clonepub.cgi
edit/submitclone.cgi

change_tag_status.cgi

cpanel.cgi

hardreject.cgi

hold.cgi

ka_new.cgi

Under Python2:

Restore the database
Method 1
- Open title: https://www.isfdb2.org/cgi-bin/title.cgi?2925742
- Click on "Make This Title a Variant" from the navbar.
- In the option 1 section, put a parent # of '1234'.
- Click 'Link to Existing Parent'
- Go to moderator list, and approve the edit. Record the SQL results.
Method 2
- Go back to * Open title: https://www.isfdb2.org/cgi-bin/title.cgi?17097
- Click on "Make This Title a Variant" from the navbar.
- In the option 21 section, change the Title to 'The Positronic Man Parent'
- Click 'Create New Parent Title'
- Go to moderator list, and approve the edit. Record the SQL results.

Repeat the steps under Python3.

Python2 Results

Method #1

update tag_mapping set title_id=1234 where title_id=2925742
update titles set title_parent=1234 where title_id=2925742
update submissions set sub_state='I', sub_reviewer=2, sub_reviewed=NOW(), sub_holdid=0 where sub_id=5677673
update submissions set affected_record_id=2925742 where sub_id=5677673

Method #2

insert into titles(title_title) values('xxx');
update titles set title_title='The Positronic Man Parent' where title_id=3189269
update titles set title_copyright='1992-11-00' where title_id=3189269
update titles set title_ttype='NOVEL' where title_id=3189269
update titles set title_language='17' where title_id=3189269
update titles set title_jvn='No' where title_id=3189269
update titles set title_nvz='No' where title_id=3189269
update titles set title_non_genre='No' where title_id=3189269
update titles set title_graphic='No' where title_id=3189269
update titles set series_id=647 where title_id=3189269
update titles set series_id=NULL where title_id=17097
insert into webpages(title_id, url) values(3189269, 'https://en.wikipedia.org/wiki/The_Positronic_Man')
update tag_mapping set title_id=3189269 where title_id=17097
insert into canonical_author(title_id, author_id, ca_status) values('3189269', '5', '1');
insert into canonical_author(title_id, author_id, ca_status) values('3189269', '54', '1');
update titles set title_parent=3189269 where title_id=17097
update titles set title_parent=3189269 where title_id=1479587
update titles set title_parent=3189269 where title_id=1576501
update titles set title_parent=3189269 where title_id=1922007
update titles set title_parent=3189269 where title_id=1922009
update titles set title_parent=3189269 where title_id=2140221
update titles set title_parent=3189269 where title_id=2353884
update titles set title_parent=3189269 where title_id=2689652
update titles set title_parent=3189269 where title_id=2756360
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=17097 where sub_id=5677669

Python3 Results

Method #1

Method #2

insert into titles(title_title) values('xxx');
update titles set title_title='The Positronic Man Parent' where title_id=3189269
update titles set title_copyright='1992-11-00' where title_id=3189269
update titles set title_ttype='NOVEL' where title_id=3189269
update titles set title_language='17' where title_id=3189269
update titles set title_jvn='No' where title_id=3189269
update titles set title_nvz='No' where title_id=3189269
update titles set title_non_genre='No' where title_id=3189269
update titles set title_graphic='No' where title_id=3189269
update titles set series_id=647 where title_id=3189269
update titles set series_id=NULL where title_id=17097
insert into webpages(title_id, url) values(3189269, 'https://en.wikipedia.org/wiki/The_Positronic_Man')
update tag_mapping set title_id=3189269 where title_id=17097
insert into canonical_author(title_id, author_id, ca_status) values('3189269', '5', '1');
insert into canonical_author(title_id, author_id, ca_status) values('3189269', '54', '1');
update titles set title_parent=3189269 where title_id=17097
update titles set title_parent=3189269 where title_id=1479587
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=17097 where sub_id=5677669

Edit Tools Tested

edit/mkvariant.cgi
edit/submitmkvar1.cgi
edit/submitmkvar2.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

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

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

@@ Line 493: / Line 493: @@
 Method #2
+* insert into titles(title_title) values('xxx');
+* update titles set title_title='The Positronic Man Parent' where title_id=3189269
+* update titles set title_copyright='1992-11-00' where title_id=3189269
+* update titles set title_ttype='NOVEL' where title_id=3189269
+* update titles set title_language='17' where title_id=3189269
+* update titles set title_jvn='No' where title_id=3189269
+* update titles set title_nvz='No' where title_id=3189269
+* update titles set title_non_genre='No' where title_id=3189269
+* update titles set title_graphic='No' where title_id=3189269
+* update titles set series_id=647 where title_id=3189269
+* update titles set series_id=NULL where title_id=17097
+* insert into webpages(title_id, url) values(3189269, 'https://en.wikipedia.org/wiki/The_Positronic_Man')
+* update tag_mapping set title_id=3189269 where title_id=17097
+* insert into canonical_author(title_id, author_id, ca_status) values('3189269', '5', '1');
+* insert into canonical_author(title_id, author_id, ca_status) values('3189269', '54', '1');
+* update titles set title_parent=3189269 where title_id=17097
+* update titles set title_parent=3189269 where title_id=1479587
+* update titles set title_parent=3189269 where title_id=1576501
+* update titles set title_parent=3189269 where title_id=1922007
+* update titles set title_parent=3189269 where title_id=1922009
+* update titles set title_parent=3189269 where title_id=2140221
+* update titles set title_parent=3189269 where title_id=2353884
+* update titles set title_parent=3189269 where title_id=2689652
+* update titles set title_parent=3189269 where title_id=2756360
+* 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=17097 where sub_id=5677669
 ===Python3 Results===