def insertarCliente(name, employee, apellido, dni, nacimiento):
arg = (
"INSERT INTO cliente (nombre, empleado, apellido, dni, birthday) VALUES ('"
+ name + "','" + employee + "','" + apellido + "','" + dni + "','" +
nacimiento + "')")
database.function2(arg)
return jsonify('done')
def insertarEmpleado(name1, name2, pay, bd, dni):
arg = (
"INSERT INTO employees (first_name,last_name,salario,birthday,dni) VALUES ('"
+ name1 + "','" + name2 + "','" + pay + "','" + bd + "','" + dni +
"')")
database.function2(arg)
return jsonify('done')
def muestraUsuariosSeguro():
name = request.form['first_name']
surname = request.form['last_name']
salary = request.form['salary']
birthday = request.form['birthday']
identification_number = request.form['identification_number']
arg = ("INSERT INTO employee (first_name,last_name,salary,birthday,dni) VALUES ('" + name + "','" + surname + "','" + salary + "','" + birthday + "','" + identification_number + "')")
database.function2(arg)
return jsonify('done')
def borrarCliente(id):
arg = ("DELETE FROM cliente WHERE id='" + id + "'")
database.function2(arg)
return jsonify('done')
def cambiarEmpleado(id, employee):
arg = ("UPDATE cliente SET empleado='" + employee + "' WHERE id='" + id +
"'")
database.function2(arg)
return jsonify('done')
def cambiarSalario(id, pay):
arg = ("UPDATE employees SET SALARIO='" + pay + "' WHERE id='" + id + "'")
database.function2(arg)
return jsonify('done')
def borrarEmpleado(id):
arg = ("DELETE FROM employees WHERE id='" + id + "'")
database.function2(arg)
return jsonify('done')
def removeuser():
id = request.form['id']
arg = ("DELETE FROM employee WHERE id='" + id + "'")
database.function2(arg)
return jsonify('done')
