def update_funeral(): conn = None cursor = None try: print(request.form) status = request.form['status'] date = request.form['date'] cemetery_id = request.form['cemeteries'] client_id = request.form['clients'] id = request.form['id'] conn = mysql.connect() cursor = conn.cursor() sql = "UPDATE funeral SET " \ "FuneralDate=%s, funeralstatus=%s, " \ "CemeteryId=%s, DeceasedId=%s" \ "WHERE funeralid=%s" cursor.execute(sql, (date, status, cemetery_id, client_id, id)); conn.commit() flash('Funeral has been successfully updated'); return redirect(url_for('.funerals')); finally: if cursor is not None: cursor.close() if conn is not None: cursor.close()
def create_client(): conn = None cursor = None try: fullname = request.form['fullname'] passport_number = request.form['passport_number'] birthday = request.form['birthday'] deathday = request.form['deathday'] size = request.form['size'] weight = request.form['weight'] cemetery_id = request.form['cemeteries'] mortuary_id = request.form['mortuaries'] conn = mysql.connect() cursor = conn.cursor() sql = "INSERT INTO deceased (" \ "DeceasedFullName, DeceasedPassportNumber, " \ "DeceasedBirthDate, DeceasedDeathDate, " \ "DeceasedSizeMeasurements, DeceasedWeight, " \ "CemeteryId, MortuaryId ) " \ "VALUES (%s, %s,%s,%s,%s,%s,%s,%s)" cursor.execute(sql, (fullname, passport_number, birthday, deathday, size, weight, cemetery_id, mortuary_id)) conn.commit() flash('Client has been successfully updated') return redirect(url_for('.clients')) finally: if cursor is not None: cursor.close() if conn is not None: cursor.close()
def create_worker(): conn = None cursor = None try: passport_number = request.form['inputPassportNumber'] fullname = request.form['inputFullname'] error_validation = "" if len(passport_number) > 10: error_validation += "Passport number must be a string with number of symbols up to 10" if len(fullname) > 100: error_validation += "Fullname of car must be a string with number of symbols up to 100" if error_validation: worker = Worker(id, fullname, passport_number) flash("Server validation failed: " + error_validation) return render_template("edit_worker.html", worker=worker) conn = mysql.connect() cursor = conn.cursor() sql = "INSERT INTO worker (WorkerPassportNumber, WorkerFullName) VALUES(%s, %s)" cursor.execute(sql, (passport_number, fullname)) conn.commit() flash('Worker has been successfully created') return redirect(url_for('.workers')) finally: if cursor is not None: cursor.close() if conn is not None: cursor.close()
def create_funeral(): conn = None cursor = None try: status = request.form['status'] date = request.form['date'] client_id = request.form['clients'] cemetery_id = request.form['cemeteries'] id = request.form['id'] conn = mysql.connect() cursor = conn.cursor() sql = "INSERT INTO funeral (" \ "funeralDate, funeralstatus, " \ "CemeteryId, DeceasedId ) " \ "VALUES (%s, %s, %s, %s)" cursor.execute(sql, (date, status, cemetery_id, client_id)); conn.commit() flash('Funeral has been successfully updated'); return redirect(url_for('.funerals')); finally: if cursor is not None: cursor.close() if conn is not None: cursor.close()
def create_mortuary(): conn = None cursor = None try: address = request.form['inputAddress'] name = request.form['inputName'] error_validation = "" if len(address) > 10: error_validation += "Passport number must be a string with number of symbols up to 10" if len(name) > 100: error_validation += "Name of car must be a string with number of symbols up to 100" if error_validation: mortuary = Mortuary(12, name, address) flash("Server validation failed: " + error_validation) return render_template("edit_mortuary.html", mortuary=mortuary) conn = mysql.connect() cursor = conn.cursor() sql = "INSERT INTO mortuary (MortuaryAdress, MortuaryName) VALUES(%s, %s)" cursor.execute(sql, (address, name)) conn.commit() flash('Mortuary has been successfully created') return redirect(url_for('.mortuaries')) finally: if cursor is not None: cursor.close() if conn is not None: cursor.close()
def update_cemetery(): conn = None cursor = None try: address = request.form['inputAddress'] name = request.form['inputName'] places = request.form['inputPlaces'] phone = request.form['inputPhone'] id = request.form['id'] error_validation = "" if len(name) > 45 : error_validation += "Passport number must be a string with number of symbols up to 10" if len(address) > 100: error_validation += "Name of car must be a string with number of symbols up to 100" if len(phone) > 100: error_validation += "Phone must be a string with number of symbols up to 20" if error_validation: cemetery = Cemetery(id, name, address, places, phone) flash("Server validation failed: " + error_validation) return render_template("edit_cemetery.html", cemetery=cemetery) conn = mysql.connect() cursor = conn.cursor() sql = "SELECT * FROM cemetery WHERE cemeteryid=%s"; cursor.execute(sql, (id,)) row = cursor.fetchone() # tuples if row is None: return render_template("500.html", e="Server cannot find cemetery is being updated") sql = "UPDATE cemetery SET CemeteryAdress=%s, CemeteryName=%s, CemeteryFreePlacesNumber=%s, CemeteryPhoneNumber=%s WHERE cemeteryid=%s" cursor.execute(sql, (address, name, places, phone, id)); conn.commit() flash('Cemetery has been successfully updated'); return redirect(url_for('.cemeteries')); finally: if cursor is not None: cursor.close() if conn is not None: cursor.close()
def update_car(): conn = None cursor = None try: registration_number = request.form['inputRegistrationNumber'] type = request.form['inputType'] model = request.form['inputModel'] id = request.form['id'] error_validation = "" if len(registration_number) > 20 or len(registration_number) < 5: error_validation += "Registration number must be a string with number of symbols from 5 to 20" if len(type) > 45: error_validation += "Type of car must be a string with number of symbols up to 45" if len(model) > 45: error_validation += "Type of car must be a string with number of symbols up to 45" if error_validation: car = Car(id, registration_number, type, model) flash("Server validation failed: " + error_validation) return render_template("edit_car.html", car=car) conn = mysql.connect() cursor = conn.cursor() sql = "SELECT * FROM car WHERE carid=%s" cursor.execute(sql, (id, )) row = cursor.fetchone() # tuples if row is None: return render_template("500.html", e="Server cannot find car is being updated") sql = "UPDATE car SET RegistrationNumber=%s, CarType=%s, CarModel=%s WHERE carid=%s" cursor.execute(sql, (registration_number, type, model, id)) conn.commit() flash('Car has been successfully updated') return redirect(url_for('.cars')) finally: if cursor is not None: cursor.close() if conn is not None: cursor.close()
def delete_client(id): conn = None cursor = None try: conn = mysql.connect() cursor = conn.cursor() sql = "DELETE FROM deceased WHERE deceasedid=%s" cursor.execute(sql, (id)) conn.commit() flash('Client has been successfully deleted') return redirect(url_for('.clients')) finally: if cursor is not None: cursor.close() if conn is not None: cursor.close()
def delete_cemetery(id): conn = None cursor = None try: conn = mysql.connect() cursor = conn.cursor() sql = "DELETE FROM cemetery WHERE cemeteryid=%s" cursor.execute(sql, (id)) conn.commit() flash('Cemetery has been successfully deleted') return redirect(url_for('.cemeteries')) finally: if cursor is not None: cursor.close() if conn is not None: cursor.close()
def delete_funeral(id): conn = None cursor = None try: conn = mysql.connect() cursor = conn.cursor() sql = "DELETE FROM funeral WHERE funeralid=%s" cursor.execute(sql, (id)) conn.commit() flash('Funeral has been successfully deleted') return redirect(url_for('.funerals')) finally: if cursor is not None: cursor.close() if conn is not None: cursor.close()
def delete_worker(id): conn = None cursor = None try: conn = mysql.connect() cursor = conn.cursor() sql = "DELETE FROM worker WHERE workerid=%s" cursor.execute(sql, (id)) conn.commit() flash('Worker has been successfully deleted') return redirect(url_for('.workers')) finally: if cursor is not None: cursor.close() if conn is not None: cursor.close()
def update_mortuary(): conn = None cursor = None try: address = request.form['inputAddress'] name = request.form['inputName'] id = request.form['id'] error_validation = "" if len(address) > 10: error_validation += "Passport number must be a string with number of symbols up to 10" if len(name) > 100: error_validation += "Name of car must be a string with number of symbols up to 100" if error_validation: mortuary = Mortuary(id, name, address) flash("Server validation failed: " + error_validation) return render_template("edit_mortuary.html", mortuary=mortuary) conn = mysql.connect() cursor = conn.cursor() sql = "SELECT * FROM mortuary WHERE mortuaryid=%s" cursor.execute(sql, (id, )) row = cursor.fetchone() # tuples if row is None: return render_template( "500.html", e="Server cannot find mortuary is being updated") sql = "UPDATE mortuary SET MortuaryAdress=%s, MortuaryName=%s WHERE mortuaryid=%s" cursor.execute(sql, (address, name, id)) conn.commit() flash('Mortuary has been successfully updated') return redirect(url_for('.mortuaries')) finally: if cursor is not None: cursor.close() if conn is not None: cursor.close()
def update_worker(): conn = None cursor = None try: passport_number = request.form['inputPassportNumber'] fullname = request.form['inputFullname'] id = request.form['id'] error_validation = "" if len(passport_number) > 10 : error_validation += "Passport number must be a string with number of symbols up to 10" if len(fullname) > 100: error_validation += "Fullname of car must be a string with number of symbols up to 100" if error_validation: worker = Worker(id, fullname, passport_number) flash("Server validation failed: " + error_validation) return render_template("edit_worker.html", worker=worker) conn = mysql.connect() cursor = conn.cursor() sql = "SELECT * FROM worker WHERE workerid=%s"; cursor.execute(sql, (id,)) row = cursor.fetchone() # tuples if row is None: return render_template("500.html", e="Server cannot find worker is being updated") sql = "UPDATE worker SET WorkerPassportNumber=%s, WorkerFullName=%s WHERE workerid=%s" cursor.execute(sql, (passport_number, fullname, id)); conn.commit() flash('Worker has been successfully updated'); return redirect(url_for('.workers')); finally: if cursor is not None: cursor.close() if conn is not None: cursor.close()
def create_cemetery(): conn = None cursor = None try: address = request.form['inputAddress'] name = request.form['inputName'] places = request.form['inputPlaces'] phone = request.form['inputPhone'] error_validation = "" if len(address) > 10: error_validation += "Passport number must be a string with number of symbols up to 10" if len(name) > 100: error_validation += "Name of car must be a string with number of symbols up to 100" if len(phone) > 100: error_validation += "Phone must be a string with number of symbols up to 20" if error_validation: cemetery = Cemetery(12, name, address, places, phone) flash("Server validation failed: " + error_validation) return render_template("edit_cemetery.html", cemetery=cemetery) conn = mysql.connect() cursor = conn.cursor() sql = "INSERT INTO cemetery (CemeteryAdress, CemeteryName, CemeteryFreePlacesNumber, CemeteryPhoneNumber) VALUES(%s, %s, %s, %s)" cursor.execute(sql, (address, name, places, phone)) conn.commit() flash('Cemetery has been successfully created') return redirect(url_for('.cemeteries')) finally: if cursor is not None: cursor.close() if conn is not None: cursor.close()
def create_car(): conn = None cursor = None try: registration_number = request.form['inputRegistrationNumber'] type = request.form['inputType'] model = request.form['inputModel'] error_validation = "" if len(registration_number) > 20 or len(registration_number) < 5: error_validation += "Registration number must be a string with number of symbols from 5 to 20" if len(type) > 45: error_validation += "Type of car must be a string with number of symbols up to 45" if len(model) > 45: error_validation += "Type of car must be a string with number of symbols up to 45" if error_validation: car = Car(id, registration_number, type, model) flash("Server validation failed: " + error_validation) return render_template("new_car.html", car=car) conn = mysql.connect() cursor = conn.cursor() sql = "INSERT INTO car (RegistrationNumber, CarType, CarModel) VALUES(%s, %s, %s)" cursor.execute(sql, (registration_number, type, model)) conn.commit() flash('Car has been successfully created') return redirect(url_for('.cars')) finally: if cursor is not None: cursor.close() if conn is not None: cursor.close()
def update_client(): conn = None cursor = None try: print(request.form) fullname = request.form['fullname'] passport_number = request.form['passport_number'] birthday = request.form['birthday'] deathday = request.form['deathday'] size = request.form['size'] weight = request.form['weight'] cemetery_id = request.form['cemeteries'] mortuary_id = request.form['mortuaries'] id = request.form['id'] conn = mysql.connect() cursor = conn.cursor() sql = "UPDATE deceased SET " \ "DeceasedFullName=%s, DeceasedPassportNumber=%s, " \ "DeceasedBirthDate=%s, DeceasedDeathDate=%s, " \ "DeceasedSizeMeasurements=%s, DeceasedWeight=%s, " \ "CemeteryId=%s, MortuaryId=%s " \ "WHERE deceasedid=%s" cursor.execute(sql, (fullname, passport_number, birthday, deathday, size, weight, cemetery_id, mortuary_id, id)) conn.commit() flash('Client has been successfully updated') return redirect(url_for('.clients')) finally: if cursor is not None: cursor.close() if conn is not None: cursor.close()