def test_not_in():
c = SQLConverter()
assert c._not_in("id", ["1"]) == "id NOT IN ('1')"
assert c._not_in("id", ["1", "2"]) == "id NOT IN ('1','2')"
assert c._not_in("id", [1, 2]) == "id NOT IN (1,2)"
def test_eq():
c = SQLConverter()
assert c._eq("id", "1") == "id = '1'"
assert c._eq("id", 1) == "id = 1"
assert c._eq("id", ["1", 1]) == "(id = '1' OR id = 1)"
def test_not_eq():
c = SQLConverter()
assert c._not_eq("id", "1") == "id != '1'"
assert c._not_eq("id", 1) == "id != 1"
assert c._not_eq("id", ["1", 1]) == "(id != '1' AND id != 1)"
def test_gte():
c = SQLConverter()
assert c._gte("id", "1") == "id >= '1'"
assert c._gte("id", 1) == "id >= 1"
assert c._gte("id", ["1", 1]) == "(id >= '1' OR id >= 1)"
def test_gt():
c = SQLConverter()
assert c._gt("id", "1") == "id > '1'"
assert c._gt("id", 1) == "id > 1"
assert c._gt("id", ["1", 1]) == "(id > '1' OR id > 1)"
def test_lt():
c = SQLConverter()
assert c._lt("id", "1") == "id < '1'"
assert c._lt("id", 1) == "id < 1"
assert c._lt("id", ["1", 1]) == "(id < '1' OR id < 1)"
def test_ends_with():
c = SQLConverter()
assert c._ends_with("id", "test") == "id LIKE '%test'"
assert c._ends_with(
"id", ["test", "test1"]) == "(id LIKE '%test' OR id LIKE '%test1')"
assert c._ends_with("id",
["test", 123]) == "(id LIKE '%test' OR id LIKE '%123')"
def test_starts_with():
c = SQLConverter()
assert c._starts_with("id", "test") == "id LIKE 'test%'"
assert c._starts_with(
"id", ["test", "test1"]) == "(id LIKE 'test%' OR id LIKE 'test1%')"
assert c._starts_with(
"id", ["test", 123]) == "(id LIKE 'test%' OR id LIKE '123%')"
def test_or():
c = SQLConverter()
content = [
{
"op": "eq",
"field": "id",
"value": "1",
},
{
"op": "eq",
"field": "name",
"value": "test",
},
]
assert c._or(content) == "(id = '1' OR name = 'test')"
def test_convert():
c = SQLConverter()
data = {
"op":
"AND",
"content": [
{
"op": "eq",
"field": "id",
"value": "1",
},
{
"op": "eq",
"field": "name",
"value": "test",
},
],
}
assert c.convert(data) == "(id = '1' AND name = 'test')"
data = {
"op":
"OR",
"content": [
{
"op": "eq",
"field": "id",
"value": "1",
},
{
"op": "eq",
"field": "name",
"value": "test",
},
],
}
assert c.convert(data) == "(id = '1' OR name = 'test')"
def test_not_contains():
c = SQLConverter()
with pytest.raises(NotImplementedError):
c._not_contains("1", "1")
def test_to_str_present():
c = SQLConverter()
assert c._to_str_present(1, True) == 1
assert c._to_str_present("1", True) == "'1'"
assert c._to_str_present("1", False) == "1"
def test_any():
c = SQLConverter()
assert c._any(1, 1) == "1 = 1"