def newEmployee(company_id): if 'username' not in login_session: return redirect('/login') company = session.query(Company).filter_by(id=company_id).one() session.commit() if login_session['user_id'] != company.user_id: return "<script>function myFunction() {alert('You are not authorized \ to add Employee to this Company. Please create your own Company in \ order to add Employee.');}</script><body onload='myFunction()'>" if request.method == 'POST': file = request.files['image'] if os.path.exists("static/" + file.filename): return "File already exist rename the file/select another image!" else: f = os.path.join(app.config['UPLOAD_FOLDER'], file.filename) # add your custom code to check that the uploaded file is a valid \ # image and not a malicious file (out-of-scope for this post) file.save(f) company = session.query(Company).filter_by(id=company_id).one() newEmployee = Employee(name=request.form['name'], dob=request.form['dob'], email=request.form['email'], contact=request.form['mob'], address=request.form['address'], picture="/static/" + file.filename, company_id=company_id, user_id=company.user_id) print newEmployee session.add(newEmployee) session.commit() flash('New Employee %s Successfully Added' % (newEmployee.name)) return redirect(url_for('showEmployee', company_id=company_id)) else: return render_template('newemployee.html', company=company)
def create_employee(): employee = Employee(project_id=request.get_json().get('project_id'), name=request.get_json().get('name'), title=request.get_json().get('title'), phone=request.get_json().get('phone'), seat=request.get_json().get('seat')) employee_repository.create_employee(employee) resp = jsonify(success=True) resp.status_code = 200 return resp
def edit_employee(): employee = Employee(id=request.get_json().get('id'), project_id=request.get_json().get('project_id'), name=request.get_json().get('name'), title=request.get_json().get('title'), phone=request.get_json().get('phone'), seat=request.get_json().get('seat')) edited_employee = employee_repository.edit_employee(employee) return make_response( jsonify({'id': edited_employee.id, 'project_id': edited_employee.project_id, 'name': edited_employee.name, 'title': edited_employee.title, 'phone': edited_employee.phone, 'seat': edited_employee.seat}), 200)
def newEmployee(): if 'name' not in login_session: return redirect(url_for('showLogin')) if request.method == 'GET': return render_template('newemployee.html') name = request.form['name'] email = request.form['email'] mobile = request.form['mobile'] date = getDate(request.form['date']) employee = Employee(name=name, email=email, mobile_number=mobile, hire_date=date) session.add(employee) session.commit() flash('New Employee %s is added' % name) return redirect(url_for('mainPage'))
def importRow(row): employeeId = session.query(Employee.p_id).\ filter(Employee.name == row[2]).scalar() if (employeeId is None): newEmployee = Employee(name=row[2], address=row[3]) session.add(newEmployee) session.commit() employeeId = session.query(Employee.p_id).\ filter(Employee.name == row[2]).scalar() newExpense = Expense(date=row[0], category=row[1], employee=employeeId, description=row[4], pre_tax=row[5].replace(',', ''), tax_name=row[6], tax_amount=row[7].replace(',', '')) session.add(newExpense) session.commit()
def addCashier(): if request.method == 'POST': if not request.form['eid']: flash('Please enter employee id') return redirect(url_for('addCashier')) if not request.form['fname']: flash('Please enter first name') return redirect(url_for('addCashier')) if not request.form['lname']: flash('Please enter last name') return redirect(url_for('addCashier')) if not request.form['stsid']: flash('Please enter status id') return redirect(url_for('addCashier')) if not request.form['salary']: flash('Please enter salary') return redirect(url_for('addCashier')) # Add new item cashier = Employee(eid=request.form['eid'], etid='ET2', fname=request.form['fname'], lname=request.form['lname'], stsid=request.form['stsid'], salary=request.form['salary']) session.add(cashier) user = Cashier(username=request.form['username'], password=request.form['password']) session.add(user) session.commit() return redirect(url_for('showCashiers')) else: # Get all categories return render_template('addCashier.html')
def create_new_emp(): if 'username' not in login_session: return redirect('/login') all_dept = get_all_dept() if request.method == 'POST': newemp = Employee(name=request.form['name'], designation=request.form['designation'], salary=request.form['salary'], dept_id=get_dept_id(request.form['department']), archival_flag='N', desk_ph=request.form['desk_ph'], emp_email=request.form['emp_email'], city_state=request.form['city_state'], reporting_manager=request.form['reporting_manager'], user_id=login_session['user_id']) session.add(newemp) session.commit() flash('New Employee %s Successfully Created' % newemp.name) return redirect(url_for('employee_catalog')) else: return render_template('newEmpRec.html', all_dept=all_dept)
DBSession = sessionmaker(bind=engine) # A DBSession() instance establishes all conversations with the database # and represents a "staging zone" for all the objects loaded into the # database session object. Any change made against the objects in the # session won't be persisted into the database until you call # session.commit(). If you're not happy about the changes, you can # revert all of them back to the last commit by calling # session.rollback() session = DBSession() new_emp1 = Employee(name='Carson Wentz', designation='11 - Quarterback', salary='10,000,000', archival_flag='N', dept_id='10', start_date=func.now(), desk_ph='428-789-1256', emp_email='*****@*****.**', city_state='Phildadelphia/PA', reporting_manager='Doug Pederson', user_id=1) session.add(new_emp1) session.commit() new_emp2 = Employee(name='Nick Foles', designation='12 - Quarterback', salary='10,000,000', archival_flag='N', dept_id='10', start_date=func.now(),
session.add(foodit51) #change..................... session.add(foodit52) #change..................... session.add(foodit53) #change..................... session.add(foodit54) #change..................... session.add(foodit55) #change..................... session.add(foodit56) #change..................... session.add(foodit57) #change..................... session.add(foodit58) #change..................... session.add(foodit59) #change..................... session.add(foodit60) #change..................... etype1 = EmployeeType(etid='ET1', name='ADMIN', description='ADMIN') etype2 = EmployeeType(etid='ET2', name='CASHIER', description='CASHIER') session.add(etype1) session.add(etype2) employee1 = Employee(eid='E1', etid='ET2', fname='Sultan', lname='Lubbad', stsid='S1', salary=1000.5) session.add(employee1) user1 = Admin(username="******", password="******") user2 = Cashier(username="******", password="******") session.add(user1) session.add(user2) session.commit()
'''Creates an Employee with an Address''' # Imports from sqlalchemy import create_engine from sqlalchemy.orm import sessionmaker from database_setup import Base, Employee, Address engine = create_engine('sqlite:///employees.db') Base.metadata.bind = engine DBSession = sessionmaker(bind = engine) session = DBSession() # Create Employee rebeccaEmployee = Employee(name = "Rebecca Allen") session.add(rebeccaEmployee) session.commit() # Create Employee rebeccaAddress = Address(street = "512 Sycamore Road", zip = "02001", employee = rebeccaEmployee) session.add(rebeccaAddress) session.commit() # Read employees = session.query(Employee).all() for employee in employees: print(employee.name) # Update rebecca = session.query(Employee).filter_by(name = "Rebecca Allen").one() address = session.query(Address).filter_by(employee_id = rebecca.id).one()
company1 = Company(user_id=1, name="Mahindra Motors",\ picture="/static/Mahindra-logo.png") session.add(company1) session.commit() company2 = Company(user_id=1, name="Sweetlime ventures", \ picture="/static/sweetlime.png") session.add(company2) session.commit() employee1 = Employee(user_id=1, name="Mandar Waghe", \ dob="17/12/1994",\ email="*****@*****.**", \ contact="8007528271", address="Thane",\ picture="/static/mandar1.jpg"\ ,company=company1) session.add(employee1) session.commit() employee2 = Employee(user_id=1, name="Vijay Nath", dob="02/02/1994",\ email="*****@*****.**", contact="9856432312", \ address="Thane",\ picture="/static/blank_user.gif"\ ,company=company1) session.add(employee2) session.commit()
from sqlalchemy import create_engine from sqlalchemy.orm import sessionmaker from database_setup import Address, Base, Employee from faker import Faker fake = Faker() engine = create_engine('sqlite:///empData.db') Base.metadata.bind = engine DBSession = sessionmaker(bind=engine) session = DBSession() emp2 = Employee(name='Pavan') session.add(emp2) session.commit() emp2Addr = Address(street='2', zip='50002', employee=emp2) session.add(emp2Addr) session.commit() emp3 = Employee(name='Hruday') session.add(emp3) session.commit() emp3Addr = Address(street='3', zip='50003', employee=emp3) session.add(emp3Addr) session.commit() emp4 = Employee(name='Virat') session.add(emp4) session.commit() emp4Addr = Address(street='4', zip='50004', employee=emp4) session.add(emp4Addr) session.commit() emp5 = Employee(name='Rohit') session.add(emp5) session.commit() emp5Addr = Address(street='5', zip='50005', employee=emp5)