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])
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])
