def createApplication():
""" User creation """
try:
if "username" in session:
if request.method == 'POST':
myApp=Application(
systemname=request.form["inputSystemName"],
systemdescription=request.form["inputSystemDescription"],
systemtechnology=request.form["inputSystemTechnology"],
systemprovider=request.form["inputSystemProvider"],
systemowner=request.form["inputSystemOwner"],
systemstatus=request.form["inputSystemStatus"],
systemurl=request.form["inputSystemUrl"],
systemcategory=request.form["inputSystemCat"]
)
myApp.save()
flash('Application saved !!! ', 'message')
return redirect(url_for('listeApplication'))
if request.method == 'GET':
return render_template('createapplication.html')
else:
flash('Unknown user !!! ','error')
return render_template('login.html')
except:
return redirect(url_for('appError'))
def register_application():
application_form = ApplicationForm(meta={'csrf': False})
if application_form.validate_on_submit():
car_brand = request.form['car_brand']
car_model = request.form['car_model']
name = request.form['name']
last_name = request.form['last_name']
email = request.form['email']
tel = request.form['tel']
try:
application = Application(name=name, last_name=last_name, email=email, tel=tel, car_brand_id=car_brand,
car_model_id=car_model)
db.session.add(application)
db.session.commit()
# !!!
# Uncomment it if you want to use Mail
# !!!
# track_number = application.unique_track_number
# send_application_registered_msg(name, email, track_number)
return jsonify({'success': 'Ваша заявка была успешно подана!'})
except Exception as e:
return jsonify({'errors': f'Что-то пошло не так, попробуйте снова! {e}'})
return jsonify({'errors': application_form.errors})
def add_application_by_vacancy_id(payload, vacancy_id):
# try:
vacancy = Vacancy.query.filter(Vacancy.id == vacancy_id).one_or_none()
if vacancy is None:
abort(404)
body = request.get_json()
new_company_id = body.get('company_id')
new_vacancy_id = vacancy_id
new_candidate_id = body.get('candidate_id')
new_cover_leter = body.get('cover_letter', None)
new_date_submitted = datetime.now()
# Check if multiple applications are submitted
duplicate = Application.query.filter(
Application.candidate_id == new_candidate_id,
Application.vacancy_id == new_vacancy_id).one_or_none()
if duplicate is not None:
abort(406)
application = Application(company_id=new_company_id,
vacancy_id=new_vacancy_id,
candidate_id=new_candidate_id,
cover_letter=new_cover_leter,
date_submitted=new_date_submitted)
application.insert()
return jsonify({'success': True})
def setUp(self):
"""
It creates the model objects and saves then in the database
"""
super(RankingTests, self).setUp()
self.execution = Execution()
self.execution.slurm_sbatch_id = 2333
execution_configuration = ExecutionConfiguration()
execution_configuration.id = 22
self.execution.execution_configuration = execution_configuration
application = Application()
application.name = "Matmul"
execution_configuration.application = application
testbed = Testbed("nova", True, "SLURM", "SSH", "*****@*****.**",
["SINGULARITY"])
execution_configuration.testbed = testbed
db.session.add(testbed)
db.session.add(application)
db.session.add(execution_configuration)
db.session.add(self.execution)
db.session.commit()
def workspace_test():
print_data('workspaces objects', br=False)
for index in range(3):
w = Workspace()
w.name = 'New workspace name'
w.description = 'Some new description'
w.save()
workspaces = Workspace.all()
print_data('new objects -> model.all()', workspaces)
w.name = 'Updated name'
w.save()
workspaces = Workspace.all()
print_data('UPDATED -> model.all()', workspaces)
workspaces = Workspace.get(id=w.id, name=w.name)
print_data('GET -> model.get()', [workspaces])
workspaces = Workspace.filter(name='New workspace name')
print_data('FILTER -> model.filter()', workspaces)
for index in range(2):
o = Application()
o.workspace_id = w.guid
o.save()
a = View()
a.application_id = o.guid
a.save()
a = Resource()
a.application_id = o.guid
a.save()
for index in range(3):
o = Widget()
o.workspace_id = w.guid
o.save()
for index in range(3):
o = DataSource()
o.workspace_id = w.guid
o.save()
objects = Workspace.all() + Resource.all() + Application.all() + Widget.all() + DataSource.all() + View.all()
print_data('All objects in db', objects)
# [w.delete() for w in Workspace.all()]
workspaces = Workspace.all()
print_data('cleaned', workspaces)
workspaces = Workspace.filter(include_deleted=True)
print_data('cleaned with deleted if exists', workspaces)
objects = Workspace.all() + Resource.all() + Application.all() + Widget.all() + DataSource.all() + View.all()
print_data('no objects left', objects)
def applications_register():
request_body = request.get_json()
application_id = request_body.get('applicationId')
server_key = request_body.get('serverKey')
application = Application(application_id, server_key)
application = application.save()
if application is None:
return jsonify({'message': 'Could not subsribe!'})
return jsonify(application.json())
def setUpClass(cls):
engine = create_engine(
'mysql+mysqlconnector://iteatest:iteatest@localhost/iteatest')
session_class = sessionmaker(bind=engine)
session = session_class()
app.session = session
Base.metadata.create_all(engine)
with open('department.csv', 'r') as c_file:
reader = csv.reader(c_file)
for n, row in enumerate(reader):
if n == 0:
pass
else:
department = Department(id=row[0],
city=row[1],
count_of_workers=row[2])
session.add(department)
with open('client.csv', 'r') as c_file:
reader = csv.reader(c_file)
for n, row in enumerate(reader):
if n == 0:
pass
else:
client = Client(id=row[0],
first_name=row[1],
last_name=row[2],
education=row[3],
passport=row[4],
city=row[5],
age=row[6],
department_id=row[7])
session.add(client)
with open('application.csv', 'r') as c_file:
reader = csv.reader(c_file)
for n, row in enumerate(reader):
if n == 0:
pass
else:
application = Application(suma=row[1],
credit_state=row[2],
currency=row[3],
client_id=row[4])
session.add(application)
session.commit()
def apply(bot, update, args):
session = Session()
event = _get_event(args, session)
username = update.message.from_user.username
if not session.query(exists().where(Application.event_id == event.id).
where(Application.username == username)).scalar():
new_application = Application(event_id=event.id, username=username)
session.add(new_application)
session.commit()
bot.send_message(chat_id=update.message.chat_id,
text='@{} is going to [{}]({})'.format(username,
event.name,
event.url),
parse_mode='Markdown')
def set_up_database():
Session = sessionmaker(bind=engine)
session = Session()
with open('department.csv') as source:
reader = csv.DictReader(source)
for d in reader:
department = \
Department(idDepartment=int(d['idDepartment']),
DepartmentCity=d['DepartmentCity'],
CountOfWorkers=int(d['CountOfWorkers']))
session.add(department)
with open('client.csv') as source:
reader = csv.DictReader(source)
for c in reader:
client = \
Client(idClient=int(c['idClient']),
FirstName=c['FirstName'],
LastName=c['LastName'],
Education=c['Education'],
Passport=c['Passport'],
City=c['City'],
Age=int(c['Age']),
department_id=int(c['Department_idDepartment']))
session.add(client)
with open('application.csv') as source:
reader = csv.DictReader(source)
for a in reader:
application = \
Application(idApplication=int(a['idApplication']),
Sum=int(a['Sum']),
CreditState=a['CreditState'],
Currency=a['Currency'],
client_id=int(a['Client_idClient']))
session.add(application)
session.commit()
