def display_employees(): results, headers = database.query_handler(mysql_procedures.SELECT_ALL) if results and headers: print_factory.print_result(results, headers) if not len(results) and headers: print "\n<Empty>\n" raw_input("\n\n\n... Press any key to return to main menu.\n") return
def show_contents_of_table(): result, headers = database.query_handler(mysql_procedures.SHOW_TABLES) print_factory.print_result(result, headers) tablename = raw_input("\nPlease enter a valid tablename from the table above: ") while not valid_table_name(result, tablename) and len(tablename) != 0: tablename = raw_input("\nResearch shows that your suggested tablename is not real. Please provide from list above or <Enter> to exit: ") if len(tablename) != 0: query = "SELECT * FROM {0};".format(tablename) result, headers = database.query_handler(query) print_factory.print_result(result, headers) raw_input("\n\n\n... Press any key to return to main menu.\n")
def update_employee(): results, headers = database.query_handler(mysql_procedures.SELECT_ALL) if results and headers: print_factory.print_result(results, headers) if not len(results) and headers: print "There is no records in this table." return e_id = raw_input("Enter id of Employee: ") column = raw_input("Enter property to update: ") value = raw_input("Enter new value of {0}: ".format(column)) update_query = mysql_procedures.update_employee(e_id, column, value) database.query_handler(update_query) print "Updated!"
def show_tables(): result, headers = database.query_handler(mysql_procedures.SHOW_TABLES) print_factory.print_result(result, headers) raw_input("\n\n\n... Press any key to return to main menu.\n")