import mariadb
 
config = {
    'host': 'localhost',
    'user': 'feherbt',
    'password': 'titok',
}

try :
    conn = mariadb.connect(**config, database='feherbt')
    cur = conn.cursor()

    sql = """
    insert into employees
    (name, city, salary)
    values
    (?, ?, ?)
    """
    values = ('Csirke Borbála', 'Miskolc', 5250000)
    cur.execute(sql, values)

    lastrowid = cur.lastrowid
    print('Utoljára beszúrt: ', cur.lastrowid)
    print('Érintett rekordok száma: ', cur.rowcount)

    sql = """
    update employees
    set
    name='Tengeri Béla' where id = {lastrowid}
    """

    conn.commit() 
    conn.close()
except Exception as ex:
    print(f'Hiba a commit során: {ex}')
    conn.rollback()