class DSourceUserDirectory(Component):
implements (IRequestHandler, IUserDirectory)
# IRequestHandler methods
def match_request(self, req):
self.req = req
return False
def process_request(self, req):
pass
# IUserDirectory methods
def get_known_user_info(self, cnx=None, limit=None):
proj = get_project_code(self.req)
cnx = get_db()
cursor = cnx.cursor()
cursor.execute("SELECT username, user_email "
"FROM phpbb_users u "
" INNER JOIN members_projects mp on u.user_id=mp.member_id "
" INNER JOIN projects p on mp.project_id=p.project_id "
"WHERE project_code=%s "
"ORDER BY username", (proj,))
for username,email in cursor:
yield username,username,email
def get_known_users(self, cnx=None, limit=None):
proj = get_project_code(self.req)
cnx = get_db()
cursor = cnx.cursor()
cursor.execute("SELECT username "
"FROM phpbb_users u "
" INNER JOIN members_projects mp on u.user_id=mp.member_id "
" INNER JOIN projects p on mp.project_id=p.project_id "
"WHERE project_code=%s "
"ORDER BY username", (proj,))
for username in cursor:
yield username[0]
def get_user_attribute(self, user, attr):
pass
def get_supported_attributes(self):
pass