Python cj_fields示例

示例#1

文件： select.py 项目： BackupTheBerlios/paella-svn

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

示例#2

文件： select.py 项目： pombredanne/paella-svn

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

示例#3

文件： admin.py 项目： BackupTheBerlios/paella-svn

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'

示例#4

文件： admin.py 项目： pombredanne/paella-svn

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'

示例#5

文件： select.py 项目： BackupTheBerlios/paella-svn

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

示例#6

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

示例#7

文件： select.py 项目： pombredanne/paella-svn

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

示例#8

文件： write.py 项目： BackupTheBerlios/useless-svn

def _set_vals_(a_dict):
    return cj_fields([_set_eq_(k,v) for k,v in a_dict.items()])

示例#9

文件： write.py 项目： BackupTheBerlios/useless-svn

def make_tuple(alist):
    return '(%s)' % cj_fields(alist)

示例#10

def _set_vals_(a_dict):
    return cj_fields([_set_eq_(k, v) for k, v in a_dict.items()])

示例#11

def make_tuple(alist):
    return '(%s)' % cj_fields(alist)