def change(id, data): try: author = Author.query.filter_by(id=id).first() if not author: json_abort(400, "Author not found") else: first_name = data.get('first_name') if not first_name: json_abort(400, "First Name is required") last_name = data.get('last_name') if not last_name: json_abort(400, "Last Name is required") age = data.get('age') if not age: json_abort(400, "Age is required") author.first_name = first_name author.last_name = last_name author.age = age db.session.commit() return author except SQLAlchemyError as err: db.session.rollback() error = str(err.__dict__['orig']) json_abort(500, error)
def get(id): try: author = Author.query.filter_by(id=id).first() if not author: json_abort(400, "Author not found") else: return author except SQLAlchemyError as err: db.session.rollback() error = str(err.__dict__['orig']) json_abort(500, error)
def get(id): try: post = Post.query.filter_by(id=id).first() if not post: json_abort(400,"Post not found") else: return post except SQLAlchemyError as err: db.session.rollback() error = str(err.__dict__['orig']) json_abort(500, error)
def get_all(): try: post = Post.query.all() if not post: json_abort(400,"Posts not found") else: return post except SQLAlchemyError as err: db.session.rollback() error = str(err.__dict__['orig']) json_abort(500, error)
def create(data): try: first_name = data.get('first_name') if not first_name: json_abort(400, "First Name is required") last_name = data.get('last_name') if not last_name: json_abort(400, "Last Name is required") age = data.get('age') if not age: json_abort(400, "Age is required") #chama objeto para gravar no banco author = Author(first_name=first_name, last_name=last_name, age=age) db.session.add(author) db.session.commit() return author except SQLAlchemyError as err: db.session.rollback() error = str(err.__dict__['orig']) json_abort(500, error)
def get_all(): try: data = Data.query.all() if not data: json_abort(400, "Data not found") else: return data except SQLAlchemyError as err: db.session.rollback() error = str(err.__dict__['orig']) json_abort(500, error)
def change(id, data): try: post = Post.query.filter_by(id=id).first() if not post: json_abort(400,"Post not found") else: text = data.get('text') if not text: json_abort(400,"text is required") subtitle = data.get('subtitle') if not subtitle: json_abort(400,"Subtitle is required") post.text = text post.subtitle = subtitle db.session.commit() return post except SQLAlchemyError as err: db.session.rollback() error = str(err.__dict__['orig']) json_abort(500, error)
def create(data): try: text = data.get('text') if not text: json_abort(400,"text is required") author_id = data.get('author_id') if not author_id: json_abort(400,"author_id is required") subtitle = data.get('subtitle') if not subtitle: json_abort(400,"subtitle is required") author = get_author(author_id) created = datetime.datetime.now() post = Post(text=text,created=created, author_id=author_id,author=author,subtitle=subtitle) db.session.add(post) db.session.commit() return post except SQLAlchemyError as err: db.session.rollback() error = str(err.__dict__['orig']) json_abort(500, error)
def create(data): try: acc1 = data.get('acc1') acc2 = data.get('acc2') acc3 = data.get('acc3') gyro1 = data.get('gyro1') gyro2 = data.get('gyro2') gyro3 = data.get('gyro3') countSteps = data.get('countSteps') createdAt = datetime.datetime.now() #chama objeto para gravar no banco data = Data(acc1=acc1,acc2=acc2,acc3=acc3,gyro1=gyro1,gyro2=gyro2,gyro3=gyro3,countSteps=countSteps,createdAt=createdAt) db.session.add(data) db.session.commit() return data except SQLAlchemyError as err: db.session.rollback() error = str(err.__dict__['orig']) json_abort(500, error)