CodeForce QtSql 4

def insert(db):

    query = QtSql.QSqlQuery()

    sql = """INSERT INTO EMPLOYEE(FIRST_NAME,

             LAST_NAME, AGE, SEX, INCOME)

             VALUES ('Mac', 'Mohan', 20, 'M', 2000)"""

    try:

        query.exec_(sql)

        db.commit()

    except:

        # Rollback in case there is any error

        db.rollback()

def update(db):

    query = QtSql.QSqlQuery()

    sql = "UPDATE EMPLOYEE SET AGE = AGE + 1 \

                              WHERE SEX = '%c'" % ('M')

    try:

        query.exec_(sql)

        db.commit()

    except:

        # Rollback in case there is any error

        db.rollback()



def delete(db):

    query = QtSql.QSqlQuery()

    sql = "DELETE FROM EMPLOYEE WHERE AGE > '%d'" % (20)

    try:

        query.exec_(sql)

        db.commit()

    except:

        # Rollback in case there is any error

        db.rollback()