Python DB.fetchall方法代码示例

# 需要导入模块: from webp.utils.db import DB [as 别名]
# 或者: from webp.utils.db.DB import fetchall [as 别名]
    def search_by_module_id(module_id, tac_name):
        db = DB()
        if tac_name:
            sql = " select a.id,a.name,a.description,a.dt,a.key_1,a.value_1,a.key_2,a.value_2,a.key_3,a.value_3,a.key_4,a.value_4,a.key_5,a.value_5,b.name module_name from tac a,module b where a.module_id=b.id and b.id=%d and a.name like '%s' order by a.dt desc" % (module_id, tac_name)
        else:
            sql = " select a.id,a.name,a.description,a.dt,a.key_1,a.value_1,a.key_2,a.value_2,a.key_3,a.value_3,a.key_4,a.value_4,a.key_5,a.value_5,b.name module_name from tac a,module b where a.module_id=b.id and b.id=%d order by a.dt desc" % (module_id, )

        print 'search_by_module_id', sql
        db.cursor.execute(sql)
        res = db.fetchall()
        _list = []

        for id, name, description, dt, \
            key_1, value_1, key_2, value_2, key_3, value_3, \
            key_4, value_4, key_5, value_5, module_name in res:

            keyvalues = [(key, value) for (key, value) in (
                    (key_1, value_1),
                    (key_2, value_2),
                    (key_3, value_3),
                    (key_4, value_4),
                    (key_5, value_5),
                ) if key ]
            _list.append({
                'id': id,
                'name': name,
                'description': description,
                'dt': dt,
                'keyvalues': keyvalues,
                'module_name': module_name,
                })
        return _list

# 需要导入模块: from webp.utils.db import DB [as 别名]
# 或者: from webp.utils.db.DB import fetchall [as 别名]
 def search_by_tac_id(tac_id):
     db = DB()
     sql = "select a.id,a.name,a.description,a.dt,a.key_1,a.value_1,a.key_2,a.value_2,a.key_3,a.value_3,a.key_4,a.value_4,a.key_5,a.value_5,b.name module_name from tac a,module b where a.module_id=b.id and a.id=%d"  % tac_id
     #print 'search_by_tacid', sql
     db.execute(sql)
     res = db.fetchall()
     return res

# 需要导入模块: from webp.utils.db import DB [as 别名]
# 或者: from webp.utils.db.DB import fetchall [as 别名]
def list(request):
    db = DB()
    tac_name = request.GET['tac_name']
    func_flag = request.GET['func_flag']
    sql = strtpl("select a.id,c.name taca_name,d.name tacb_name,e.name user_name,a.dt,a.status,a.description from func_tac_rel a,func b,tac c,tac d,user e where a.func_id=b.id and a.taca_id=c.id and a.tacb_id=d.id and a.user_id=e.id and b.flag='$func_flag' and (c.name like '%$tac_name%' or d.name like '%$tac_name%') order by a.dt desc").substitute(
            tac_name = tac_name,
            func_flag = func_flag)

    _debug_print('sql ' + sql)
    db.execute(sql)
    _list = []
    res = db.fetchall()
    _debug_print( 'res'+ str(res))
    data = {}
    for data['id'], data['taca_name'], data['tacb_name'], \
            data['user_name'], data['dt'], data['status'], data['description'] in res:

        _debug_print('data:' + str(data))
        ft = FuncTac( **data )
        _list.append(ft)
        data = {}

    dic = user_utils.user_info_context(request)

    user = dic['user']
    module = user.get_module('nonmarked')
    func = module.get_func('fieldcase')

    dic.update({
        'func': func,
        'list': _list,
        })
    return render_to_response("html/nonmarked/fieldcase/list.html", dic)

# 需要导入模块: from webp.utils.db import DB [as 别名]
# 或者: from webp.utils.db.DB import fetchall [as 别名]
class Module(object):

    def __init__(self, id=-1):
        self.id = id
        self.moduleobject = ModuleObject()
        self.db = DB()

    def fill(self, module_flag, module_name, roleId):
        '''
        query db and get all data to fill the object
        '''
        self.moduleobject.id = self.id
        self.moduleobject.flag = module_flag
        self.moduleobject.name = module_name
        self.roleId = roleId
        self._fill_funcs()

    def get_object(self):
        return self.moduleobject

    #TODO some bugs here
    def _fill_funcs(self):
        print 'module init len', len(self.moduleobject.list)
        sql = "select a.id func_id,a.flag func_flag,a.name func_name,c.flag purview_flag from func a,func_purview_role_rel b,purview c where a.id=b.func_id and b.purview_id=c.id and a.module_id=%d and b.role_id=%d order by a.sequence asc,a.id desc" % (self.id, self.roleId)
        self.db.execute(sql)
        res = self.db.fetchall()

        func_ids = set()
        last_f = None

        print 'module res:', res

        for func_id, func_flag, func_name, purview_flag in res:
            func_flag = func_flag
            func_name = func_name
            purview_flag = func_name

            if func_id in func_ids:
                last_f.purview.add(purview_flag)

            else:
                func_ids.add(func_id)
                f = Func(
                    id = func_id, 
                    flag = func_flag,
                    name = func_name
                )
                f.purview.add(purview_flag)
                self.moduleobject.list.add(f)
                last_f = f

    def __str__(self):
        return str(self.moduleobject)

# 需要导入模块: from webp.utils.db import DB [as 别名]
# 或者: from webp.utils.db.DB import fetchall [as 别名]
def createinit(request):
    module_flag = request.GET['module_flag']
    db = DB()
    module_id = db.get_value("select id from module where flag='%s'" % module_flag)
    db.execute("select id,name from tac where module_id=%d" % module_id)
    res = db.fetchall()
    _list = []

    for id, name in res:
        tac = Tac(id=id, name=name)
        _list.append(tac)

    dic = user_utils.user_info_context(request)
    dic['tacs'] = _list

    return render_to_response("html/nonmarked/fieldstat/create.html", dic)

# 需要导入模块: from webp.utils.db import DB [as 别名]
# 或者: from webp.utils.db.DB import fetchall [as 别名]
def createinit(request):
    db = DB()
    dic = user_utils.user_info_context(request)
    module_flag = 'dcg'
    module_id = ModuleCtrl.get_id(module_flag)
    db.execute("select key_1, key_2, key_3, key_4, key_5 from tac where module_id=%d order by dt desc limit 0,1" % module_id)
    res = db.fetchall()

    if not res:
        keylist = ["" for i in range(5)]
    else:
        res = List(res[0])
        #print 'createinit res:', res
        keys = res + ["" for i in range(5)]
        keylist = [keys[i] for i in range(5)]
    dic.update({
        'keylist': keylist,
        })
    return render_to_response("html/dcg/tac/tac_create.html", dic)

# 需要导入模块: from webp.utils.db import DB [as 别名]
# 或者: from webp.utils.db.DB import fetchall [as 别名]
 def search(tac_name, func_flag):
     print 'searching ...'
     db = DB()
     sql = strtpl("select a.id,c.name tac_name,d.name user_name,a.dt,a.status,a.description from func_tac_rel a,func b,tac c,user d where a.func_id=b.id and a.taca_id=c.id and a.user_id=d.id and b.flag='$func_flag' and c.name like '%$tac_name%' order by a.dt desc").safe_substitute(dict(func_flag=func_flag, tac_name=tac_name))
     print 'anchorstat search sql:', sql
     db.execute(sql)
     res = db.fetchall()
     _list = []
     for id, tac_name, user_name, dt, status, description in res:
         keys = dict(
             id = id,
             tac_name = tac_name,
             user_name = user_name,
             dt = dt,
             status = status, 
             description = description,
             status_is_1 = (status == 1),
             status_is_m1 = (status == -1),
             status_is_0 = (status == 0))
         _list.append(keys)
     return _list