from sqlobject import *
from sqlobject.inheritance import *
from sqlobject.tests.dbtest import *

class TestAggregate1(InheritableSQLObject):
    value1 = IntCol()

class TestAggregate2(TestAggregate1):
    value2 = IntCol()

def test_aggregates():
    setupClass([TestAggregate1, TestAggregate2])

    TestAggregate1(value1=1)
    TestAggregate2(value1=2, value2=12)

    assert TestAggregate1.select().max("value1") == 2
    assert TestAggregate2.select().max("value1") == 2
    raises(Exception, TestAggregate2.select().max, "value2")
    assert TestAggregate2.select().max(TestAggregate2.q.value2) == 12