from sqlobject import *
from dbtest import *

class EmptyClass(SQLObject):

    pass

def test_empty():
    if not supports('empty_table'):
        return
    setup_class(EmptyClass)
    e1 = EmptyClass()
    e2 = EmptyClass()
    assert e1 != e2
    assert e1.id != e2.id
    assert e1.id in [e.id for e in EmptyClass.select()]
    assert e2.id in [e.id for e in EmptyClass.select()]
    e1.destroy_self()
    assert [e.id for e in EmptyClass.select()] == [e2.id]