def insert():
info = request.get_data()
info = json.loads(info)
sql = 'replace into playbook (name,hosts_path, playbook_path, forks) VALUES(%s, %s, %s, %s);'
params = ( info['name'], info['hosts_path'], info['playbook_path'], info['forks'])
tool_db.updateByParameters( sql, params )
return "Success"
def insert():
info = request.get_data()
info = json.loads(info)
# name, hosts_path, hosts_pattern, module, args, forks
sql = 'replace into deploy (name,hosts_path, hosts_pattern, module, args, forks) VALUES(%s, %s, %s, %s, %s, %s);'
params = (info['name'], info['hosts_path'], info['hosts_pattern'],
info['module'], info['args'], info['forks'])
tool_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 servers (name,ip, port, user) VALUES( %s, %s, %s, %s);'
tool_db.updateByParameters(
sql, (value[0], value[1], value[2], value[3]))
def delete_by_id():
id = int( request.args.get('id') )
sql = 'delete from playbook where id = %s'
tool_db.updateByParameters( sql, (id, ) )
return "Servers!"