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)