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 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_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 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():
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_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_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 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 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 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 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 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)
