from sqlobject import *
from sqlobject.manage.creation import create_tables
from dbtest import *

class TestCreateDrop(SQLObject):
    class sqlmeta(sqlmeta):
        table = 'test_create_drop_table'
    id = IntCol(db_name='test_id_here', primary_key=True,
                auto_increment=True)
    name = StringCol()
    number = IntCol()
    time = DateTimeCol()
    short = StringCol(length=10)
    blobcol = BlobCol()

def test_create_drop():
    setup_class(TestCreateDrop)
    conn = get_connection()
    TestCreateDrop.sqlmeta.drop_table()
    assert not TestCreateDrop.sqlmeta.table_exists()
    create_tables([TestCreateDrop])
    assert TestCreateDrop.sqlmeta.table_exists()