cassandra_vs_mariadb/mariadb_read_data.py

#!/usr/bin/python
import mysql.connector as mariadb
import time

mariadb_connection = mariadb.connect(user='vagrant',
                                     database='testdb')
cursor = mariadb_connection.cursor()

allowed_query = ("select username, hobby from user;")

print()
print()
print()
print()
print()
start_time = time.time()
cursor.execute(allowed_query)
data = cursor.fetchall()
print("--- %s seconds ---" % (time.time() - start_time))
print(len(data))
print()
print()
print()
print()
print()