from sqlobject import *
from sqlobject.manage.creation import *
from sqlapi.sql import sqlrepr

class Person(SQLObject):

    name = StringCol(not_null=True)
    age = IntCol(not_null=True)
    birthday = DateCol(not_null=False)
    last_viewed = DateTimeCol()
    gender = StringCol(length=1)
    
def test_create():
    conn = sqlhub.get_connection()
    sql = create_tables_sql([Person], conn)
    print conn.sqlrepr(sql)