def complex_select(table, columns=None, clause=None, group=None, having=None, order=None): sel = simple_select(table, columns=columns, clause=clause) if group: sel += ' GROUP BY %s' % handle_fieldlist(group) if having: sel += ' HAVING %s' % having if order: sel += ' ORDER BY %s' % handle_fieldlist(order) return sel
def simple_select(table=None, columns=None, clause=None): if columns is not None: if type(columns) != str: cols = handle_fieldlist(list(columns)) else: cols = columns else: cols = '*' sel = 'select %s' % cols if table is not None: sel += ' from %s' % table if clause is not None: sel += ' where %s' % clause return sel
def make_tuple(alist): return '(%s)' % handle_fieldlist(alist)
def _set_vals_(a_dict): return handle_fieldlist([_set_eq_(k,v) for k,v in a_dict.items()])