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 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()