def add_job(): form = JobsForm() if form.validate_on_submit(): session = create_session() job = Jobs() job.customer = current_user.id job.title = form.title.data job.cost = form.cost.data job.description = form.description.data job.brief = ''.join(form.description.data[:30] + '...') job.category = form.category.data job.category_2 = form.category_2.data UPLOAD_DIR: Path = Path(__file__).parent / 'static/jobs_img' UPLOAD_DIR.mkdir(parents=True, exist_ok=True) for upload in request.files.getlist('images'): filename = secure_filename(upload.filename) if filename != '': save_path = str(UPLOAD_DIR / filename) upload.save(save_path) job.img = '\\static' + save_path.split("\\static")[1] session.add(job) session.merge(current_user) session.commit() return redirect('/') return render_template('job_add.html', title='Adding a job', form=form)
def add_job(): form = JobsForm() session = db_session.create_session() jobs = Jobs() if form.validate_on_submit(): jobs.description = form.description.data jobs.employer = current_user jobs.address = form.address.data jobs.date = form.date.data jobs.info = form.info.data address = form.address.data geocoder_api_server = "http://geocode-maps.yandex.ru/1.x/" geocoder_params = { "apikey": "40d1649f-0493-4b70-98ba-98533de7710b", "geocode": address, "format": "json" } response = requests.get(geocoder_api_server, params=geocoder_params) if response: json_response = response.json() toponym = json_response["response"]["GeoObjectCollection"][ "featureMember"][0]["GeoObject"] jobs.coords = toponym["Point"]["pos"] user = session.query(User).filter(User.id == current_user.id).first() user.job.append(jobs) session.merge(user) session.commit() return redirect('/myjobs') return render_template('jobs.html', title='Добавление обращения', form=form)
def add_job(): form = JobForm() if form.validate_on_submit(): db_sess = db_session.create_session() job = Jobs() job.description = form.description.data job.work_size = form.work_size.data job.collaborators = form.collaborators.data job.team_leader = form.team_leader.data job.start_date = datetime.datetime.strptime(form.start_date.data, "%d/%m/%Y %H:%M") job.end_date = datetime.datetime.strptime(form.end_date.data, "%d/%m/%Y %H:%M") job.is_finished = form.is_finished.data db_sess.add(job) db_sess.commit() return redirect('/index') return render_template('addjob.html', form=form)
def createData(): session = db_session.create_session() if session.query(Jobs).count() > 0: return user = User() leader1 = user user.surname = "Scott" user.name = "Ridley" user.position = "captain" user.speciality = "research engineer" user.address = "module_1" user.email = "*****@*****.**" session.add(user) user = User() leader2 = user user.surname = "Weir" user.name = "Andy" user.position = "helper of captain" user.speciality = "engineer" user.address = "module_2" user.email = "*****@*****.**" session.add(user) user = User() user.surname = "Wotny" user.name = "Mark" user.position = "member" user.speciality = "board engineer" user.address = "module_3" user.email = "*****@*****.**" session.add(user) user = User() leader3 = user user.surname = "Sanders" user.name = "Teddy" user.position = "member" user.speciality = "explorer" user.address = "module_3" user.email = "*****@*****.**" session.add(user) # session.commit() job = Jobs() job.team_leader = leader1 job.description = 'deployment of residential modules 1 and 2' job.start_date = datetime.datetime(2012, 3, 3, 10, 10, 10) job.work_size = 15 job.collaborators = "2, 3" job.is_finished = False session.add(job) job = Jobs() job.team_leader = leader2 job.description = 'Exploration of mineral resources' job.start_date = datetime.datetime(2012, 3, 3, 10, 10, 10) job.work_size = 15 job.collaborators = "4, 3" job.is_finished = False session.add(job) job = Jobs() job.team_leader = leader3 job.description = 'Development of a management system' job.start_date = datetime.datetime(2012, 3, 3, 10, 10, 10) job.work_size = 25 job.collaborators = "5" job.is_finished = False session.add(job) session.commit()