def search_all_resource(name, resource_type = 'All', limit=200):
"全站搜索"
if resource_type == 'All':
return db.select(alldbname, where = 'resource_name like "%' + name + '%"', order = "hotrank DESC", limit = limit).list()
else:
return db.select(alldbname,
where = 'typeL1 = "' + resource_type + '" and resource_name like "%' + name + '%"', order = "hotrank DESC", limit = limit).list()
def search_all_resource(name, resource_type='All', limit=200):
"全站搜索"
if resource_type == 'All':
return db.select(alldbname,
where='resource_name like "%' + name + '%"',
order="hotrank DESC",
limit=limit).list()
else:
return db.select(alldbname,
where='typeL1 = "' + resource_type +
'" and resource_name like "%' + name + '%"',
order="hotrank DESC",
limit=limit).list()
def get_id_byname(name):
try:
return db.select(tb, what="id", where="hostname=$name",
vars=locals())[0]
except IndexError:
return None
def checkLogin(self, username, password):
password1 = hashlib.md5(password).hexdigest()
myvar = dict(username=username, password1=password1)
result = db.select(table,
myvar,
where='username=$username and password=$password1')
return result
def find_user(username):
try:
return db.select('users',
what="*",
where="username=$username",
vars=locals())[0]
except IndexError:
return None
def get_status_by_name(username):
try:
return db.select('users',
what='status',
where="username=$username",
vars=locals())[0]
except IndexError:
return None
def get_allentries(tb='vserver_info'):
return db.select(tb, order='hostname ASC', vars=locals())
def get_tags(tb=tb_ctmgt):
return db.select(tb, order="tagname ASC", vars=locals())
def get(table, **kw):
return db.select(table, **kw)
def get_asset_by_name(name, tb='asset'):
return db.select(tb, where='logic_name=$logic_name', vars=locals())
def get_hosts_orderby_db(order='ASC'):
return db.select(tb, where="type='host'", order='datacenter ' + order)
def get_item_text(itemid):
'''编辑页面，更新信息回显'''
return db.select('item', what='id, pid, item_order, is_visible, title, text', where='id=$itemid', vars=locals())
def get_item_text(itemid):
return db.select('item', what='id, pid, item_order, title, text', where='id=$itemid', vars=locals())
def get_tags_by_id(id, tb=tb_ctmgt):
return db.select(tb, where='id=$id', vars=locals())
def get_hosts():
return db.select(tb, order='hostname ASC')
def get_project_list():
return db.select("project", what="id, name", where="id>=99")
def get_project_list():
return db.select('project', what='id, name', where='id>=100')
def get_item_list(pid, is_visible=1):
'''左侧显示列表'''
return db.select('item', what='id, title', where='pid=$pid and is_visible=$is_visible', order="item_order", vars=locals())
def get_pids_with_itemid():
return db.select('item', what='id, pid', where='pid>=99')
def get_maxtag(tb=tb_ctmgt):
return db.select(tb,
what="*",
where="tagname=(select max(tagname) from capacity_tags)",
vars=locals())
def checkLogin(self, username, password): password1 = hashlib.md5(password).hexdigest() myvar = dict(username=username, password1=password1) result = db.select(table, myvar, where='username=$username and password=$password1') return result
def get_hosts():
return db.select(tb, where="type='host'", order='hostname ASC')
def getUserList():
return db.select('users', order="lastlogin DESC")
def get_tags_by_name(name, tb=tb_ctmgt):
return db.select(tb, where='tagname=$name', vars=locals())
def get_item_list(pid):
return db.select('item', what='id, title', where='pid=$pid', order="item_order", vars=locals())
def get_entry(id, tb='vserver_info'):
try:
return db.select(tb, where='id=$id', vars=locals())[0]
except IndexError:
return None
def get_item_content(itemid):
'''右侧显示文章区'''
return db.select('item', what='title, html', where='id=$itemid', vars=locals())
def get_entries(type='vhost'):
return db.select(tb,
where='type=$type',
order='hostname ASC',
vars=locals())
def get_entries_orderby_dc(type='vhost', item='datacenter', order='ASC'):
return db.select(tb,
where='type=$type',
order=item + ' ' + order,
vars=locals())
def get_fail_times(name):
r = db.select('loginfail', what='times', where='name=$name', vars=locals())
if r:
return r[0].times
else:
return 0
def get_assets(tb='asset'):
return db.select(tb, order="logic_name ASC", vars=locals())
def getConfig():
query = db.select('config')
return query[0]
def get_asset(id, tb='asset'):
return db.select(tb, where='id=$id', vars=locals())
def get_resource_group(resource_info_id):
"获取相近资源记录"
return db.select(alldbname, where = 'resource_info_id=' + str(resource_info_id), order = "hotrank DESC").list()
def get_resource_group(resource_info_id):
"获取相近资源记录"
return db.select(alldbname,
where='resource_info_id=' + str(resource_info_id),
order="hotrank DESC").list()
