#!/usr/bin/env python

from sqlalchemy import create_engine

from sqlalchemy.orm import scoped_session, sessionmaker

from sqlalchemy.orm.shard import ShardedSession

from lookup import *
from post import *
from blog_engine import lookup2, lookup1, shard1, shard2

setup_all()

for db in (lookup1, lookup2):
    a_metadata.drop_all(bind=db)
    a_metadata.create_all(bind=db)

for db in (shard1, shard2):

    b_metadata.drop_all(bind=db)
    b_metadata.create_all(bind=db)