def write_spreadsheet(fl, compressed, site_rows, era_rows, read_rows):
fl.seek(0)
fl.truncate()
with odio.create_spreadsheet(fl, "1.2", compressed=compressed) as f:
f.append_table("Site Level", site_rows)
f.append_table("Era Level", era_rows)
f.append_table("Normal Reads", read_rows)
def test_file_not_closed(tmpdir):
fname = tmpdir.join('test.ods')
f = open(str(fname), 'wb')
with odio.create_spreadsheet(f, '1.2') as sheet:
sheet.append_table('Keats', ('Season', 'of', 'mists'))
f.seek(0)
f.close()
def test_writerow(tmpdir):
TABLE_NAME = 'Plan'
ROW = ["veni, vidi, vici", 0.3, 5, Datetime(2015, 6, 30, 16, 38), None]
fname = tmpdir.join('actual.ods')
with odio.create_spreadsheet(open(str(fname), "wb"), '1.1') as sheet:
table = sheet.append_table(TABLE_NAME)
table.append_row(ROW)
actual_dir = str(tmpdir.mkdir('actual'))
with zipfile.ZipFile(str(fname)) as z:
z.extractall(str(actual_dir))
desired_dir = str(os.path.join(os.path.dirname(__file__), 'unpacked'))
actual_walk = normalize_walk(actual_dir)
desired_walk = normalize_walk(desired_dir)
assert actual_walk == desired_walk
for i, (actual_pth, actual_dirs, actual_fls) in enumerate(actual_walk):
desired_pth, desired_dirs, desired_fls = desired_walk[i]
for j, actual_fl in enumerate(actual_fls):
desired_fl = desired_fls[j]
actual_f = open(os.path.join(actual_dir, actual_pth, actual_fl))
desired_f = open(
os.path.join(desired_dir, desired_pth, desired_fl))
assert ''.join(actual_f) == ''.join(desired_f)
sheet = odio.parse_spreadsheet(open(str(fname), 'rb'))
table = sheet.tables[0]
assert table.name == TABLE_NAME
assert table.rows[0] == ROW
def test_create_parse_spreadsheet(tmpdir):
TABLE_NAME = 'Plan'
ROW = [
"veni, vidi, vici", 0.3, 5, 5, odio.Formula('=B1 + C1'),
datetime.datetime(2015, 6, 30, 16, 38), None, "Dombey & Son", True]
fname = tmpdir.join('actual.ods')
with open(str(fname), 'wb') as f, \
odio.create_spreadsheet(f, '1.2') as sheet:
sheet.append_table(TABLE_NAME, [ROW])
actual_dir = str(tmpdir.mkdir('actual'))
with zipfile.ZipFile(str(fname)) as z:
z.extractall(actual_dir)
desired_dir = str(os.path.join(os.path.dirname(__file__), 'unpacked'))
actual_walk = normalized_walk(actual_dir)
desired_walk = normalized_walk(desired_dir)
assert actual_walk == desired_walk
for i, (actual_pth, actual_dirs, actual_fls) in enumerate(actual_walk):
desired_pth, desired_dirs, desired_fls = desired_walk[i]
for j, actual_fl in enumerate(actual_fls):
desired_fl = desired_fls[j]
actual_f = open(os.path.join(actual_dir, actual_pth, actual_fl))
desired_f = open(
os.path.join(desired_dir, desired_pth, desired_fl))
ac = ''.join(actual_f)
de = ''.join(desired_f)
print(de)
print(ac)
assert ac == de
sheet = odio.parse_spreadsheet(open(str(fname), 'rb'))
table = sheet.tables[0]
assert table.name == TABLE_NAME
assert table.rows[0] == ROW
def write_spreadsheet(fl, compressed, site_rows, era_rows):
fl.seek(0)
fl.truncate()
with odio.create_spreadsheet(fl, '1.2', compressed=compressed) as f:
f.append_table("Site Level", site_rows)
f.append_table("Era Level", era_rows)