字典取元素

for h_id, p_id in rt_list_:
    print assets_[h_id]
    if assets_[h_id] not in assets_projects:
        assets_projects[assets_[h_id]] = {project_name_id[p_id]: p_id}
    elif assets_[h_id] in assets_projects:
        assets_projects[assets_[h_id]].update({project_name_id[p_id]: p_id})

# 没有考虑到key不存在时会报KeyError

# 改版dict.get()
assets_projects = {}
for h_id, p_id in rt_list_:
    if not assets_projects.get(assets_[h_id]):
        assets_projects[assets_[h_id]] = {project_name_id[p_id]: p_id}
    elif assets_projects.get(assets_[h_id]):
        assets_projects[assets_[h_id]].update({project_name_id[p_id]: p_id})

print assets_projects

数据库授权

1.先 GRANT ALL ON 
2.再 GRANT SELECT 
以上方法失误
必须REVOKE 收回权限再次授权,否则无法生效