def _create_test_content(self):
"""
This method can be used to set up some test content. The method
may be called from various test case, but not all (if they require
very special test data).
"""
self.page = create(Builder('sl content page'))
slick_config = json.dumps(
{'arrows': 'false', 'autoplaySpeed': 1000, 'autoplay': 'false'}
)
block_builder = Builder('sliderblock')
block_builder.within(self.page)
block_builder.titled('SliderBlock title')
block_builder.having(slick_config=slick_config)
self.block = create(block_builder)
create(Builder('slider pane')
.within(self.block)
.titled(u'Pane 1')
.with_dummy_image())
create(Builder('slider pane')
.within(self.block)
.titled(u'Pane 2')
.with_dummy_image())
def test_xls_in_zip_file(self, browser):
ticket_builder = Builder('ticket')
ticket_builder.titled(u'T\xc3st')
ticket_builder.with_id('1')
ticket_builder.having(dueDate=DateTime(2011, 11, 10, 17, 14, 35),
ticket_description='<p>This is a<br />test.</p>')
ticket_builder.within(self.ticketbox)
with freeze(datetime(2011, 2, 3, 5, 7, 11)):
create(ticket_builder)
browser.login()
browser.visit(self.ticketbox, view='zip_export')
self.assertEquals('application/zip', browser.headers['Content-Type'])
zipfile = ZipFile(StringIO(browser.contents))
self.assertEquals(['ticketbox.xlsx'], zipfile.namelist())
xlsx = zipfile.read('ticketbox.xlsx')
workbook = open_workbook(file_contents=xlsx)
sheet = workbook.sheet_by_index(0)
data = map(sheet.row_values, range(sheet.nrows))
headers = data.pop(0)
data = map(
lambda row: dict(zip(headers, row)),
data
)
self.maxDiff = None
self.assertEquals(
first=[
{
u'Created': u'03.02.2011 05:07',
u'Due date': u'10.11.2011 17:14',
u'No.': u'1',
u'Description': u' This is a test. ',
u'Releases': u'',
u'Creator': u'test_user_1_',
u'Responsible': u'',
u'Watched release': u'',
u'Priorities': u'',
u'State': u'',
u'Variety': u'',
u'Title': u'T\xc3st',
u'Area': u'',
}
],
second=data
)
def test_xlsx_export(self):
ticketbox = create(Builder('ticket box')
.titled(u'My Tickät Box'))
ticket_builder = Builder('ticket')
ticket_builder.titled(u'Täst')
ticket_builder.with_id('1')
ticket_builder.having(dueDate=DateTime(2010, 11, 10, 17, 14, 35),
ticket_description="<p>This is a<br />test.</p>")
ticket_builder.within(ticketbox)
with freeze(datetime(2010, 11, 1, 8, 25, 20)):
create(ticket_builder)
export_view = ticketbox.restrictedTraverse('tickets_export_xlsx')
response = export_view()
workbook = open_workbook(file_contents=response)
sheet = workbook.sheet_by_index(0)
data = map(sheet.row_values, range(sheet.nrows))
headers = data.pop(0)
data = map(
lambda row: dict(zip(headers, row)),
data
)
self.maxDiff = None
self.assertEquals(
first=[
{
u'Created': u'01.11.2010 08:25',
u'Due date': u'10.11.2010 17:14',
u'No.': u'1',
u'Description': u' This is a test. ',
u'Releases': u'',
u'Creator': u'test_user_1_',
u'Responsible': u'',
u'Watched release': u'',
u'Priorities': u'',
u'State': u'',
u'Variety': u'',
u'Title': u'Täst',
u'Area': u'',
}
],
second=data
)
