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" % cj_fields(group) if having: sel += " HAVING %s" % having if order: sel += " ORDER BY %s" % cj_fields(order) return sel
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' % cj_fields(group) if having: sel += ' HAVING %s' % having if order: sel += ' ORDER BY %s' % cj_fields(order) return sel
def _change_access(type, privilege, tables, user): tables = cj_fields(tables) if type == 'grant': return 'GRANT %s on %s to %s' %(privilege, tables, user) elif type == 'revoke': return 'REVOKE %s on %s from %s' %(privilege, tables, user) else: raise Error, 'bad command type in _change_access'
def _change_access(type, privilege, tables, user): tables = cj_fields(tables) if type == 'grant': return 'GRANT %s on %s to %s' % (privilege, tables, user) elif type == 'revoke': return 'REVOKE %s on %s from %s' % (privilege, tables, user) else: raise Error, 'bad command type in _change_access'
def simple_select(table, columns=None, clause=None): if len(columns): cols = cj_fields(columns) else: cols = "*" sel = "select %s from %s" % (cols, table) if clause: sel += " where %s" % clause return sel
def simple_select(table, columns=None, clause=None): if len(columns): cols = cj_fields(columns) else: cols = '*' sel = 'select %s from %s' %(cols, table) if clause: sel += ' where %s' % clause return sel
def simple_select(table, columns=None, clause=None): if columns is not None: if type(columns) != str: cols = cj_fields(list(columns)) else: cols = columns else: cols = '*' sel = 'select %s from %s' %(cols, table) if clause: sel += ' where %s' % clause return sel
def _set_vals_(a_dict): return cj_fields([_set_eq_(k,v) for k,v in a_dict.items()])
def make_tuple(alist): return '(%s)' % cj_fields(alist)
def _set_vals_(a_dict): return cj_fields([_set_eq_(k, v) for k, v in a_dict.items()])