1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
|
"""Test for miscellaneous sql queries in widgets
Please note that such use is deprecated.
"""
import unittest
from Orange.data.sql.table import SqlTable
from Orange.preprocess import Discretize
from Orange.preprocess.discretize import EqualFreq
from Orange.tests.sql.base import DataBaseTest as dbt
try:
from Orange.widgets.visualize.owmosaic import get_conditional_distribution
from Orange.widgets.visualize.utils.lac import \
create_sql_contingency, get_bin_centers
except ImportError:
no_widgets = True
else:
no_widgets = False
class MiscSqlTests(unittest.TestCase, dbt):
def setUpDB(self):
self.conn, self.iris = self.create_iris_sql_table()
def tearDownDB(self):
self.drop_iris_sql_table()
@dbt.run_on(["postgres"])
def test_discretization(self):
iris = SqlTable(self.conn, self.iris, inspect_values=True)
sepal_length = iris.domain["sepal length"]
EqualFreq(n=4)(iris, sepal_length)
@dbt.run_on(["postgres"])
@unittest.skipIf(no_widgets, "Cannot import widgets")
def test_get_conditional_distribution(self):
iris = SqlTable(self.conn, self.iris, inspect_values=True)
sepal_length = iris.domain["sepal length"]
get_conditional_distribution(iris, [sepal_length])
get_conditional_distribution(iris, list(iris.domain.variables))
@dbt.run_on(["postgres"])
@unittest.skipIf(no_widgets, "Cannot import widgets")
def test_create_sql_contingency(self):
iris = SqlTable(self.conn, self.iris, inspect_values=True)
d_iris = Discretize()(iris)
create_sql_contingency(d_iris, [0, 1], get_bin_centers(d_iris))
|
