def getResultsFromDataBase(query, database):
db = create_database_connection("localhost", "root", "", database)
my_cursor = db.cursor()
my_cursor.execute(query)
result = my_cursor.fetchall()
return bytesToLines(result)
def databaseToLines(localhost, root, password, database, query):
db = create_database_connection(localhost, root, password, database)
my_cursor = db.cursor()
my_cursor.execute(query)
result = my_cursor.fetchall()
return bytesToLines(result)
def queryMultipleResultsToLines(query):
db = create_database_connection("localhost", "root", "", "esystant1920")
my_cursor = db.cursor()
my_cursor.execute(query)
result = my_cursor.fetchall()
return bytesToLines(result)