def updateUser(username=None, password=None, userid=None):
if username is None:
logging.info('updateUser: '******'username']
userid = request.json['user_id']
query = "UPDATE `users` SET `username` = %s WHERE `idusers` = %s"
args = (username, bio, email, privacy, userid)
try:
dbconnect.__change_data(query, args)
return codes.JSON_SUCCESS
except Exception as e:
logging.error('updateUser: ' + str(e))
return codes.JSON_FAILURE
def downloadRoute(routeId=None):
if routeId is None:
routeId = request.json['routeId']
query = "SELECT * FROM `routes` WHERE `idroutes` = %s"
cursor = dbconnect.__change_data(query, (routeId, ))
try:
route = cursor
return json.dumps(route[0])
except Exception as e:
print(e)
return json.dumps('{status: failure}')
def checkLogin(username=None, password=None):
if username is None:
username = request.json['username']
password = request.json['password']
query = "SELECT `username`, `pass` FROM `users` WHERE `username` = %s AND `pass` = %s"
cursor = dbconnect.__change_data(query, (username, password))
try:
for key, value in (dict(cursor)).items():
return json.dumps(SUCCESS)
return json.dumps(FAILURE)
except Exception as e:
return json.dumps(FAILURE)
def checkLogin(username=None, password=None):
if username is None:
username = request.json['username']
password = request.json['password']
logging.info("checkLogin: "******"SELECT `idusers`, `username`FROM `users` WHERE `username` = %s AND `pass` = %s"
cursor = dbconnect.__change_data(query, (username, password))
try:
for key, value in (dict(cursor[0])).items():
return json.dumps(cursor)
return JSON_FAILURE
except Exception as e:
logging.error("checkLogin: " + str(e))
return JSON_FAILURE
def getNearMe(userLatitude=None, userLongitude=None, preferredDistance=None):
isThisAProductionRun = userLatitude is None or userLongitude is None
query = "SELECT idroutes, route, ( 3959 * acos( cos( radians(" + userLatitude
query += " ) ) * cos( radians( startPointLat ) ) * cos( radians( startPointLon ) - radians(" + userLongitude
query += " ) ) + sin( radians(" + userLatitude + ") ) * sin( radians( startPointLat ) ) ) ) "
query += "AS distance FROM routes HAVING distance < " + str(
preferredDistance) + " ORDER BY distance LIMIT 0 , 20"
try:
assert (isThisAProductionRun == True)
except AssertionError:
userLatitude = request.json['userLat']
userLongitude = request.json['userLon']
preferredDistance = request.json['dist']
finally:
cursor = dbconnect.__change_data(query, preferredDistance)
return json.dumps(cursor)