sqlbean

from sqlbean.db.sqlstore import SqlStore

#tables can in different databases

DATABASE_CONFIG = { "mokodb": { "master": "localhost:3306:mokodb:root:111111", "tables": ["*", "user"], }, }

SQLSTORE = SqlStore(db_config=DATABASE_CONFIG, **{})

def get_db_by_table(table_name): return SQLSTORE.get_db_by_table(table_name)

from sqlbean.db import connection connection.get_db_by_table = get_db_by_table

from sqlbean.shortcut import Model

will auto mapping the table structure

class User will mapping to user

class UserProfile will mapping to user_profile and so on

class User(Model): pass

for i in User.where(): print i.id

more useage please the source code :)