Example #1
0
 def NOT_IN(builder, expr1, x):
     if not x:
         return '1 = 1'
     if len(x) >= 1 and x[0] == 'SELECT':
         return builder(expr1), ' NOT IN ', builder(x)
     op = ' NOT IN (VALUES ' if expr1[0] == 'ROW' else ' NOT IN ('
     expr_list = [builder(expr) for expr in x]
     return builder(expr1), op, join(', ', expr_list), ')'
Example #2
0
 def MAX(builder, *args):
     if len(args) == 0: assert False  # pragma: no cover
     elif len(args) == 1: fname = 'MAX'
     else: fname = 'max'
     return fname, '(', join(', ', imap(builder, args)), ')'
Example #3
0
 def MAKE_ARRAY(builder, *items):
     return 'ARRAY[', join(', ', (builder(item) for item in items)), ']'
Example #4
0
 def CONCAT(builder, *args):
     return 'concat(', join(', ', imap(builder, args)), ')'
 def MAKE_ARRAY(builder, *items):
     return 'py_make_array(', join(', ',
                                   (builder(item) for item in items)), ')'
Example #6
0
 def MIN(builder, *args):
     if len(args) == 0: assert False
     elif len(args) == 1: fname = 'MIN'
     else: fname = 'min'
     return fname, '(', join(', ', map(builder, args)), ')'
Example #7
0
 def MAX(builder, *args):
     if len(args) == 0: assert False
     elif len(args) == 1: fname = 'MAX'
     else: fname = 'max'
     return fname, '(',  join(', ', map(builder, args)), ')'
Example #8
0
 def CONCAT(builder, *args):
     return 'concat(',  join(', ', map(builder, args)), ')'
Example #9
0
 def MIN(builder, *args):
     if len(args) == 0: assert False  # pragma: no cover
     elif len(args) == 1: fname = 'MIN'
     else: fname = 'min'
     return fname, '(',  join(', ', imap(builder, args)), ')'