Python metaclass example

gistfile1.txt

class QueryBook(object):
    def __init__(self, tableName):
        self.tableName = tableName

    def add(self, queryName, query):
        #setattr(self, queryName, query)
        def execute(*args):
            self.__execute(query, args)

        setattr(self, "exec"+queryName.upper(), execute)

    def __execute(self, query, *args):
        print self.tableName,query,args

class MetaObjectQueryBook(type):
    def __new__(mcs, name, bases, dct):
        tableName = dct["TABLE_NAME"]
        book = QueryBook(tableName)
        del dct["TABLE_NAME"]
        attributes = ((name, value) for name, value in dct.items() if not name.startswith('__'))

        for name, value in attributes:
            book.add(name, value)

        return super(MetaObjectQueryBook, mcs).__new__(mcs, name, bases, {"queryBook":book})

class One:
    __metaclass__ = MetaObjectQueryBook

    TABLE_NAME = "login"
    CREATE = "CREATE TABLE LOGIN"
    INSERT = "CREATE TABLE DATA"

one = One()
one.queryBook.execCREATE(1,2,3)