How to insert, commit and fetch data using PyMySQL

dummy.txt

import pymysql.cursors

connection = pymysql.connect(host='localhost',
                             user='dummy',
                             password='pass',
                             db='demo',
                             cursorclass=pymysql.cursors.DictCursor)
try:
    with connection.cursor() as cursor:
        sql = "INSERT INTO student ( roll, name ) VALUES (%s, %s)"
        cursor.execute(sql, (15, "/home/test/Desktop"))
        cursor.execute(sql, (11, "Nano $ King"))
    connection.commit()
    with connection.cursor() as cursor:
        sql = "SELECT * FROM student"
        cursor.execute(sql)
        result = cursor.fetchall()
        print(result)
finally:
    connection.close()