mspadaru

CodeForce QtSql 6

Aug 19th, 2012
28
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Python 0.44 KB | None | 0 0
  1. def insert(db):
  2.     query = QtSql.QSqlQuery()
  3.     query.prepare("INSERT INTO developers ( first_name, last_name) "
  4.                   "VALUES (:forename, :surname)")
  5.     query.bindValue(":forename", "Bart")
  6.     query.bindValue(":surname", "Simpson")
  7.     try:
  8.         query.exec_()
  9.         db.commit()
  10.     except:
  11.         # Rollback in case there is any error
  12.         db.rollback()        
  13.     last_id = query.lastInsertId()
  14.     print last_id
Advertisement
Add Comment
Please, Sign In to add comment