示例#1
0
    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)
示例#2
0
    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)
示例#3
0
    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)
示例#4
0
    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)