def add(request, **kwargs): user = kwargs['username'] if request.method == 'POST': inp_hosts_group = request.POST.get('inp_hg') # print(inp_hosts_group) inp_host = request.POST.get('inp_host') inp_ip = request.POST.get('inp_ip') inp_port = request.POST.get('inp_port') inp_dns_name = request.POST.get('inp_dns_name') inp_remark = request.POST.get('inp_remark') inp_pc = request.POST.get('inp_pc') inp_buy_year = request.POST.get('inp_buy_year') h = models.Hosts(host=inp_host, ip=inp_ip, port=inp_port, dns_name=inp_dns_name, remark=inp_remark, pc=inp_pc, buy_year=inp_buy_year, modify_user='******', modify_datetime=datetime.datetime.now(), status=1, hosts_group_id=inp_hosts_group) print(h) # 生成session实例 db_session = models.Session_class() db_session.add(h) db_session.commit() db_session.close() return redirect('/index/' + user)
def detail(request): nid = request.GET.get('nid') print(nid) # 生成session实例 db_session = models.Session_class() data = db_session.query(models.Hosts).filter( models.Hosts.id == nid).filter(models.Hosts.status == 1).first() db_session.close() return render(request, 'detail.html', {'data': data})
def host_del(request, **kwargs): user = kwargs['username'] if request.method == 'POST': nid = request.POST.get('nid') print(nid) # 生成session实例 db_session = models.Session_class() hosts = db_session.query( models.Hosts).filter(models.Hosts.id == nid).first() hosts.status = 0 hosts.modify_user = user hosts.modify_datetime = datetime.datetime.now() db_session.commit() db_session.close() return redirect('/index/' + user)
def index(request, **kwargs): # 生成session实例 user = kwargs['username'] HOST_LIST = [] db_session = models.Session_class() data = db_session.query(models.User).filter_by(name=user).first() for g in data.hosts_group: for h in g.hosts_list: if h.status == 1: HOST_LIST.append(h) db_session.close() return render(request, 'index.html', { 'host_list': HOST_LIST, 'username': user })
def login(request): error_msg = '' if request.method == 'POST': user = request.POST.get('username', None) pwd = request.POST.get('password', None) print(user, md5_encode(pwd)) # 生成session实例 db_session = models.Session_class() data = db_session.query(models.User).filter_by(name=user).filter_by( password=md5_encode(pwd)).first() # print(data) db_session.close() if data: return redirect('/index/' + user) # if user == 'root' and pwd == '123': # return redirect('/index') else: error_msg = '用户名或者密码错误!' return render(request, 'login.html', {'error_msg': error_msg})
def edit(request, **kwargs): user = kwargs['username'] nid = request.GET.get('nid') print(nid) # 生成session实例 db_session = models.Session_class() hosts = db_session.query(models.Hosts).filter( models.Hosts.id == nid).filter(models.Hosts.status == 1).first() if request.method == 'GET': host_group_list = db_session.query(models.Hosts_Group).all() db_session.close() return render(request, 'edit.html', { 'hosts': hosts, 'host_group_list': host_group_list, 'username': user }) if request.method == 'POST': inp_hosts_group = request.POST.get('inp_hg') inp_host = request.POST.get('inp_host') inp_ip = request.POST.get('inp_ip') inp_port = request.POST.get('inp_port') inp_dns_name = request.POST.get('inp_dns_name') inp_remark = request.POST.get('inp_remark') inp_pc = request.POST.get('inp_pc') inp_buy_year = request.POST.get('inp_buy_year') hosts.host = inp_host hosts.ip = inp_ip hosts.port = inp_port hosts.dns_name = inp_dns_name hosts.remark = inp_remark hosts.pc = inp_pc hosts.buy_year = inp_buy_year hosts.modify_datetime = datetime.datetime.now() hosts.hosts_group_id = inp_hosts_group print(hosts) db_session.commit() db_session.close() return HttpResponse('update successful..')