def test_input_and_output_character_encoding_in_method_to_csv(self):
temp_fp = tempfile.NamedTemporaryFile(delete=False)
temp_fp.close()
my_table = Table(headers=['Álvaro'.decode('utf8').encode('utf16')],
input_encoding='utf16', output_encoding='iso-8859-1')
my_table.rows.append(['Píton'.decode('utf8').encode('utf16')])
my_table.to_csv(temp_fp.name)
fp = open(temp_fp.name)
file_contents = fp.read()
fp.close()
os.remove(temp_fp.name)
output = '"Álvaro"\n"Píton"\n'.decode('utf8').encode('iso-8859-1')
self.assertEqual(file_contents, output)
def test_output_to_csv_should_create_the_file_correctly_with_headers(self):
temp_fp = tempfile.NamedTemporaryFile()
temp_fp.close()
my_table = Table(headers=['ham', 'spam', 'eggs'])
my_table.rows.append({'ham': 'ham spam ham', 'spam': 'spam eggs spam',
'eggs': 'eggs ham eggs'})
my_table.to_csv(temp_fp.name)
fp = open(temp_fp.name)
contents = fp.read()
fp.close()
os.remove(temp_fp.name)
self.assertEquals(contents, dedent('''\
"ham","spam","eggs"
"ham spam ham","spam eggs spam","eggs ham eggs"
'''))
#!/usr/bin/env python
# coding: utf-8
from outputty import Table
my_table = Table(headers=['First name', 'Last name'])
my_table.rows.append({'First name': 'Álvaro', 'Last name': 'Justen'})
my_table.rows.append(['Tatiana', 'Al-Chueyr'])
my_table.rows.append(('Flávio', 'Amieiro'))
my_table.to_csv('my-data.csv')
print my_table
