def modifyCity(cid, city, other): result = db.query("SELECT cid FROM city WHERE city = '%s' AND cid != '%s'" % (city, cid)) if result: return False else: db.update("city", where='cid=$cid', vars={'cid': cid}, city=city, other=other) return True
def modifyProject(pid,project,other): result = db.query("SELECT pid FROM project WHERE project = '%s' AND pid != '%s'" % (project,pid)) if result: return False else: db.update("project", where='pid=$pid', vars={'pid': pid}, project=project ,other=other) return True
def modifyIDC(iid,idcname,city,contact,hztime,other): result = db.query("SELECT iid FROM idc WHERE idcname = '%s' AND iid != '%s'" % (idcname, iid)) if result: return False else: db.update("idc", where='iid=$iid', vars={'iid': iid}, idcname=idcname, city=city, contact=contact, hztime=hztime,other=other) return True
def modifyHost(hid,hostname,city,project,idc,port,addr1_ip,addr1_netmask,addr1_gateway,addr1_line,addr2_ip,addr2_netmask,addr2_gateway,addr2_line,addr3_ip,addr3_netmask,addr3_gateway,addr3_line,memory,cpu,disk,buytime,servicetime,hardwareinfo,bandwidth,uses,status,company,os,other,modifytime,modifyman): # Check the ip address exists? if addr1_ip != '': result = db.query("SELECT hid FROM `hosts` WHERE addr1_ip='%s' OR addr2_ip='%s' OR addr3_ip='%s'" % (addr1_ip, addr1_ip, addr1_ip)) if result: return 'addr' if addr2_ip != '': result = db.query("SELECT hid FROM `hosts` WHERE addr1_ip='%s' OR addr2_ip='%s' OR addr3_ip='%s'" % (addr2_ip, addr2_ip, addr2_ip)) if result: return 'addr' if addr3_ip != '': result = db.query("SELECT hid FROM `hosts` WHERE addr1_ip='%s' OR addr2_ip='%s' OR addr3_ip='%s'" % (addr3_ip, addr3_ip, addr3_ip)) if result: return 'addr' # Check hostname exists? if hostname != '': result = db.query("SELECT hid FROM hosts WHERE hostname = '%s'" % (hostname)) if result: return 'hostname' #result = db.query("SELECT hid FROM hosts WHERE hostname = '%s' AND hid != '%s'" % (hostname, hid)) #if result: # return False #else: db.update("hosts", where='hid=$hid', vars={'hid':hid}, hostname=hostname,city=city,project=project,idc=idc,port=port,addr1_ip=addr1_ip,addr1_netmask=addr1_netmask,addr1_gateway=addr1_gateway,addr1_line=addr1_line,addr2_ip=addr2_ip,addr2_netmask=addr2_netmask,addr2_gateway=addr2_gateway,addr2_line=addr2_line,addr3_ip=addr3_ip,addr3_netmask=addr3_netmask,addr3_gateway=addr3_gateway,addr3_line=addr3_line,memory=memory,cpu=cpu,disk=disk,buytime=buytime,servicetime=servicetime,hardwareinfo=hardwareinfo,bandwidth=bandwidth,uses=uses,status=status,company=company,os=os,other=other,modifytime=modifytime,modifyman=modifyman) return True
def modifyApply(aid,sitename,idc,project,addr_ip,sofeware,datadir,startscrite,port,mysql_conf,mysql_ip,mysql_stype,mysql_name,mysql_use,mysql_pw,dev_name,other,modifytime,modifyman): if addr_ip != '': result = db.query("SELECT aid FROM applications WHERE sitename = '%s' AND addr_ip = '%s'" % (sitename,addr_ip)) if result: return False db.update("applications", where='aid=$aid', vars={'aid':aid}, sitename=sitename,idc=idc,project=project,addr_ip=addr_ip,sofeware=sofeware,datadir=datadir,startscrite=startscrite,port=port,mysql_conf=mysql_conf,mysql_ip=mysql_ip,mysql_stype=mysql_stype,mysql_name=mysql_name,mysql_use=mysql_use,mysql_pw=mysql_pw,dev_name=dev_name,other=other,modifytime=modifytime,modifyman=modifyman) return True
def up_entry(id, eth0, eth1, eth2, gateway, os, project, owners, dmz, datacenter, hosted, eth0_vlan, eth1_vlan, status, type=None): db.update(tb, where='id=$id', vars=locals(), eth0=eth0, eth1=eth1, eth2=eth2, hosted=hosted, gateway=gateway, os=os, project=project, dmz=dmz, datacenter=datacenter, updated_on=datetime.datetime.now(), eth0_vlan=eth0_vlan, eth1_vlan=eth1_vlan, status=status, owners=owners)
def set_status_by_user(username, status): try: db.update('users', status=status, where="username=$username", vars=locals()) except IndexError: return None
def update_project(pid, project_name, project_descrip, html): project_rlt = db.update( "project", name=project_name, description=project_descrip, update_date=now(), where="id=%s" % pid ) if project_rlt: return True else: return False
def update_project(pid, project_name, project_descrip, html): query_str = r'''update item i, project p set i.title='%s', i.text='%s', i.html='%s', i.update_date='%s' where p.id=%s and p.name=i.title and i.pid=99''' % (project_name.replace("'", "\\'"), project_descrip.replace("'", "\\'"), html.replace("'", "\\'"), now(), pid) # print query_str item_rlt = db.query(query_str) project_rlt = db.update('project', name=project_name, update_date=now(), where='id=%s' % pid) if item_rlt and project_rlt: return True else: return False
def up_asset( id, logic_name, device_type, serial_number, hardware_info, layout, status, history, updated_on=datetime.datetime.now(), tb='asset', ): db.update(tb, where='id=$id', vars=locals(), logic_name=logic_name, device_type=device_type, serial_number=serial_number, hardware_info=hardware_info, layout=layout, status=status, history=history, updated_on=updated_on)
def UpdateUserPrivilege(user,privilege): return db.update("users", where='username=$user', vars={'user':user}, privilege=privilege)
def UpdateUserInfo(user,phone,email,other): return db.update("users", where='username=$user', vars={'user':user}, phone=phone, email=email, other=other)
def login_fail(name, times): if times < 2: return db.insert('loginfail', times=times, name=name) else: return db.update('loginfail', times=times, where='name=$name', vars=locals())
def up_passwd(username, password): db.update('users', where="username=$username", password=password, vars=locals())
def update_item(item_id, pid, item_name, item_order, item_content, html, is_visible): return db.update('item', where='id=%s'%item_id, pid=pid, title=item_name, text=item_content, html=html, item_order=item_order, is_visible=is_visible, update_date=now())
def update(table, **kw): return db.update(table, **kw)