import unittest

from meerkat_abacus import model
from meerkat_abacus.codes.to_codes import to_code
from meerkat_abacus.codes.variable import Variable
from geoalchemy2.shape import from_shape
from shapely.geometry import Polygon

# Data for the tests
class ToCodeTest(unittest.TestCase):
    """
    Test the to_code functionality
    """

    def setUp(self):
        locations = {1: model.Locations(name="Demo", id=1),
             2: model.Locations(
                 name="Region 1", parent_location=1, id=2),
             3: model.Locations(
                 name="Region 2", parent_location=1, id=3),
             4: model.Locations(
                 name="District 1", parent_location=2,
                 level="district", id=4,
                 area=from_shape(Polygon([(0, 0), (0, 0.4), (0.2, 0.4),
                                          (0.2, 0), (0, 0)]))
             ),
             5: model.Locations(
                 name="District 2", parent_location=3,
                 level="district", id=5,
                 area=from_shape(Polygon([(0.2, 0.4), (0.4, 0.4), (0.4, 0),
                                          (0.2, 0), (0.2, 0.4)]))),
             6: model.Locations(
                 name="Clinic 1", parent_location=4, id=6),
             7: model.Locations(
                 name="Clinic 2", parent_location=5, id=7),
             8: model.Locations(
                 name="Clinic with no district", parent_location=2, id=8)}
        locations_by_deviceid = {"1": 6, "2": 7, "3": 8}
        zones = []
        regions = [2, 3]
        districts = [4, 5]
        agg_variables = [
            model.AggregationVariables(
                id=1, method="not_null", db_column="index", condition="",
                category=[],
                form="form1"),
            model.AggregationVariables(
                id=2,
                method="match",
                db_column="column1",
                alert=1,
                category=[],
                alert_type="individual",
                condition="A",
                form="form1"),
            model.AggregationVariables(
                id=3,
                category=[],
                method="sub_match",
                db_column="column2",
                condition="B",
                form="form1"),
            model.AggregationVariables(
                id=4,
                category=[],
                method="between",
                calculation="column3",
                db_column="column3",
                condition="5,10",
                disregard=1,
                form="form1")
        ]
        self.alert_data = {"form1": {"column1": "column1"}}

        devices = {"1": [], "2": [], "3": [], "4": [], "5": [],
                   "6": [], "7": [], "8": []}
        self.all_locations = (locations, locations_by_deviceid, zones, regions, districts, devices)

        self.variables = {"case": {1: {}, 2: {}, 3: {}, 4: {}}}
        self.variables_forms = {}
        self.variables_test = {}
        self.variables_groups = {}
        self.mul_forms = []
        for av in agg_variables:
            self.variables["case"][av.id][av.id] = Variable(av)
            self.variables_forms[av.id] = "form1"
            self.variables_test[av.id] = self.variables["case"][av.id][av.id].test
            self.variables_groups[av.id] = [av.id]

    def tearDown(self):
        pass

    def test_location_information(self):
        """
        Testing that all the location infomation is translated correctly
        """
        row = {"form1":
               {"index": 1,
                "column1": "A",
                "column2": "B34",
                "column3": "7",
                "date": "2015-10-25",
                "deviceid": "1",
                "meta/instanceID": "a"},
        "original_form": "form1"}
        var, category, ret_location, disregarded = to_code(
            row,
            (self.variables, self.variables_forms, self.variables_test, self.variables_groups, {}),
            self.all_locations, "case",  self.alert_data, self.mul_forms, "deviceid")
        self.assertEqual(ret_location["country"], 1)
        self.assertEqual(ret_location["region"], 2)
        self.assertEqual(ret_location["district"], 4)
        self.assertEqual(ret_location["clinic"], 6)
        self.assertEqual(ret_location["device_id"], '1')

        row["form1"]["deviceid"] = "2"
        var, category, ret_location, disregard = to_code(
            row,
            (self.variables, self.variables_forms, self.variables_test, self.variables_groups, {}),
            self.all_locations, "case",  self.alert_data, self.mul_forms, "deviceid")
        self.assertEqual(ret_location["country"], 1)
        self.assertEqual(ret_location["region"], 3)
        self.assertEqual(ret_location["district"], 5)
        self.assertEqual(ret_location["device_id"], '2')

        row["form1"]["deviceid"] = "3"
        var, category, ret_location, disregard = to_code(
            row,
            (self.variables, self.variables_forms, self.variables_test, self.variables_groups, {}),
            self.all_locations, "case",  self.alert_data, self.mul_forms, "deviceid")
        self.assertEqual(ret_location["country"], 1)
        self.assertEqual(ret_location["region"], 2)
        self.assertEqual(ret_location["district"], None)
        self.assertEqual(ret_location["device_id"], '3')
        row["form1"]["deviceid"] = "99"
        var, category, ret_location, disregard = to_code(
            row,
            (self.variables, self.variables_forms, self.variables_test, self.variables_groups, {}),
            self.all_locations, "case", self.alert_data, self.mul_forms, "deviceid")
        self.assertEqual(ret_location, None)

        # Test gps in district
        row = {"form1":
               {"index": 1,
                "column1": "A",
                "column2": "B34",
                "column3": "7",
                "lat": "0.1",
                "lng": "0.1",
                "date": "2015-10-25",
                "deviceid": "1",
                "meta/instanceID": "a"},
                "original_form": "form1"}
        var, category, ret_location, disregard = to_code(
            row,
            (self.variables, self.variables_forms, self.variables_test, self.variables_groups, {}),
            self.all_locations, "case",  self.alert_data, self.mul_forms,
            "in_geometry$lat,lng")
        
        self.assertEqual(ret_location["district"], 4)
        self.assertEqual(ret_location["region"], 2)
        self.assertEqual(ret_location["clinic"], None)
        row = {"form1":
               {"index": 1,
                "column1": "A",
                "column2": "B34",
                "column3": "7",
                "lat": "0.3",
                "lng": "0.1",
                "date": "2015-10-25",
                "deviceid": "1",
                "meta/instanceID": "a"},
                "original_form": "form1"}
        var, category, ret_location, disregard = to_code(
            row,
            (self.variables, self.variables_forms, self.variables_test, self.variables_groups, {}),
            self.all_locations, "case",  self.alert_data, self.mul_forms,
            "in_geometry$lat,lng")
        
        self.assertEqual(ret_location["district"], 5)
        self.assertEqual(ret_location["region"], 3)
        self.assertEqual(ret_location["clinic"], None)
        row = {"form1":
               {"index": 1,
                "column1": "A",
                "column2": "B34",
                "column3": "7",
                "lat": "0.5",
                "lng": "0.1",
                "date": "2015-10-25",
                "deviceid": "1",
                "meta/instanceID": "a"},
                "original_form": "form1"}
        var, category, ret_location, disregard = to_code(
            row,
            (self.variables, self.variables_forms, self.variables_test, self.variables_groups, {}),
            self.all_locations, "case",  self.alert_data, self.mul_forms,
            "in_geometry$lat,lng")
        
        self.assertEqual(ret_location, None)


    def test_variables(self):
        """
        Checking that variables returned and alerts are working
        """
        row1 = {"form1": {"index": 1,
                          "column1": "A",
                          "column2": "B34",
                          "column3": "7",
                          "date": "2015-10-25",
                          "deviceid": "1",
                          "meta/instanceID": "a"},
                "original_form": "form1"}
        row2 = {"form1": {"index": 2,
                          "column1": "B",
                          "column2": "A",
                          "column3": "4",
                          "date": "2015-10-25",
                          "deviceid": "2",
                          "meta/instanceID": "b"},
                "original_form": "form1"}
        row3 = {"form1": {"index": 1,
                          "column1": "A",
                          "column2": "C",
                          "column3": "7",
                          "date": "2015-10-25",
                          "deviceid": "2",
                          "meta/instanceID": "c"},
                "original_form": "form1"}
        var, category, ret_loc, disregard = to_code(
            row1,
            (self.variables, self.variables_forms, self.variables_test, self.variables_groups, {}),
            self.all_locations, "case", self.alert_data, self.mul_forms, "deviceid")
        self.assertEqual(var, {1: 1,
                               2: 1,
                               3: 1,
                               4: 1,
                               'alert_reason': 2,
                               'alert': 1,
                               'alert_type': "individual",
                               'alert_column1': 'A'})
        self.assertEqual(disregard, True)
        var, category, ret_loc, disregard = to_code(
            row2,
            (self.variables, self.variables_forms, self.variables_test, self.variables_groups, {}),
            self.all_locations, "case", self.alert_data, self.mul_forms, "deviceid")
        self.assertEqual(var, {1: 1})
        self.assertEqual(disregard, False)
        var, category, ret_loc, disregard = to_code(
            row3,
            (self.variables, self.variables_forms, self.variables_test, self.variables_groups, {}),
            self.all_locations, "case", self.alert_data, self.mul_forms, "deviceid")
        self.assertEqual(var, {1: 1,
                               2: 1,
                               4: 1,
                               'alert': 1,
                               'alert_column1': 'A',
                               "alert_type": "individual",
                               'alert_reason': 2})
        self.assertEqual(disregard, True)

if __name__ == "__main__":
    unittest.main()

import unittest

from meerkat_abacus import model
from meerkat_abacus.codes.to_codes import to_code
from meerkat_abacus.codes.variable import Variable
from geoalchemy2.shape import from_shape
from shapely.geometry import Polygon

# Data for the tests
class ToCodeTest(unittest.TestCase):
    """
    Test the to_code functionality
    """

    def setUp(self):
        locations = {1: model.Locations(name="Demo", id=1),
             2: model.Locations(
                 name="Region 1", parent_location=1, id=2),
             3: model.Locations(
                 name="Region 2", parent_location=1, id=3),
             4: model.Locations(
                 name="District 1", parent_location=2,
                 level="district", id=4,
                 area=from_shape(Polygon([(0, 0), (0, 0.4), (0.2, 0.4),
                                          (0.2, 0), (0, 0)]))
             ),
             5: model.Locations(
                 name="District 2", parent_location=3,
                 level="district", id=5,
                 area=from_shape(Polygon([(0.2, 0.4), (0.4, 0.4), (0.4, 0),
                                          (0.2, 0), (0.2, 0.4)]))),
             6: model.Locations(
                 name="Clinic 1", parent_location=4, id=6),
             7: model.Locations(
                 name="Clinic 2", parent_location=5, id=7),
             8: model.Locations(
                 name="Clinic with no district", parent_location=2, id=8)}
        locations_by_deviceid = {"1": 6, "2": 7, "3": 8}
        zones = []
        regions = [2, 3]
        districts = [4, 5]
        agg_variables = [
            model.AggregationVariables(
                id=1, method="not_null", db_column="index", condition="",
                category=[],
                form="form1"),
            model.AggregationVariables(
                id=2,
                method="match",
                db_column="column1",
                alert=1,
                category=[],
                alert_type="individual",
                condition="A",
                form="form1"),
            model.AggregationVariables(
                id=3,
                category=[],
                method="sub_match",
                db_column="column2",
                condition="B",
                form="form1"),
            model.AggregationVariables(
                id=4,
                category=[],
                method="between",
                calculation="column3",
                db_column="column3",
                condition="5,10",
                disregard=1,
                form="form1")
        ]
        self.alert_data = {"form1": {"column1": "column1"}}

        devices = {"1": [], "2": [], "3": [], "4": [], "5": [],
                   "6": [], "7": [], "8": []}
        self.all_locations = (locations, locations_by_deviceid, zones, regions, districts, devices)

        self.variables = {"case": {1: {}, 2: {}, 3: {}, 4: {}}}
        self.variables_forms = {}
        self.variables_test = {}
        self.variables_groups = {}
        self.mul_forms = []
        for av in agg_variables:
            self.variables["case"][av.id][av.id] = Variable(av)
            self.variables_forms[av.id] = "form1"
            self.variables_test[av.id] = self.variables["case"][av.id][av.id].test
            self.variables_groups[av.id] = [av.id]

    def tearDown(self):
        pass

    def test_location_information(self):
        """
        Testing that all the location infomation is translated correctly
        """
        row = {"form1":
               {"index": 1,
                "column1": "A",
                "column2": "B34",
                "column3": "7",
                "date": "2015-10-25",
                "deviceid": "1",
                "meta/instanceID": "a"},
        "original_form": "form1"}
        var, category, ret_location, disregarded = to_code(
            row,
            (self.variables, self.variables_forms, self.variables_test, self.variables_groups, {}),
            self.all_locations, "case",  self.alert_data, self.mul_forms, "deviceid")
        self.assertEqual(ret_location["country"], 1)
        self.assertEqual(ret_location["region"], 2)
        self.assertEqual(ret_location["district"], 4)
        self.assertEqual(ret_location["clinic"], 6)
        self.assertEqual(ret_location["device_id"], '1')

        row["form1"]["deviceid"] = "2"
        var, category, ret_location, disregard = to_code(
            row,
            (self.variables, self.variables_forms, self.variables_test, self.variables_groups, {}),
            self.all_locations, "case",  self.alert_data, self.mul_forms, "deviceid")
        self.assertEqual(ret_location["country"], 1)
        self.assertEqual(ret_location["region"], 3)
        self.assertEqual(ret_location["district"], 5)
        self.assertEqual(ret_location["device_id"], '2')

        row["form1"]["deviceid"] = "3"
        var, category, ret_location, disregard = to_code(
            row,
            (self.variables, self.variables_forms, self.variables_test, self.variables_groups, {}),
            self.all_locations, "case",  self.alert_data, self.mul_forms, "deviceid")
        self.assertEqual(ret_location["country"], 1)
        self.assertEqual(ret_location["region"], 2)
        self.assertEqual(ret_location["district"], None)
        self.assertEqual(ret_location["device_id"], '3')
        row["form1"]["deviceid"] = "99"
        var, category, ret_location, disregard = to_code(
            row,
            (self.variables, self.variables_forms, self.variables_test, self.variables_groups, {}),
            self.all_locations, "case", self.alert_data, self.mul_forms, "deviceid")
        self.assertEqual(ret_location, None)

        # Test gps in district
        row = {"form1":
               {"index": 1,
                "column1": "A",
                "column2": "B34",
                "column3": "7",
                "lat": "0.1",
                "lng": "0.1",
                "date": "2015-10-25",
                "deviceid": "1",
                "meta/instanceID": "a"},
                "original_form": "form1"}
        var, category, ret_location, disregard = to_code(
            row,
            (self.variables, self.variables_forms, self.variables_test, self.variables_groups, {}),
            self.all_locations, "case",  self.alert_data, self.mul_forms,
            "in_geometry$lat,lng")
        
        self.assertEqual(ret_location["district"], 4)
        self.assertEqual(ret_location["region"], 2)
        self.assertEqual(ret_location["clinic"], None)
        row = {"form1":
               {"index": 1,
                "column1": "A",
                "column2": "B34",
                "column3": "7",
                "lat": "0.3",
                "lng": "0.1",
                "date": "2015-10-25",
                "deviceid": "1",
                "meta/instanceID": "a"},
                "original_form": "form1"}
        var, category, ret_location, disregard = to_code(
            row,
            (self.variables, self.variables_forms, self.variables_test, self.variables_groups, {}),
            self.all_locations, "case",  self.alert_data, self.mul_forms,
            "in_geometry$lat,lng")
        
        self.assertEqual(ret_location["district"], 5)
        self.assertEqual(ret_location["region"], 3)
        self.assertEqual(ret_location["clinic"], None)
        row = {"form1":
               {"index": 1,
                "column1": "A",
                "column2": "B34",
                "column3": "7",
                "lat": "0.5",
                "lng": "0.1",
                "date": "2015-10-25",
                "deviceid": "1",
                "meta/instanceID": "a"},
                "original_form": "form1"}
        var, category, ret_location, disregard = to_code(
            row,
            (self.variables, self.variables_forms, self.variables_test, self.variables_groups, {}),
            self.all_locations, "case",  self.alert_data, self.mul_forms,
            "in_geometry$lat,lng")
        
        self.assertEqual(ret_location, None)


    def test_variables(self):
        """
        Checking that variables returned and alerts are working
        """
        row1 = {"form1": {"index": 1,
                          "column1": "A",
                          "column2": "B34",
                          "column3": "7",
                          "date": "2015-10-25",
                          "deviceid": "1",
                          "meta/instanceID": "a"},
                "original_form": "form1"}
        row2 = {"form1": {"index": 2,
                          "column1": "B",
                          "column2": "A",
                          "column3": "4",
                          "date": "2015-10-25",
                          "deviceid": "2",
                          "meta/instanceID": "b"},
                "original_form": "form1"}
        row3 = {"form1": {"index": 1,
                          "column1": "A",
                          "column2": "C",
                          "column3": "7",
                          "date": "2015-10-25",
                          "deviceid": "2",
                          "meta/instanceID": "c"},
                "original_form": "form1"}
        var, category, ret_loc, disregard = to_code(
            row1,
            (self.variables, self.variables_forms, self.variables_test, self.variables_groups, {}),
            self.all_locations, "case", self.alert_data, self.mul_forms, "deviceid")
        self.assertEqual(var, {1: 1,
                               2: 1,
                               3: 1,
                               4: 1,
                               'alert_reason': 2,
                               'alert': 1,
                               'alert_type': "individual",
                               'alert_column1': 'A'})
        self.assertEqual(disregard, True)
        var, category, ret_loc, disregard = to_code(
            row2,
            (self.variables, self.variables_forms, self.variables_test, self.variables_groups, {}),
            self.all_locations, "case", self.alert_data, self.mul_forms, "deviceid")
        self.assertEqual(var, {1: 1})
        self.assertEqual(disregard, False)
        var, category, ret_loc, disregard = to_code(
            row3,
            (self.variables, self.variables_forms, self.variables_test, self.variables_groups, {}),
            self.all_locations, "case", self.alert_data, self.mul_forms, "deviceid")
        self.assertEqual(var, {1: 1,
                               2: 1,
                               4: 1,
                               'alert': 1,
                               'alert_column1': 'A',
                               "alert_type": "individual",
                               'alert_reason': 2})
        self.assertEqual(disregard, True)

if __name__ == "__main__":
    unittest.main()

# Data for the tests Test the to_code functionality Testing that all the location infomation is translated correctly # Test gps in district Checking that variables returned and alerts are working