def insert_update_dept():
with scott.Database() as db:
if request.form.get('insert_depto_bttn', '') != '':
db.add_dept(request.form.get('deptno', 'null'),
request.form.get('dname', 'null'),
request.form.get('loc', 'null'))
elif request.form.get('update_depto_bttn', '') != '':
db.update_dept(request.form.get('deptno', 'null'),
request.form.get('dname', 'null'),
request.form.get('loc', 'null'))
return render_template('op-done.html')
def insert_update_emp():
with scott.Database() as db:
if request.form.get('insert_emp_bttn', '') != '':
hiredate = 'null' if (date := request.form.get('hiredate')
) == 0 else datetime.strptime(
date + ' 00:00:00', "%Y-%m-%d %H:%M:%S")
db.add_emp(request.form.get('empno', 'null'),
request.form.get('ename', 'null'),
request.form.get('job', 'null'),
request.form.get('mgr', 'None'), hiredate,
request.form.get('sal', 'null'),
request.form.get('comm', 'None'),
request.form.get('deptno', 'null'))
elif request.form.get('update_emp_bttn', '') != '':
hiredate = 'null' if (date := request.form.get('hiredate')
) == 0 else datetime.strptime(
date + ' 00:00:00', "%Y-%m-%d %H:%M:%S")
db.update_emp(request.form.get('empno', 'null'),
request.form.get('ename', 'null'),
request.form.get('job', 'null'),
request.form.get('mgr', 'None'), hiredate,
request.form.get('sal', 'null'),
request.form.get('comm', 'None'),
request.form.get('deptno', 'null'))
def noEmp_depto():
with scott.Database() as db:
deptno = request.form.get('deptno')
ans = "El depto {} tiene {} empleados".format(deptno,
db.noEmp_depto(deptno))
return render_template('noEmp_depto.html', ans=ans)
def delete_emp():
with scott.Database() as db:
db.delete_emp(request.form.get('empno'))
return render_template('emp-op-done.html')
def delete_dept():
with scott.Database() as db:
db.delete_dept(request.form.get('deptno'))
return render_template('op-done.html')
def show_emps():
rows = list()
with scott.Database() as db:
for row in db._cursor.execute("select * from emp"):
rows.append(row)
return render_template('show-emps.html', rows=rows)