def iptables():
offset = int(request.args.get("offset", 0))
limit = 50
conn = get_db_connection()
cur = conn.cursor()
cur.execute("select count(*) from iptables;")
count = cur.fetchall()[0][0]
cur.execute("select * from iptables limit %s offset %s", (limit, offset))
li = cur.fetchall()
conn.close()
return render_template("list.html", count=count, iptables=li, offset=offset, limit=limit)
def interconnection():
user1 = request.args["user1"]
user2 = request.args["user2"]
start = time.time()
conn = get_db_connection()
cur = conn.cursor()
cur.execute(sql_intersect_iptables(user1, user2))
ips = [ip for row in cur.fetchall() for ip in row]
conn.close()
resp = {
"user1": user1,
"user2": user2,
"interconnection": not all(map(lambda p: is_same_subnet(*p), itertools.combinations(ips, 2))),
"duration": time.time() - start
}
return jsonify(resp)