def create_emp_cat(rank_id): if not request.json: abort(400) if not 'name' in request.json.keys(): abort(401) if len(request.json['name'].strip()) < 2: abort(411) #strip down the values display_name = request.json['name'].strip() name = display_name.lower() emp_cat_rank_id = rank_id #try to put onto database try: cat = EmployeeCategory(name=name, display_name=display_name, emp_cat_rank_id=emp_cat_rank_id) db_session.add(cat) db_session.commit() except IntegrityError as e: return record_exists_envelop() except Exception as e: return fatal_error_envelop() else: return record_created_envelop(request.json)
def create_employee_type(): if not request.json: abort(400) if not 'name' in request.json.keys(): abort(401) if len(request.json['name'].strip()) < 2: abort(411) #clear up the values display_name = request.json['name'].strip() name = display_name.lower() try: e_type = EmployeeType(name=name, display_name=display_name) db_session.add(e_type) db_session.commit() except IntegrityError as e: return record_exists_envelop() except Exception as e: return fatal_error_envelop() else: return record_created_envelop(request.json)
def create_certification_by_emp(id): if not request.json: abort(400) #check if there is empty field comming up if not all( len(str(val).strip()) >= 1 for key, val in request.json.items()): abort(411) #check if there is no registration number and registration body result = {'regulatory_body', 'registration_number'} - set( request.json.keys()) if result: return keys_require_envelop( '"regulatory_body" and "regstration_number" is required') #clean up the values cert = { key: val.strip() if isinstance(val, str) else val for key, val in request.json.items() } #insert cert['employee_id'] = id ################################### cert['expiry_date'] = '04-mar-2012' cert['last_renewal_date'] = '03-mar-2017' ################################ try: db_session.add(Certification(**cert)) db_session.commit() except IntegrityError as e: return record_exists_envelop() except Exception as e: return fatal_error_envelop() else: return record_created_envelop(request.json)
def add_company_detail(): if not set(request.json.keys()) == { 'name', 'currency_symbol', 'is_prefix', 'country', 'description' }: return missing_keys_envelop() if len(request.json['name']) < 4 or len( request.json['country']) < 3 or len( request.json['currency_symbol']) < 1: return length_require_envelop() #now shape up the fields name = request.json['name'].strip() currency_symbol = request.json['currency_symbol'].lower().strip() is_prefix = request.json['is_prefix'] country = request.json['country'].strip() des = request.json['description'].strip() company = CompanyDetail(name=name, currency_symbol=currency_symbol, is_prefix=is_prefix, country=country, description=des) try: db_session.add(company) db_session.commit() except IntegrityError as e: return record_exists_envelop() else: return record_created_envelop(request.json)
def create_division_types(): if not request.json: abort(400) #empty check if not all( len(val.strip()) >= 1 for val in request.json.values() if isinstance(val, unicode)): return length_require_envelop() _result = {'name'} - set(request.json.keys()) if _result: return keys_require_envelop('key : name is required') request.json['display_name'] = request.json['name'].strip() request.json['name'] = request.json['name'].strip().lower() try: db_session.add(DivisionTypeSetup(**request.json)) db_session.commit() except IntegrityError: return record_exists_envelop() except Exception: return fatal_error_envelop() else: return record_created_envelop(request.json)
def create_employee_extra(id): #cheek to see if ther is json if not request.json: abort(400) #if there is json, if there are required fields required_keys = set(col.name for col in EmployeeExtra.__mapper__.columns) - {'id', 'employee_id'} #keys from the rquest object result = request.json.keys() - required_keys #if there is extra remaining keys , abort if result: return extra_keys_envelop('keys not accepeted %r' % result) #check to see if there are any valuekjdhflkjadsfaklsdhfkajsds less than 1 if not all(len(str(val).strip())>=1 for val in request.json.values()): return length_require_envelop() #clearn up the dictionary json_vals = {key : val.strip() if isinstance(val, str) else val for key, val in request.json.items()} #try to insert to database try: db_session.add(EmployeeExtra(**json_vals, employee_id=id)) db_session.commit() except IntegrityError as e: return record_exists_envelop() except Exception as e: raise e return fatal_error_envelop() else: return record_created_envelop(request.json)
def create_division(t_id): if not request.json: abort(400) if not all( len(val.strip()) >= 1 for val in request.json.values() if isinstance(val, unicode)): return length_require_envelop() _result = {'name', 'code'} - set(request.json.keys()) if _result: return keys_require_envelop('Key: %r is require' % ', '.join(_result)) request.json['display_name'] = request.json['name'].strip() request.json['name'] = request.json['name'].strip().lower() #inject the id request.json['division_type_id'] = t_id try: db_session.add(Division(**request.json)) db_session.commit() except IntegrityError: return record_exists_envelop() except Exception: return fatal_error_envelop() else: return record_created_envelop(request.json)
def create_emp_position(): if not request.json: abort(401) required_fields = set(col.name for col in EmployeePosition.__mapper__.columns) - {'id', 'emp_pos_title_display_name', 'del_flag'} extra_fields = set(request.json) - required_fields if extra_fields: return extra_keys_envelop('Unknown Keys : %s' % ', '.join(key for key in extra_fields)) _required = required_fields - set(request.json) if _required: return missing_keys_envelop('Required Keys : %s' % ', '.join(key for key in _required)) #check to see if there is any blank if not all(len(val.strip()) >= 1 for key, val in request.json.items() if isinstance(val, str)): return length_require_envelop() #inject request.json['emp_pos_title_display_name'] = request.json['emp_pos_title'] request.json['emp_pos_title'] = request.json['emp_pos_title'].lower().strip() #initiate the dession try: e_type = EmployeePosition(**request.json) db_session.add(e_type) db_session.commit() except IntegrityError as e: return record_exists_envelop() except Exception as e: return fatal_error_envelop() else: return record_created_envelop(request.json)
def create_training_by_emp(id): if not request.json: abort(400) #check if there is empty field comming up #check if there is no registration number and registration body trs = { key: val.strip() if isinstance(val, str) else val for key, val in request.json.items() } #insert ################################### #trs['start_date'] = '01-feb-2012' #trs['end_date'] = '03-feb-2005' ########################## print(id) trs['employee_id'] = id try: db_session.add(Training(**trs)) db_session.commit() except IntegrityError as e: return record_exists_envelop() except Exception as e: return fatal_error_envelop() else: return record_created_envelop(request.json)
def create_province(): if not request.json: abort(400) if not set(request.json.keys()) == {'name', 'province_code', 'region_id'}: return jsonify({'message': 'missing keys'}) #lower case the facility name display_name = request.json['name'].strip() name = request.json['name'].replace(' ', '').lower().strip() province_code = request.json['province_code'].upper().strip() region_id = request.json['region_id'] #insert into the database try: dis = Province(name=name, display_name=display_name, province_code=province_code, region_id=region_id) db_session.add(dis) db_session.commit() except IntegrityError as ie: return record_exists_envelop() except Exception as e: print(e) return fatal_error_envelop() else: return record_created_envelop(request.json)
def create_training_by_emp(id): if not request.json: abort(400) #check if there is empty field comming up if not all( len(str(val).strip()) >= 1 for key, val in request.json.items()): abort(411) #check if there is no registration number and registration body result = {'name'} - set(request.json.keys()) if result: return keys_require_envelop('key : "name" is required') #clean up the values trs = { key: val.strip() if isinstance(val, str) else val for key, val in request.json.items() } #insert ################################### trs['start_date'] = '01-feb-2012' trs['end_date'] = '03-feb-2005' ########################## print(id) trs['employee_id'] = id try: print(id) db_session.add(Training(**trs)) db_session.commit() except IntegrityError as e: return record_exists_envelop() except Exception as e: return fatal_error_envelop() else: return record_created_envelop(request.json)
def create_llg(): print('This function was called') if not set(request.json.keys()) == {'name', 'llg_code', 'district_id'}: return jsonify({'message': 'missing keys'}) if not len(request.json['name']) > 3: return jsonify({'message': 'not adequate length'}) #lower case the facility name display_name = request.json['name'].strip() name = request.json['name'].replace(' ', '').lower().strip() llg_code = request.json['llg_code'] district_id = request.json['district_id'] #insert into the database try: dis = LLG(name=name, display_name=display_name, llg_code=llg_code, district_id=district_id) db_session.add(dis) db_session.commit() except IntegrityError as ie: return record_exists_envelop() else: return record_created_envelop(request.json)
def create_district(): if not set( request.json.keys()) == {'name', 'district_code', 'province_id'}: return jsonify({'message': 'missing keys'}) #lower case the facility name display_name = request.json['name'].strip() name = request.json['name'].replace(' ', '').lower().strip() district_code = request.json['district_code'] province_id = request.json['province_id'] #insert into the database try: dis = District(name=name, display_name=display_name, district_code=district_code, province_id=province_id) db_session.add(dis) db_session.commit() except IntegrityError as ie: raise return record_exists_envelop() else: return record_created_envelop(request.json)
def create_qualification_by_emp(id): if not request.json: abort(400) #check if there is empty field comming up if not all( len(str(val).strip()) >= 1 for key, val in request.json.items()): abort(411) #clean up the values qual = { key: val.strip() if isinstance(val, str) else val for key, val in request.json.items() } #insert print(qual) qual['employee_id'] = id ####################### qual['start_date'] = '03-jan-2018' qual['end_date'] = '05-jan-2020' ############### try: print(id) db_session.add(Qualification(**qual)) db_session.commit() except IntegrityError as e: return fatal_error_envelop() except Exception as e: return fatal_error_envelop() else: return record_created_envelop(request.json)
def create_certification_by_emp(id): if not request.json: abort(400) #check if there is empty field comming up cert = { key: val.strip() if isinstance(val, str) else val for key, val in request.json.items() } #insert cert['employee_id'] = id ################################### #cert['expiry_date'] = '04-mar-2012' #cert['last_renewal_date'] = '03-mar-2017' ################################ try: db_session.add(Certification(**cert)) db_session.commit() except IntegrityError as e: return record_exists_envelop() except Exception as e: return fatal_error_envelop() else: return record_created_envelop(request.json)
def create_emp_cat_ranks(): if not request.json: abort(400) if not 'name' in request.json.keys(): abort(401) if len(request.json['name'].strip()) < 2: abort(411) #if everything is fine name = request.json['name'].replace(' ', '').lower().strip() display_name = request.json['name'].strip() #put to db try: rank = EmployeeCategoryRank(name=name, display_name=display_name) db_session.add(rank) db_session.commit() except IntegrityError as e: return record_exists_envelop() except Exception as e: return fatal_error_envelop() else: return record_created_envelop(request.json)
def create_roles(): '''This method will create a role and assign diffenet permissions''' try: role = Role(**request.json) db_session.add(role) db_session.commit() except IntegrityError as e: return record_exists_envelop() except Exception as e: return fatal_error_envelop() else: return record_created_envelop(request.json)
def create_organizer_names(): if not request.json: abort(400) try: db_session.add(OrganizerName(**request.json)) db_session.commit() except IntegrityError: return record_exists_envelop() except Exception: return fatal_error_envelop() else: return record_created_envelop(request.json)
def create_institute(): if not request.json: abort(400) try: db_session.add(Institute(**request.json)) db_session.commit() except IntegrityError: return record_exists_envelop() except Exception: return fatal_error_envelop() else: return record_created_envelop(request.json)
def create_roles(): '''This method will create a role and assign diffenet permissions''' try: json_request = dict(copy.deepcopy(request.json)) json_request['role_type_display_name'] = request.json.get('role_type') role = Role(**json_request) db_session.add(role) db_session.commit() except IntegrityError as e: return record_exists_envelop() except Exception as e: raise return fatal_error_envelop() else: return record_created_envelop(request.json)
def create_region(): if not request.json: abort(400) if 'name' in request.json: request.json['display_name'] = request.json['name'].strip() request.json['name'] = request.json['name'].lower().strip() try: dis = Region(**request.json) db_session.add(dis) db_session.commit() except IntegrityError as ie: return record_exists_envelop() else: return record_created_envelop(request.json)
def create_employee(): if not request.json: abort(400) req_fields = { 'first_name', 'last_name', 'current_sex', 'address_one', 'age', 'retirement_age', 'employee_type_id', 'employee_category_id', 'date_of_birth', 'employee_position_id', 'employement_number', 'employee_agency_id' } result = req_fields - set(request.json.keys()) #if there is some value then abort if result: return keys_require_envelop('Key required %s' % ', '.join(result)) #if everything is included, check to see if there is any empty values # if not all(len(str(val).strip()) >= 1 for key, val in request.json.items()): # abort(411) #now clean up the data to insert into database(onyl for strin) data = { key: val.strip() if isinstance(val, str) else val for key, val in request.json.items() } #for oracle #data['date_of_birth'] = '01-feb-2017' #data['date_of_commencement'] = '02-feb-2011' #now try to insert #for raocle try: emp = Employee(**data) db_session.add(emp) db_session.commit() except IntegrityError as e: return record_exists_envelop() except Exception as e: print(e) return fatal_error_envelop() else: return record_created_envelop(request.json)
def create_langauge(): if not request.json: abort(400) if not all( len(val.strip()) >= 1 for val in request.json.values() if isinstance(val, unicode)): return length_require_envelop() try: db_session.add(Language(**request.json)) db_session.commit() except IntegrityError: return record_exists_envelop() except Exception: return fatal_error_envelop() else: return record_created_envelop(request.json)
def create_emphistory_by_emp(id): if not request.json: abort(400) if not all( len(val.strip()) >= 1 for val in request.json.values() if isinstance(val, str)): abort(411) request.json['employee_id'] = id try: db_session.add(EmployementHistory(**request.json)) db_session.commit() except IntegrityError as e: return record_exists_envelop() except Exception as e: return fatal_error_envelop() else: return record_created_envelop(request.json)
def create_employee(): if not request.json: abort(400) req_fields = {'first_name', 'last_name', 'sex', 'address_one', 'age', 'retirement_age', 'employee_type_id', 'employee_category_id', 'date_of_birth', 'is_branch', 'employement_number', 'employee_branch_id'} result = req_fields - request.json.keys() #if there is some value then abort if result: abort(400) #if everything is included, check to see if there is any empty values if not all(len(str(val).strip()) >= 1 for key, val in request.json.items()): abort(411) #now clean up the data to insert into database(onyl for strin) data = {key : val.strip() if isinstance(val, str) else val for key, val in request.json.items()} #now try to insert try: emp = Employee(**data) db_session.add(emp) db_session.commit() except IntegrityError as e: return record_exists_envelop() except Exception as e: return fatal_error_envelop() else: return record_created_envelop(request.json)
def create_relative_bye_emp(id): if not request.json: abort(400) #check to see if there are any fields if not all( len(val.strip()) >= 1 for val in request.json.values() if isinstance(val, str)): abort(411) request.json['employee_id'] = id try: db_session.add(EmployeeRelative(**request.json)) db_session.commit() except IntegrityError as e: return record_exists_envelop() except Exception as e: return fatal_error_envelop() else: return record_created_envelop(request.json)
def create_emp_appraisal(id): if not request.json: abort(400) #check to see if there are any empty fields if not all(len(val.strip()) >= 1 for val in request.json.values()): abort(411) #now insert the shit down request.json['employee_id'] = id try: db_session.add(EmployeeAppraisal(**request.json)) db_session.commit() except IntegrityError: return record_exists_envelop() except Exception: #raise return fatal_error_envelop() else: return record_created_envelop(request.json)
def create_employee_educations(id): if not request.json: abort(400) # if not all(len(val.strip()) >= 1 for val in request.json.values() # if isinstance(val, unicode)): # return length_require_envelop() request.json['employee_id'] = id try: db_session.add(EmployeeEducation(**request.json)) db_session.commit() except IntegrityError: return record_exists_envelop() except Exception: return fatal_error_envelop() else: return record_created_envelop(request.json)
def create_agency(): if not request.json: abort(400) if not set(request.json.keys()) == { 'facility_name', 'facility_type_id', 'llg_id', 'district_id', 'province_id', 'region_id' }: abort(401) #try to store the branch #make sure all the fields are non-empty if any(len(str(val).strip()) == 0 for val in request.json.values()): abort(411) #clean up the json values facility_display_name = request.json['facility_name'].strip() facility_type_id = request.json['facility_type_id'] llg_id = request.json['llg_id'] district_id = request.json['district_id'] province_id = request.json['province_id'] region_id = request.json['region_id'] facility_name = facility_display_name.replace(' ', '').lower().strip() ## try: branch = Branch(facility_name=facility_name, facility_display_name=facility_display_name, is_branch=False, llg_id=llg_id, district_id=district_id, province_id=province_id, region_id=region_id, facility_type_id=facility_type_id) db_session.add(branch) db_session.commit() except IntegrityError as e: return record_exists_envelop() except Exception as e: abort(500) else: return record_created_envelop(request.json)
def create_facilities_by_facility_type(f_id): if not request.json: abort(400) #check to see if there is empty fileds if not all(len(val.strip()) >= 1 for val in request.json.values()\ if isinstance(val, str)): return length_require_envelop() #now see if if mandatory fields are not provided _required_keys = { 'district_id', 'province_id', 'region_id', 'agency_id', 'facility_name', 'facility_code' } _remaining = _required_keys - set(request.json.keys()) if _remaining: return keys_require_envelop('Missing Keys %s' % ', '.join(_remaining)) #now change facility display_name request.json['facility_display_name'] = request.json[ 'facility_name'].strip() request.json['facility_name'] = request.json['facility_name'].lower( ).strip() #now inject the facility type id request.json['facility_type_id'] = f_id #now initiate the session try: db_session.add(Facility(**request.json)) db_session.commit() except IntegrityError: return record_exists_envelop() except Exception: return fatal_error_envelop() else: return record_created_envelop(request.json)