base.py 文件源码

def EXPAND_CASE(self, query, true_false):
        def represent(x):
            types = {type(True):'boolean',type(0):'integer',type(1.0):'double'}
            if x is None: return 'NULL'
            elif isinstance(x,Expression): return str(x)
            else: return self.represent(x,types.get(type(x),'string'))

        return 'CASE WHEN %s THEN %s ELSE %s END' % (
            self.expand(query),
            represent(true_false[0]),
            represent(true_false[1]))