def _convert_results(self): from osweb import data from datamatrix import io jatos_results_path = QFileDialog.getOpenFileName( self.main_window, _(u'Select JATOS results file…'), filter=u'JATOS results (*.txt)') if isinstance(jatos_results_path, tuple): jatos_results_path = jatos_results_path[0] if not jatos_results_path: return self.main_window.set_busy(True) try: dm = data.parse_jatos_results(jatos_results_path) finally: self.main_window.set_busy(False) export_path = QFileDialog.getSaveFileName( self.main_window, _(u'Save as…'), filter=u'Excel (*.xlsx);;CSV (*.csv)') if isinstance(export_path, tuple): export_path = export_path[0] if not export_path: return if export_path.lower().endswith(u'.xlsx'): io.writexlsx(dm, export_path) else: io.writetxt(dm, export_path)
def test_io(): refdm = DataMatrix(length=3) refdm[u'tést'] = 1, 2, u'' refdm.B = u'mathôt', u'b', u'x' refdm.C = u'a,\\b"\'c', 8, u'' testdm = io.readtxt('testcases/data/data.csv') check_dm(refdm, testdm) io.writetxt(testdm, 'tmp.csv') testdm = io.readtxt('tmp.csv') check_dm(refdm, testdm) refdm = io.readtxt('testcases/data/line-ending-cr.csv') check_dm(refdm, testdm) refdm = io.readtxt('testcases/data/line-ending-crlf.csv') check_dm(refdm, testdm) io.writepickle(testdm, 'tmp.pickle') testdm = io.readpickle('tmp.pickle') check_dm(refdm, testdm) io.writexlsx(testdm, 'tmp.xlsx') testdm = io.readxlsx('tmp.xlsx') check_dm(refdm, testdm)
def test_io(): refdm = DataMatrix(length=3) refdm[u'tést'] = 1, 2, u'' refdm.B = u'mathôt', u'b', u'x' refdm.C = u'a,\\b"\'c', 8, u'' testdm = io.readtxt('testcases/data/data.csv') check_dm(refdm, testdm) io.writetxt(testdm, 'tmp.csv') testdm = io.readtxt('tmp.csv') check_dm(refdm, testdm) refdm = io.readtxt('testcases/data/line-ending-cr.csv') check_dm(refdm, testdm) refdm = io.readtxt('testcases/data/line-ending-crlf.csv') check_dm(refdm, testdm) refdm = io.readtxt('testcases/data/data-with-bom.csv') check_dm(refdm, testdm) io.writepickle(testdm, 'tmp.pickle') testdm = io.readpickle('tmp.pickle') check_dm(refdm, testdm) io.writexlsx(testdm, 'tmp.xlsx') with pytest.warns(UserWarning): # Not all rows have column C testdm = io.readxlsx('tmp.xlsx') check_dm(refdm, testdm) io.writexlsx(testdm, 'tmp.xlsx') with pytest.warns(UserWarning): # Not all rows have column C testdm = io.readxlsx('tmp.xlsx') check_dm(refdm, testdm)
def test_io(): refdm = DataMatrix(length=3) refdm[u'tést'] = 1, 2, u'' refdm.B = u'mathôt', u'b', u'x' refdm.C = u'a,\\b"\'c', 8, u'' testdm = io.readtxt('testcases/data/data.csv') check_dm(refdm, testdm) io.writetxt(testdm, 'tmp.csv') testdm = io.readtxt('tmp.csv') check_dm(refdm, testdm) io.writepickle(testdm, 'tmp.pickle') testdm = io.readpickle('tmp.pickle') check_dm(refdm, testdm) io.writexlsx(testdm, 'tmp.xlsx') testdm = io.readxlsx('tmp.xlsx') check_dm(refdm, testdm)
def _convert_results(self): from osweb import data from datamatrix import io jatos_results_path = QFileDialog.getOpenFileName( self.main_window, _(u'Select JATOS results file…'), filter=u'JATOS results (*.*)') if isinstance(jatos_results_path, tuple): jatos_results_path = jatos_results_path[0] if not jatos_results_path: return self.main_window.set_busy(True) try: dm = data.parse_jatos_results( jatos_results_path, include_context=cfg.oswebext_include_context) except UnicodeDecodeError: self.extension_manager.fire('notify', message=_('File is not utf-8 encoded'), category='warning') return finally: self.main_window.set_busy(False) export_path = QFileDialog.getSaveFileName( self.main_window, _(u'Save as…'), filter=u'Excel (*.xlsx);;CSV (*.csv)') if isinstance(export_path, tuple): export_path = export_path[0] if not export_path: return if export_path.lower().endswith(u'.xlsx'): io.writexlsx(dm, export_path) else: io.writetxt(dm, export_path)