From ca8dbcf9bea46607d22fe205498b4c071c705860 Mon Sep 17 00:00:00 2001 From: Claude Paroz Date: Fri, 4 Oct 2019 23:23:43 +0200 Subject: Refs #108 - Test and improve format autodetection Autodetection was added for the odf format. --- test_tablib.py | 26 +++++++++++++++++++++----- 1 file changed, 21 insertions(+), 5 deletions(-) (limited to 'test_tablib.py') diff --git a/test_tablib.py b/test_tablib.py index f15724d..216ca88 100755 --- a/test_tablib.py +++ b/test_tablib.py @@ -288,17 +288,33 @@ class TablibTestCase(BaseTestCase): def test_auto_format_detect(self): """Test auto format detection.""" + # html, jira, latex, rst are export only. + + _xls = self.founders.export('xls') + self.assertEqual(tablib.detect_format(_xls), 'xls') + + _xlsx = self.founders.export('xlsx') + self.assertEqual(tablib.detect_format(_xlsx), 'xlsx') + + _ods = self.founders.export('ods') + self.assertEqual(tablib.detect_format(_ods), 'ods') + + _df = self.founders.export('df') + self.assertEqual(tablib.detect_format(_df), 'df') _yaml = '- {age: 90, first_name: John, last_name: Adams}' + self.assertEqual(tablib.detect_format(_yaml), 'yaml') + _json = '[{"last_name": "Adams","age": 90,"first_name": "John"}]' - _csv = '1,2,3\n4,5,6\n7,8,9\n' - _tsv = '1\t2\t3\n4\t5\t6\n7\t8\t9\n' - _bunk = '¡¡¡¡¡¡---///\n\n\n¡¡£™∞¢£§∞§¶•¶ª∞¶•ªº••ª–º§•†•§º¶•†¥ª–º•§ƒø¥¨©πƒø†ˆ¥ç©¨√øˆ¥≈†ƒ¥ç©ø¨çˆ¥ƒçø¶' + self.assertEqual(tablib.detect_format(_json), 'json') - self.assertEqual(tablib.detect_format(_yaml), 'yaml') + _csv = '1,2,3\n4,5,6\n7,8,9\n' self.assertEqual(tablib.detect_format(_csv), 'csv') + + _tsv = '1\t2\t3\n4\t5\t6\n7\t8\t9\n' self.assertEqual(tablib.detect_format(_tsv), 'tsv') - self.assertEqual(tablib.detect_format(_json), 'json') + + _bunk = '¡¡¡¡¡¡---///\n\n\n¡¡£™∞¢£§∞§¶•¶ª∞¶•ªº••ª–º§•†•§º¶•†¥ª–º•§ƒø¥¨©πƒø†ˆ¥ç©¨√øˆ¥≈†ƒ¥ç©ø¨çˆ¥ƒçø¶' self.assertEqual(tablib.detect_format(_bunk), None) def test_transpose(self): -- cgit v1.2.1