import mariadb

conn= mariadb.connect(db="test")
cursor=conn.cursor()
cursor.execute("DROP TABLE IF EXISTS t1")
cursor.execute("CREATE TABLE t1 (a int) ENGINE=InnoDB")

cursor.execute("INSERT INTO t1 VALUES (1),(2),(3)")
conn.commit()

cursor.execute("INSERT INTO t2 VALUES (4),(5),(6)")
conn.rollback()

conn.close()

newconn= mariadb.connect(db="test")
cursor= newconn.cursor()
cursor.execute("SELECT * FROM t1")
row= cursor.fetchall()
assert row == [(1,),(2,),(3,)]