cornice with sqlalchemy

gistfile1.py

from cornice.resource import resource
def dbresource(**kw):
    """Class decorator to declare CRUD classes.
    """
    def wrapper(klass):
        setattr(klass, kw.pop('mapping'))
        setattr(klass, kw.pop('session'))
        setattr(klass, kw.pop('match_key', 'id'))
        setattr(klass, kw.pop('primary_key', 'id'))

        if klass.mapping is None:
            raise ValueError('You need to define a mapping when calling @crud')

        if klass.session is None:
            raise ValueError('You need to define a session when calling @crud')

        klass.dbsession = klass.session()
        klass.cols = klass.mapping.__table__.c.keys()

        klass = resource(**kw)(klass)
        return klass
    return wrapper