actually check the result of some Session IO to xlsx tests

gdementen · gdementen · commit 3372fb925f1d · 2017-05-04T12:17:42.000+02:00
(ie check that array order is preserved)
diff --git a/larray/tests/test_session.py b/larray/tests/test_session.py
@@ -146,7 +146,11 @@ def test_h5_io(self):
         self.assertEqual(list(s.keys()), ['e', 'f'])
 
     def test_xlsx_pandas_io(self):
-        self.session.save(abspath('test_session.xlsx'), engine='pandas_excel')
+        fpath = abspath('test_session.xlsx')
+        self.session.save(fpath, engine='pandas_excel')
+        s = Session()
+        s.load(fpath, engine='pandas_excel')
+        self.assertEqual(list(s.keys()), ['e', 'g', 'f'])
 
         fpath = abspath('test_session_ef.xlsx')
         self.session.save(fpath, ['e', 'f'], engine='pandas_excel')
@@ -156,7 +160,12 @@ def test_xlsx_pandas_io(self):
 
     @pytest.mark.skipif(xw is None, reason="xlwings is not available")
     def test_xlsx_xlwings_io(self):
-        self.session.save(abspath('test_session_xw.xlsx'), engine='xlwings_excel')
+        fpath = abspath('test_session_xw.xlsx')
+        self.session.save(fpath, engine='xlwings_excel')
+        s = Session()
+        s.load(fpath, engine='xlwings_excel')
+        # ordering is only kept if the file did not exist previously (otherwise the ordering is left intact)
+        self.assertEqual(list(s.keys()), ['e', 'g', 'f'])
 
         fpath = abspath('test_session_ef_xw.xlsx')
         self.session.save(fpath, ['e', 'f'], engine='xlwings_excel')
