def downgrade():
    setup_logging(config_uri)
    settings = get_appsettings(config_uri)
    engine = sa.engine_from_config(settings, 'sqlalchemy.')
    DBSession.configure(bind=engine)
    Base.metadata.create_all(engine)

    with transaction.manager:
        post1 = Post.get(title=title1)
        DBSession.delete(post1)
        post2 = Post.get(title=title2)
        DBSession.delete(post2)
def downgrade():
    setup_logging(config_uri)
    settings = get_appsettings(config_uri)
    engine = sa.engine_from_config(settings, 'sqlalchemy.')
    DBSession.configure(bind=engine)
    Base.metadata.create_all(engine)

    with transaction.manager:
        post1 = Post.get(title=title1)
        DBSession.delete(post1)
        post2 = Post.get(title=title2)
        DBSession.delete(post2)
def upgrade():
    setup_logging(config_uri)
    settings = get_appsettings(config_uri)
    engine = sa.engine_from_config(settings, 'sqlalchemy.')
    DBSession.configure(bind=engine)
    Base.metadata.create_all(engine)

    with transaction.manager:

        p1 = Post(title=title1,
                  hash_url=create_hashed_url(title1),
                  url="http://getbootstrap.com/",
                  votes=100)
        DBSession.add(p1)

        p2 = Post(title=title2,
                  hash_url=create_hashed_url(title2),
                  url="http://foundation.zurb.com/",
                  votes=101)
        DBSession.add(p2)
def upgrade():
    setup_logging(config_uri)
    settings = get_appsettings(config_uri)
    engine = sa.engine_from_config(settings, 'sqlalchemy.')
    DBSession.configure(bind=engine)
    Base.metadata.create_all(engine)

    with transaction.manager:

        p1 = Post(
            title=title1,
            hash_url= create_hashed_url(title1),
            url="http://getbootstrap.com/",
            votes=100
        )
        DBSession.add(p1)

        p2 = Post(
            title=title2,
            hash_url= create_hashed_url(title2),
            url="http://foundation.zurb.com/",
            votes=101
        )
        DBSession.add(p2)