Exemple #1
0
 def get_all():
     sql = "SELECT * FROM employees"
     qry = QtSql.QSqlQuery()
     if not qry.exec_(sql):
         raise AllocatException(qry.lastError().text())
     return Recordset.to_dict(qry, Employee, 'name')
Exemple #2
0
 def get_all():
     sql = "SELECT * FROM projects"
     qry = QtSql.QSqlQuery()
     if not qry.exec_(sql):
         raise AllocatException(qry.lastError().text())
     return Recordset.to_dict(qry, Project, 'nickname')