def get_user():
idinfo = default_auth(request.headers['Content-Type'],
request.json['token'])
if idinfo is None:
abort(403)
user = User.query.filter(User.google_id == idinfo['sub']).first()
return jsonify(user.to_dict())
def get_subject_all():
idinfo = default_auth(request.headers['Content-Type'],
request.json['token'])
if idinfo is None:
abort(403)
subjects = Subject.query.all()
return jsonify({'subjects': [subject.to_dict() for subject in subjects]})
def get_joboffer_all():
idinfo = default_auth(request.headers['Content-Type'],
request.json['token'])
if idinfo is None:
abort(403)
joboffers = JobOffer.query.all()
return jsonify(
{'joboffers': [joboffer.to_dict() for joboffer in joboffers]})
def create_subject():
idinfo = default_auth(request.headers['Content-Type'],
request.json['token'])
if idinfo is None:
abort(403)
try:
db.session.add(Subject(request.json['name']))
db.session.commit()
return jsonify({'result': True}), 201
except:
return jsonify({'result': False}), 500
def login():
print(request.json['token'])
idinfo = default_auth(request.headers['Content-Type'],
request.json['token'])
if idinfo is None:
abort(403)
if User.query.filter(User.google_id == idinfo['sub']).first() is None:
print('みつからなかったよーゆうてから')
return jsonify({'result': 'account not found'})
else:
print('見つかったよーゆうてから')
return jsonify({'result': 'account found'})
def delete_joboffer(id):
idinfo = default_auth(request.headers['Content-Type'],
request.json['token'])
if idinfo is None:
abort(403)
try:
jobinfo = JobOffer.query.filter_by(id=id).first()
db.session.delete(jobinfo)
db.session.commit()
return make_response('', 204)
except:
print(traceback.format_exc())
return jsonify({'result': False}), 500
def delete_subject(subject_id):
idinfo = default_auth(request.headers['Content-Type'],
request.json['token'])
if idinfo is None:
abort(403)
try:
subject = Subject.query.filter_by(id=subject_id).first()
if subject is None:
return jsonify({'message': 'record not found'}), 400
db.session.delete(subject)
db.session.commit()
return make_response('', 204)
except:
# print(traceback.format_exc())
return jsonify({'message': 'failed'}), 500
def create_user():
idinfo = default_auth(request.headers['Content-Type'],
request.json['token'])
if idinfo is None:
abort(403)
try:
db.session.add(
User(idinfo['sub'],
request.json['subject_id'],
request.json['is_admin'],
class_number=request.json['class_number']))
db.session.commit()
return jsonify({'result': True})
except IntegrityError as e:
# print(traceback.format_exc())
return hsonify({'result': False})
def searches_subject():
idinfo = default_auth(request.headers['Content-Type'],
request.json['token'])
if idinfo is None:
abort(403)
searches_request = {}
# カラムを取得して検索条件に指定されているかをチェックする
# NOTE: モデル名.__table__.c.keys()でカラムの一覧を取得できる
for column in Subject.__table__.c.keys():
if column in request.json.keys():
searches_request[column] = request.json[column]
else:
searches_request[column] = None
subjects = common.search_query(Subject, searches_request)
return jsonify({'subjects': [subject.to_dict() for subject in subjects]})
def update_joboffer(id):
idinfo = default_auth(request.headers['Content-Type'],
request.json['token'])
if idinfo is None:
abort(403)
try:
subject = Subject.query.filter_by(id=id).first()
if subject is None:
return jsonify({'message': 'record not found'}), 400
subject.name = request.json['name']
subject.updated_by = request.json['updated_by']
subject.updated = datetime.now()
db.session.commit()
return make_response('', 204)
except Exception as e:
return jsonify({'message': 'failed'}), 500
def searches_joboffer():
idinfo = default_auth(request.headers['Content-Type'],
request.json['token'])
if idinfo is None:
abort(403)
searches_request = {}
# カラムを取得して検索条件に指定されているかをチェックする
# NOTE: モデル名.__table__.c.keys()でカラムの一覧を取得できる
for column in JobOffer.__table__.c.keys():
if column in request.json.keys():
searches_request[column] = request.json[column]
else:
searches_request[column] = None
joboffers = common.search_query(JobOffer, searches_request)
return jsonify(
{'joboffers': [joboffer.to_dict() for joboffer in joboffers]})
def create_joboffer():
idinfo = default_auth(request.headers['Content-Type'],
request.json['token'])
if idinfo is None:
abort(403)
try:
db.session.add(
JobOffer(request.json['company_name'], request.json['industry_id'],
request.json['occupation'], request.json['max_appicants'],
request.json['starting_salary'],
request.json['image_url_text']))
db.session.commit()
return jsonify({'result': True}), 201
except IntegrityError as e:
# スタックトレース
print(traceback.format_exc())
return jsonify({'result': False}), 500
def update_joboffer(id):
idinfo = default_auth(request.headers['Content-Type'],
request.json['token'])
if idinfo is None:
abort(403)
try:
jobinfo = JobOffer.query.filter_by(id=id).first()
jobinfo.company_name = request.json['company_name']
jobinfo.industry_id = request.json['industry_id']
jobinfo.occupation = request.json['occupation']
jobinfo.max_appicants = request.json['max_appicants']
jobinfo.starting_salary = request.json['starting_salary']
jobinfo.image_url_text = request.json['image_url_text']
jobinfo.updated = datetime.now()
jobinfo.updated_by = request.json['updated_by']
db.session.commit()
return make_response('', 204)
except Exception as e:
print(traceback.format_exc())
return jsonify({'result': False}), 500
def get_subject(id):
idinfo = default_auth(request.headers['Content-Type'])
if idinfo is None:
abort(403)
subject = Subject.query.filter_by(id=id).first()
return jsonify(subject.to_dict())
