Changeset f3898f7 for fedd/exp_access_db.py

Timestamp:

Oct 5, 2011 5:11:01 PM (13 years ago)

Author:

Ted Faber <faber@…>

Branches:

compt_changes, info-ops, master

Children:

b6a6206

Parents:

53b5c18

git-author:

Ted Faber <faber@…> (10/05/11 17:10:01)

git-committer:

Ted Faber <faber@…> (10/05/11 17:11:01)

Message:

Simple support for experiments in groups. Closes #32

File:

• fedd/exp_access_db.py (modified) (2 diffs)

fedd/exp_access_db.py

@@ -52 +52 @@
 q_start = """
 SELECT
-    g.uid, g.pid,
+    g.uid, 
+    CASE g.gid
+        WHEN g.pid THEN g.pid
+        ELSE CONCAT(g.pid, '/', g.gid)
+    END,
     CONCAT('-----BEGIN CERTIFICATE-----\\n',
         s.cert,
@@ -59 +63 @@
 FROM group_membership g INNER JOIN user_sslcerts s
     ON g.uid = s.uid
-WHERE revoked is NULL AND g.pid = g.gid
+WHERE revoked is NULL
 """
 q_end ="""