from sqlalchemy import create_engine

import logging


logging.basicConfig(level=logging.DEBUG,
    filename='./sa.log',
    filemode='w')

engineLogger = logging.getLogger('sqlalchemy.engine')
engineLogger.setLevel(logging.DEBUG)

lookup1 = create_engine("mysql://lookup1:lookup1@127.0.0.1:3306/lookup1", echo=False)
lookup2 = create_engine("mysql://lookup2:lookup2@127.0.0.1:3306/lookup2", echo=False)

shard1 = create_engine("mysql://blog1:blog1@127.0.0.1:3306/blog1", echo=False)
shard2 = create_engine("mysql://blog2:blog2@127.0.0.1:3306/blog2", echo=False)