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