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()