def mutidelete():
info = request.get_data()
info = json.loads(info)
for oneid in info:
sql = 'delete from server where id = %s'
db.updateByParameters(sql, (oneid, ))
return "Success!"
def insert():
info = request.get_data()
info = json.loads(info)
sql = 'replace into server (name,ip, port, user) VALUES(%s, %s, %s, %s);'
params = ( info['name'], info['ip'], info['port'], info['user'])
db.updateByParameters( sql, params )
return "Success"
def insertFromExcel(excelPath):
book = xlrd.open_workbook(excelPath)
sheet = book.sheet_by_index(0)
rowsnumber = sheet.nrows
colsnumber = sheet.ncols
for i in range(0, rowsnumber):
value = []
for j in range(0, colsnumber):
value.append(sheet.cell(i, j).value)
if i != 0:
sql = 'replace into server (name,ip, port, user) VALUES( %s, %s, %s, %s);'
db.updateByParameters(sql,
(value[0], value[1], value[2], value[3]))
def delete_by_id():
id = int(request.args.get('id'))
sql = 'delete from server where id = %s'
db.updateByParameters( sql, (id) )
return "Servers!"