# -*- coding: utf-8 -*-
import pytest
import time

from aerospike_helpers import expressions as exp
from aerospike import exception as e

import aerospike


def seconds_to_nanos(num):
    """
    converter seconds to nanoseconds
    """
    return int(num) * (10**9)


# GeoConstants
geo_object1 = aerospike.GeoJSON({"type": "AeroCircle", "coordinates": [[-122.0, 37.5], 1000]})

geo_object2 = aerospike.GeoJSON({"type": "AeroCircle", "coordinates": [[-132.0, 37.5], 1000]})

geo_point1 = aerospike.GeoJSON({"coordinates": [-122.0, 37.5], "type": "Point"})

geo_point2 = aerospike.GeoJSON({"coordinates": [-132.0, 37.5], "type": "Point"})


def assert_each_record(records, check_func, *args):
    for record in records:
        assert check_func(record, *args)


def assert_each_record_bins(records, check_func):
    for _, _, bins in records:
        assert check_func(bins)


@pytest.fixture(scope="class")
def clean_test_demo_namespace(as_connection):
    names = ["Alice", "Bob", "John", "Jane"]
    for i in range(100):
        key = "test", "demo", i
        record = {
            "name": names[i % 4],
            "positive_i": i,
            "i_mod_5": i % 5,
            "i_mod_10": i % 10,
            # This is a list: [i, i + 1, i +2 , i+3, i+4, i+5]
            "plus_five_l": list(range(i, i + 6)),
        }
        as_connection.put(key, record)

        #  For list tests
        flist1 = ["Alice", "Bob", "John"]
        flist2 = ["Alice", "Bob", "Jane"]
        flist3 = ["John", "Jane"]
        key1 = "test", "demo2", "f1"
        key2 = "test", "demo2", "f2"
        key3 = "test", "demo2", "f3"

        as_connection.put(key1, {"slist": flist1})
        as_connection.put(key2, {"slist": flist2})
        as_connection.put(key3, {"slist": flist3})

        #  For map tests:
        flist1 = ["Alice", "Bob", "John"]
        flist2 = ["Alice", "Bob", "Jane"]
        flist3 = ["John", "Jane"]

        # dictionary: {'Alice': 5, 'Bob': '3'...}
        map1 = dict([(name, len(name)) for name in flist1])
        map2 = dict([(name, len(name)) for name in flist2])
        map3 = dict([(name, len(name)) for name in flist3])

        key1 = "test", "demo3", "f1"
        key2 = "test", "demo3", "f2"
        key3 = "test", "demo3", "f3"

        as_connection.put(key1, {"map": map1})
        as_connection.put(key2, {"map": map2})
        as_connection.put(key3, {"map": map3})

        geok1 = "test", "geo", 1
        geok2 = "test", "geo", 2

        georec1 = {"id": 1, "point": geo_point1, "region": geo_object1, "geolist": [geo_point1]}

        georec2 = {"id": 2, "point": geo_point2, "region": geo_object2, "geolist": [geo_point2]}

        as_connection.put(geok1, georec1)
        as_connection.put(geok2, georec2)

    yield

    as_connection.truncate("test", None, 0)


@pytest.mark.usefixtures("clean_test_demo_namespace")
class TestQueryExpressions(object):
    @pytest.fixture(autouse=True)
    def setup(self, request, as_connection):
        self.del_keys = []
        self.query = as_connection.query("test", "demo")

    def test_integer_equals(self):
        expr = exp.Eq(exp.IntBin("positive_i"), 5)
        results = self.query.results(policy={"expressions": expr.compile()})
        assert len(results) == 1
        assert_each_record_bins(results, lambda b: b["positive_i"] == 5)

    def test_integer_greater(self):
        expr = exp.GT(exp.IntBin("positive_i"), 49)
        results = self.query.results(policy={"expressions": expr.compile()})
        assert len(results) == 50
        assert_each_record_bins(results, lambda b: b["positive_i"] > 49)

    def test_integer_greatereq(self):
        expr = exp.GE(exp.IntBin("positive_i"), 49)
        results = self.query.results(policy={"expressions": expr.compile()})
        assert len(results) == 51
        assert_each_record_bins(results, lambda b: b["positive_i"] >= 49)

    def test_integer_less(self):
        expr = exp.LT(exp.IntBin("positive_i"), 10)
        results = self.query.results(policy={"expressions": expr.compile()})
        assert len(results) == 10
        assert_each_record_bins(results, lambda b: b["positive_i"] < 10)

    def test_integer_lesseq(self):
        expr = exp.LE(exp.IntBin("positive_i"), 10)
        results = self.query.results(policy={"expressions": expr.compile()})
        assert len(results) == 11
        assert_each_record_bins(results, lambda b: b["positive_i"] <= 10)

    # TBD What calculation is the server doing here, I don't get it right now.

    def test_digest_modulo(self):
        # Count of digests whose last byte is < 128
        less_than_128 = 0
        expected_ids = set([])
        for i in range(100):
            key = "test", "demo", i
            if aerospike.calc_digest(*key)[-1] < 128:
                expected_ids.add(i)
                less_than_128 += 1

        expr = exp.LT(exp.DigestMod(256), 128)

        results = self.query.results(policy={"expressions": expr.compile()})
        assert len(results) == less_than_128

    def test_string_equal(self):
        expr = exp.Eq(exp.StrBin("name"), "Alice")
        results = self.query.results(policy={"expressions": expr.compile()})
        assert len(results) == 25
        assert_each_record_bins(results, lambda b: b["name"] == "Alice")

    def test_string_unequal(self):
        expr = exp.NE(exp.StrBin("name"), "Alice")
        results = self.query.results(policy={"expressions": expr.compile()})
        assert len(results) == 75
        assert_each_record_bins(results, lambda b: b["name"] != "Alice")

    # TODO GEO BIN WITHIN CONTAINS

    def test_geo_within(self):
        expr = exp.CmpGeo(exp.GeoBin("point"), geo_object1)

        query = self.as_connection.query("test", "geo")
        results = query.results(policy={"expressions": expr.compile()})
        assert len(results) == 1
        assert results[0][2]["id"] == 1

    def test_geo_contains(self):
        expr = exp.CmpGeo(geo_point2, exp.GeoBin("region"))

        query = self.as_connection.query("test", "geo")
        results = query.results(policy={"expressions": expr.compile()})
        assert len(results) == 1
        assert results[0][2]["id"] == 2

    def test_geo_contains2(self):
        expr = exp.CmpGeo(exp.GeoBin("point"), exp.GeoBin("region"))

        query = self.as_connection.query("test", "geo")
        results = query.results(policy={"expressions": expr.compile()})
        assert len(results) == 2

    def test_not(self):
        expr = exp.Not(exp.Eq(exp.IntBin("positive_i"), 5))
        results = self.query.results(policy={"expressions": expr.compile()})

        assert len(results) == 99
        assert_each_record_bins(results, lambda b: b["positive_i"] != 5)

    def test_or(self):
        expr = exp.Or(exp.Eq(exp.IntBin("positive_i"), 5), exp.Eq(exp.IntBin("positive_i"), 10))
        results = self.query.results(policy={"expressions": expr.compile()})
        assert len(results) == 2
        assert_each_record_bins(results, lambda b: b["positive_i"] in (5, 10))

    def test_and(self):
        expr = exp.And(exp.GT(exp.IntBin("positive_i"), 10), exp.LT(exp.IntBin("positive_i"), 20))
        results = self.query.results(policy={"expressions": expr.compile()})
        assert len(results) == 9
        assert_each_record_bins(results, lambda b: b["positive_i"] > 10 and b["positive_i"] < 20)

    def test_string_regex(self):
        expr = exp.CmpRegex(aerospike.REGEX_ICASE, ".*O.*", exp.StrBin("name"))
        results = self.query.results(policy={"expressions": expr.compile()})
        assert len(results) == 50
        assert_each_record_bins(results, lambda b: b["name"] in ("Bob", "John"))

    # List Tests
    def test_list_or_int(self):
        expr = exp.GT(
            exp.ListGetByRank(None, aerospike.LIST_RETURN_VALUE, exp.ResultType.INTEGER, -1, "plus_five_l"), 10
        )
        results = self.query.results(policy={"expressions": expr.compile()})
        assert len(results) == 94  # This isn't true for 0,1,2,3,4,5 so 100 - 6
        assert_each_record_bins(results, lambda b: b["plus_five_l"][-1] > 10)

    def test_list_and_int(self):
        expr = exp.GT(
            exp.ListGetByRank(None, aerospike.LIST_RETURN_VALUE, exp.ResultType.INTEGER, 0, "plus_five_l"), 10
        )
        results = self.query.results(policy={"expressions": expr.compile()})
        assert len(results) == 89  # This isn't true for the first 11
        assert_each_record_bins(results, lambda b: b["plus_five_l"][-1] > 10)

    def test_list_or_str(self):
        expr = exp.GE(exp.ListGetByValue(None, aerospike.LIST_RETURN_COUNT, "Bob", "slist"), 1)
        query = self.as_connection.query("test", "demo2")
        results = query.results(policy={"expressions": expr.compile()})
        assert len(results) == 2
        assert_each_record_bins(results, lambda b: any([name == "Bob" for name in b["slist"]]))

    def test_list_and_str(self):
        expr = exp.Eq(exp.ListGetByValue(None, aerospike.LIST_RETURN_COUNT, "Bob", "slist"), 0)
        # Only one friend list without Bob
        query = self.as_connection.query("test", "demo2")
        results = query.results(policy={"expressions": expr.compile()})
        assert len(results) == 1
        assert_each_record_bins(results, lambda b: all([name != "Bob" for name in b["slist"]]))

    # Mapkey Tests
    def test_mapkey_iterate_or(self):
        expr = exp.GE(exp.MapGetByKey(None, aerospike.LIST_RETURN_COUNT, exp.ResultType.INTEGER, "Bob", "map"), 1)
        query = self.as_connection.query("test", "demo3")
        results = query.results(policy={"expressions": expr.compile()})
        assert len(results) == 2
        assert_each_record_bins(results, lambda b: any([key == "Bob" for key in b["map"]]))

    def test_mapkey_iterate_and(self):
        expr = exp.Eq(exp.MapGetByKey(None, aerospike.LIST_RETURN_COUNT, exp.ResultType.INTEGER, "Bob", "map"), 0)
        query = self.as_connection.query("test", "demo3")
        results = query.results(policy={"expressions": expr.compile()})
        assert len(results) == 1
        assert_each_record_bins(results, lambda b: all([key != "Bob" for key in b["map"]]))

    # MapValueTest
    def test_mapvalue_iterate_or(self):
        expr = exp.GE(exp.MapGetByValue(None, aerospike.LIST_RETURN_COUNT, 3, "map"), 1)
        query = self.as_connection.query("test", "demo3")
        results = query.results(policy={"expressions": expr.compile()})
        assert len(results) == 2
        assert_each_record_bins(results, lambda b: any([b["map"][key] == 3 for key in b["map"]]))

    def test_mapvalue_iterate_and(self):
        expr = exp.Eq(exp.MapGetByValue(None, aerospike.LIST_RETURN_COUNT, 3, "map"), 0)
        query = self.as_connection.query("test", "demo3")
        results = query.results(policy={"expressions": expr.compile()})
        assert len(results) == 1
        assert_each_record_bins(results, lambda b: all([b["map"][key] != 3 for key in b["map"]]))

    @pytest.mark.xfail(reason="This only works when not running data in memory")  # TODO test this on device config
    def test_rec_device_size(self):
        long_str_len = 65 * 1024
        long_str = long_str_len * "a"  # A 65K string

        # Store 5 records with a string of 65K
        for i in range(5):
            key = "test", "dev_size", i
            self.as_connection.put(key, {"string": long_str})

        # Store 3 records with a size much less than 65K
        for i in range(5, 8):
            key = "test", "dev_size", i
            self.as_connection.put(key, {"string": "short"})

        query = self.as_connection.query("test", "dev_size")
        expr = exp.GT(exp.DeviceSize(), 64 * 1024)
        results = query.results(policy={"expressions": expr.compile()})
        assert len(results) == 5
        assert_each_record_bins(
            results, lambda b: len(b["string"]) == long_str_len
        )  # This is faster than doing a string compare

    def test_rec_last_update(self):
        """
        This could fail due to clock skew
        """
        for i in range(7):
            key = "test", "lut", i
            self.as_connection.put(key, {"time": "earlier"})

        time.sleep(5)  # Make sure that we wait long enough

        cutoff_nanos = time.time_ns()

        time.sleep(5)

        # Store 5 records after the cutoff
        for i in range(7, 12):
            key = "test", "lut", i
            self.as_connection.put(key, {"time": "later"})

        query = self.as_connection.query("test", "lut")

        expr = exp.LT(exp.LastUpdateTime(), cutoff_nanos)
        results = query.results(policy={"expressions": expr.compile()})
        assert len(results) == 7
        assert_each_record_bins(results, lambda b: b["time"] == "earlier")

    def test_rec_void_time(self):
        """
        This could fail due to clock skew
        """
        for i in range(7):
            key = "test", "ttl", i
            self.as_connection.put(key, {"time": "earlier"}, meta={"ttl": 100})

        # 150 second range for record TTLs should be enough, we are storing with
        # Current time + 100s and current time +5000s, so only one of the group should be found
        void_time_range_start = seconds_to_nanos(int(time.time() + 50))
        void_time_range_end = seconds_to_nanos(int(time.time() + 150))

        # Store 5 records after the cutoff
        for i in range(7, 12):
            key = "test", "ttl", i
            self.as_connection.put(key, {"time": "later"}, meta={"ttl": 1000})

        query = self.as_connection.query("test", "ttl")

        expr = exp.And(exp.GT(exp.VoidTime(), void_time_range_start), exp.LT(exp.VoidTime(), void_time_range_end))
        results = query.results(policy={"expressions": expr.compile()})
        assert len(results) == 7
        assert_each_record_bins(results, lambda b: b["time"] == "earlier")

    def test_with_eq_expr_too_big(self):
        expr = exp.Eq(1, 1 << 64)  # This needs to be over 2 ^ 63 - 1
        query = self.as_connection.query("test", "or")
        with pytest.raises(e.ParamError):
            query.results(policy={"expressions": expr.compile()})

    def test_with_invalid_predicate(self):
        """
        This passes something which isn't a predicate
        """
        expr = exp.Or(exp.Eq(1, 1), "bad_expression")
        with pytest.raises(e.InvalidRequest):
            self.query.results(policy={"expressions": expr.compile()})

    @pytest.mark.parametrize(
        "func",
        [
            exp.IntBin,
            exp.StrBin,
            exp.GeoBin,
            exp.MapBin,
            exp.ListBin,
        ],
    )
    def test_with_wrong_predicate_argument_type_expecting_str(self, func):
        """
        These functions all expect an integer argument, call with a string
        """
        expr = func(5)
        with pytest.raises(e.ParamError):
            self.query.results(policy={"expressions": expr.compile()})

    def test_with_invalid_predicate_tuple(self):
        """
        This passes something which isn't a predicate
        """
        expr = (1234, "not real")
        with pytest.raises(e.ParamError):
            self.query.results(policy={"expressions": expr})

    def test_with_empty_exp_list(self):
        """
        Pass an empty list of predicates
        """
        expr = []
        with pytest.raises(e.ParamError):
            self.query.results(policy={"expressions": expr})
