def post(self): email = self.get_argument("email") """ reg = conn_remote.get("SELECT * FROM event_reg WHERE email = %s", email) if not reg: self.finish("You email is not registered.") return """ regs = conn_remote.query("SELECT * FROM event_reg_mac WHERE email = %s", email) if len(regs) >= 2: self.finish("Sorry, your email has been used for too many times") return # find mac by ip? remote_ip = self.request.remote_ip if self.request.remote_ip != '127.0.0.1' else self.request.headers['X-Forwarded-For'] device_logs = conn.query("SELECT * FROM device_log WHERE ipv4 = %s ORDER BY id DESC", remote_ip) if len(device_logs) == 0: self.finish("Something wrong!") return mac = device_logs[0]["mac"] conn_remote.execute("INSERT INTO event_reg_mac (email, mac) VALUES(%s, %s)", email, mac) # create an unquie token in database self.redirect("http://10.0.0.1:2060/wifidog/auth?token=%s" % mac)
def post(self): title = self.get_argument("title", "") content = self.get_argument("content", "") if conn_remote.get("SELECT * FROM event_slide WHERE title = %s", title): conn_remote.execute("UPDATE event_slide SET content = %s WHERE title = %s", content, title) else: conn_remote.execute("INSERT INTO event_slide (title, content) VALUES (%s, %s)", title, content) self.finish({})
def post(self): title = self.get_argument("title", "") conn_remote.execute("DELETE FROM event_slide WHERE title = %s", title) self.finish({})