def test_create_table():
conn = Model.setup_db()
Project.create_table(conn)
sql = "select * from sqlite_master where type='table' and name='Project'"
assert len(conn.execute(sql).fetchall()) == 1
row = conn.execute(sql).fetchone()
assert row['sql'] == Project.create_table_sql()
conn.execute("select * from Project")
def test_persist_instance():
conn = Model.setup_db()
Project.create_table(conn)
project = Project.create(conn, name="My New Project")
print project.persist_instance_sql()
print project.persist(conn)
