本文整理汇总了Python中webp.utils.db.DB.execute方法的典型用法代码示例。如果您正苦于以下问题:Python DB.execute方法的具体用法?Python DB.execute怎么用?Python DB.execute使用的例子?那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类webp.utils.db.DB
的用法示例。
在下文中一共展示了DB.execute方法的15个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的Python代码示例。
示例1: list
# 需要导入模块: from webp.utils.db import DB [as 别名]
# 或者: from webp.utils.db.DB import execute [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)
示例2: from_db_by_func_tac_id
# 需要导入模块: from webp.utils.db import DB [as 别名]
# 或者: from webp.utils.db.DB import execute [as 别名]
def from_db_by_func_tac_id(tac='taca_id', func_tac_id=-1):
db = DB()
sql = "select id,name,key_1,value_1,key_2,value_2,key_3,value_3,key_4,value_4,key_5,value_5 from tac where id=(select %s from func_tac_rel where id=%d)" % (tac, func_tac_id)
db.execute(sql)
res = db.fetchone()
tac = Tac()
if res:
(id, name,
key_1, value_1,
key_2, value_2,
key_3, value_3,
key_4, value_4,
key_5, value_5,) = res
tac = Tac( id = id, name = name)
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 or value:
tac.map[key] = value
return tac
示例3: from_db
# 需要导入模块: from webp.utils.db import DB [as 别名]
# 或者: from webp.utils.db.DB import execute [as 别名]
def from_db(id):
db = DB()
sql = "select id,name,key_1,value_1,key_2,value_2,key_3,value_3,key_4,value_4,key_5,value_5 from tac where id=%d" % id
db.execute(sql)
res = db.fetchone()
tac = Tac()
if res:
(id, name, key_1, value_1,
key_2, value_2, key_3, value_3,
key_4, value_4, key_5, value_5) = res
tac.id = id
tac.name = name
for (key, value) in [
(key_1, value_1),
(key_2, value_2),
(key_3, value_3),
(key_4, value_4),
(key_5, value_5),]:
key = key.strip()
value = value.strip()
if key or value:
tac.map[key] = value
return tac
示例4: search_by_tac_id
# 需要导入模块: from webp.utils.db import DB [as 别名]
# 或者: from webp.utils.db.DB import execute [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
示例5: has
# 需要导入模块: from webp.utils.db import DB [as 别名]
# 或者: from webp.utils.db.DB import execute [as 别名]
def has( tac_id):
db = DB()
sql = "select count(*) from func_tac_rel where taca_id=%d or tacb_id=%d" % (tac_id, tac_id)
db.execute(sql)
res = db.fetchone()
print 'count', res
count = res[0]
return count > 0
示例6: get_id
# 需要导入模块: from webp.utils.db import DB [as 别名]
# 或者: from webp.utils.db.DB import execute [as 别名]
def get_id(flag):
db = DB()
sql = "select id from module where flag='%s'" % flag
print 'sql:', sql
db.execute(sql)
res = db.fetchone()
id = res[0]
return id
示例7: delete
# 需要导入模块: from webp.utils.db import DB [as 别名]
# 或者: from webp.utils.db.DB import execute [as 别名]
def delete(tac_id):
db = DB()
if Tac.has(tac_id):
return "a task is running!"
sql = "delete from tac where id=%d" % tac_id
db.execute(sql)
db.commit()
return True
示例8: Module
# 需要导入模块: from webp.utils.db import DB [as 别名]
# 或者: from webp.utils.db.DB import execute [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)
示例9: create
# 需要导入模块: from webp.utils.db import DB [as 别名]
# 或者: from webp.utils.db.DB import execute [as 别名]
def create(dic):
db = DB()
g = dic
module_id = g['module_id']
sql = "insert into tac(module_id,name,description,key_1,value_1,key_2,value_2,key_3,value_3,key_4,value_4,key_5,value_5) values(%d,'%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s')" \
% (module_id, g['name'], g['description'],
g['key_1'], g['value_1'], g['key_2'], g['value_2'],
g['key_3'], g['value_3'], g['key_4'], g['value_4'],
g['key_5'], g['value_5'], )
try:
db.execute(sql)
return True
except Exception,e:
print 'error of create:', e
示例10: update
# 需要导入模块: from webp.utils.db import DB [as 别名]
# 或者: from webp.utils.db.DB import execute [as 别名]
def update(dic):
db = DB()
sql = "update tac set name='%s',description='%s',key_1='%s',value_1='%s',key_2='%s',value_2='%s',key_3='%s',value_3='%s',key_4='%s',value_4='%s',key_5='%s',value_5='%s' where id=%d" \
% tuple([ dic[key] for key in (
'name', 'description',
'key_1', 'value_1',
'key_2', 'value_2',
'key_3', 'value_3',
'key_4', 'value_4',
'key_5', 'value_5',
'tac_id',
)])
db.execute(sql)
db.commit()
return True
示例11: createinit
# 需要导入模块: from webp.utils.db import DB [as 别名]
# 或者: from webp.utils.db.DB import execute [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)
示例12: create_schedule
# 需要导入模块: from webp.utils.db import DB [as 别名]
# 或者: from webp.utils.db.DB import execute [as 别名]
def create_schedule(request):
db = DB()
func_tac_id = int(request.GET["func_tac_id"])
db.execute("select a.path,c.name taca_name,d.name tacb_name from func_tac_log a join func_tac_rel b on a.func_tac_id=b.id left join tac c on b.taca_id=c.id left join tac d on b.tacb_id=d.id where b.id=%d" % func_tac_id)
res = db.fetchone()
if res: log_path, taca_name, tacb_name = res
dic = user_utils.user_info_context(request)
try:
dic.update( dict(
schedule = filetool.read(log_path) + "<br/>",
tacName = "%s_%s"%(taca_name, tacb_name) if tacb_name != None else taca_name,
))
return render_to_response("/html/nonmarked/fieldcase/createschedule.html", dic)
except:
return HttpResponse("日志文件不存在")
示例13: createinit
# 需要导入模块: from webp.utils.db import DB [as 别名]
# 或者: from webp.utils.db.DB import execute [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)
示例14: show
# 需要导入模块: from webp.utils.db import DB [as 别名]
# 或者: from webp.utils.db.DB import execute [as 别名]
def show(request):
db = DB()
dic = user_utils.user_info_context(request)
module_flag = request.GET['module_flag']
func_flag = request.GET['func_flag']
func_tac_id = request.GET['func_tac_id']
sql = strtpl("select c.name from func_tac_rel a,func b,tac c where a.func_id=b.id and a.taca_id=c.id and a.id=$func_tac_id").substitute(func_tac_id = func_tac_id)
db.execute(sql)
tac_name = (db.fetchone()[0]).strip()
try:
path = os.path.join(
Util.INVLINK_HOME,
module_flag, func_flag,
'display', tac_name, 'info')
_debug_print("des_path: ", path)
return render_to_response("html/dcg/rankla/show.html", dic)
except:
return HttpResponse("file does not exist!")
示例15: search
# 需要导入模块: from webp.utils.db import DB [as 别名]
# 或者: from webp.utils.db.DB import execute [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