def test_get_election0_xlsx(self):
        response = self.client.get(
            reverse('results-export'),
            { 'election': str(Election.objects.get(name='Election 0').id) }
        )

        self.assertEqual(response.status_code, 200)        

        self.assertEqual(
            response['Content-Disposition'],
            'attachment; filename="Election 0 Results.xlsx"'
        )

        wb = openpyxl.load_workbook(io.BytesIO(response.content))

        self.assertEqual(len(wb.worksheets), 1)

        # Check first worksheet.
        ws = wb.worksheets[0]

        self.assertEqual(wb.sheetnames[0], 'Election 0')

        row_count = ws.max_row
        col_count = ws.max_column
        self.assertEqual(row_count, 25)
        self.assertEqual(col_count, 5)

        self.assertEqual(str(ws.cell(1, 1).value), 'Election 0 Results')

        self.assertEqual(str(ws.cell(2, 1).value), 'Candidates')

        cellContents = [
            'Position 0',
            'Party 0',
            '0, 0',
            'Party 1',
            '3, 3',
            'Party 2',
            'None',
            'Position 1',
            'Party 0',
            '1, 1',
            'Party 1',
            '4, 4',
            'Party 2',
            'None',
            'Position 2',
            'Party 0',
            '2, 2',
            'Party 1',
            '5, 5',
            'Party 2',
            'None'
        ]
        for cellIndex, content in enumerate(cellContents, 5):
            self.assertEqual(str(ws.cell(cellIndex, 1).value), content) 

        self.assertEqual(str(ws.cell(2, 2).value), 'Number of Votes')

        self.assertEqual(str(ws.cell(3, 2).value), '0')

        self.assertEqual(str(ws.cell(4, 2).value), '0') # Section

        self.assertEqual(str(ws.cell(7, 2).value), '1')
        self.assertEqual(str(ws.cell(9, 2).value), '0')
        self.assertEqual(str(ws.cell(11, 2).value), 'N/A')
        self.assertEqual(str(ws.cell(14, 2).value), '2')
        self.assertEqual(str(ws.cell(16, 2).value), '0')
        self.assertEqual(str(ws.cell(18, 2).value), 'N/A')
        self.assertEqual(str(ws.cell(21, 2).value), '0')
        self.assertEqual(str(ws.cell(23, 2).value), '0')
        self.assertEqual(str(ws.cell(25, 2).value), 'N/A')

        self.assertEqual(str(ws.cell(4, 3).value), '1') # Section

        self.assertEqual(str(ws.cell(7, 3).value), '0')
        self.assertEqual(str(ws.cell(9, 3).value), '1')
        self.assertEqual(str(ws.cell(11, 2).value), 'N/A')
        self.assertEqual(str(ws.cell(14, 3).value), '0')
        self.assertEqual(str(ws.cell(16, 3).value), '0')
        self.assertEqual(str(ws.cell(18, 2).value), 'N/A')
        self.assertEqual(str(ws.cell(21, 3).value), '1')
        self.assertEqual(str(ws.cell(23, 3).value), '0')
        self.assertEqual(str(ws.cell(25, 2).value), 'N/A')

        self.assertEqual(str(ws.cell(3, 4).value), '1')

        self.assertEqual(str(ws.cell(4, 4).value), '2') # Section

        self.assertEqual(str(ws.cell(7, 4).value), '0')
        self.assertEqual(str(ws.cell(9, 4).value), '0')
        self.assertEqual(str(ws.cell(11, 2).value), 'N/A')
        self.assertEqual(str(ws.cell(14, 4).value), '0')
        self.assertEqual(str(ws.cell(16, 4).value), '1')
        self.assertEqual(str(ws.cell(18, 2).value), 'N/A')
        self.assertEqual(str(ws.cell(21, 4).value), '0')
        self.assertEqual(str(ws.cell(23, 4).value), '1')
        self.assertEqual(str(ws.cell(25, 2).value), 'N/A')

        self.assertEqual(str(ws.cell(3, 5).value), 'Total Votes')
        self.assertEqual(str(ws.cell(7, 5).value), '1')
        self.assertEqual(str(ws.cell(9, 5).value), '1')
        self.assertEqual(str(ws.cell(11, 2).value), 'N/A')
        self.assertEqual(str(ws.cell(14, 5).value), '2')
        self.assertEqual(str(ws.cell(16, 5).value), '1')
        self.assertEqual(str(ws.cell(18, 2).value), 'N/A')
        self.assertEqual(str(ws.cell(21, 5).value), '1')
        self.assertEqual(str(ws.cell(23, 5).value), '1')
        self.assertEqual(str(ws.cell(25, 2).value), 'N/A')
def testProvenanceItemFiles(self):
        """
        Test item provenance when adding, modifying, and deleting files.
        """
        item = self.item1
        admin = self.admin

        # Test adding a new file to an existing item
        fileData1 = 'Hello world'
        fileData2 = 'Hello world, again'
        fileName1 = 'helloWorld.txt'
        fileName2 = 'helloWorldEdit.txt'
        resp = self.request(
            path='/file', method='POST', user=admin, params={
                'parentType': 'item',
                'parentId': item['_id'],
                'name': fileName1,
                'size': len(fileData1),
                'mimeType': 'text/plain'
            })
        self.assertStatusOk(resp)
        uploadId = resp.json['_id']
        fields = [('offset', 0), ('uploadId', uploadId)]
        files = [('chunk', fileName1, fileData1)]
        resp = self.multipartRequest(
            path='/file/chunk', user=admin, fields=fields, files=files)
        self.assertStatusOk(resp)
        file1 = resp.json
        self._checkProvenance(None, item, 2, admin, 'fileAdded',
                              fileInfo={'fileId': str(file1['_id']),
                                        'new': {'mimeType': 'text/plain',
                                                'size': len(fileData1),
                                                'name': fileName1}})
        # Edit the file name
        resp = self.request(path='/file/%s' % file1['_id'], method='PUT',
                            user=admin, params={'name': fileName2})
        self.assertStatusOk(resp)
        self._checkProvenance(None, item, 3, admin, 'fileUpdate',
                              fileInfo={'fileId': str(file1['_id']),
                                        'old': {'name': fileName1},
                                        'new': {'name': fileName2}})
        # Reupload the file
        resp = self.request(path='/file/%s/contents' % file1['_id'],
                            method='PUT', user=admin,
                            params={'size': len(fileData2)})
        self.assertStatusOk(resp)
        uploadId = resp.json['_id']
        fields = [('offset', 0), ('uploadId', uploadId)]
        files = [('chunk', fileName1, fileData2)]
        resp = self.multipartRequest(
            path='/file/chunk', user=admin, fields=fields, files=files)
        self.assertStatusOk(resp)
        self.assertEqual(file1['_id'], resp.json['_id'])
        self._checkProvenance(None, item, 4, admin, 'fileUpdate',
                              fileInfo={'fileId': str(file1['_id']),
                                        'old': {'size': len(fileData1)},
                                        'new': {'size': len(fileData2)}})
        # Delete the file
        resp = self.request(path='/file/%s' % file1['_id'],
                            method='DELETE', user=admin)
        self.assertStatusOk(resp)
        self._checkProvenance(None, item, 5, admin, 'fileRemoved',
                              fileInfo={'fileId': str(file1['_id']),
                                        'old': {'size': len(fileData2),
                                                'name': fileName2}})