Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- 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()
- last_id = query.lastInsertId()
- print last_id
- 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()
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement