def test_XY_large(self): mat = np.random.randint(0, 2, (1020, 3)) uri = self.create_sql_table(mat) sql_table = SqlTable(uri, type_hints=Domain([], DiscreteVariable( name='col2', values=['0', '1', '2']))) with self.assertRaises(ValueError): sql_table.X with self.assertRaises(ValueError): sql_table.Y with self.assertRaises(ValueError): sql_table.download_data(1019) sql_table.download_data() assert_almost_equal(sql_table.X, mat[:,:2]) assert_almost_equal(sql_table.Y.flatten(), mat[:, 2])
def test_XY_large(self): mat = np.random.randint(0, 2, (1020, 3)) conn, table_name = self.create_sql_table(mat) sql_table = SqlTable(conn, table_name, type_hints=Domain([], DiscreteVariable( name='col2', values=['0', '1', '2']))) with self.assertRaises(ValueError): sql_table.X with self.assertRaises(ValueError): sql_table.Y with self.assertRaises(ValueError): sql_table.download_data(1019) sql_table.download_data() assert_almost_equal(sql_table.X, mat[:, :2]) assert_almost_equal(sql_table.Y.flatten(), mat[:, 2])
def test_XY_large(self): from Orange.data.sql.table import AUTO_DL_LIMIT as DLL mat = np.random.randint(0, 2, (DLL + 100, 3)) conn, table_name = self.create_sql_table(mat) sql_table = SqlTable(conn, table_name, type_hints=Domain([], DiscreteVariable( name='col2', values=['0', '1', '2']))) with self.assertRaises(ValueError): sql_table.X with self.assertRaises(ValueError): sql_table.Y with self.assertRaises(ValueError): sql_table.download_data(DLL + 10) # Download partial data sql_table.download_data(DLL + 10, partial=True) assert_almost_equal(sql_table.X, mat[:DLL + 10, :2]) assert_almost_equal(sql_table.Y.flatten()[:DLL + 10], mat[:DLL + 10, 2]) # Download all data sql_table.download_data() assert_almost_equal(sql_table.X, mat[:, :2]) assert_almost_equal(sql_table.Y.flatten(), mat[:, 2])