Allow "permission list user" to show permissions for a given user

[Juanma Barranquero]

trac-admin's "permission list" could allow a parameter "user" (an SQL regexp, like "a%") to show permissions just for a user (or a group of them, if passed a regexp). The following patch is a proof-of-concept, but it lacks tests because I'm at present unable to run them.

scripts/trac-admin

@@ -374 +374 @@
     ## Permission
-    _help_permission = [('permission list', 'List permission rules'),
+    _help_permission = [('permission list [user]', 'List permission rules'),
                        ('permission add <user> <action> [action] [...]', 'Add a new permission rule'),
@@ -381 +381 @@
         try:
-            if arg[0]  == 'list':
-                self._do_permission_list()
+            if arg[0] == 'list':
+                if len(arg) > 1:
+                    user = arg[1]
+                else:
+                    user = None
+                self._do_permission_list(user)
             elif arg[0] == 'add' and len(arg) >= 3:
@@ -396 +400 @@
 
-    def _do_permission_list(self):
-        data = self.db_execsql('SELECT username, action FROM permission') 
+    def _do_permission_list(self, user):
+        select = 'SELECT username, action FROM permission'
+        if user:
+            select += (" WHERE username LIKE '%s'" % user)
+        data = self.db_execsql(select)
         self.print_listing(['User', 'Action'], data)

[Christopher Lenz]

Implemented in [1438]. Thanks!