def post(self):
json_data = request.get_json(force=True)
if not json_data:
return {'message': 'No input data provided'}, 400
# if type(json_data['name']) == str:
# data, errors = category_schema.load(json_data)
# elif type(json_data['name']) == list:
# data, errors = categories_schema.load(json_data)
# # Validate and deserialize input
data, errors = category_schema.load(json_data)
if errors:
return errors, 422
category = Category.query.filter_by(name=data['name']).first()
if category:
return {'message': 'Category already exists'}, 400
category = Category(
name=json_data['name']
)
db.session.add(category)
db.session.commit()
result = category_schema.dump(category).data
return { "status": 'success', 'data': result },200
def post(self):
current_app.logger.info('Processing Category POST')
json_data = request.get_json(force=True)
if not json_data:
current_app.logger.error('No input data given to Category POST')
return {'message': 'No input data provided', 'error': 'true'}, 400
# Validate and deserialize input
data, errors = category_schema.load(json_data)
if errors:
current_app.logger.error('Bad data given to Category POST')
return errors, 422
category = Category.query.filter_by(name=data['name']).first()
if category:
current_app.logger.error(
'Category already exists in Category POST')
return {'message': 'Category already exists', 'error': 'true'}, 400
category = Category(name=json_data['name'])
db.session.add(category)
db.session.commit()
result = category_schema.dump(category).data
current_app.logger.info('Successful Category POST')
return {"status": 'success', 'data': result}, 201
def post(self):
# Check for JSON input data
json_data = request.get_json(force=True)
if not json_data:
return {'message': 'No input data provided'}, 400
# Validate and deserialize input
data, errors = category_schema.load(json_data)
if errors:
return errors, 422
# Check if category already exists
category = Category.query.filter_by(name=data['name']).first()
if category:
return {'message': 'Category already exists'}, 400
category = Category(
name=json_data['name']
)
# Add dataset and commit changes to DB
db.session.add(category)
db.session.commit()
result = category_schema.dump(category).data
# Return HTTP status code 201
return {"status": 'success', 'data': result}, 201
def post(self):
json_data = request.get_json()
if not json_data:
return {'message': 'No input data provided'}, 400
# Validate and deserialize input
data = category_schema.load(json_data)
name = data['name']
category = Category.query.filter_by(name=name).first()
if category:
return {'message': 'Category already exists'}, 400
category = Category(name=json_data['name'])
db.session.add(category)
db.session.commit()
result = category_schema.dump(category)
return {"status": 'success', 'data': result}, 201
def save(response):
"""
:param response: Checkin data from API response.
:type response: dict
"""
checkin = Checkin(**response)
try:
venue = Venue(**response['venue'])
checkin.venue = venue
for category_response in response['venue']['categories']:
category = Category(**category_response)
venue.categories.append(category)
except KeyError:
pass
db.merge(checkin)
db.commit()
def post(self):
json_data = request.get_json(force=True)
if not json_data:
return {'message': 'No input data provided'}, 400
data, errors = category_schema.load(json_data)
if errors:
return errors, 422
category = Category.query.filter_by(name=data['name']).first()
if category:
return {'message': 'Category already exists'}, 400
category = Category(name=json_data['name'])
db.session.add(category)
db.session.commit()
result = category_schema.dump(category).data
return {'status': 'success', 'data': result}, 201
def post(self):
json_data = request.get_json(force=True)
if not json_data or not 'name' in json_data:
return {"error": "No input data provided"}, 400
category = Category.query.filter_by(name=json_data['name']).first()
if category:
return {'message': 'Category already exists'}, 400
category = Category(name=json_data['name'])
db.session.add(category)
db.session.commit()
result = category_schema.dump(category)
return {"message": "Saved successfully!", "data": result}, 201
def post(self):
json_data = request.get_json(force=True)
if not json_data:
return {'message': 'No input data provided'}, 400
# Validate and deserialize input
data, errors = category_schema.load(json_data)
print(json_data, 'nnnnnnnnnnppl')
print(category_schema.load(json_data), 'nnnnnnnnnnppll')
if errors:
return errors, 422
# category = Category.query.filter_by(name=data['name']).first()
# if category:
# return {'message': 'Category already exists'}, 400
category = Category(name=json_data['name'])
category.save()
# Serialize data
result = category_schema.dump(category).data
return {"status": 'success', 'data': result}, 201
def post(self):
json_data = request.get_json(force=True)
if not json_data:
return ({'message': 'No input data provided'}, 400)
# Validate and deserialize input
data, errors = category_schema.load(json_data)
if errors:
return (errors, 422)
category = Category.query.filter_by(name=data['name']).first()
if category:
return ({'message': 'Category already exists'}, 400)
category = Category(name=json_data['name'])
session = db.session
try:
session.add(category)
session.commit()
except:
session.rollback()
finally:
session.close()
result = category_schema.dump(category).data
return ({"status": 'success', 'data': result}, 201)
from sqlalchemy.orm import Session
from Model import Comment, Translation, Language, Category
from sqlalchemy import create_engine
engine = create_engine("postgresql://*****:*****@localhost/discuss")
session = Session(bind=engine)
# session = sessionmaker(bind=engine)
# init_sqlalchemy()
categories = [
Category(name='Children'),
Category(name='Cars'),
Category(name='Jokes'),
Category(name='Religion'),
Category(name='Philosophy'),
Category(name='Leadership'),
Category(name='Marriage'),
Category(name='Cooking'),
Category(name='Technology'),
Category(name='Spiritual')
]
languages = [
Language(name='Spanish', code="SP"),
Language(name='French', code='FR'),
Language(name='German', code='GR')
]
comments = [
