cccursor.py

python web programming 部分

#
# ccCursor.py: baseCursor to handle "+" instead of "||"
#
from baseCursor import baseCursor

def gfs(s):
    if s:
        return s.replace("||", "+")

def gft(x):
    if x:
        if type(x) == type(""):
            return gfs(x)
        else:
            return [gft(e) for e in x]

class ccCursor(baseCursor):
    """Subclass replacing ANSI concatenation with "+"."""

    def DELETE(self, tname, WHERE=None):
        return baseCursor.DELETE(self, tname, gft(WHERE))

    def INSERT(self, tname, fnames=None, VALUES=None):
        return baseCursor.INSERT(self, tname, fnames, VALUES=gft(VALUES))

    def SELECT(self, fields, FROM=None, WHERE=None, REST=None):
        return baseCursor.SELECT(self, gft(fields), FROM=FROM, WHERE=gft(WHERE), REST=gft(REST))

    def UPDATE(self, table, cols, vals, WHERE=None):
        return baseCursor.UPDATE(self, table, cols, gft(vals), WHERE=gft(WHERE))