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())