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)
