def getUsers(id): try: itr = db.session.query(Users).get(id) data = UsersSchema().dumps(itr) resp = Response(simplejson.dumps(data), status=200, mimetype='application/json') return resp except SQLAlchemyError as e: return handle_sql_error(e, logger) except Exception as e: return handle_error(e, logger)
def listUsers(): try: # payload = request.json itr = Users.query.all() #filter_by(**payload) data = UsersSchema(many=True).dumps(itr) resp = Response(simplejson.dumps(data), status=200, mimetype='application/json') return resp except SQLAlchemyError as e: return handle_sql_error(e, logger) except Exception as e: return handle_error(e, logger)
def getSegmap(id): try: itr = db.session.query(Segmap).get(id) data = SegmapSchema(exclude=['secretKey', 'accessKey']).dump(itr) resp = Response(json.dumps(data), status=200, mimetype='application/json') return resp except SQLAlchemyError as e: return handle_sql_error(e, logger) except Exception as e: return handle_error(e, logger)
def editUsers(id): try: payload = request.json payload = validate_update(payload) users = Users(**payload) db.session.merge(users) db.session.commit() resp = Response("Success", status=200, mimetype='application/json') return resp except SQLAlchemyError as e: return handle_sql_error(e, logger) except Exception as e: return handle_error(e, logger)
def listSegmap(): try: # payload = request.json itr = Segmap.query.all() #filter_by(**payload) data = SegmapSchema(many=True, exclude=['secretKey', 'accessKey']).dump(itr) resp = Response(json.dumps(data), status=200, mimetype='application/json') return resp except SQLAlchemyError as e: return handle_sql_error(e, logger) except Exception as e: return handle_error(e, logger)
def addSegmap(): try: payload = request.json segmap = Segmap(**payload) # print(segmap) db.session.add(segmap) db.session.commit() resp = Response("Success", status=200, mimetype='application/json') return resp except SQLAlchemyError as e: return handle_sql_error(e, logger) except Exception as e: return handle_error(e, logger)
def addUsers(): try: payload = request.json users = Users(**payload) print(users) # hashed_password = generate_password_hash(users.password, method='sha256') hashed_password = hashed = bcrypt.hashpw(users.password.encode("utf-8"), bcrypt.gensalt()) users.password = hashed_password db.session.add(users) db.session.commit() resp = Response("Success", status=200, mimetype='application/json') return resp except SQLAlchemyError as e: return handle_sql_error(e, logger) except Exception as e: return handle_error(e, logger)
def searchSegmapList(): try: payload = request.json print(payload) itr = db.session.execute( "call searchSegmap (:cid, :segid, :str, :type )", { 'cid': payload['cid'], 'segid': payload['segid'], 'str': payload['str'], 'type': payload['type'] }) data = [dict(row) for row in itr] resp = Response(json.dumps(data, default=str), status=200, mimetype='application/json') return resp except SQLAlchemyError as e: return handle_sql_error(e, logger) except Exception as e: return handle_error(e, logger)