示例#1
0
def idc(req):
    context = {}
    if not req.user.is_authenticated():
        return HttpResponseRedirect('/login/')
    username = req.session.get('username')
    import MySQLdb
    db = MySQLdb.connect(user='******',
                         db='opsadmin',
                         passwd='opsadmin',
                         host='localhost',
                         charset='utf8')
    cursor = db.cursor()
    #cursor.execute("SET NAMES 'gb2312'")
    cursor.execute('select * from opsadmin_idcnamelist')
    idcnamelist = cursor.fetchall()
    cursor.execute('select * from opsadmin_location')
    locationlist = cursor.fetchall()
    cursor.execute(
        'select id,nodename,ipv4,sshport,status,location,idcname,is_virtual,serialnumber,cpu_model,harddisk,memory,ostype,buytime,qualitytime,detail from opsadmin_idcmanager'
    )
    idcmanager_host_info = cursor.fetchall()
    db.close

    if req.method == "POST":
        print req.POST
        idcmanager = Idcmanager()
        idcmanager.nodename = req.POST.get('hostname')
        idcmanager.ipv4 = req.POST.get('ip')
        idcmanager.serialnumber = req.POST.get('serialnumber')
        idcmanager.sshport = req.POST.get('sshport')
        idcmanager.status = req.POST.get('status')
        idcmanager.location = req.POST.get('location')
        idcmanager.idcname = req.POST.get('idcname')
        idcmanager.ostype = req.POST.get('ostype')
        idcmanager.cpu = req.POST.get('cpu')
        idcmanager.harddisk = req.POST.get('harddisk')
        idcmanager.memory = req.POST.get('memory')
        idcmanager.buytime = req.POST.get('buytime')
        idcmanager.qualitytime = req.POST.get('qualitytime')
        idcmanager.detail = req.POST.get('detail')

        idcmanager.save()
    if req.method == "GET":
        #data=Idcnamelist.objects.all()
        #idcnamelist_dict=Idcnamelist.objects.order_by("id")
        #idcnamelist=idcnamelist_dict.values()
        #idcnamelist=Idcnamelist.objects.values()
        get = 'test'
    return render_to_response('idc-manager.html', {
        'username': username,
        'idcnamelist': idcnamelist,
        'locationlist': locationlist,
        'idcmanager_host_info': idcmanager_host_info
    },
                              context_instance=RequestContext(req))
示例#2
0
文件: views.py 项目: AmiLiY/opsadmin
def idc(req):
    context={}
    if not req.user.is_authenticated():
        return HttpResponseRedirect('/login/')
    username=req.session.get('username')
    import MySQLdb
    db = MySQLdb.connect(user='******', db='opsadmin', passwd='opsadmin', host='localhost',charset='utf8')
    cursor=db.cursor()
    #cursor.execute("SET NAMES 'gb2312'")
    cursor.execute('select * from opsadmin_idcnamelist')
    idcnamelist=cursor.fetchall()
    cursor.execute('select * from opsadmin_location')
    locationlist=cursor.fetchall()
    cursor.execute('select id,nodename,ipv4,sshport,status,location,idcname,is_virtual,serialnumber,cpu_model,harddisk,memory,ostype,buytime,qualitytime,detail from opsadmin_idcmanager')
    idcmanager_host_info=cursor.fetchall()
    db.close

    if req.method == "POST":
       print req.POST
       idcmanager=Idcmanager()
       idcmanager.nodename=req.POST.get('hostname')
       idcmanager.ipv4=req.POST.get('ip')
       idcmanager.serialnumber=req.POST.get('serialnumber')
       idcmanager.sshport=req.POST.get('sshport')
       idcmanager.status=req.POST.get('status')
       idcmanager.location=req.POST.get('location')
       idcmanager.idcname=req.POST.get('idcname')
       idcmanager.ostype=req.POST.get('ostype')
       idcmanager.cpu=req.POST.get('cpu')
       idcmanager.harddisk=req.POST.get('harddisk')
       idcmanager.memory=req.POST.get('memory')
       idcmanager.buytime=req.POST.get('buytime')
       idcmanager.qualitytime=req.POST.get('qualitytime')
       idcmanager.detail=req.POST.get('detail')

       idcmanager.save()
    if req.method == "GET":
        #data=Idcnamelist.objects.all()
        #idcnamelist_dict=Idcnamelist.objects.order_by("id")
        #idcnamelist=idcnamelist_dict.values()
        #idcnamelist=Idcnamelist.objects.values()
        get='test'
    return render_to_response('idc-manager.html',{'username':username,'idcnamelist':idcnamelist,'locationlist':locationlist,'idcmanager_host_info':idcmanager_host_info},context_instance=RequestContext(req))
示例#3
0
文件: views.py 项目: huahu/opsadmin-1
def idc(req):
    context={}
    if req.method == "POST":
       idcmanager=Idcmanager()
       idcmanager.hostname=req.POST.get('hostname')
       idcmanager.ip=req.POST.get('ip')
       idcmanager.serialnumber=req.POST.get('serialnumber')
       idcmanager.sshport=req.POST.get('sshport')
       idcmanager.status=req.POST.get('status')
       idcmanager.location=req.POST.get('location')
       idcmanager.idcname=req.POST.get('idcname')
       idcmanager.ostype=req.POST.get('ostype')
       idcmanager.cpu=req.POST.get('cpu')
       idcmanager.harddisk=req.POST.get('harddisk')
       idcmanager.memory=req.POST.get('memory')
       idcmanager.buytime=req.POST.get('buytime')
       idcmanager.qualitytime=req.POST.get('qualitytime')
       idcmanager.detail=req.POST.get('detail')

       idcmanager.save()
    return render_to_response('idc-manager.html')
示例#4
0
def idc(req):
    context = {}
    if req.method == "POST":
        idcmanager = Idcmanager()
        idcmanager.hostname = req.POST.get('hostname')
        idcmanager.ip = req.POST.get('ip')
        idcmanager.serialnumber = req.POST.get('serialnumber')
        idcmanager.sshport = req.POST.get('sshport')
        idcmanager.status = req.POST.get('status')
        idcmanager.location = req.POST.get('location')
        idcmanager.idcname = req.POST.get('idcname')
        idcmanager.ostype = req.POST.get('ostype')
        idcmanager.cpu = req.POST.get('cpu')
        idcmanager.harddisk = req.POST.get('harddisk')
        idcmanager.memory = req.POST.get('memory')
        idcmanager.buytime = req.POST.get('buytime')
        idcmanager.qualitytime = req.POST.get('qualitytime')
        idcmanager.detail = req.POST.get('detail')

        idcmanager.save()
    return render_to_response('idc-manager.html')
示例#5
0
def idc(req):
    context={}
    if not req.user.is_authenticated():
        return HttpResponseRedirect('/login/')
    username=req.session.get('username')
    if req.method == "POST":
       idcmanager=Idcmanager()
       idcmanager.hostname=req.POST.get('hostname')
       idcmanager.ip=req.POST.get('ip')
       idcmanager.serialnumber=req.POST.get('serialnumber')
       idcmanager.sshport=req.POST.get('sshport')
       idcmanager.status=req.POST.get('status')
       idcmanager.location=req.POST.get('location')
       idcmanager.idcname=req.POST.get('idcname')
       idcmanager.ostype=req.POST.get('ostype')
       idcmanager.cpu=req.POST.get('cpu')
       idcmanager.harddisk=req.POST.get('harddisk')
       idcmanager.memory=req.POST.get('memory')
       idcmanager.buytime=req.POST.get('buytime')
       idcmanager.qualitytime=req.POST.get('qualitytime')
       idcmanager.detail=req.POST.get('detail')

       idcmanager.save()
    return render_to_response('idc-manager.html',{'username':username},context_instance=RequestContext(req))
示例#6
0
文件: views.py 项目: pengyao/opsadmin
def idc(req):
    context = {}
    if not req.user.is_authenticated():
        return HttpResponseRedirect("/login/")
    username = req.session.get("username")
    if req.method == "POST":
        idcmanager = Idcmanager()
        idcmanager.hostname = req.POST.get("hostname")
        idcmanager.ip = req.POST.get("ip")
        idcmanager.serialnumber = req.POST.get("serialnumber")
        idcmanager.sshport = req.POST.get("sshport")
        idcmanager.status = req.POST.get("status")
        idcmanager.location = req.POST.get("location")
        idcmanager.idcname = req.POST.get("idcname")
        idcmanager.ostype = req.POST.get("ostype")
        idcmanager.cpu = req.POST.get("cpu")
        idcmanager.harddisk = req.POST.get("harddisk")
        idcmanager.memory = req.POST.get("memory")
        idcmanager.buytime = req.POST.get("buytime")
        idcmanager.qualitytime = req.POST.get("qualitytime")
        idcmanager.detail = req.POST.get("detail")

        idcmanager.save()
    return render_to_response("idc-manager.html", {"username": username}, context_instance=RequestContext(req))