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()])