import mariadb

config = {
    'host': 'localhost',
    'database': 'project_one',
    'user': 'myuser',
    'password': 'mypassword'
}

conn = mariadb.connect(**config)

cursor = conn.cursor()

with open('operations.sql') as f:
    operations = f.read()

try:
    for result in cursor.execute(operations, multi=True):
        if result.with_rows:
            msg = f"Zeilen resultierend aus SQL-Anweisung '{result.statement}':\n"
            print(msg)
            for res in result.fetchall():
                print(res, end="\n")
        else:
            msg = f"Anzahl Zeilen resultierend aus SQL-Anweisung '{result.statement}': {result.rowcount}\n"
            print(msg)
except mariadb.DatabaseError as DBE:
    print("DatabaseError", DBE)
finally:
    cursor.close()
    conn.close()