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_insert_submission(self):
'''Test_insert_submission - check insert submission rows in swrCLIENTDATA'''
self.id_tests.append(insert_into_swr_clientdata(1, 97, 'TESLA-FEL-99-07', 10030148,
'6', 'test_username', '*****@*****.**',
'test_media_deposit', 'test_media_submit',
'https://arxiv.org/sword-app/edit/10030148',
'https://arxiv.org/sword-app/edit/10030148.atom',
'http://arxiv.org/resolve/app/10030148'))
self.id_tests.append(insert_into_swr_clientdata(1, 92, 'hep-th/0606096', 10070221,
'5', 'test_username', '*****@*****.**',
'test_media_deposit', 'test_media_submit',
'https://arxiv.org/sword-app/edit/10070221',
'https://arxiv.org/sword-app/edit/10070221.atom',
'http://arxiv.org/resolve/app/10070221'))
self.id_tests.append(insert_into_swr_clientdata(1, 92, 'hep-th/0606096', 12340097,
'5', 'test_username', '*****@*****.**',
'test_media_deposit', 'test_media_submit',
'https://arxiv.org/sword-app/edit/12340097',
'https://arxiv.org/sword-app/edit/12340097.atom',
'http://arxiv.org/resolve/app/12340097'))
rows = run_sql('''SELECT * 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], '10070221')
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_SUBMITTED)
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_SUBMITTED)
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_insert_submission(self):
'''Test_insert_submission - check insert submission rows in swrCLIENTDATA'''
self.id_tests.append(
insert_into_swr_clientdata(
1, 97, 'TESLA-FEL-99-07', 10030148, '6', 'test_username',
'*****@*****.**', 'test_media_deposit',
'test_media_submit',
'https://arxiv.org/sword-app/edit/10030148',
'https://arxiv.org/sword-app/edit/10030148.atom',
'http://arxiv.org/resolve/app/10030148'))
self.id_tests.append(
insert_into_swr_clientdata(
1, 92, 'hep-th/0606096', 10070221, '5', 'test_username',
'*****@*****.**', 'test_media_deposit',
'test_media_submit',
'https://arxiv.org/sword-app/edit/10070221',
'https://arxiv.org/sword-app/edit/10070221.atom',
'http://arxiv.org/resolve/app/10070221'))
self.id_tests.append(
insert_into_swr_clientdata(
1, 92, 'hep-th/0606096', 12340097, '5', 'test_username',
'*****@*****.**', 'test_media_deposit',
'test_media_submit',
'https://arxiv.org/sword-app/edit/12340097',
'https://arxiv.org/sword-app/edit/12340097.atom',
'http://arxiv.org/resolve/app/12340097'))
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], '10070221')
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_SUBMITTED)
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_SUBMITTED)
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_insert_submission(self):
"""Test_insert_submission - check insert submission rows in swrDATA"""
self.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",
)
)
self.id_tests.append(
insert_into_swr_clientdata(
4,
92,
2,
"test",
"test",
"10070221",
"https://arxiv.org/sword-app/edit/10070221",
"https://arxiv.org/sword-app/edit/10070221.atom",
"http://arxiv.org/resolve/app/10070221",
)
)
self.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",
)
)
rows = run_sql("""SELECT * FROM swrDATA""")
for row in rows:
self.assertEqual(row[0] in self.id_tests, True)
if row[0] == self.id_tests[0]:
self.assertEqual(row[1], 4)
self.assertEqual(row[2], 97)
self.assertEqual(row[4], 1)
self.assertEqual(row[3], "10030148")
self.assertEqual(row[10], "https://arxiv.org/sword-app/edit/10030148")
self.assertEqual(row[11], "https://arxiv.org/sword-app/edit/10030148.atom")
self.assertEqual(row[12], "http://arxiv.org/resolve/app/10030148")
self.assertEqual(row[13], CFG_SUBMISSION_STATUS_SUBMITTED)
if row[0] == self.id_tests[1]:
self.assertEqual(row[1], 4)
self.assertEqual(row[2], 92)
self.assertEqual(row[4], 2)
self.assertEqual(row[3], "10070221")
self.assertEqual(row[10], "https://arxiv.org/sword-app/edit/10070221")
self.assertEqual(row[11], "https://arxiv.org/sword-app/edit/10070221.atom")
self.assertEqual(row[12], "http://arxiv.org/resolve/app/10070221")
self.assertEqual(row[13], CFG_SUBMISSION_STATUS_SUBMITTED)
if row[0] == self.id_tests[2]:
self.assertEqual(row[1], 3)
self.assertEqual(row[2], 92)
self.assertEqual(row[4], 2)
self.assertEqual(row[3], "12340097")
self.assertEqual(row[10], "https://arxiv.org/sword-app/edit/12340097")
self.assertEqual(row[11], "https://arxiv.org/sword-app/edit/12340097.atom")
self.assertEqual(row[12], "http://arxiv.org/resolve/app/12340097")
self.assertEqual(row[13], CFG_SUBMISSION_STATUS_SUBMITTED)
def test_insert_submission(self):
'''Test_insert_submission - check insert submission rows in swrCLIENTDATA'''
self.id_tests.append(
insert_into_swr_clientdata(
1, 97, 'TESLA-FEL-99-07', 10030148, '6', 'test_username',
'*****@*****.**', 'test_media_deposit',
'test_media_submit',
'https://arxiv.org/sword-app/edit/10030148',
'https://arxiv.org/sword-app/edit/10030148.atom',
'http://arxiv.org/resolve/app/10030148'))
self.id_tests.append(
insert_into_swr_clientdata(
1, 92, 'hep-th/0606096', 10070221, '5', 'test_username',
'*****@*****.**', 'test_media_deposit',
'test_media_submit',
'https://arxiv.org/sword-app/edit/10070221',
'https://arxiv.org/sword-app/edit/10070221.atom',
'http://arxiv.org/resolve/app/10070221'))
self.id_tests.append(
insert_into_swr_clientdata(
1, 92, 'hep-th/0606096', 12340097, '5', 'test_username',
'*****@*****.**', 'test_media_deposit',
'test_media_submit',
'https://arxiv.org/sword-app/edit/12340097',
'https://arxiv.org/sword-app/edit/12340097.atom',
'http://arxiv.org/resolve/app/12340097'))
rows = run_sql('''SELECT * 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], '10070221')
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_SUBMITTED)
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_SUBMITTED)
def test_insert_submission(self):
'''Test_insert_submission - check insert submission rows in swrCLIENTDATA'''
self.id_tests.append(insert_into_swr_clientdata(1, 97, 'TESLA-FEL-99-07', 10030148,
'6', 'test_username', '*****@*****.**',
'test_media_deposit', 'test_media_submit',
'https://arxiv.org/sword-app/edit/10030148',
'https://arxiv.org/sword-app/edit/10030148.atom',
'http://arxiv.org/resolve/app/10030148'))
self.id_tests.append(insert_into_swr_clientdata(1, 92, 'hep-th/0606096', 10070221,
'5', 'test_username', '*****@*****.**',
'test_media_deposit', 'test_media_submit',
'https://arxiv.org/sword-app/edit/10070221',
'https://arxiv.org/sword-app/edit/10070221.atom',
'http://arxiv.org/resolve/app/10070221'))
self.id_tests.append(insert_into_swr_clientdata(1, 92, 'hep-th/0606096', 12340097,
'5', 'test_username', '*****@*****.**',
'test_media_deposit', 'test_media_submit',
'https://arxiv.org/sword-app/edit/12340097',
'https://arxiv.org/sword-app/edit/12340097.atom',
'http://arxiv.org/resolve/app/12340097'))
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], '10070221')
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_SUBMITTED)
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_SUBMITTED)
