def wireless_post():
data = request.get_json(force=True)
ldate = data["date"]
ltime = data["time"]
try:
records = [
Wireless(source=item["source"],
date=ldate,
time=ltime,
ap=item["AP"],
mac=item["MAC"],
lastip=item["Last IP"],
dnsname=item["DNSname"],
rx=item["RX"],
tx=item["TX"],
uptime=item["Uptime"],
lastact=item["LastACT"],
signalstrength=item["SignalStrength"],
snr=item["SNR"],
ccq=item["TX/RX-CCQ"],
throughput=item["PThroughput"]) for item in data["items"]
]
with database.atomic():
Wireless.bulk_create(records, batch_size=10)
database.commit()
except Exception as e:
# make_dump(ldate, data, e)
raise e
return 'Ok'
def ping_post_parse():
# Parse request
str_data = str(request.data)
pattern = '\[source=\'(?P<source>\S+)\'\s+date=\'(?P<dt>\d+)\'\s+time=\'(?P<tm>[\d\:]+)\'\s+host=\'(?P<host>\S+)\'\][\S\s]+min-rtt=(?P<min>\d+)[\S\s]+avg-rtt=(?P<avg>\d+)[\S\s]+max-rtt=(?P<max>\d+)'
match = re.search(pattern, str_data)
if not match:
abort(400)
try:
ip = socket.gethostbyname(match.group('host'))
except socket.gaierror:
ip = socket.getaddrinfo(match.group('host'), None,
socket.AF_INET6)[0][4][0]
# Database
record = Latency.create(source=match.group('source'),
date=match.group('dt'),
time=str(match.group('tm')).replace(':', ''),
ip=ip,
dnsname=match.group('host'),
minrtt=match.group('min'),
maxrtt=match.group('max'),
avgrtt=match.group('avg'))
record.save()
database.commit()
# database.close()
return f'Ok'
def add_favorite():
if request.method == "POST":
user_id = request.json["user_id"]
movie_id = request.json["movie_id"]
sql_query = "INSERT INTO user_favorite(user_id, movie_id) VALUES(%s, %s)"
cursor.execute(sql_query, tuple([user_id, movie_id]))
database.commit()
return "SUCCESS"
return "FAILED"
def sign_in():
if request.method == "POST":
id = request.json["id"]
username = request.json["username"]
email = request.json["email"]
sql_query = "SELECT * FROM user WHERE email = %s"
cursor.execute(sql_query, tuple([email]))
if cursor.rowcount == 0:
sql_query = "INSERT INTO user(id, username, email) VALUES(%s, %s, %s)"
cursor.execute(sql_query, tuple([id, username, email]))
database.commit()
return "SUCCESS"
return "FAILED"
def home():
logging.info("Launching homepage: start")
if request.method == "POST":
my_title= request.form.get("title")
my_link= request.form.get("video_link")
my_category= request.form.get("category")
print("MES DATAS", my_link, my_title, my_category)
mycursor.execute("INSERT INTO Courses (CATEGORY, TITLE, LINK) VALUES (%s,%s,%s) ",(my_category, my_title, my_link) )
database.commit()
logging.info("Launching homepage: end")
return render_template("index.html")
def create():
# {"source":"CCRU","rx":15,"tx":40,"date":"20200401","time":"120000","localCPU":50,"remoteCPU":23}
data = request.get_json(force=True)
# database.connect()
meas = Measurements.create(
source=data["source"],
date=data["date"],
time=str(data["time"]).replace(':', ''),
send=data["tx"],
receive=data["rx"],
localCPU=data["localCPU"] if "localCPU" in data else 0,
remoteCPU=data["remoteCPU"] if "remoteCPU" in data else 0)
meas.save()
database.commit()
# database.close()
return f'OK'
def setUp(self): database = db.database.get_frontend_db_rw() ident1 = database.query(db.sqldb.Ident)\ .filter(db.sqldb.Ident.title == self.main_ident)\ .first() if ident1 == None: ident1 = db.sqldb.Ident(self.main_ident, self.idents_tag) database.add(ident1) ident2 = database.query(db.sqldb.Ident)\ .filter(db.sqldb.Ident.title == self.secondary_ident)\ .first() if ident2 == None: ident2 = db.sqldb.Ident(self.secondary_ident, self.idents_tag) database.add(ident2) node = database.query(db.sqldb.Node)\ .filter(db.sqldb.Node.ident_1_id == ident1.id)\ .filter(db.sqldb.Node.ident_2_id == ident2.id)\ .first() if node == None: url = database.query(db.sqldb.Url)\ .filter(db.sqldb.Url.ref == self.ref)\ .first() if url == None: url = db.sqldb.Url(self.ref, '') database.add(url) database.commit() node = db.sqldb.Node(ident1, ident2, url, 0) database.add(node) link = database.query(db.sqldb.Link)\ .filter(db.sqldb.Link.ident_1_id == ident1.id)\ .filter(db.sqldb.Link.ident_2_id == ident2.id)\ .first() if link == None: link = db.sqldb.Link(ident1, ident2) database.add(link) database.commit()
def store_document(update, context):
"""Handle received documents
Args:
update (Update): the Telegram update object
context (Context): the Telegram context object
"""
message = update.effective_message
if not should_respond_message(context, message):
return
key = doc_type = None
if consts.STORE_NOTES in context.user_data:
key = consts.STORE_NOTES
doc_type = "notes"
elif consts.STORE_AGENDA in context.user_data:
key = consts.STORE_AGENDA
doc_type = "agenda"
if key is not None:
meeting = context.user_data[key]
if doc_type == "notes":
database.store_meeting_notes(meeting.meeting_id, message.document.file_id)
else:
database.store_meeting_agenda(meeting.meeting_id, message.document.file_id)
# Update reminder with agenda
if meeting.has_reminder:
database.cancel_remind(meeting.meeting_id, message.chat.id)
database.set_remind(meeting.meeting_id, message.chat.id)
database.commit()
update.effective_message.reply_text(
f"<b>{message.document.file_name}</b> has been stored as the {doc_type} "
f"for the meeting on <b>{meeting.formatted_datetime()}</b>",
parse_mode=ParseMode.HTML,
)
del context.user_data[key]