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
