def testReadCorrectFile(self):
reader = Reader(SAMPLE)
rows = reader.openFile()
# 6 rows
assert len(rows) == 6
for row in rows:
# 3 columns
assert len(row) == 3
def testReadCorrectFile(self):
reader = Reader(SAMPLE)
rows = reader.openFile()
# 6 rows
assert len(rows) == 6
for row in rows:
# 3 columns
assert len(row) == 3
def testWriteEmptyFile(self):
_, filename = tempfile.mkstemp('.xls')
writer = Writer(filename)
writer.saveFile()
reader = Reader(filename)
rows = reader.openFile()
assert len(rows) == 0
os.remove(filename)
def testWriteEmptyFile(self):
_, filename = tempfile.mkstemp('.xls')
writer = Writer(filename)
writer.saveFile()
reader = Reader(filename)
rows = reader.openFile()
assert len(rows) == 0
os.remove(filename)
def testWriteNullCell(self):
_, filename = tempfile.mkstemp('.xls')
writer = Writer(filename)
row0 = ['ID', 'NUMBER']
row1 = ['0', None]
writer.writeAttributeRow(0, row0)
writer.writeAttributeRow(1, row1)
writer.saveFile()
reader = Reader(filename)
rows = reader.openFile()
assert rows[1][1] == 'NULL'
os.remove(filename)
def testWriteNullCell(self):
_, filename = tempfile.mkstemp('.xls')
writer = Writer(filename)
row0 = ['ID', 'NUMBER']
row1 = ['0', None]
writer.writeAttributeRow(0, row0)
writer.writeAttributeRow(1, row1)
writer.saveFile()
reader = Reader(filename)
rows = reader.openFile()
assert rows[1][1] == 'NULL'
os.remove(filename)
def testQByteArrayCell(self):
_, filename = tempfile.mkstemp('.xls')
writer = Writer(filename)
row0 = ['ID', 'NUMBER']
row1 = [QByteArray('0'), QByteArray('42')]
writer.writeAttributeRow(0, row0)
writer.writeAttributeRow(1, row1)
writer.saveFile()
reader = Reader(filename)
rows = reader.openFile()
assert rows[1][0] == 0
assert rows[1][1] == 42
os.remove(filename)
def testQByteArrayCell(self):
_, filename = tempfile.mkstemp('.xls')
writer = Writer(filename)
row0 = ['ID', 'NUMBER']
row1 = [QByteArray('0'), QByteArray('42')]
writer.writeAttributeRow(0, row0)
writer.writeAttributeRow(1, row1)
writer.saveFile()
reader = Reader(filename)
rows = reader.openFile()
assert rows[1][0] == 0
assert rows[1][1] == 42
os.remove(filename)
def testWriteCorrectFile(self):
_, filename = tempfile.mkstemp('.xls')
writer = Writer(filename)
row0 = ['ID', 'NUMBER']
row1 = ['0', '42']
writer.writeAttributeRow(0, row0)
writer.writeAttributeRow(1, row1)
writer.saveFile()
reader = Reader(filename)
rows = reader.openFile()
assert len(rows) == 2
assert rows[0] == row0
assert rows[1][0] == 0
assert rows[1][1] == 42
os.remove(filename)
def testWriteCorrectFile(self):
_, filename = tempfile.mkstemp('.xls')
writer = Writer(filename)
row0 = ['ID', 'NUMBER']
row1 = ['0', '42']
writer.writeAttributeRow(0, row0)
writer.writeAttributeRow(1, row1)
writer.saveFile()
reader = Reader(filename)
rows = reader.openFile()
assert len(rows) == 2
assert rows[0] == row0
assert rows[1][0] == 0
assert rows[1][1] == 42
os.remove(filename)
def testReadEmptyFile(self):
reader = Reader(EMPTY)
rows = reader.openFile()
assert len(rows) == 0
def testReadEmptyFile(self):
reader = Reader(EMPTY)
rows = reader.openFile()
assert len(rows) == 0
