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