def item_list(req, pager): tran = req.db.transaction(req.log_info) c = tran.cursor() c.execute(""" SELECT login_id, email, name, rights, enabled FROM logins ORDER BY email %s LIMIT %%d, %%d """ % pager.sort, (pager.offset, pager.limit)) items = [] for row in iter(c.fetchone, None): login = Login(row[0]) login.email = row[1] login.name = row[2] login.rights = json.loads(row[3]) login.enabled = row[4] items.append(login) # endfor c.execute("SELECT count(*) FROM logins") pager.total = c.fetchone()[0] tran.commit() return items
def mod(self, req, id): login = Login(id) return login._mod(req, ["data"], [{"addresses": self.items}])