def edit_indicator(id): category = db.table('categories').where('id',id).update(request.get_json()['category']) indicator = request.get_json()['indicators'] ilist= ["CALL edit_indicator('{id}','{name}','{variable}','{description}')".format(**x) for x in indicator] for x in ilist: db.select(x) return jsonify({'message':'updated'}),200
def create_indicators(): c= request.get_json()['category'] print c indicator = request.get_json()['indicators'] sql = u"CALL creatCategory('{name}','{about}','{image}','{nextTime}')".format(**c) cat = db.select(sql) dex= [ x for x in cat][0]['ID'] ilist= ["CALL createIndicator('{}','{name}','{variable}','{description}')".format(dex,**x) for x in indicator] for x in ilist: db.select(x) return jsonify({'message':'created'}),200
def updatie_equation(): t = request.get_json()["treatment"] e = request.get_json()["equations"] d = request.get_json()["diagnosis"] db.select("START TRANSACTION") for x in t: db.table("treatments").where('id', x['id']).update(x) for x in e: db.table("equations").where('id', x['id']).update(x) for x in d: db.table("dignoses").where('id', x['id']).update(x) db.select("COMMIT") return jsonify(request.get_json())
def get_permissions(): fg = db.select('describe user_permission') pm = [{'name': x['Field'], 'value': '0'} for x in fg] #val = ['0']*22 #li = dict(zip(pm,val)) return jsonify({'list': pm}), 200
def create_equation(): sql = [ "CALL createEquation('{equation}','{opr}','{disease_id}')".format(**c) for c in request.get_json() ] [db.select(x) for x in sql] return jsonify({'message': 'created'}), 200
def get_them_all(): d = db.select( "select diseases.id as Id, diseases.name as name from diseases") e = [{ "Id": x.Id, "name": x.name, "equations": db.select("select * from equations where disease_id={}".format(x.Id)), "diagnosis": db.select("select * from dignoses where disease_id ={} limit 1".format( x.Id)), "treatment": db.select( "select * from treatments where disease_id={} limit 1".format( x.Id)) } for x in d] print e return jsonify(e), 200
def del_disease(id): tex = db.select("CALL check_treatment('{}')".format(id)) texists = str(tex[0]['exists']) if texists == '1': db.table('treatments').where('disease_id', id).delete() print 'delete treatment for {}'.format(id) dgx = db.select("CALL check_diagnosis('{}')".format(id)) dgexists = str(dgx[0]['exists']) if dgexists == '1': db.table('dignoses').where('disease_id', id).delete() print 'delete diagnosis for {}'.format(id) eqx = db.select("CALL check_equation('{}')".format(id)) eqxist = str(eqx[0]['exists']) if eqxist == '1': db.table('equations').where('disease_id', id).delete() print 'delete all equations' db.table('diseases').where('id', id).delete() print 'delete disease {}'.format(id) return jsonify({ "message":'deleted' }),200
def user_summary(id): user = db.select("select user_diseases.disease_id as id, user_diseases.created_at as date from user_diseases where user_id = {}".format(id)) ind = db.select("select test, indicator from user_blood_indicators where user_id={}".format(id)) diseases = [ { "id":x['id'], "disease":[ { "category":y['category_id'], "disease":y, "bloodReport":db.select("select test,indicator from user_blood_indicators where user_id={} and catID = {}".format(id,y['category_id'])) } for y in db.select("select name, description, icon, category_id from diseases where id= {} limit 1".format(x['id'])) ], "date":x['date'], "treatment":db.select("select treatments.name , treatments.price, treatments.description from treatments where treatments.disease_id= {} limit 1".format(x['id'])), "diagnoses":db.select("select name, summary, pricetag,image from dignoses where disease_id={} limit 1".format(x['id'])) } for x in user] return jsonify(diseases)
def del_category(id): dex = db.select("CALL check_diseases('{}')".format(id)) dexists= str(dex[0]['exists']) if dexists == '1': print 'delete all disease----' ad = db.table('diseases').where('category_id',id).get().serialize() for x in ad: print x['id'] tex = db.select("CALL check_treatment('{}')".format(x['id'])) texists = str(tex[0]['exists']) if texists == '1': db.table('treatments').where('disease_id',x['id']).delete() print 'delete treatment for {}'.format(x['id']) dgx = db.select("CALL check_diagnosis('{}')".format(x['id'])) dgexists = str(dgx[0]['exists']) if dgexists == '1': db.table('dignoses').where('disease_id',x['id']).delete() print 'delete diagnosis for {}'.format(x['id']) eqx = db.select("CALL check_equation('{}')".format(x['id'])) eqxist = str(eqx[0]['exists']) if eqxist == '1': db.table('equations').where('disease_id',x['id']).delete() print 'delete all equations' db.table('diseases').where('id',x['id']).delete() print 'delete disease {}'.format(x['id']) print 'delete all disease----' dit = db.select("CALL check_indicators('{}')".format(id)) ditex = str(dit[0]['exists']) if ditex == '1': db.table('indicators').where('categories_id',id).delete() db.table('categories').where('id',id).delete() print 'delete category {}'.format(id) else: dit = db.select("CALL check_indicators('{}')".format(id)) ditex = str(dit[0]['exists']) if ditex == '1': db.table('indicators').where('categories_id',id).delete() db.table('categories').where('id',id).delete() print 'delete category {}'.format(id) print 'just delete categories' return jsonify({"message":dex}),200
def activate_user(email): user = db.table('users').where('email', email).first() if user is not None: verfication = db.table('verifications').where('user_id', user.id).first() if verfication is not None: if verfication.code == request.get_json()['code']: db.select('START TRANSACTION') db.select( 'update users set active= "1" where users.id= {}'.format( user.id)) db.select('COMMIT') return jsonify({'token': user.token}) else: return jsonify({'message': 'wrong verification code'}) else: return jsonify({'message': 'Something wrong happens'}) else: return jsonify({'message': 'No user exists'})
def list_permissions(id): fg = db.select('describe user_permission') pm = ["'{}'".format(x['Field']) for x in fg] up = db.table('user_permission').where('user_id', id).first() print up return jsonify({'permission': up})
def disease(): sql = "SELECT * , (select categories.name from categories where categories.id = diseases.category_id) as category FROM diseases" alt = db.select(sql) disease = db.table('diseases').get() return jsonify(alt)
def make_online(id): db.select("CALL trigger_online('{}')".format(id)) return jsonify({'message': 'ok'}), 200
def get_recent_diagnosis(id): sql = "SELECT * FROM user_orders WHERE user_id = {} order by id desc limit 1" y = db.select(sql.format(id)) return jsonify(y), 200
def about_app(): return jsonify(db.select("select text,contact from about limit 1")[0])
def del_user(id): db.select("delete from roles_users where user_id={}".format(id)) db.select("delete from users where id={}".format(id)) return jsonify({'message': 'deleted'}), 202
def test_api(): sql = "CALL all_diseases_info()"; return jsonify(db.select(sql)),200
def make_custom_des(user, status): db.select("SET @user='******'".format(user)) db.select("INSERT into online_users(id,)")
def make_default_units(id): query = "insert into user_defaults_units(id,user_id,unit)values(null,{},'{unit}') on duplicate key update unit='{unit}'".format( id, **request.get_json()) db.select(query) return jsonify({'message': 'saved'}), 200