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