def add_work(): form = AddWorkForm() if request.method == 'POST': session = db_session.create_session() data = form.end_date.data date = datetime.datetime.strptime(data, "%Y-%m-%d %H:%M:%S") job = Jobs() job.team_leader = form.team_leader.data job.job = form.job.data job.work_size = form.work_size.data job.collaborators = form.collaborators.data job.end_date = date job.is_finished = form.is_finished.data session.add(job) session.commit() return redirect('/works', code=302) return render_template('add_work.html', title='Adding work', form=form, warnings=[], data=[''] * 6)
def add_job(): form = Add_Job() if form.validate_on_submit(): session = db_session.create_session() job = Jobs() a = [user.id for user in session.query(User)] if form.team_leader.data not in a: return render_template( 'add_job.html', message="Такого пользователя не сущестсвует", form=form) job.team_leader = form.team_leader.data job.job = form.job.data job.work_size = form.work_size.data job.collaborators = form.collaborators.data if form.start_date.data: job.start_date = datetime.strptime(form.start_date.data, '%d.%m.%Y').date() if form.end_date.data: job.end_date = datetime.strptime(form.end_date.data, '%d.%m.%Y').date() job.is_finished = form.is_finished.data session.add(job) session.commit() return redirect('/') return render_template('add_job.html', title='Добавление работы', form=form)
def add_job(): form = JobForm() if form.validate_on_submit(): session = db_session.create_session() job = Jobs() job.job = form.title.data job.team_leader = form.leader_id.data job.work_size = form.work_size.data job.collaborators = form.collaborators.data job.is_finished = form.is_finished.data job.creator = current_user.id category_id = form.category.data category = session.query(CategoryJob).filter( CategoryJob.id == category_id).first() job.categories.append(category) session.commit() try: current_user.jobs.append(job) except sqlalchemy.orm.exc.DetachedInstanceError: pass except sqlalchemy.exc.InvalidRequestError: pass session.merge(current_user) session.commit() return redirect('/') return render_template('add_job.html', title='Adding a job', form=form)
def new_job(): form = JobForm() if form.validate_on_submit(): session = db_session.create_session() job = Jobs() job.job = form.title.data job.team_leader = form.leader_id.data job.work_size = form.work_size.data job.collaborators = form.collaborators.data job.is_finished = form.is_finished.data job.creator = current_user.id category_id = form.category.data category = session.query(CategoryJob).filter( CategoryJob.id == category_id).first() job.categories.append(category) session.commit() try: current_user.jobs.append(job) except: pass session.merge(current_user) session.commit() return redirect('/') return render_template('new_job.html', title='New job', form=form)
def create_job(): if not request.json: return jsonify({'error': 'Empty request'}) elif not all(key in request.json for key in [ 'id', 'job', 'team_leader_id', 'work_size', 'collaborators', 'categories_id', 'is_finished' ]): return jsonify({'error': 'Bad request'}) session = db_session.create_session() if session.query(Jobs).filter(Jobs.id == request.json['id']).first(): return jsonify({'error': 'Id already exists'}) job = Jobs() job.job = request.json['job'] job.id = request.json['id'] job.team_leader_id = request.json['team_leader_id'] job.work_size = request.json['work_size'] job.collaborators = request.json['collaborators'] job.is_finished = request.json['is_finished'] job.team_leader = session.query(User).filter( User.id == request.json['team_leader_id']).first() job.categories_id = request.json['categories_id'] session.add(job) session.commit() for i in request.json['categories_id'].split(', '): job.categories.append( session.query(Category).filter(Category.id == int(i)).first()) session.commit() return jsonify({'success': 'OK'})
def add_job(): db_sess = db_session.create_session() form = AddJobForm() categories = {'': 0} for i in db_sess.query(Category).all(): categories[i.name] = i.id form.categories.choices = [i for i in categories.keys()] if form.validate_on_submit(): db_sess = db_session.create_session() job = Jobs() job.job = form.job.data job.work_size = form.work_size.data job.collaborators = form.collaborators.data job.team_leader = form.team_leader.data job.is_finished = form.is_finished.data category = categories[form.categories.data] if category: category = db_sess.query(Category).filter( Category.id == category).first() job.categories.append(category) db_sess.add(job) db_sess.commit() return redirect("/get_jobs") return render_template('add_job_form.html', title='Добавление работы', form=form)
def add_job(): form = JobForm() if form.validate_on_submit(): session = db_session.create_session() if str(current_user.id) == str(form.team_leader.data): job = Jobs() job.job = form.job.data job.team_leader = form.team_leader.data job.work_size = form.work_size.data job.collaborators = form.collaborators.data job.is_finished = form.is_finished.data job.start_date = datetime.datetime.now() job.end_date = datetime.datetime.now() job.categories.append(Category(name=form.categories.data)) print(job.categories, job.categories[0].name) session.add(job) session.commit() return redirect("/") return render_template('add_job.html', message="нет доступа", form=form, name='Добавление') return render_template('add_job.html', title='Добавление работы', form=form, text='Наше приложение', name='Добавление')
def add_work(team_leader, jobe, work_size, collaborators, is_finished): db_sess = db_session.create_session() job = Jobs() job.team_leader = team_leader job.job = jobe job.work_size = work_size job.collaborators = collaborators job.is_finished = is_finished db_sess.add(job) db_sess.commit()
def main(): db_session.global_init("db/mars_explorer.db") job = Jobs() job.team_leader = 1 job.job = 'deployment of residential modules 1 and 2' job.work_size = 15 job.collaborators = '2, 3' job.is_finished = False db_sess = db_session.create_session() db_sess.add(job) db_sess.commit()
def main(): db_session.global_init("db/mars_explorer.sqlite") session = db_session.create_session() job = Jobs() job.team_leader = 1 job.job = 'deployment of residential modules 1 and 2' job.work_size = 15 job.is_finished = False session.add(job) session.commit() app.run()
def main(): db_session.global_init("db/blogs.db") session = db_session.create_session() user = User() user.surname = 'Scott' user.name = 'Ridley' user.age = '21' user.position = 'captain' user.speciality = 'research engineer' user.address = 'module_1' user.email = '*****@*****.**' col1 = User() col1.surname = 'Derkach' col1.name = 'Dima' col1.age = '23' col1.position = 'polomoishik' col1.speciality = 'research engineer' col1.address = 'module_1' col1.email = '*****@*****.**' col2 = User() col2.surname = 'Kaha' col2.name = 'Sergo' col2.age = '26' col2.position = 'polomoishik' col2.speciality = 'research engineer' col2.address = 'module_1' col2.email = '*****@*****.**' col3 = User() col3.surname = 'Alex' col3.name = 'Boiko' col3.age = '21' col3.position = 'pilot' col3.speciality = 'research engineer' col3.address = 'module_1' col3.email = '*****@*****.**' job1 = Jobs() job1.team_leader = 1 job1.job = 'deployment of residential modules 1 and 2' job1.work_size = 15 job1.collaborators = '2, 3' session.add(user) session.add(col1) session.add(col2) session.add(col3) session.add(job1) session.commit() app.run(port=8080, host='127.0.0.1')
def main(): session = db_session.create_session() job = Jobs() job.team_leader = 1 job.job = 'deployment of residential modules 1 and 2' job.work_size = 15 job.collaborators = '2, 3' job.start_date = datetime.datetime.now() job.is_finished = False session.add(job) session.commit() app.run()
def add_job(tl, jobs, ws, collab, st, isfin): job = Jobs() job.team_leader = tl job.job = jobs job.work_size = ws job.collaborators = collab if st != "now": job.start_date = st job.is_finished = isfin db_sess = db_session.create_session() db_sess.add(job) db_sess.commit()
def main(): db_session.global_init("db/mars_explorer.sqlite") session = db_session.create_session() job = Jobs() job.team_leader = 1 job.job = 'deployment of residential modules 1 and 2' job.work_size = 15 job.collaborators = '2, 3' job.is_finished = False session.add(job) job = Jobs() job.team_leader = 2 job.job = 'exploration of mineral resources' job.work_size = 15 job.collaborators = '4, 3, 6' job.is_finished = True session.add(job) job = Jobs() job.team_leader = 3 job.job = 'development of a management system' job.work_size = 25 job.collaborators = '5' job.is_finished = False session.add(job) job = Jobs() job.team_leader = 4 job.job = 'analysis of atmospheric air samples' job.work_size = 15 job.collaborators = '4, 5' job.is_finished = False session.add(job) job = Jobs() job.team_leader = 5 job.job = 'Mars Rover maintenance' job.work_size = 5 job.collaborators = '4' job.is_finished = True session.add(job) job = Jobs() job.team_leader = 7 job.job = 'preventive vaccinations of the crew' job.work_size = 7 job.collaborators = '3' job.is_finished = False session.add(job) session.commit()
def main(): db_session.global_init("db/mars.db") # db_session.global_init(name) db_sess = db_session.create_session() job = Jobs() job.team_leader = 1 job.job = 'make cake' job.work_size = 2 job.collaborators = '2, 4' job.is_finished = False db_sess.add(job) db_sess.commit()
def main(): db_session.global_init("db/blogs.db") db_sess = db_session.create_session() app.register_blueprint(news_api.blueprint) app.register_blueprint(jobs_api.blueprint) news = News(title="Первая новость", content="Привет блог!", user_id=1, is_private=False) db_sess.add(news) db_sess.commit() jobs = Jobs() jobs.team_leader = 1 jobs.job = 'deployment of residential modules 1 and 2' jobs.work_size = 15 jobs.collaborators = '2, 3' jobs.is_finished = False db_sess.add(jobs) db_sess.commit() jobs = Jobs() jobs.team_leader = 2 jobs.job = 'deployment of residential modules 1 and 2aaa' jobs.work_size = 153 jobs.collaborators = '2' jobs.is_finished = False db_sess.add(jobs) db_sess.commit() user = User() user.name = "Пользователь 1" user.about = "биография пользователя 1" user.email = "*****@*****.**" db_sess.add(user) db_sess.commit() port = int(os.environ.get("PORT", 5000)) app.run(host='0.0.0.0', port=port)
def add_jobs(): users_id = list(map(lambda x: x.id, db_sess.query(User))) for i in range(22, 25): job = Jobs() job.team_leader = choice(users_id) job.job = f"test_work{i}" job.work_size = randint(5, 16) tmp = choice(users_id) while tmp == job.team_leader: tmp = choice(users_id) job.collaborators = f'{job.team_leader}, {tmp}' job.is_finished = choice([False, True]) db_sess.add(job)
def add_news(): form = JobsForm() if form.validate_on_submit(): db_sess = db_session.create_session() job = Jobs() job.job = form.job.data job.team_leader = form.team_leader.data job.work_size = form.work_size.data job.collaborators = form.collaborators.data job.is_finished = form.is_finished.data db_sess.add(job) db_sess.commit() return redirect('/') return render_template('jobs.html', title='Добавление работы', form=form)
def addjob(): form = JobForm() if form.validate_on_submit(): db_sess = db_session.create_session() job = Jobs() job.job = form.title.data job.team_leader = int(form.id.data) job.work_size = int(form.size.data) job.collaborators = form.collaborators.data job.is_finished = form.is_finished.data db_sess.add(job) db_sess.commit() return redirect('/') return render_template('jobs.html', form=form)
def main(): db_session.global_init("db/blogs.sqlite") captain = User() captain.surname = 'Scott' captain.name = 'Ridley' captain.age = 21 captain.position = 'captain' captain.speciality = 'research engineer' captain.address = 'module_1' captain.email = '*****@*****.**' user1 = User() user1.surname = 'Max' user1.name = 'Riddel' user1.age = 47 user1.position = 'ex-captain' user1.speciality = 'physic engineer' user1.address = 'module_7' user1.email = '*****@*****.**' user2 = User() user2.surname = 'Scaut' user2.name = 'Cherly' user2.age = 31 user2.position = 'high enginer' user2.speciality = 'theory engineer' user2.address = 'module_4' user2.email = '*****@*****.**' user3 = User() user3.surname = 'Presnyakov' user3.name = 'Nikita' user3.age = 28 user3.position = 'mechanic' user3.speciality = 'mechanic' user3.address = 'module_2' user3.email = '*****@*****.**' job1 = Jobs() job1.team_leader = 1 job1.job = 'deployment of residential modules 1 and 2' job1.work_size = 15 job1.collaborators = '2, 3' job1.start_date = '(now)' job1.is_finished = False session = db_session.create_session() session.add(captain) session.add(user1) session.add(user2) session.add(user3) session.add(job1) session.commit() app.run()
def jobs(): form = JobsForm() if form.validate_on_submit(): db_sess = db_session.create_session() jobs = Jobs() jobs.team_leader = form.team_leader.data jobs.job = form.jobs.data jobs.work_size = form.work_size.data jobs.collaborators = form.collaborators.data jobs.is_finished = form.is_finished.data current_user.jobs.append(jobs) db_sess.merge(current_user) db_sess.commit() return redirect('/') return render_template('jobs.html', title='Добавление работы', form=form)
def add_news(): form = JobsForm() if form.validate_on_submit(): session = create_session() job = Jobs() job.team_leader = form.team_leader.data job.job = form.job.data job.work_size = form.work_size.data job.collaborators = form.collaborators.data job.is_finished = form.is_finished.data session.add(job) session.commit() return redirect('/') return render_template('jobs.html', title='Adding a job', form=form)
def main(): db_session.global_init('db/mars_explorer.db') ex_job = Jobs() ex_job.team_leader = 1 ex_job.job = 'deployment of residential modules 1' ex_job.work_size = 15 ex_job.collaborators = 2 ex_job.start_date = datetime.date.today() ex_job.is_finished = False db_sess = db_session.create_session() db_sess.add(ex_job) db_sess.commit() ex_job = Jobs() ex_job.team_leader = 1 ex_job.job = 'deployment of residential modules 2' ex_job.work_size = 20 ex_job.collaborators = 3 ex_job.start_date = datetime.date.today() ex_job.is_finished = False db_sess = db_session.create_session() db_sess.add(ex_job) db_sess.commit()
def add_job(): form = AddJobForm() if form.validate_on_submit(): db_sess = db_session.create_session() jobs = Jobs() jobs.team_leader = form.team_leader.data jobs.job = form.job.data jobs.work_size = form.work_size.data jobs.collaborators = form.collaborators.data jobs.is_finished = form.is_finished.data current_user.jobs.append(jobs) db_sess.merge(current_user) db_sess.commit() return redirect("/") return render_template("job.html", title="Добавление работы", form=form)
def edit_job(id): form = JobsForm() if request.method == "GET": session = db_session.create_session() job = session.query(Jobs).filter(Jobs.id == id).first() if job: form.job.data = job.job form.team_leader.data = job.team_leader form.work_size.data = job.work_size form.collaborators.data = job.collaborators form.start_date.data = job.start_date form.end_date.data = job.end_date form.is_finished.data = job.is_finished cats = "" for i in job.categories: cats += str(i.id) + "," form.categories.data = cats[:-1] else: abort(404) if form.validate_on_submit(): session = db_session.create_session() job = session.query(Jobs).filter(Jobs.id == id, ((Jobs.creator == current_user.id) | (current_user.id == 1))).first() if job: creatorr = job.creator session.delete(job) job = Jobs() job.team_leader = form.team_leader.data job.job = form.job.data job.work_size = form.work_size.data job.collaborators = form.collaborators.data job.start_date = form.start_date.data job.end_date = form.end_date.data job.is_finished = form.is_finished.data job.creator = creatorr for i in job.categories: job.categories.remove(HazardCategory(name=i.name)) categories = HazardCategory(name=form.categories.data) job.categories.append(categories) session.add(job) session.commit() return redirect('/page') else: abort(404) return render_template('edit_job.html', title='Редактирование работы', form=form)
def add_jobs(): form = JobsForm() if form.validate_on_submit(): session = db_session.create_session() job = Jobs() job.job = form.job.data job.team_leader = form.team_leader.data job.work_size = form.work_size.data job.collaborators = form.collaborators.data job.is_finished = form.is_finished.data # current_user.jobs.append(job) # session.merge(current_user) session.add(job) session.commit() return redirect('/jobs') return render_template('jobs.html', title='Добавление работы', form=form)
def add_jobs(): form = JobsForm() if form.validate_on_submit(): session = db_session.create_session() jobs = Jobs() jobs.job = form.title.data jobs.team_leader = form.team_leader.data jobs.work_size = form.work_size.data jobs.collaborators = form.collaborators.data jobs.is_finished = form.is_finished.data jobs.hazard_category = form.hazard_category.data current_user.jobs.append(jobs) session.merge(current_user) session.commit() return redirect('/') return render_template('job.html', title='Add job', form=form)
def adding_job(): form = AddingJobForm() if form.validate_on_submit(): db_session.global_init("db/mars.db") db_sess = db_session.create_session() job = Jobs() job.job = form.job.data job.team_leader = form.team_leader_id.data job.work_size = form.work_size.data job.collaborators = form.collaborators.data job.start_date = datetime.now() job.is_finished = form.is_job_finished.data db_sess.add(job) db_sess.commit() return redirect("/") return render_template('add_job.html', form=form)
def g(): db_session.global_init(f"db/main_data_base.db") user = Jobs() user.team_leader = 1 user.job = "deployment of residential modules 1 and 2" user.work_size = 15 user.collaborators = '2, 3' user.start_date = datetime.datetime.now() user.is_finished = False connect = db_session.create_session() connect.add(user) connect.commit() connect = db_session.create_session() listt = [] for user in connect.query(Jobs): listt.append(user) return render_template('jobs.html', listt=listt)
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)