def main(): """Entyr point.""" db = mysql.connector.connect(option_files="config.conf", use_pure=True) cursor = db.cursor() # cmd_query_iter() converter = MySQLConverter(db.charset, True) q1 = """SELECT Name, CountryCode, Population FROM world.city WHERE CountryCode = 'USA' ORDER BY Population DESC LIMIT 3""" q2 = "DO SLEEP(3)" q3 = """SELECT Name, CountryCode, Population FROM world.city WHERE CountryCode = 'IND' ORDER BY Population DESC LIMIT 3""" queries = [q1, q2, q3] result = db.cmd_query_iter(";".join(queries)) # Iterate throw the results count = 0 # It is one of the SELECT statements # as it has coumn definitions # print the result. for results in result: count = count + 1 time = datetime.now().strftime('%H:%M:%S') print(f"query {count} - {time}\n") if 'columns' in results: print(f"{'City':18s} {'Code':7s} {'Popul':3s}") city, eof = db.get_row() while not eof: values = converter.row_to_python(city, results["columns"]) print( f"{values[0]:18s} {values[1]:7s} {values[2]/10000000:3f}" ) city, eof = db.get_row() else: print("No results.") sleep(2) print("") cursor.close() db.close()
ORDER BY Population DESC""" ) # Fetch the rows (cities, eof) = db.get_rows() # Initialize the converter converter = MySQLConverter( db.charset, True) # Print the rows found print(__file__ + " - Using MySQLConverter:") print("") print( "{0:15s} {1:7s} {2:3s}".format( "City", "Country", "Pop" ) ) for city in cities: values = converter.row_to_python( city, result["columns"]) print( "{0:15s} {1:^7s} {2:4.1f}".format( values[0], values[1], values[2]/1000000.0 ) ) db.close()