def update_member(username, body): # noqa: E501 """Updated member This can only be done by the logged in member. # noqa: E501 :param username: name that need to be updated :type username: str :param body: Update member object :type body: dict | bytes :rtype: MemberPrivate """ if connexion.request.is_json: body = MemberUpdate.from_dict( connexion.request.get_json()) # noqa: E501 updateMember = db_session.query( dbModels.Member).filter(dbModels.Member.username == username).first() updateMember.update(body.name, body.password, body.name, body.email, body.description) db_session.add(updateMember) try: db_session.commit() except: db_session.rollback() # Bad Error Handling TODO return connexion.problem( 400, "Bad Request", "Username, Name, Passwd and Email are required.", "Parsing") return updateMember.get_privat(), 200
def create_event(body): # noqa: E501 """Create event This can only be done by the logged in member. # noqa: E501 :param body: Created event object :type body: dict | bytes :rtype: Event """ auth = flask.request.authorization if connexion.request.is_json: body = EventRequest.from_dict( connexion.request.get_json()) # noqa: E501 member_id = db_session.query(dbModels.Member.id).filter( dbModels.Member.username == auth.username).first()[0] # TODO validate event body function if not body.start_datetime or not body.end_datetime or not body.start_datetime <= body.end_datetime: return connexion.problem( 400, "Bad Request", "Date: Dates not valid; Is the start_date earlier than the end_date?", "Parsing") images = None if body.images: images = db_session.query(dbModels.Image).filter( dbModels.Image.uuid.in_(body.images)).all() newEvent = dbModels.Event(member_id, body.name, body.description, body.start_datetime, body.end_datetime, body.age_from, body.age_to, body.location, images) db_session.add(newEvent) try: db_session.commit() except: db_session.rollback() # Bad Error Handling TODO raise return connexion.problem(400, "Bad Request", "Event: model failed", "Parsing") return newEvent.to_dict(), 201
def update_event(event_id, body): # noqa: E501 """Updated event This can only be done by the logged in member. # noqa: E501 :param event_id: name that need to be updated :type event_id: int :param body: Updated event object :type body: dict | bytes :rtype: Event """ if connexion.request.is_json: body = EventRequest.from_dict( connexion.request.get_json()) # noqa: E501 putEvent = db_session.query( dbModels.Event).filter(dbModels.Event.id == event_id).first() if putEvent is None: return connexion.problem(404, "Not Found", "event_id not found.", "Lookup") # TODO validate event body function if not body.start_datetime or not body.end_datetime or not body.start_datetime <= body.end_datetime: return connexion.problem( 400, "Bad Request", "Date: Dates not valid; Is the start_date earlier than the end_date?", "Parsing") images = None if body.images: images = db_session.query(dbModels.Image).filter( dbModels.Image.uuid.in_(body.images)).all() putEvent.update(body.name, body.description, body.start_datetime, body.end_datetime, body.age_from, body.age_to, body.location, images) db_session.add(putEvent) try: db_session.commit() except: db_session.rollback() raise return putEvent.to_dict()
def image_upload_post(image, description=None): # noqa: E501 """Uploads a file. # noqa: E501 :param image: The file to upload. :type image: werkzeug.datastructures.FileStorage :param description: Description of the Image. :type description: str :rtype: Image """ # check file if image.content_type not in ALLOWED_MIME_TYPES: # 415 Unsupported Media Type - https://www.w3.org/Protocols/rfc2616/rfc2616-sec10.html#sec10.4.16 return connexion.problem( 415, "Unsupported Media Type", "Image: only files with mime-type " + str(ALLOWED_MIME_TYPES) + " are allowed", "Parsing") # File Handling unique_id = str(uuid.uuid1()) path = IMAGE_DATA_PATH + unique_id create_path(path) # Database auth = flask.request.authorization member_id = db_session.query(dbModels.Member.id).filter( dbModels.Member.username == auth.username).first()[0] newImage = dbModels.Image(member_id, unique_id, path, image.content_type, description) db_session.add(newImage) try: db_session.commit() except: db_session.rollback() # Error Handling TODO raise # Save file if database was successful image.save(path) return newImage.to_dict()
def add_pet(body): """ Add a new pet to the store :param body: Pet object that needs to be added to the store :type body: dict | bytes :rtype: None """ if connexion.request.is_json: body = Pet.from_dict(connexion.request.get_json()) ses.add(body) try: ses.commit() return body.to_str() except Exception as e: ses.rollback() return e
def create_member(body): # noqa: E501 """Create member This creates a new Member # noqa: E501 :param body: Created member object :type body: dict | bytes :rtype: MemberPrivate """ if connexion.request.is_json: body = MemberCreate.from_dict( connexion.request.get_json()) # noqa: E501 if not body.username or not re.match( r'^(?=.{4,20}$)(?![_.])(?!.*[_.]{2})[a-zA-Z0-9._]+(?<![_.])$', body.username): return connexion.problem(400, "Bad Request", "Username validation failed.", "Parsing") if db_session.query(dbModels.Member.id).filter_by( username=body.username).scalar() is not None: return connexion.problem(409, "Conflict", "Username already used", "IntegrityError") newMember = dbModels.Member(body.username, body.password, body.name, body.email, body.description) db_session.add(newMember) try: db_session.commit() except Exception as e: logging.error(e) db_session.rollback() if isinstance(e, sqlalchemy.exc.IntegrityError): return connexion.problem( 400, "Bad Request", "'username', 'name', 'password' and 'email' are required.", "Parsing") raise e return newMember.get_privat(), 201
def attend_event(event_id, state): # noqa: E501 """change attendence to a event This can only be done by the logged in member. # noqa: E501 :param event_id: The Event ID :type event_id: int :param state: The status :type state: bool :rtype: Success """ auth = flask.request.authorization member = db_session.query(dbModels.Member).filter( dbModels.Member.username == auth.username).first() event = db_session.query( dbModels.Event).filter(dbModels.Event.id == event_id).first() if state == True: event.participants.append(member) else: event.participants.remove(member) db_session.add(event) try: db_session.commit() except: db_session.rollback() # Bad Error Handling TODO raise return connexion.problem(400, "Bad Request", "Event: model failed", "Parsing") return event.to_dict()
def add_user(user_dict): db_session.add(user_dict) db_session.commit()