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')
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')