def create_security(payload): body = request.get_json() security_name = body.get('security_name', None) region_id = body.get('region_id', None) asset_class_id = body.get('asset_class_id', None) if Region.query.get(region_id) is None or AssetClass.query.get( asset_class_id) is None: abort(422) security = Security(name=security_name, region_id=region_id, asset_class_id=asset_class_id) security.insert() db.session.add(security) db.session.commit() return jsonify({ 'success': True, 'security_id': security.id, 'security_name': security.name, 'region': security.region.name, 'asset_class': security.asset_class.name, })