def test_select_from_where_and():
class Customer:
name = "string"
category = "string"
size = "string"
customer = table(Customer)
category_is_gold = customer.category == "gold"
size_is_big = customer.size == "BIG"
q = select(customer.name).frm(customer).where(category_is_gold
& size_is_big)
assert (str(q) == "select customer.name from customer "
"where ( customer.category = 'gold' and customer.size = 'BIG' )")
q = select(customer.name).frm(customer).where(size_is_big
& category_is_gold)
assert (str(q) == "select customer.name from customer "
"where ( customer.size = 'BIG' and customer.category = 'gold' )")
def test_select_from():
class Customer:
name = "string"
category = "string"
customer = table(Customer)
q = select(customer.name).frm(customer)
assert str(q) == "select customer.name from customer"
def test_select_from_where_or():
class Customer:
name = "string"
category = "string"
customer = table(Customer)
category_is_gold = customer.category == "gold"
q = select(customer.name).frm(customer).where(category_is_gold)
assert (
str(q) ==
"select customer.name from customer where customer.category = 'gold'")