def test_list_submitted_resources(self):
'''Test_list_submitted_resources - check the data selection and update for admin interface'''
id_tests = []
id_tests.append(insert_into_swr_clientdata(4, 97, 1, 'test', 'test', '10030148',
'https://arxiv.org/sword-app/edit/10030148',
'https://arxiv.org/sword-app/edit/10030148.atom',
'http://arxiv.org/resolve/app/10030148'))
time.sleep(1)
id_tests.append(insert_into_swr_clientdata(4, 97, 1, 'test', 'test', '10030148',
'https://arxiv.org/sword-app/edit/10030148',
'https://arxiv.org/sword-app/edit/10030148.atom',
'http://arxiv.org/resolve/app/10030148'))
update_submission_status(id_tests[1], CFG_SUBMISSION_STATUS_PUBLISHED, '1003.0148')
time.sleep(1)
id_tests.append(insert_into_swr_clientdata(3, 92, 2, 'test', 'test', '12340097',
'https://arxiv.org/sword-app/edit/12340097',
'https://arxiv.org/sword-app/edit/12340097.atom',
'http://arxiv.org/resolve/app/12340097'))
time.sleep(1)
(submissions, modifications) = list_submitted_resources(0, 10, '')
self.assertEqual(len(submissions), 3)
self.assertEqual(len(modifications), 2)
self.assertEqual(submissions[1]['id_remote'], '1003.3743')
self.assertEqual(submissions[1]['status'], CFG_SUBMISSION_STATUS_PUBLISHED)
self.assertEqual(submissions[1]['publication_date'] != '', True)
self.assertEqual(submissions[2]['id_remote'], '1003.0148')
self.assertEqual(submissions[2]['status'], CFG_SUBMISSION_STATUS_PUBLISHED)
self.assertEqual(submissions[2]['publication_date'] != '', True)
self.assertEqual(submissions[0]['id_remote'], '12340097')
self.assertEqual(submissions[0]['status'], CFG_SUBMISSION_STATUS_REMOVED)
self.assertEqual(submissions[0]['removal_date'] != '', True)
self.assertEqual(modifications[1], submissions[0]['id'])
self.assertEqual(modifications[0], submissions[1]['id'])
for id_test in id_tests:
delete_from_swr_clientdata(id_test)
def test_list_submitted_resources(self):
'''Test_list_submitted_resources - check the data selection and update for admin interface'''
id_tests = []
id_tests.append(insert_into_swr_clientdata(4, 97, 1, 'test', 'test', '10030148',
'https://arxiv.org/sword-app/edit/10030148',
'https://arxiv.org/sword-app/edit/10030148.atom',
'http://arxiv.org/resolve/app/10030148'))
time.sleep(1)
id_tests.append(insert_into_swr_clientdata(4, 97, 1, 'test', 'test', '10030148',
'https://arxiv.org/sword-app/edit/10030148',
'https://arxiv.org/sword-app/edit/10030148.atom',
'http://arxiv.org/resolve/app/10030148'))
update_submission_status(id_tests[1], CFG_SUBMISSION_STATUS_PUBLISHED, '1003.0148')
time.sleep(1)
id_tests.append(insert_into_swr_clientdata(3, 92, 2, 'test', 'test', '12340097',
'https://arxiv.org/sword-app/edit/12340097',
'https://arxiv.org/sword-app/edit/12340097.atom',
'http://arxiv.org/resolve/app/12340097'))
time.sleep(1)
(submissions, modifications) = list_submitted_resources(0, 10, '')
self.assertEqual(len(submissions), 3)
self.assertEqual(len(modifications), 2)
self.assertEqual(submissions[1]['id_remote'], '1003.3743')
self.assertEqual(submissions[1]['status'], CFG_SUBMISSION_STATUS_PUBLISHED)
self.assertEqual(submissions[1]['publication_date'] != '', True)
self.assertEqual(submissions[2]['id_remote'], '1003.0148')
self.assertEqual(submissions[2]['status'], CFG_SUBMISSION_STATUS_PUBLISHED)
self.assertEqual(submissions[2]['publication_date'] != '', True)
self.assertEqual(submissions[0]['id_remote'], '12340097')
self.assertEqual(submissions[0]['status'], CFG_SUBMISSION_STATUS_REMOVED)
self.assertEqual(submissions[0]['removal_date'] != '', True)
self.assertEqual(modifications[1], submissions[0]['id'])
self.assertEqual(modifications[0], submissions[1]['id'])
for id_test in id_tests:
delete_from_swr_clientdata(id_test)
def test_update_submission(self):
'''Test_insert_submission - check update submission rows in swrCLIENTDATA'''
update_submission_status(self.id_tests[0], CFG_SUBMISSION_STATUS_SUBMITTED)
update_submission_status(self.id_tests[1], CFG_SUBMISSION_STATUS_PUBLISHED, '1007.0221')
update_submission_status(self.id_tests[2], CFG_SUBMISSION_STATUS_REMOVED)
rows = run_sql('''SELECT id, id_swrREMOTESERVER, id_record, report_no,
id_remote, id_user, user_name, user_email, xml_media_deposit,
xml_metadata_submit, submission_date, publication_date, removal_date,
link_medias, link_metadata, link_status, status, last_update
FROM swrCLIENTDATA''')
for row in rows:
self.assertEqual(row[0] in self.id_tests, True)
if row[0] == self.id_tests[0]:
self.assertEqual(row[1], 1)
self.assertEqual(row[2], 97)
self.assertEqual(row[4], '10030148')
self.assertEqual(row[8], 'test_media_deposit')
self.assertEqual(row[13], 'https://arxiv.org/sword-app/edit/10030148')
self.assertEqual(row[14], 'https://arxiv.org/sword-app/edit/10030148.atom')
self.assertEqual(row[15], 'http://arxiv.org/resolve/app/10030148')
self.assertEqual(row[16], CFG_SUBMISSION_STATUS_SUBMITTED)
if row[0] == self.id_tests[1]:
self.assertEqual(row[1], 1)
self.assertEqual(row[2], 92)
self.assertEqual(row[4], '1007.0221')
self.assertEqual(row[8], 'test_media_deposit')
self.assertEqual(row[13], 'https://arxiv.org/sword-app/edit/10070221')
self.assertEqual(row[14], 'https://arxiv.org/sword-app/edit/10070221.atom')
self.assertEqual(row[15], 'http://arxiv.org/resolve/app/10070221')
self.assertEqual(row[16], CFG_SUBMISSION_STATUS_PUBLISHED)
if row[0] == self.id_tests[2]:
self.assertEqual(row[1], 1)
self.assertEqual(row[2], 92)
self.assertEqual(row[4], '12340097')
self.assertEqual(row[8], 'test_media_deposit')
self.assertEqual(row[13], 'https://arxiv.org/sword-app/edit/12340097')
self.assertEqual(row[14], 'https://arxiv.org/sword-app/edit/12340097.atom')
self.assertEqual(row[15], 'http://arxiv.org/resolve/app/12340097')
self.assertEqual(row[16], CFG_SUBMISSION_STATUS_REMOVED)
def test_update_submission(self):
'''Test_insert_submission - check update submission rows in swrCLIENTDATA'''
update_submission_status(self.id_tests[0], CFG_SUBMISSION_STATUS_SUBMITTED)
update_submission_status(self.id_tests[1], CFG_SUBMISSION_STATUS_PUBLISHED, '1007.0221')
update_submission_status(self.id_tests[2], CFG_SUBMISSION_STATUS_REMOVED)
rows = run_sql('''SELECT id, id_swrREMOTESERVER, id_record, report_no,
id_remote, id_user, user_name, user_email, xml_media_deposit,
xml_metadata_submit, submission_date, publication_date, removal_date,
link_medias, link_metadata, link_status, status, last_update
FROM swrCLIENTDATA''')
for row in rows:
self.assertEqual(row[0] in self.id_tests, True)
if row[0] == self.id_tests[0]:
self.assertEqual(row[1], 1)
self.assertEqual(row[2], 97)
self.assertEqual(row[4], '10030148')
self.assertEqual(row[8], 'test_media_deposit')
self.assertEqual(row[13], 'https://arxiv.org/sword-app/edit/10030148')
self.assertEqual(row[14], 'https://arxiv.org/sword-app/edit/10030148.atom')
self.assertEqual(row[15], 'http://arxiv.org/resolve/app/10030148')
self.assertEqual(row[16], CFG_SUBMISSION_STATUS_SUBMITTED)
if row[0] == self.id_tests[1]:
self.assertEqual(row[1], 1)
self.assertEqual(row[2], 92)
self.assertEqual(row[4], '1007.0221')
self.assertEqual(row[8], 'test_media_deposit')
self.assertEqual(row[13], 'https://arxiv.org/sword-app/edit/10070221')
self.assertEqual(row[14], 'https://arxiv.org/sword-app/edit/10070221.atom')
self.assertEqual(row[15], 'http://arxiv.org/resolve/app/10070221')
self.assertEqual(row[16], CFG_SUBMISSION_STATUS_PUBLISHED)
if row[0] == self.id_tests[2]:
self.assertEqual(row[1], 1)
self.assertEqual(row[2], 92)
self.assertEqual(row[4], '12340097')
self.assertEqual(row[8], 'test_media_deposit')
self.assertEqual(row[13], 'https://arxiv.org/sword-app/edit/12340097')
self.assertEqual(row[14], 'https://arxiv.org/sword-app/edit/12340097.atom')
self.assertEqual(row[15], 'http://arxiv.org/resolve/app/12340097')
self.assertEqual(row[16], CFG_SUBMISSION_STATUS_REMOVED)