张沈鹏,在路上...

from sqlalchemy import orm
from sqlalchemy import types

def init_model(bind):
    """Call me at the beginning of the application.
       'bind' is a SQLAlchemy engine or connection, as returned by
       sa.create_engine, sa.engine_from_config, or engine.connect().
    """
    global engine, Session
    engine = bind
    Session = orm.scoped_session(orm.sessionmaker(
        transactional=True, autoflush=True, bind=bind)
    )
    Table.do_mapper(orm)


import sqlalchemy as sa
from datetime import datetime

class Table(object):
    wait_mapper={}
    meta = sa.MetaData()
    
    def __init__(self,cls,*args,**keys):
        cls.table=sa.Table(
                cls.__name__,self.meta,
                *args,**keys
        )
        self.wait_mapper[cls]={}
        self.cls=cls

    def mapper(self,**keys):
        self.wait_mapper[self.cls]=keys

    @classmethod
    def do_mapper(cls,orm):
        wait_mapper=cls.wait_mapper
        for i,keys in wait_mapper.iteritems():
            orm.mapper(i,i.table,**keys)
        wait_mapper={}

class IdTable(Table):
    def __init__(self,cls,*args,**keys):
        super(self.__class__,self).__init__(cls,
            sa.Column("id",types.Integer, primary_key=True,autoincrement=True),
            *args,**keys
            )

def ForeignKey(cls,*args,**keys):
    table_name=cls.table.name
    return sa.Column(
            '%s_id'%table_name,
            types.Integer,
            sa.ForeignKey('%s.id'%table_name),
            *args,
            **keys
           )

class ResourceSite(object):
    def __str(self):
        return self.title

IdTable(
    ResourceSite,
    sa.Column("href", types.String()),
    sa.Column("title", types.String(255)),
    sa.Column("brief", types.String()),
    sa.Column("update_time", types.DateTime()),
)

class Subject(object):
    def __str(self):
        return self.title

IdTable(
    Subject,
    ForeignKey(ResourceSite),
    sa.Column("href", types.String()),
    sa.Column("title", types.String(255)),
    sa.Column("update_time", types.DateTime()),
)

class Plunder(object):
    def __str(self):
        return self.title

IdTable(
    Plunder,
    ForeignKey(Subject),
    sa.Column("href", types.String()),
    sa.Column("title", types.String(255)),  
    sa.Column("brief", types.String()),
    sa.Column("update_time", types.DateTime(),default=lambda:datetime.now()),
    sa.Column("tag", types.String(255)),
    sa.Column("author", types.String(255)),
    sa.Column("content", types.String()),
).mapper(order_by=[Plunder.table.c.update_time.desc()])