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() 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 make_job(team_leaderid, job, work_size, collaborators, start_date, is_finished): job_el = Jobs() job_el.team_leaderid = team_leaderid job_el.job = job job_el.work_size = work_size job_el.collaborators = collaborators job_el.start_date = start_date job_el.is_finished = is_finished session.add(job_el) session.commit()
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(): 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 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 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 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 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 add_job(): 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.job.data jobs.work_size = form.work_size.data jobs.collaborators = form.collaborators.data jobs.start_date = form.start_date.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_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 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_func(team_leader, job, work_size=None, collaborators=None, start_date=None, end_date=None, is_finished=None): session = db_session.create_session() new_job = Jobs() new_job.team_leader = team_leader new_job.job = job new_job.work_size = work_size new_job.collaborators = collaborators new_job.start_date = start_date new_job.end_date = end_date new_job.is_finished = is_finished session.add(new_job) session.commit()
def add_job(): form = JobsForm() if form.validate_on_submit(): session = 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.start_date = form.start_date.data jobs.end_date = form.end_date.data jobs.is_finished = form.is_finished.data jobs.category = form.category.data current_user.jobs.append(jobs) session.merge(current_user) session.commit() return redirect("/") return render_template("jobs.html", title="Добавление работы", form=form)
def jobs_add(): form = JobForm() if form.validate_on_submit(): db_sess = db_session.create_session() jobs = Jobs() jobs.team_leader = current_user jobs.job = form.job.data jobs.work_size = float(form.work_size.data) jobs.collaborators = form.collaborators.data jobs.start_date = datetime.datetime.now() jobs.end_date = datetime.datetime.now() + datetime.timedelta(hours=float(form.work_size.data)) jobs.is_finished = form.is_finished.data current_user.jobs.append(jobs) db_sess.merge(current_user) db_sess.commit() return redirect('/jobs') return render_template('create_jobs.html', title='Создание работы', form=form)
def older_main(): db_session.global_init("mars_explorer.sqlite") session = db_session.create_session() user = User() user.surname = "Scott" user.name = 'Ridley' user.age = 21 user.position = 'captain' user.address = 'module_1' user.email = '*****@*****.**' session.add(user) user = User() user.surname = "Scott" user.name = 'Mark' user.age = 21 user.position = 'captain_helper' user.address = 'module_2' user.email = '*****@*****.**' session.add(user) user = User() user.surname = "DOCTOR" user.name = 'WHO' user.age = 1821 user.position = 'solder' user.address = 'TARDIS' user.email = '*****@*****.**' session.add(user) user = User() user.surname = "MASK" user.name = 'ILON' user.age = 31 user.position = 'sponser' user.address = 'Earth' user.email = '*****@*****.**' session.add(user) 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()
def post(self): args = parser.parse_args() session = db_session.create_session() job = Jobs(id=int(args['job_id']), team_leader=int(args['team_leader']), job=args['job'], work_size=int(args['work_size']), collaborators=args['collaborators'], is_finished=args['is_finished']) if args['start_date']: job.start_date = datetime.datetime.strptime( args['start_date'], '%d-%m-%y').date() if args['end_date']: job.end_date = datetime.datetime.strptime(args['end_date'], '%d-%m-%y').date() session.add(job) session.commit() return jsonify({'success': 'OK'})
def add_job(): form = JobsForm() if request.method == 'POST' and form.validate_on_submit(): s = db_session.create_session() job = Jobs() job.team_leader = form.team_leader.data job.user = s.query(User).filter(User.id == job.team_leader).first() 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 = current_user.id s.add(job) s.commit() return redirect('/page') return render_template('add_job.html', title='Добавление работы', form=form)
def edit_news(id): form = JobsForm() if request.method == "GET": session = db_session.create_session() job = session.query(Jobs).filter(Jobs.id == id).first() if job and (current_user.id == job.creator or current_user.id == 1): 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 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: 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 session.add(job) session.commit() return redirect('/page') else: abort(404) return render_template('edit_job.html', title='Редактирование работы', form=form)
def add_job(): form = JobForm() if form.validate_on_submit(): session = db_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.start_date = form.start_date.data job.is_finished = form.is_finished.data job.categories = list( session.query(Category).\ filter(Category.id.in_( map(str.strip, form.categories.data.split(',')) ) ) ) session.add(job) session.commit() return redirect('/') return render_template('job_form.html', title='Добавление задания', form=form)
def create_start_base(): data = [{ 'surname': "Scott", 'name': "Ridley", 'age': 21, 'position': "captain", 'speciality': "research engineer", 'address': "module_1", 'email': "*****@*****.**", 'hashed_password': "******" }, { 'surname': "Hunhau", 'name': "Nata", 'age': 27, 'position': "officer", 'speciality': "scientist", 'address': "module_2", 'email': "*****@*****.**", 'hashed_password': "******" }, { 'surname': "Zayko", 'name': "Oleg", 'age': 19, 'position': "soldier", 'speciality': "cleaner", 'address': "module_3", 'email': "*****@*****.**", 'hashed_password': "******" }, { 'surname': "Hurican", 'name': "Felix", 'age': 15, 'position': "officer", 'speciality': "pilot", 'address': "module_2", 'email': "*****@*****.**", 'hashed_password': "******" }] db_session.global_init("db/colonists.sqlite") session = db_session.create_session() for elem in data: user = User() user.surname = elem['surname'] user.name = elem['name'] user.age = elem['age'] user.position = elem['position'] user.speciality = elem['speciality'] user.address = elem['address'] user.email = elem['email'] user.hashed_password = elem['hashed_password'] session.add(user) jobs = Jobs() jobs.team_leader = 1 jobs.job = 'deployment of residential modules 1 and 2' jobs.work_size = 15 jobs.collaborators = '2, 3' jobs.start_date = datetime.datetime.now() jobs.is_finished = False session.add(jobs) jobs = Jobs() jobs.team_leader = 2 jobs.job = 'clean' jobs.work_size = 3 jobs.collaborators = '3' jobs.start_date = datetime.datetime.now() jobs.is_finished = False session.add(jobs) session.commit()
def main1(): session = db_session.create_session() captain = User() captain.surname = 'Scott' captain.name = 'Ridley' captain.age = 21 captain.position = 'captain' captain.speciality = 'research engineer' captain.address = 'module_1' captain.email = '*****@*****.**' captain.hashed_password = '******' colonist = User() colonist.surname = 'Htata' colonist.name = 'Chupakabra' colonist.age = 228 colonist.position = 'door' colonist.speciality = 'open door' colonist.address = 'door' colonist.email = '*****@*****.**' cook = User() cook.surname = 'Ramzi' cook.name = 'Gordon' cook.age = 2 cook.position = 'room cook' cook.speciality = 'covid cook' cook.address = 'cook home' cook.email = '*****@*****.**' pirat = User() pirat.surname = 'Vorobushek' pirat.name = 'Jack' pirat.age = 19 pirat.position = 'pirat' pirat.speciality = 'thief' pirat.address = 'None' pirat.email = '*****@*****.**' 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) job = Jobs() job.team_leader = 2 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) job = Jobs() job.team_leader = 3 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.add(captain) session.add(colonist) session.add(cook) session.add(pirat) session.commit() news = News(title="Первая новость", content="Привет блог!", user_id=2, is_private=False) session.add(news) session.commit() user = session.query(User).filter(User.id == 1).first() news = News(title="Вторая новость", content="Уже вторая запись!", user=user, is_private=False) session.add(news) session.commit() app.run()
doctor.email = "*****@*****.**" lead_research = User() lead_research.surname = "Wright" lead_research.name = "Apollo" lead_research.age = 21 lead_research.position = "scientist" lead_research.speciality = "lead researcher" lead_research.address = "module_4" lead_research.email = "*****@*****.**" job = Jobs() job.team_leader = 1 job.job = "deployment of residental modules 1 and 2" job.work_size = 15 job.collaborators = "2, 3" job.start_date = datetime.datetime.now() job.is_finished = False db_sess = db_session.create_session() db_sess.add(captain) db_sess.add(colonist) db_sess.add(doctor) db_sess.add(lead_research) db_sess.add(job) db_sess.commit() main()
self.assertEqual({"success": "OK"}, resp.json()) if __name__ == "__main__": db_session.global_init("db/test_database.db") job_1 = Jobs() job_1.id = 1 job_1.team_leader = 2 job_1 = "Repair broken TV" job_1.work_size = 1 job_1.collaborators = "1,2,3" job_1.start_date = datetime.datetime.now() job_1.end_date = datetime.datetime.now() + datetime.timedelta(1, 2, 3) job_1.is_finished = False job_2 = Jobs() job_1.id = 2 job_1.team_leader = 1 job_1 = "Repair broken spaceship" job_1.work_size = 5 job_1.collaborators = "2,3,4" job_1.start_date = datetime.datetime.now() job_1.end_date = datetime.datetime.now() + datetime.timedelta(1, 2, 3) job_1.is_finished = True
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()
def main(): db_session.global_init("db/astro.db") capitan = User() capitan.surname = "Scott" capitan.name = "Ridley" capitan.age = 21 capitan.position = "captain" capitan.speciality = "research engineer" capitan.address = "module_1" capitan.email = "*****@*****.**" capitan.set_password('password') capitan.city_from = 'Berlin' colon1 = User() colon1.surname = "Weir" colon1.name = "Andy" colon1.age = 18 colon1.position = "common" colon1.speciality = "worker" colon1.address = "module_1" colon1.email = "*****@*****.**" colon1.city_from = 'New York' colon2 = User() colon2.surname = "Sanders" colon2.name = "Teddy" colon2.age = 19 colon2.position = "common" colon2.speciality = "worker" colon2.address = "module_2" colon2.email = "*****@*****.**" colon2.city_from = 'Paris' category1 = Category() category1.name = '1' category2 = Category() category2.name = '2' category3 = Category() category3.name = '3' 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 = datetime.datetime.now() job1.is_finished = False job1.categories.append(category1) job2 = Jobs() job2.team_leader = 2 job2.job = "Exploration of mineral resourses" job2.work_size = 15 job2.collaborators = "4, 3" job2.start_date = datetime.datetime.now() job2.is_finished = False job2.categories.append(category2) job3 = Jobs() job3.team_leader = 3 job3.job = "Development of management system" job3.work_size = 25 job3.collaborators = "5" job3.start_date = datetime.datetime.now() job3.is_finished = True job3.categories.append(category3) department1 = Department() department1.title = 'Department of geological exploration' department1.chief = 2 department1.members = '1, 2, 3' department1.email = '*****@*****.**' department2 = Department() department2.title = 'Department of biological research' department2.chief = 3 department2.members = '2, 3' department2.email = '*****@*****.**' department3 = Department() department3.title = 'Department of construction' department3.chief = 1 department3.members = '1, 3' department3.email = '*****@*****.**' db_sess = db_session.create_session() db_sess.add(capitan) db_sess.add(colon1) db_sess.add(colon2) db_sess.add(job1) db_sess.add(job2) db_sess.add(job3) db_sess.add(department1) db_sess.add(department2) db_sess.add(department3) db_sess.add(category1) db_sess.add(category2) db_sess.add(category3) db_sess.commit()