def post(self): DATA = eval(crypto2.des_dicrypte((request.json['data']), key)) conn = db_connect.connect() try: user_Name = DATA['UserRequsting'] if SubFunc.CheckAdmin(user_Name) or SubFunc.CheckManger(user_Name): try: temp = [] query = conn.execute( "select user from Guider where GuideName==? and active='True';", (str(user_Name), )) for user in query.cursor: temp += user result = {'data': temp, 'status': 'success'} return crypto2.des(str(result), key) except: return crypto2.des( str({ 'status': 'fail', 'code': 'sqlfail' }), key) return crypto2.des(str({'status': 'haven\'t Permissions'}), key) except: return crypto2.des(str({'status': 'fail'}), key)
def post(self): DATA = eval(crypto2.des_dicrypte((request.json['data']), key)) conn = db_connect.connect() try: user_Name = DATA['UserRequsting'] if SubFunc.CheckAdmin(user_Name): try: temp = [] query = conn.execute( "select User from Accounts where User like '{0}' ". format('%' + DATA['serchData'] + '%')) for user in query.cursor: temp += [user[0]] result = {'data': temp, 'status': 'success'} if not result['data']: x = ['not find'] result = {'data': x, 'status': 'success'} return crypto2.des(str(result), key) except: return crypto2.des( str({ 'status': 'fail', 'code': 'sqlfail' }), key) return crypto2.des(str({'status': 'haven\'t Permissions'}), key) except: return crypto2.des(str({'status': 'fail'}), key)
def post(self): DATA = eval(crypto2.des_dicrypte(request.json['data'], key)) try: conn = db_connect.connect() user = DATA['user'] pas = DATA['pas'] query = conn.execute( "select * from Accounts WHERE User=? and Active=?", ( user, "True", )) result = { 'data': [dict(zip(tuple(query.keys()), i)) for i in query.cursor] } if not result['data']: return crypto2.des(str({'status': 'Ufail'}), key) password = result['data'][0]['Password'] if password == pas: result = { 'status': 'success', 'permissions': result['data'][0]['Permissions'] } return crypto2.des(str(result), key) return crypto2.des(str({'status': 'Pfail'}), key) except: return crypto2.des(str({'status': 'fail'}), key)
def post(self): DATA = eval(crypto2.des_dicrypte((request.json['data']), key)) try: conn = db_connect.connect() Name = DATA['User'] try: if type(DATA['language']) == type("help"): language = DATA['language'] else: language = DATA['language'][0] query = conn.execute( "select word from '{1}' WHERE user='******'".format( Name, language)) result = {'data': [i[0].encode('utf-8') for i in query.cursor]} if not result['data']: try: query = conn.execute( "select DISTINCT word from '{0}'".format(language)) result = { 'data': [i[0].encode('utf-8') for i in query.cursor] } except: return crypto2.des(str({ 'status': 'bug2', 'data': {} }), key) return str(crypto2.des(str(result), key)) except: return crypto2.des(str({'status': 'bug1', 'data': {}}), key) except: return crypto2.des(str({'status': 'fail', 'data': {}}), key)
def post(self): DATA = eval(crypto2.des_dicrypte(request.json['data'], key)) conn = db_connect.connect() try: Name = DATA['User'] if SubFunc.CheckAdmin(Name): if type(DATA['del']) == type("help"): Name = DATA['del'] else: Name = DATA['del'][0] query = conn.execute( "select * from Accounts WHERE User=? and Active=?", ( str(Name), "True", )) result = { 'data': [dict(zip(tuple(query.keys()), i)) for i in query.cursor] } if not result['data']: return crypto2.des(str({'status': 'NoFind'}), key) conn.execute(" UPDATE Accounts SET Active =? WHERE User=?", ( 'False', str(Name), )) return crypto2.des(str({'status': 'success'}), key) return crypto2.des(str({'status': 'fail'}), key) except: return crypto2.des(str({'status': 'fail'}), key)
def post(self): DATA = eval(crypto2.des_dicrypte((request.json['data']), key)) try: conn = db_connect.connect() query = conn.execute( "select * from Trylogin WHERE user=? and key=? ", ( DATA['user'], DATA['Key'], )) result = { 'data': [dict(zip(tuple(query.keys()), i)) for i in query.cursor] } date = datetime.datetime.now() if not result['data']: return crypto2.des(str({ 'status': 'fail', 'res': 'Not find' }), key) else: try: if (str(date).split(' ')[0] == result['data'][0] ['date'].split(' ')[0]): if (str(date).split(' ')[1].split(':')[0] == result['data'][0]['date'].split(' ')[1].split( ':')[0]): if ((int(str(date).split(' ')[1].split(':')[1]) - int(result['data'][0]['date'].split(' ') [1].split(':')[1])) < 10): result['data'][0]['status'] = 'success' return crypto2.des(str(result['data'][0]), key) else: return crypto2.des( str({ 'status': 'fail', 'res': 'time over' }), key) else: return crypto2.des( str({ 'status': 'fail', 'res': 'not some houer' }), key) else: return crypto2.des( str({ 'status': 'fail', 'res': 'not some day' }), key) except: return crypto2.des( str({ 'status': 'fail', 'res': 'date bug' }), key) except: return crypto2.des(str({'status': 'fail', 'res': 'bug'}), key)
def post(self): try: DATA = eval(crypto2.des_dicrypte(request.json['data'], key)) conn = db_connect.connect() conn.execute("DELETE FROM SpeechTasks WHERE User = ?;", (DATA['User'], )) return crypto2.des(str({'status': 'success'}), key) except: return crypto2.des(str({'status': 'fail'}), key)
def sent_to_server(data, type_request): temp = {"data": crypto2.des(str(data), key)} data = json.dumps(temp) header = {"Content-Type": "application/json"} response = requests.post(my_domain + type_request, auth=(S_username, S_password), data=data, headers=header) msg = eval(crypto2.des_dicrypte(str(eval(response.content)), key)) return msg
def post(self): DATA = eval(crypto2.des_dicrypte((request.json['data']), key)) conn = db_connect.connect() Name = DATA['User'] if SubFunc.CheckAdmin(Name): if type(DATA['UserUpdate']) == type("help"): Name = DATA['UserUpdate'] Permissions = DATA['Permissions'] else: Name = DATA['UserUpdate'][0] Permissions = DATA['Permissions'][0] query = conn.execute( "select * from Accounts WHERE User=? and Active=?", ( str(Name), 'True', )) result = { 'data': [dict(zip(tuple(query.keys()), i)) for i in query.cursor] } if not result['data']: return crypto2.des( str({ 'status': 'fail', 'reason': 'cannot find user' }), key) if 'Permissions' in DATA.keys(): if Permissions == 'Admin' or Permissions == 'Manger' or Permissions == 'Normal': if Name != 'admin': conn.execute( " UPDATE Accounts SET Permissions =? WHERE User=?", ( Permissions, str(Name), )) return crypto2.des(str({'status': 'success'}), key) else: return crypto2.des(str({'status': 'fail'}), key) conn.execute(" UPDATE Accounts SET Permissions =? WHERE User=?", ( 'Normal', str(Name), )) return crypto2.des( str({ 'status': 'fail', 'reason': 'return regular user' }), key) return crypto2.des( str({ 'status': 'fail', 'reason': 'dont have Permissions' }), key)
def post(self): DATA = eval(crypto2.des_dicrypte((request.json['data']), key)) conn = db_connect.connect() Name = DATA['User'] if SubFunc.CheckAdmin(Name): query = conn.execute("select * from request") result = { 'data': [dict(zip(tuple(query.keys()), i)) for i in query.cursor] } return crypto2.des(str(result), key) return crypto2.des(str({'data': []}), key)
def post(self): DATA = eval(crypto2.des_dicrypte((request.json['data']), key)) try: conn = db_connect.connect() conn.execute(" UPDATE Accounts SET Password =? WHERE User=?", ( DATA['new'], str(DATA['user']), )) return crypto2.des(str({'status': 'change password'}), key) except: return crypto2.des(str({'status': 'fail ,sorry cant do this'}), key)
def decrypt(object): if type(object) == type(1) or object == null or object == None: return object if type(object) == type("string"): return str(crypto2.des_dicrypte(object, key)) elif type(object) == type(list()): for i in range(len(object)): object[i] = decrypt(object[i]) return object else: for obj in object.keys(): object[obj] = decrypt(object[obj]) return object
def post(self): DATA = eval(crypto2.des_dicrypte(request.json['data'], key)) try: conn = db_connect.connect() query = conn.execute("select * from Profile WHERE UserName=?", (DATA['user'], )) result = { 'data': [dict(zip(tuple(query.keys()), i)) for i in query.cursor] } if not result['data']: try: conn.execute( "insert into Profile values('{0}','{1}','{2}','{3}')". format(DATA['user'], DATA['email'], DATA['tel'], DATA['address'])) return crypto2.des( str({ 'status': 'success', 'res': 'new' }), key) except: return crypto2.des(str({'status': 'fail'}), key) else: if DATA['email'] != '': conn.execute( " UPDATE Profile SET email =? WHERE UserName=?", ( DATA['email'], DATA['user'], )) if DATA['tel'] != '': conn.execute( " UPDATE Profile SET Tel =? WHERE UserName=?", ( DATA['tel'], DATA['user'], )) if DATA['address'] != '': conn.execute( " UPDATE Profile SET address =? WHERE UserName=?", ( DATA['address'], DATA['user'], )) return crypto2.des(str({ 'status': 'success', 'res': 'update' }), key) except: return crypto2.des(str({'status': 'bug'}), key)
def post(self): DATA = eval(crypto2.des_dicrypte((request.json['data']), key)) try: conn = db_connect.connect() Name = DATA['User'] query = conn.execute("select * from Profile WHERE UserName=?", (str(Name), )) result = { 'data': [dict(zip(tuple(query.keys()), i)) for i in query.cursor] } if not result['data']: return crypto2.des(str({'status': 'NoFind'}), key) return crypto2.des(str(result), key) except: return crypto2.des(str({'status': 'fail'}), key)
def post(self): DATA = eval(crypto2.des_dicrypte((request.json['data']), key)) try: if type(DATA['UserName']) == type("help"): UserName = DATA['UserName'] ReasonForRequest = DATA['ReasonForRequest'] else: ReasonForRequest = DATA['ReasonForRequest'][0] UserName = DATA['UserName'][0] if (SubFunc.CheckAdmin(DATA['user']) or SubFunc.CheckManger( DATA['user'])) and SubFunc.CheckNormal(UserName): conn = db_connect.connect() query = conn.execute( "select * from request WHERE requesting=? and user=? ", ( DATA['user'], UserName, )) result = { 'data': [dict(zip(tuple(query.keys()), i)) for i in query.cursor] } if len(result['data']) < 3: try: conn.execute( "insert into request (requesting, user, reason) values('{0}','{1}','{2}')" .format(DATA['user'], UserName, ReasonForRequest)) return crypto2.des( str({'status': 'success seve request'}), key) except: return crypto2.des( str({'status': 'can\'t save request'}), key) else: return crypto2.des( str({ 'status': 'too mach request, pls wait for answer from admins ' }), key) else: return crypto2.des( str({ 'status': 'incorrect request, not save', 'data': DATA }), key) except: return crypto2.des(str({'status': 'can\'t find db'}), key)
def post(self): try: DATA = eval(crypto2.des_dicrypte((request.json['data']), key)) conn = db_connect.connect() Name = DATA['User'] if SubFunc.CheckAdmin(Name) or SubFunc.CheckManger(Name): if type(DATA['language']) == type("help"): conn.execute( "DELETE FROM '{0}' WHERE user = '******';".format( DATA['language'], DATA['trainee'])) else: conn.execute( "DELETE FROM '{0}' WHERE user = '******';".format( DATA['language'][0], DATA['trainee'][0])) return crypto2.des(str({'status': 'success'}), key) return crypto2.des(str({'status': 'haven\'t Permissions'}), key) except: return crypto2.des(str({'status': 'fail'}), key)
def post(Self): conn = db_connect.connect() DATA = eval(crypto2.des_dicrypte((request.json['data']), key)) User = DATA['user'] if 'Date' in DATA.keys(): Date = DATA['Date'] else: Date = datetime.datetime.now().strftime("%Y-%m-%d") query = conn.execute( "select * from SpeechTasks where Date=? and User=?", ( Date, User, )) result = { 'data': [dict(zip(tuple(query.keys()), i)) for i in query.cursor] } return crypto2.des(str(result), key)
def post(self): DATA = eval(crypto2.des_dicrypte(request.json['data'], key)) conn = db_connect.connect() try: conn.execute("DELETE FROM Accounts WHERE User = ?;", (DATA['user'], )) conn.execute("DELETE FROM LVL WHERE User = ?;", (DATA['user'], )) conn.execute("DELETE FROM Profile WHERE UserName = ?;", (DATA['user'], )) conn.execute("DELETE FROM Guider WHERE user = ?;", (DATA['user'], )) conn.execute("DELETE FROM speechTasks WHERE User = ?;", (DATA['user'], )) conn.execute("DELETE FROM request WHERE user = ?;", (DATA['user'], )) return crypto2.des(str({'status': 'success'}), key) except: return crypto2.des(str({'status': 'fail'}), key)
def post(self): DATA = eval(crypto2.des_dicrypte((request.json['data']), key)) conn = db_connect.connect() try: Name = DATA['User'] if SubFunc.CheckAdmin(Name) or SubFunc.CheckManger(Name): query = conn.execute( "select User from Guider WHERE GuideName =?;", (str(Name), )) result = { 'data': [dict(zip(tuple(query.keys()), i)) for i in query.cursor], 'status': 'success' } return crypto2.des(str(result), key) return crypto2.des(str({'status': 'haven\'t Permissions'}), key) except: return crypto2.des(str({'status': 'fail'}), key)
def post(self): DATA = eval(crypto2.des_dicrypte((request.json['data']), key)) conn = db_connect.connect() try: Name = DATA['User'] Password = DATA['Password'] Perm = DATA['perm'] if len(Name) <= 1 or len(Password) < 6 or Name.count( "select") != 0 or Perm not in [ "normal", "Normal", "mannger", "Manger" ]: return crypto2.des(str({'status': 'hacker'}), key) query = conn.execute("select * from Accounts WHERE User=?", (str(Name), )) result = { 'data': [dict(zip(tuple(query.keys()), i)) for i in query.cursor] } if not result['data']: conn.execute( "insert into Accounts values('{0}','{1}','{2}','{3}')". format(Name, Password, Perm, 'True')) conn.execute("insert into LVL values('{0}','{1}')".format( Name, "1")) conn.execute( "insert into Profile values('{0}','{1}','{2}','{3}')". format(Name, DATA['Email'], '', '')) return crypto2.des(str({'status': 'success'}), key) return crypto2.des(str({'status': 'fail'}), key) except: try: conn.execute("DELETE FROM Accounts WHERE User = ?;", (DATA['user'], )) conn.execute("DELETE FROM LVL WHERE User = ?;", (DATA['user'], )) conn.execute("DELETE FROM Profile WHERE UserName = ?;", (DATA['user'], )) return crypto2.des(str({'status': 'failAndDeleted'}), key) except: return crypto2.des(str({'status': 'failAndCrash'}), key)
def post(self): DATA = eval(crypto2.des_dicrypte((request.json['data']), key)) conn = db_connect.connect() try: user = DATA['user'] user_name = DATA['user_search'] if SubFunc.CheckAdmin(user) or SubFunc.CheckManger( user) or user == user_name: try: temp = [] query = conn.execute( "select avg(grade) avrage from SpeechTasks WHERE user==?", (str(user_name), )) for user in query.cursor: avrage = user[0] query = conn.execute( "select Line,Say,grade,Date from SpeechTasks WHERE user==?", (str(user_name), )) for user in query.cursor: temp += [[ user[0].encode('utf-8'), user[1].encode('utf-8'), user[2], user[3] ]] result = { 'data': temp, 'status': 'success', 'avrage': avrage } return crypto2.des(str(result), key) except: return crypto2.des( str({ 'status': 'fail', 'code': 'sqlfail' }), key) return crypto2.des(str({'status': 'haven\'t Permissions'}), key) except: return crypto2.des(str({'status': 'fail'}), key)
def post(self): try: DATA = eval(crypto2.des_dicrypte(request.json['data'], key)) conn = db_connect.connect() User = DATA['user'] query = conn.execute( "select * from Accounts WHERE User=? and Active=?", ( User, "True", )) result = { 'data': [dict(zip(tuple(query.keys()), i)) for i in query.cursor] } if not result['data']: return crypto2.des(str({'status': 'fail'}), key) Date = datetime.datetime.now().strftime("%Y-%m-%d") if type(DATA['line']) == type("help"): line = DATA['line'] say = DATA['say'] grade = DATA['grade'] else: line = DATA['line'][0] say = DATA['say'][0] grade = DATA['grade'][0] try: conn.execute( "insert into SpeechTasks values(NULL,'{0}','{1}','{2}','{3}','{4}')" .format(User, line, say, grade, Date)) except: return crypto2.des(str({ 'status': 'bug save', 'send': DATA }), key) return crypto2.des(str({'status': 'save'}), key) except: return crypto2.des(str({'status': 'bug'}), key)
def post(self): DATA = eval(crypto2.des_dicrypte((request.json['data']), key)) conn = db_connect.connect() try: Name = DATA['User'] if SubFunc.CheckAdmin(Name) or SubFunc.CheckManger(Name): try: if type(DATA['trainee']) == type("help"): conn.execute( "insert into '{2}' (user, word) values('{0}','{1}')" .format(DATA['trainee'], DATA['word'], DATA['language'])) else: conn.execute( "insert into '{2}' (user, word) values('{0}','{1}')" .format(DATA['trainee'][0], DATA['word'][0], DATA['language'][0])) except: return crypto2.des( str({'status': 'that word already exists'}), key) return crypto2.des(str({'status': 'success'}), key) return crypto2.des(str({'status': 'haven\'t Permissions'}), key) except: return crypto2.des(str({'status': 'fail'}), key)
def post(self): DATA = eval(crypto2.des_dicrypte((request.json['data']), key)) try: conn = db_connect.connect() Name = DATA['user'] query = conn.execute("select * from Trylogin WHERE user=?", (Name, )) result = { 'data': [dict(zip(tuple(query.keys()), i)) for i in query.cursor] } date = datetime.datetime.now() if not result['data']: conn.execute( "insert into Trylogin values('{0}','{1}','{2}','{3}')". format(DATA['user'], DATA['permissions'], DATA['key'], date)) return crypto2.des(str({ 'status': 'success', 'res': 'new' }), key) else: conn.execute( " UPDATE Trylogin SET permissions=?,key=?,date=? WHERE user=?", ( DATA['permissions'], DATA['key'], date, Name, )) return crypto2.des(str({ 'status': 'success', 'res': 'update' }), key) except: return crypto2.des(str({'status': 'fail', 'res': 'bug'}), key)
def post(self): DATA = eval(crypto2.des_dicrypte((request.json['data']), key)) conn = db_connect.connect() try: Name = DATA['User'] Permissions = DATA['Permissions'] if SubFunc.CheckAdmin(Name): query = conn.execute( "select User from Accounts WHERE User<>? and Active=? and Permissions=? ORDER BY Permissions ASC;", ( str(Name), "True", Permissions, )) result = { 'data': [dict(zip(tuple(query.keys()), i)) for i in query.cursor], 'status': 'success' } return crypto2.des(str(result), key) return crypto2.des(str({'status': 'haven\'t Permissions'}), key) except: return crypto2.des(str({'status': 'fail'}), key)
def post(self): DATA = eval(crypto2.des_dicrypte((request.json['data']), key)) massge = "deleted this request" conn = db_connect.connect() Name = DATA['User'] try: try: if SubFunc.CheckAdmin(Name) and (SubFunc.CheckManger( DATA['requesting']) or SubFunc.CheckAdmin( DATA['requesting'])) and SubFunc.CheckNormal( DATA['user']): if DATA['insert']: try: query = conn.execute( "select * from Guider where User=? AND GuideName=?", ( DATA['user'], DATA['requesting'], )) result = { 'data': [ dict(zip(tuple(query.keys()), i)) for i in query.cursor ] } if not result['data']: conn.execute( "insert into Guider values('{0}','{1}','True')" .format(DATA['user'], DATA['requesting'])) massge = massge + " and saved" else: conn.execute( " UPDATE Guider SET Active =? where User=? AND GuideName=?", ( "True", DATA['user'], DATA['requesting'], )) massge = massge + " and update" conn.execute( "DELETE FROM request WHERE requesting = ? and user=?;", ( DATA['requesting'], DATA['user'], )) except: conn.execute( "DELETE FROM request WHERE IDrequest = ?;", (DATA['IDrequest'], )) return crypto2.des( str({'status': 'he can see hes info'}), key) else: conn.execute( "DELETE FROM request WHERE IDrequest = ?;", (DATA['IDrequest'], )) return crypto2.des(str({'status': massge}), key) conn.execute("DELETE FROM request WHERE IDrequest = ?;", (DATA['IDrequest'], )) return crypto2.des(str({'status': "bad user Permissions"}), key) except: try: conn.execute("DELETE FROM request WHERE IDrequest = ?;", (DATA['IDrequest'], )) except: return crypto2.des( str({ 'status': '1sorry some thing happend send report bug' }), key) return crypto2.des(str({'status': 'fail'}), key) except: if type(DATA['IDrequest']) == type("help"): requesting = DATA['requesting'] user = DATA['user'] IDrequest = DATA['IDrequest'] else: requesting = DATA['requesting'][0] user = DATA['user'][0] IDrequest = DATA['IDrequest'][0] try: if SubFunc.CheckAdmin(Name) and ( SubFunc.CheckManger(requesting) or SubFunc.CheckAdmin(requesting) ) and SubFunc.CheckNormal(user): if DATA['insert']: try: query = conn.execute( "select * from Guider where User=? AND GuideName=?", ( user, requesting, )) result = { 'data': [ dict(zip(tuple(query.keys()), i)) for i in query.cursor ] } if not result['data']: conn.execute( "insert into Guider values('{0}','{1}','True')" .format(user, requesting)) massge = massge + " and saved" else: conn.execute( " UPDATE Guider SET Active =? where User=? AND GuideName=?", ( "True", user, requesting, )) massge = massge + " and update" conn.execute( "DELETE FROM request WHERE requesting = ? and user=?;", ( requesting, user, )) except: conn.execute( "DELETE FROM request WHERE IDrequest = ?;", (IDrequest, )) return crypto2.des( str({'status': 'he can see hes info'}), key) else: conn.execute( "DELETE FROM request WHERE IDrequest = ?;", (IDrequest, )) return crypto2.des(str({'status': massge}), key) conn.execute("DELETE FROM request WHERE IDrequest = ?;", (IDrequest, )) return crypto2.des(str({'status': "bad user Permissions"}), key) except: try: conn.execute("DELETE FROM request WHERE IDrequest = ?;", (IDrequest, )) except: return crypto2.des( str({ 'status': 'sorry some thing happend send report bug' }), key) return crypto2.des(str({'status': 'fail'}), key)