本文整理汇总了Python中webp.utils.db.DB.fetchall方法的典型用法代码示例。如果您正苦于以下问题:Python DB.fetchall方法的具体用法?Python DB.fetchall怎么用?Python DB.fetchall使用的例子?那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类webp.utils.db.DB
的用法示例。
在下文中一共展示了DB.fetchall方法的7个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的Python代码示例。
示例1: search_by_module_id
# 需要导入模块: 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
示例2: search_by_tac_id
# 需要导入模块: 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
示例3: list
# 需要导入模块: 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)
示例4: Module
# 需要导入模块: 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)
示例5: createinit
# 需要导入模块: 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)
示例6: createinit
# 需要导入模块: 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)
示例7: search
# 需要导入模块: 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