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}])
