def test_xlsx_types(self, open_workbook, ext):
with open_workbook(get_file('types', ext)) as workbook:
self.assert_workbooks_equal(
workbook,
Workbook(worksheets=[
make_worksheet(title='Sheet1',
rows=[
['String', 'Danny'],
['Date', date(1988, 7, 7)],
['Date Time',
datetime(2016, 1, 1, 12, 0)],
['Time', time(12, 0)],
[
'Midnight',
date(1899, 12, 30) if ext ==
'xlsx' else time(0, 0)
],
['Int', 28],
['Int.0', 5],
['Float', 5.1],
['Bool-F', False],
['Bool-T', True],
['Empty', None],
['Percent', 0.49],
['Calculation', 2],
['Styled', 'Styled'],
['Empty Date', None],
]),
]))
def _import_case_type(domain, case_type, csv_filename, user):
headers, rows = _read_csv(csv_filename)
worksheet = WorksheetWrapper(make_worksheet([headers] + rows))
config = _get_importer_config(case_type, headers, user._id)
res = do_import(worksheet, config, domain)
if res['errors']:
raise Exception(res)
def test_xlsx_types(self, open_workbook, ext):
with open_workbook(get_file("types", ext)) as workbook:
self.assert_workbooks_equal(
workbook,
Workbook(
worksheets=[
make_worksheet(
title="Sheet1",
rows=[
[u"String", u"Danny"],
[u"Date", date(1988, 7, 7)],
[u"Date Time", datetime(2016, 1, 1, 12, 0)],
[u"Time", time(12, 0)],
[u"Midnight", time(0, 0)],
[u"Int", 28],
[u"Int.0", 5],
[u"Float", 5.1],
[u"Bool-F", False],
[u"Bool-T", True],
[u"Empty", None],
[u"Percent", 0.49],
[u"Calculation", 2],
[u"Styled", u"Styled"],
[u"Empty Date", None],
],
)
]
),
)
def test_csv_types(self, open_workbook, ext):
with open_workbook(get_file('types', ext)) as workbook:
self.assert_workbooks_equal(
workbook,
Workbook(
worksheets=[
make_worksheet(title='Sheet1', rows=[
['String', 'Danny'],
['Date', '7/7/1988'],
['Date Time', '1/1/2016 12:00'],
['Time', '12:00 PM'],
['Midnight', '12:00 AM'],
['Int', '28'],
['Int.0', '5.0'],
['Float', '5.1'],
['Bool-F', 'FALSE'],
['Bool-T', 'TRUE'],
['Empty', ''],
['Percent', '49%'],
['Calculation', '2'],
['Styled', 'Sطαйλד tэξţ'],
['Empty Date', ''],
]),
]
)
)
def test_xlsx_types(self, open_workbook, ext):
with open_workbook(get_file('types', ext)) as workbook:
self.assert_workbooks_equal(
workbook,
Workbook(
worksheets=[
make_worksheet(title='Sheet1', rows=[
['String', 'Danny'],
['Date', date(1988, 7, 7)],
['Date Time', datetime(2016, 1, 1, 12, 0)],
['Time', time(12, 0)],
['Midnight', date(1899, 12, 30) if ext == 'xlsx' else time(0, 0)],
['Int', 28],
['Int.0', 5],
['Float', 5.1],
['Bool-F', False],
['Bool-T', True],
['Empty', None],
['Percent', 0.49],
['Calculation', 2],
['Styled', 'Styled'],
['Empty Date', None],
]),
]
)
)
def make_worksheet_wrapper(*rows):
return WorksheetWrapper(make_worksheet(rows))
def make_worksheet_wrapper(*rows):
return WorksheetWrapper(make_worksheet(rows))
