def add_server(): form = AddServerForm() if form.validate_on_submit(): server_ip = form.server_ip.data server_username = form.server_username.data server_password = form.server_password.data server_port = form.server_port.data server_env = form.server_env.data server_tag = form.server_tag.data server_os = form.server_os.data server_type = form.server_type.data server_loc = form.server_loc.data if func.is_connect_server(server_ip, server_username, server_port, server_password): server_info = func.collect_info(server_ip, server_username, server_port, server_password) query = """INSERT INTO infra_server(server_hostname,server_ip,server_username,server_password, server_port, server_env,server_tag, server_os,server_version,server_cpu, server_mem,server_disk,server_type,server_loc) VALUES('%s','%s','%s','%s',%s,%s,'%s','%s','%s', %s, %s, %s,%s,'%s') """ % ( server_info['hostname'], int(ipaddress.ip_address(server_ip)), server_username, server_password, server_port, server_env, server_tag, server_os, server_info['release'], int(server_info['cpuinfo']), int(server_info['meminfo']), int(server_info['diskinfo'])/1024/1024, server_type, server_loc) c = g.db.cursor() c.execute(query) g.db.commit() return redirect(url_for('main.server', server_env=server_env)) else: flash(u'connect failed, invalid username or password!') return render_template('add_server.html', form=form)
def add_server(): form = AddServerForm() if form.validate_on_submit(): server = Server( form.name.data, form.description.data, form.match.data, form.ip.data, form.url.data, form.enabled.data, ) db.session.add(server) db.session.commit() return redirect(url_for('servers')) server = Server.query.order_by(db.desc(Server.name)) return render_template('servers/add_server.html', server=server, form=form)
def edit_server(server_id): form = AddServerForm() entry = Server.query.filter_by(id = server_id).first_or_404() if form.validate_on_submit(): server = Server( form.name.data, form.description.data, form.match.data, form.ip.data, form.url.data, form.enabled.data, ) entry.name = form.name.data entry.description = form.description.data entry.match = form.match.data entry.ip = form.ip.data entry.url = form.url.data entry.enabled = form.enabled.data db.session.commit() return redirect(url_for('dashboard')) else: form = AddServerForm(obj=entry) form.populate_obj(entry) return render_template('servers/edit_server.html', entry=entry, form=form)