def login():
try:
# userid = request.args['userid']
password = request.args['password']
name = request.args['name']
#query="select userid,usertype from usermaster where userid = '" + userid + "' and password='******';"
query ="select mobile,Usertype_Id,Hospital_Id from Signup where name = '" + name + "' and password='******';"
conn=Connection()
cursor = conn.cursor()
cursor.execute(query)
loginuser = cursor.fetchone()
cursor.close()
if loginuser:
Data = json.dumps(loginuser, default=str)
return Data
else:
data={"status":"Failed","result":"Login Failed"}
return data
except KeyError as e:
print("Exception---->" +str(e))
output = {"result":"Input Keys are not Found","status":"false"}
return output
except Exception as e :
print("Exception---->" +str(e))
output = {"result":"something went wrong","status":"false"}
return output
def Device_master():
try:
json1=request.get_data()
data=json.loads(json1.decode("utf-8"))
query1 = "select * from Device_master where DeviceMac = "+'"'+str(data["DeviceMac"])+'"'+" ;"
print(query1)
conn=Connection()
cursor = conn.cursor()
cursor.execute(query1)
data= cursor.fetchone()
conn.commit()
cursor.close()
if data != None:
output={"output": " DeviceMac name already registered ,Please enter the other DeviceMac ","status":"false"}
else:
json1=request.get_data()
data=json.loads(json1.decode("utf-8"))
print("77787878")
query2 = " insert into Device_master (DeviceMac,Bed_Number,Vard_Name,Hospital_Id,usercreate)"
query2 = query2 +" values("+'"'+str(data["DeviceMac"])+'"'+','+'"'+str(data["Bed_Number"])+'"'+','+'"'+str(data["Vard_Name"])+'"'+','+'"'+str(data["Hospital_Id"])+'"'+','+'"'+str(data["usercreate"])+'"'+' '+");"
print(query2)
conn=Connection()
cursor = conn.cursor()
cursor.execute(query2)
conn.commit()
output={"output": "DeviceMac Added succesfully","status":"true"}
except Exception as e :
print("Exception---->" + str(e))
output = {"result":"something went wrong","status":"false"}
return output
def SelectQuery1(table,columns,whereCondition):
try:
if whereCondition != "":
whereCondition = " where 1=1 " + whereCondition
query = " select " + columns + " from " + table + " " + whereCondition + " ;"
print(query)
conn = Connection()
cursor = conn.cursor()
cursor.execute(query)
data = cursor.fetchall()
cursor.close()
if data:
data = {"status":"true","message":"","result":data}
else:
data = {"status":"true","message":"No Data Found","result":""}
return data
except Exception as e:
print("Error--->" + str(e))
return "0"
def Hospital_master():
try:
json1=request.get_data()
data=json.loads(json1.decode("utf-8"))
query1 = "select ID,hospital_name,City,State from Hospital_master where hospital_name = "+'"'+str(data["hospital_name"])+'"'+" ;"
print(query1)
conn=Connection()
cursor = conn.cursor()
cursor.execute(query1)
data= cursor.fetchone()
conn.commit()
cursor.close()
if data != None:
output={"output": "Hospital name already registered ,Please enter the other Hospital name ","status":"false"}
else:
json1=request.get_data()
data=json.loads(json1.decode("utf-8"))
print("77787878")
query2 = " insert into Hospital_master (hospital_name,City,State,usercreate)"
query2 = query2 +" values("+'"'+str(data["hospital_name"])+'"'+','+'"'+str(data["City"])+'"'+','+'"'+str(data["State"])+'"'+','+'"'+str(data["usercreate"])+'"'+' '+");"
print(query2)
conn=Connection()
cursor = conn.cursor()
cursor.execute(query2)
conn.commit()
output={"output": "Hospital Name Added succesfully","status":"true"}
except Exception as e :
print("Exception---->" + str(e))
output = {"result":"something went wrong","status":"false"}
return output
def updateSignup():
try:
json1=request.get_data()
data=json.loads(json1.decode("utf-8"))
print("yy")
query1 = " update Signup set name= '" + str(data["name"]) + "', password ='******' , mobile ='" + str(data["mobile"]) + "' , Usertype_Id ='" + str(data["Usertype_Id"]) + "' , Hospital_Id ='" + str(data["Hospital_Id"]) + "' , UserUpdate ='" + str(data["UserUpdate"]) + "' , Status ='1' where ID = '" + str(data["ID"])+ "';"
print(query1)
conn=Connection()
cursor = conn.cursor()
cursor.execute(query1)
conn.commit()
cursor.close()
output = {"result":"Updated Successfully","status":"true"}
return output
except KeyError :
print("Key Exception---->")
output = {"result":"key error","status":"false"}
return output
except Exception as e :
print("Exception---->" +str(e))
output = {"result":"somthing went wrong","status":"false"}
return output
def page(web):
try:
bssid = bssid2bytes(web.args['bssid'])
for i in range(len(connection)):
if connection[i].bssid == bssid:
connection.remove(connection[i])
Connection.flush()
break
except Exception as e:
dump_exception('WEB error:', e)
yield web.index
def send_to_frontend(queue_name, response_message, request_id):
try:
Connection.channel.queue_declare(queue_name)
msg_json = {
'requestId': request_id,
'result': response_message
}
print("\n================================== RESPONSE MESSAGE ==================================\n"
+ json.dumps(msg_json, indent=2) + "\n"
"======================================================================================\n")
Connection.channel.basic_publish(exchange='', routing_key=queue_name, body=json.dumps(msg_json))
return True
except StreamLostError:
Connection.connect_to_rabbitmq()
return False
def InsertQuery(table,columns,values):
try:
query = " insert into " + table + " (" + columns + ") values(" + values + ");"
print(query)
conn = Connection()
cursor = conn.cursor()
cursor.execute(query)
conn.commit()
cursor.close()
message = commonfile.Successmessage('insert')
data = {"status":"true","message":message,"result":""}
return data
except Exception as e:
print("Error--->" + str(e))
return "0"
def Usertypelist():
try:
query = "select * from Usertype_master "
conn=Connection()
cursor = conn.cursor()
cursor.execute(query)
data = cursor.fetchall()
cursor.close()
if data:
Data = json.dumps(data, default=str)
return str(Data)
else:
output = {"result":"No Data Found","status":"false"}
return output
except Exception as e :
print("Exception---->" + str(e))
output = {"result":"something went wrong","status":"false"}
return output
def Patient_Vital_master_select():
try:
# query = " select distinct userid,username,usertype from usermaster where usertype <> 'Admin';"
query = "select * from Patient_Vital_master "
conn=Connection()
cursor = conn.cursor()
cursor.execute(query)
data = cursor.fetchall()
cursor.close()
if data:
Data = json.dumps(data, default=str)
return str(Data)
else:
output = {"result":"No Data Found","status":"false"}
return output
except Exception as e :
print("Exception---->" + str(e))
output = {"result":"something went wrong","status":"false"}
return output
def signup():
try:
json1=request.get_data()
data=json.loads(json1.decode("utf-8"))
query1 = "select Usertype_Id,Hospital_Id,mobile from signup where name = "+'"'+str(data["name"])+'"'+" ;"
print(query1)
conn=Connection()
cursor = conn.cursor()
cursor.execute(query1)
data= cursor.fetchone()
conn.commit()
cursor.close()
if data != None:
output={"output": "Name already registered ,Please enter the other Name","status":"false"}
else:
json1=request.get_data()
data=json.loads(json1.decode("utf-8"))
print("77787878")
query2 = " insert into signup (name,mobile,password,Usertype_Id,Hospital_Id,usercreate)"
query2 = query2 +" values("+'"'+str(data["name"])+'"'+','+'"'+str(data["mobile"])+'"'+','+'"'+str(data["password"])+'"'+','+'"'+str(data["Usertype_Id"])+'"'+','+'"'+str(data["Hospital_Id"])+'"'+','+'"'+str(data["usercreate"])+'"'+' '+");"
print(query2)
conn=Connection()
cursor = conn.cursor()
cursor.execute(query2)
conn.commit()
cursor.close()
output={"output": "User Signup succesfully","status":"true"}
except Exception as e :
print("Exception---->" + str(e))
output = {"result":"something went wrong","status":"false"}
return output
def Patient_master():
try:
json1=request.get_data()
data=json.loads(json1.decode("utf-8"))
query = "select * from Patient_master where PatientName = "+'"'+str(data["PatientName"])+'"'+" ;"
conn=Connection()
cursor = conn.cursor()
cursor.execute(query)
data= cursor.fetchone()
conn.commit()
cursor.close()
if data != None:
output={"output": "PatientName already registered ,Please enter other PatientName "}
else:
json1=request.get_data()
data=json.loads(json1.decode("utf-8"))
query2 = " insert into Patient_master(PatientName,DeviceMac,Bed_Number,hospital_Name,startdate,enddate,usercreate)"
query2 =query2 +" values("+'"'+str(data["PatientName"])+'"'+','+'"'+str(data["DeviceMac"])+'"'+','+'"'+str(data["Bed_Number"])+'"'+','+'"'+str(data["hospital_name"])+'"'+','+'"'+str(data["startdate"])+'"'+','+'"'+str(data["enddate"])+'"'+','+'"'+str(data["usercreate"])+'"'+''+");"
print(query2)
conn=Connection()
cursor = conn.cursor()
cursor.execute(query2)
conn.commit()
cursor.close()
output={"output": "Patient Added succesfully","status":"true"}
except Exception as e :
print("Exception---->" + str(e))
output = {"result":"something went wrong","status":"false"}
return output
def Patient_Vital_master():
try:
json1=request.get_data()
data=json.loads(json1.decode("utf-8"))
query = "select * from Patient_Vital_master where PatientId = "+'"'+str(data["PatientId"])+'"'+" ;"
conn=Connection()
cursor = conn.cursor()
cursor.execute(query)
data= cursor.fetchone()
conn.commit()
cursor.close()
if data != None:
output={"output": "PatientId already registered ,Please enter other PatientId ","status":"false"}
else:
json1=request.get_data()
data=json.loads(json1.decode("utf-8"))
query2 = " insert into Patient_Vital_master(PatientId,Bp,SPO2,TEMP,usercreate)"
query2 =query2 +" values("+'"'+str(data["PatientId"])+'"'+','+'"'+str(data["Bp"])+'"'+','+'"'+str(data["SPO2"])+'"'+','+'"'+str(data["TEMP"])+'"'+','+'"'+str(data["usercreate"])+'"'+' '+");"
print(query2)
conn=Connection()
cursor = conn.cursor()
cursor.execute(query2)
conn.commit()
cursor.close()
output={"output": "Patient Vital Details Added succesfully","status":"true"}
except Exception as e :
print("Exception---->" + str(e))
output = {"result":"something went wrong","status":"false"}
return output
def UpdateQuery(table,columns,whereCondition):
try:
if whereCondition != "":
whereCondition = " where 1=1 " + whereCondition
if columns != "":
query = " update " + table + " set " + columns + " " + whereCondition + ";"
print(query)
conn = Connection()
cursor = conn.cursor()
cursor.execute(query)
conn.commit()
cursor.close()
message = commonfile.Successmessage('update')
data = {"status":"true","message":message,"result":""}
return data
else:
return "0"
except Exception as e:
print("Error--->" + str(e))
return "0"
def update_Patient_type():
try:
json1=request.get_data()
data=json.loads(json1.decode("utf-8"))
print("yy")
query1 = " update Patient_master set PatientName ='" + str(data["PatientName"]) + "' , DeviceMac ='" + str(data["DeviceMac"]) + "' , Bed_Number = '" + str(data["Bed_Number"]) + "' , hospital_Name ='" + str(data["hospital_Name"]) + "' , startdate='" + str(data["startdate"]) + "', enddate = '" + str(data["enddate"]) + "' , UserUpdate ='" + str(data["UserUpdate"]) + "' , Status ='1' where PatientId = '" + str(data["PatientId"])+ "';"
print(query1)
conn=Connection()
cursor = conn.cursor()
cursor.execute(query1)
conn.commit()
cursor.close()
output = {"result":"Updated Successfully","status":"true"}
return output
except KeyError :
print("Key Exception---->")
output = {"result":"key error","status":"false"}
return output
except Exception as e :
print("Exception---->" +str(e))
output = {"result":"somthing went wrong","status":"false"}
return output
def update_Patient_Vital_master():
try:
json1=request.get_data()
data=json.loads(json1.decode("utf-8"))
print("yy")
query1 = " update Patient_Vital_master set PatientId ='" + str(data["PatientId"]) + "' , Bp ='" + str(data["Bp"]) + "' , SPO2 = '" + str(data["SPO2"]) + "' , TEMP ='" + str(data["TEMP"]) + "' , UserUpdate ='" + str(data["UserUpdate"]) + "' , Status ='1' where Id = '" + str(data["Id"])+ "';"
print(query1)
conn=Connection()
cursor = conn.cursor()
cursor.execute(query1)
conn.commit()
cursor.close()
output = {"result":"Updated Successfully","status":"true"}
return output
except KeyError :
print("Key Exception---->")
output = {"result":"key error","status":"false"}
return output
except Exception as e :
print("Exception---->" +str(e))
output = {"result":"somthing went wrong","status":"false"}
return output
import json
from datetime import datetime
from flask import Response
from sqlalchemy.exc import SQLAlchemyError
from config import Connection
conn = Connection()
app = conn.app
db = conn.db
manager = conn.manager
# This File handles all models from application. That's the database definition,
# all changes here reflect to your real database, so make sure everything it's
class Client(db.Model):
__tablename__ = "Client"
id = db.Column(db.Integer, primary_key=True)
username = db.Column(db.String(64), index=False, unique=False, nullable=False)
email = db.Column(db.String(80), index=True, unique=True, nullable=False)
password = db.Column(db.String(255), index=False, unique=False, nullable=False)
created_at = db.Column(db.DateTime, index=False, unique=False, nullable=True,
default=datetime.now)
updated_at = db.Column(db.DateTime, index=False, unique=False, nullable=True,
default=datetime.now)
class Product(db.Model):
__tablename__ = "Product"
id = db.Column(db.Integer, primary_key=True)
else:
print(op + " not succeeded")
else:
msg = "Error: operation not valid"
print(msg)
send_to_frontend(queue_name, msg, request_id)
print("================================== Waiting for task message ==================================")
print("Initializing parameters...")
Config.initialize_parameters()
print("Parameters initialized")
print("Connecting to RabbitMQ...")
Connection.connect_to_rabbitmq()
print("Connection to RabbitMQ succeeded")
print("Connecting to the Database...")
db = DatabaseManager(Config.mysql_address, Config.mysql_db, Config.mysql_user, Config.mysql_pwd)
if db.isConnected() is False:
print("Error database connection")
else:
print("Connection to the Database succeeded")
Connection.channel.queue_declare('tasks')
Connection.channel.basic_consume(queue='tasks', on_message_callback=callback, auto_ack=True)
print("Start consuming")
print("================================== Waiting for task message ==================================")
Connection.channel.start_consuming()
