Mercurial > p > roundup > code

annotate share/roundup/templates/devel/schema.py @ 4244:e8fb186265b7 gsoc-2009

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Added some hg patch apply things
author Pygi <pygi@users.sourceforge.net>
date Sat, 15 Aug 2009 07:43:45 +0000
parents 8838ff0165fa
children
Ignore whitespace changes - Everywhere: Within whitespace: At end of lines:
rev   line source
4122
115e9883311e Add new tracker template sandbox.
Stefan Seefeld <stefan@seefeld.name>
parents:
diff changeset
1
115e9883311e Add new tracker template sandbox.
Stefan Seefeld <stefan@seefeld.name>
parents:
diff changeset
2 #
115e9883311e Add new tracker template sandbox.
Stefan Seefeld <stefan@seefeld.name>
parents:
diff changeset
3 # TRACKER SCHEMA
115e9883311e Add new tracker template sandbox.
Stefan Seefeld <stefan@seefeld.name>
parents:
diff changeset
4 #
115e9883311e Add new tracker template sandbox.
Stefan Seefeld <stefan@seefeld.name>
parents:
diff changeset
5
115e9883311e Add new tracker template sandbox.
Stefan Seefeld <stefan@seefeld.name>
parents:
diff changeset
6 # Class automatically gets these properties:
115e9883311e Add new tracker template sandbox.
Stefan Seefeld <stefan@seefeld.name>
parents:
diff changeset
7 # creation = Date()
115e9883311e Add new tracker template sandbox.
Stefan Seefeld <stefan@seefeld.name>
parents:
diff changeset
8 # activity = Date()
115e9883311e Add new tracker template sandbox.
Stefan Seefeld <stefan@seefeld.name>
parents:
diff changeset
9 # creator = Link('user')
115e9883311e Add new tracker template sandbox.
Stefan Seefeld <stefan@seefeld.name>
parents:
diff changeset
10 # actor = Link('user')
115e9883311e Add new tracker template sandbox.
Stefan Seefeld <stefan@seefeld.name>
parents:
diff changeset
11
4141
c2e920eaee0a Implemented schema changes for svn-roundup support
Pygi <pygi@users.sourceforge.net>
parents: 4122
diff changeset
12
c2e920eaee0a Implemented schema changes for svn-roundup support
Pygi <pygi@users.sourceforge.net>
parents: 4122
diff changeset
13 # This is the repository class, then you can see/edit repositories in pages like
4167
2b554b262d29 Changed schema to be vcs agnostic
Pygi <pygi@users.sourceforge.net>
parents: 4141
diff changeset
14 # "http://tracker/url/vcs_repo1"
2b554b262d29 Changed schema to be vcs agnostic
Pygi <pygi@users.sourceforge.net>
parents: 4141
diff changeset
15 vcs_repo = Class(db, "vcs_repo",
4141
c2e920eaee0a Implemented schema changes for svn-roundup support
Pygi <pygi@users.sourceforge.net>
parents: 4122
diff changeset
16 name=String(),
c2e920eaee0a Implemented schema changes for svn-roundup support
Pygi <pygi@users.sourceforge.net>
parents: 4122
diff changeset
17 host=String(),
c2e920eaee0a Implemented schema changes for svn-roundup support
Pygi <pygi@users.sourceforge.net>
parents: 4122
diff changeset
18 path=String(),
4167
2b554b262d29 Changed schema to be vcs agnostic
Pygi <pygi@users.sourceforge.net>
parents: 4141
diff changeset
19 webview_url=String())
2b554b262d29 Changed schema to be vcs agnostic
Pygi <pygi@users.sourceforge.net>
parents: 4141
diff changeset
20 vcs_repo.setkey('name')
4141
c2e920eaee0a Implemented schema changes for svn-roundup support
Pygi <pygi@users.sourceforge.net>
parents: 4122
diff changeset
21
c2e920eaee0a Implemented schema changes for svn-roundup support
Pygi <pygi@users.sourceforge.net>
parents: 4122
diff changeset
22 # Stores revision data, lets you see/edit revisions in pages like
4167
2b554b262d29 Changed schema to be vcs agnostic
Pygi <pygi@users.sourceforge.net>
parents: 4141
diff changeset
23 # "http://tracker/url/vcs_rev1". The vcs_rev.item.html template is currently
4141
c2e920eaee0a Implemented schema changes for svn-roundup support
Pygi <pygi@users.sourceforge.net>
parents: 4122
diff changeset
24 # broken, but this works fine without it.
4167
2b554b262d29 Changed schema to be vcs agnostic
Pygi <pygi@users.sourceforge.net>
parents: 4141
diff changeset
25 vcs_rev = Class(db, "vcs_rev",
2b554b262d29 Changed schema to be vcs agnostic
Pygi <pygi@users.sourceforge.net>
parents: 4141
diff changeset
26 repository=Link('vcs_repo'),
4207
8838ff0165fa Revision should be a string
Pygi <pygi@users.sourceforge.net>
parents: 4167
diff changeset
27 revision=String())
4141
c2e920eaee0a Implemented schema changes for svn-roundup support
Pygi <pygi@users.sourceforge.net>
parents: 4122
diff changeset
28
c2e920eaee0a Implemented schema changes for svn-roundup support
Pygi <pygi@users.sourceforge.net>
parents: 4122
diff changeset
29
c2e920eaee0a Implemented schema changes for svn-roundup support
Pygi <pygi@users.sourceforge.net>
parents: 4122
diff changeset
30
4122
115e9883311e Add new tracker template sandbox.
Stefan Seefeld <stefan@seefeld.name>
parents:
diff changeset
31 # Component
115e9883311e Add new tracker template sandbox.
Stefan Seefeld <stefan@seefeld.name>
parents:
diff changeset
32 component = Class(db, 'component',
115e9883311e Add new tracker template sandbox.
Stefan Seefeld <stefan@seefeld.name>
parents:
diff changeset
33 name=String(),
115e9883311e Add new tracker template sandbox.
Stefan Seefeld <stefan@seefeld.name>
parents:
diff changeset
34 description=String(),
115e9883311e Add new tracker template sandbox.
Stefan Seefeld <stefan@seefeld.name>
parents:
diff changeset
35 order=Number(),
115e9883311e Add new tracker template sandbox.
Stefan Seefeld <stefan@seefeld.name>
parents:
diff changeset
36 assign_to=Link('user'))
115e9883311e Add new tracker template sandbox.
Stefan Seefeld <stefan@seefeld.name>
parents:
diff changeset
37 component.setkey('name')
115e9883311e Add new tracker template sandbox.
Stefan Seefeld <stefan@seefeld.name>
parents:
diff changeset
38
115e9883311e Add new tracker template sandbox.
Stefan Seefeld <stefan@seefeld.name>
parents:
diff changeset
39 # Version
115e9883311e Add new tracker template sandbox.
Stefan Seefeld <stefan@seefeld.name>
parents:
diff changeset
40 version = Class(db, 'version',
115e9883311e Add new tracker template sandbox.
Stefan Seefeld <stefan@seefeld.name>
parents:
diff changeset
41 name=String(),
115e9883311e Add new tracker template sandbox.
Stefan Seefeld <stefan@seefeld.name>
parents:
diff changeset
42 description=String(),
115e9883311e Add new tracker template sandbox.
Stefan Seefeld <stefan@seefeld.name>
parents:
diff changeset
43 order=Number())
115e9883311e Add new tracker template sandbox.
Stefan Seefeld <stefan@seefeld.name>
parents:
diff changeset
44 version.setkey('name')
115e9883311e Add new tracker template sandbox.
Stefan Seefeld <stefan@seefeld.name>
parents:
diff changeset
45
115e9883311e Add new tracker template sandbox.
Stefan Seefeld <stefan@seefeld.name>
parents:
diff changeset
46 # Severity
115e9883311e Add new tracker template sandbox.
Stefan Seefeld <stefan@seefeld.name>
parents:
diff changeset
47 severity = Class(db, 'severity',
115e9883311e Add new tracker template sandbox.
Stefan Seefeld <stefan@seefeld.name>
parents:
diff changeset
48 name=String(),
115e9883311e Add new tracker template sandbox.
Stefan Seefeld <stefan@seefeld.name>
parents:
diff changeset
49 description=String(),
115e9883311e Add new tracker template sandbox.
Stefan Seefeld <stefan@seefeld.name>
parents:
diff changeset
50 order=Number())
115e9883311e Add new tracker template sandbox.
Stefan Seefeld <stefan@seefeld.name>
parents:
diff changeset
51 severity.setkey('name')
115e9883311e Add new tracker template sandbox.
Stefan Seefeld <stefan@seefeld.name>
parents:
diff changeset
52
115e9883311e Add new tracker template sandbox.
Stefan Seefeld <stefan@seefeld.name>
parents:
diff changeset
53 # Priority
115e9883311e Add new tracker template sandbox.
Stefan Seefeld <stefan@seefeld.name>
parents:
diff changeset
54 priority = Class(db, 'priority',
115e9883311e Add new tracker template sandbox.
Stefan Seefeld <stefan@seefeld.name>
parents:
diff changeset
55 name=String(),
115e9883311e Add new tracker template sandbox.
Stefan Seefeld <stefan@seefeld.name>
parents:
diff changeset
56 description=String(),
115e9883311e Add new tracker template sandbox.
Stefan Seefeld <stefan@seefeld.name>
parents:
diff changeset
57 order=Number())
115e9883311e Add new tracker template sandbox.
Stefan Seefeld <stefan@seefeld.name>
parents:
diff changeset
58 priority.setkey('name')
115e9883311e Add new tracker template sandbox.
Stefan Seefeld <stefan@seefeld.name>
parents:
diff changeset
59
115e9883311e Add new tracker template sandbox.
Stefan Seefeld <stefan@seefeld.name>
parents:
diff changeset
60 # Status
115e9883311e Add new tracker template sandbox.
Stefan Seefeld <stefan@seefeld.name>
parents:
diff changeset
61 status = Class(db, "status",
115e9883311e Add new tracker template sandbox.
Stefan Seefeld <stefan@seefeld.name>
parents:
diff changeset
62 name=String(),
115e9883311e Add new tracker template sandbox.
Stefan Seefeld <stefan@seefeld.name>
parents:
diff changeset
63 description=String(),
115e9883311e Add new tracker template sandbox.
Stefan Seefeld <stefan@seefeld.name>
parents:
diff changeset
64 order=Number())
115e9883311e Add new tracker template sandbox.
Stefan Seefeld <stefan@seefeld.name>
parents:
diff changeset
65 status.setkey("name")
115e9883311e Add new tracker template sandbox.
Stefan Seefeld <stefan@seefeld.name>
parents:
diff changeset
66
115e9883311e Add new tracker template sandbox.
Stefan Seefeld <stefan@seefeld.name>
parents:
diff changeset
67 # Resolution
115e9883311e Add new tracker template sandbox.
Stefan Seefeld <stefan@seefeld.name>
parents:
diff changeset
68 resolution = Class(db, "resolution",
115e9883311e Add new tracker template sandbox.
Stefan Seefeld <stefan@seefeld.name>
parents:
diff changeset
69 name=String(),
115e9883311e Add new tracker template sandbox.
Stefan Seefeld <stefan@seefeld.name>
parents:
diff changeset
70 description=String(),
115e9883311e Add new tracker template sandbox.
Stefan Seefeld <stefan@seefeld.name>
parents:
diff changeset
71 order=Number())
115e9883311e Add new tracker template sandbox.
Stefan Seefeld <stefan@seefeld.name>
parents:
diff changeset
72 resolution.setkey('name')
115e9883311e Add new tracker template sandbox.
Stefan Seefeld <stefan@seefeld.name>
parents:
diff changeset
73
115e9883311e Add new tracker template sandbox.
Stefan Seefeld <stefan@seefeld.name>
parents:
diff changeset
74 # Keyword
115e9883311e Add new tracker template sandbox.
Stefan Seefeld <stefan@seefeld.name>
parents:
diff changeset
75 keyword = Class(db, "keyword",
115e9883311e Add new tracker template sandbox.
Stefan Seefeld <stefan@seefeld.name>
parents:
diff changeset
76 name=String(),
115e9883311e Add new tracker template sandbox.
Stefan Seefeld <stefan@seefeld.name>
parents:
diff changeset
77 description=String())
115e9883311e Add new tracker template sandbox.
Stefan Seefeld <stefan@seefeld.name>
parents:
diff changeset
78 keyword.setkey("name")
115e9883311e Add new tracker template sandbox.
Stefan Seefeld <stefan@seefeld.name>
parents:
diff changeset
79
115e9883311e Add new tracker template sandbox.
Stefan Seefeld <stefan@seefeld.name>
parents:
diff changeset
80
115e9883311e Add new tracker template sandbox.
Stefan Seefeld <stefan@seefeld.name>
parents:
diff changeset
81 # User-defined saved searches
115e9883311e Add new tracker template sandbox.
Stefan Seefeld <stefan@seefeld.name>
parents:
diff changeset
82 query = Class(db, "query",
115e9883311e Add new tracker template sandbox.
Stefan Seefeld <stefan@seefeld.name>
parents:
diff changeset
83 klass=String(),
115e9883311e Add new tracker template sandbox.
Stefan Seefeld <stefan@seefeld.name>
parents:
diff changeset
84 name=String(),
115e9883311e Add new tracker template sandbox.
Stefan Seefeld <stefan@seefeld.name>
parents:
diff changeset
85 url=String(),
115e9883311e Add new tracker template sandbox.
Stefan Seefeld <stefan@seefeld.name>
parents:
diff changeset
86 private_for=Link('user'))
115e9883311e Add new tracker template sandbox.
Stefan Seefeld <stefan@seefeld.name>
parents:
diff changeset
87
115e9883311e Add new tracker template sandbox.
Stefan Seefeld <stefan@seefeld.name>
parents:
diff changeset
88 # add any additional database schema configuration here
115e9883311e Add new tracker template sandbox.
Stefan Seefeld <stefan@seefeld.name>
parents:
diff changeset
89
115e9883311e Add new tracker template sandbox.
Stefan Seefeld <stefan@seefeld.name>
parents:
diff changeset
90 user = Class(db, "user",
115e9883311e Add new tracker template sandbox.
Stefan Seefeld <stefan@seefeld.name>
parents:
diff changeset
91 username=String(),
115e9883311e Add new tracker template sandbox.
Stefan Seefeld <stefan@seefeld.name>
parents:
diff changeset
92 password=Password(),
115e9883311e Add new tracker template sandbox.
Stefan Seefeld <stefan@seefeld.name>
parents:
diff changeset
93 address=String(),
115e9883311e Add new tracker template sandbox.
Stefan Seefeld <stefan@seefeld.name>
parents:
diff changeset
94 realname=String(),
115e9883311e Add new tracker template sandbox.
Stefan Seefeld <stefan@seefeld.name>
parents:
diff changeset
95 phone=String(),
115e9883311e Add new tracker template sandbox.
Stefan Seefeld <stefan@seefeld.name>
parents:
diff changeset
96 organisation=String(),
115e9883311e Add new tracker template sandbox.
Stefan Seefeld <stefan@seefeld.name>
parents:
diff changeset
97 alternate_addresses=String(),
115e9883311e Add new tracker template sandbox.
Stefan Seefeld <stefan@seefeld.name>
parents:
diff changeset
98 queries=Multilink('query'),
115e9883311e Add new tracker template sandbox.
Stefan Seefeld <stefan@seefeld.name>
parents:
diff changeset
99 roles=String(), # comma-separated string of Role names
4141
c2e920eaee0a Implemented schema changes for svn-roundup support
Pygi <pygi@users.sourceforge.net>
parents: 4122
diff changeset
100 timezone=String(),
4167
2b554b262d29 Changed schema to be vcs agnostic
Pygi <pygi@users.sourceforge.net>
parents: 4141
diff changeset
101 vcs_name=String())
4141
c2e920eaee0a Implemented schema changes for svn-roundup support
Pygi <pygi@users.sourceforge.net>
parents: 4122
diff changeset
102
4122
115e9883311e Add new tracker template sandbox.
Stefan Seefeld <stefan@seefeld.name>
parents:
diff changeset
103 user.setkey("username")
115e9883311e Add new tracker template sandbox.
Stefan Seefeld <stefan@seefeld.name>
parents:
diff changeset
104
4141
c2e920eaee0a Implemented schema changes for svn-roundup support
Pygi <pygi@users.sourceforge.net>
parents: 4122
diff changeset
105 # Permissions for revision creation and repository viewing.
c2e920eaee0a Implemented schema changes for svn-roundup support
Pygi <pygi@users.sourceforge.net>
parents: 4122
diff changeset
106 for role in ('User',):
4167
2b554b262d29 Changed schema to be vcs agnostic
Pygi <pygi@users.sourceforge.net>
parents: 4141
diff changeset
107 db.security.addPermissionToRole(role, 'Create', 'vcs_rev')
2b554b262d29 Changed schema to be vcs agnostic
Pygi <pygi@users.sourceforge.net>
parents: 4141
diff changeset
108 db.security.addPermissionToRole(role, 'View', 'vcs_repo')
4141
c2e920eaee0a Implemented schema changes for svn-roundup support
Pygi <pygi@users.sourceforge.net>
parents: 4122
diff changeset
109
4122
115e9883311e Add new tracker template sandbox.
Stefan Seefeld <stefan@seefeld.name>
parents:
diff changeset
110 # FileClass automatically gets this property in addition to the Class ones:
115e9883311e Add new tracker template sandbox.
Stefan Seefeld <stefan@seefeld.name>
parents:
diff changeset
111 # content = String() [saved to disk in <tracker home>/db/files/]
115e9883311e Add new tracker template sandbox.
Stefan Seefeld <stefan@seefeld.name>
parents:
diff changeset
112 # type = String() [MIME type of the content, default 'text/plain']
115e9883311e Add new tracker template sandbox.
Stefan Seefeld <stefan@seefeld.name>
parents:
diff changeset
113 msg = FileClass(db, "msg",
115e9883311e Add new tracker template sandbox.
Stefan Seefeld <stefan@seefeld.name>
parents:
diff changeset
114 author=Link("user", do_journal='no'),
115e9883311e Add new tracker template sandbox.
Stefan Seefeld <stefan@seefeld.name>
parents:
diff changeset
115 recipients=Multilink("user", do_journal='no'),
115e9883311e Add new tracker template sandbox.
Stefan Seefeld <stefan@seefeld.name>
parents:
diff changeset
116 date=Date(),
115e9883311e Add new tracker template sandbox.
Stefan Seefeld <stefan@seefeld.name>
parents:
diff changeset
117 summary=String(),
115e9883311e Add new tracker template sandbox.
Stefan Seefeld <stefan@seefeld.name>
parents:
diff changeset
118 files=Multilink("file"),
115e9883311e Add new tracker template sandbox.
Stefan Seefeld <stefan@seefeld.name>
parents:
diff changeset
119 messageid=String(),
4141
c2e920eaee0a Implemented schema changes for svn-roundup support
Pygi <pygi@users.sourceforge.net>
parents: 4122
diff changeset
120 inreplyto=String(),
4167
2b554b262d29 Changed schema to be vcs agnostic
Pygi <pygi@users.sourceforge.net>
parents: 4141
diff changeset
121 revision=Link("vcs_rev"))
4122
115e9883311e Add new tracker template sandbox.
Stefan Seefeld <stefan@seefeld.name>
parents:
diff changeset
122
4244
e8fb186265b7 Added some hg patch apply things
Pygi <pygi@users.sourceforge.net>
parents: 4207
diff changeset
123 # File
4122
115e9883311e Add new tracker template sandbox.
Stefan Seefeld <stefan@seefeld.name>
parents:
diff changeset
124 file = FileClass(db, "file",
115e9883311e Add new tracker template sandbox.
Stefan Seefeld <stefan@seefeld.name>
parents:
diff changeset
125 name=String(),
115e9883311e Add new tracker template sandbox.
Stefan Seefeld <stefan@seefeld.name>
parents:
diff changeset
126 description=String(indexme='yes'))
115e9883311e Add new tracker template sandbox.
Stefan Seefeld <stefan@seefeld.name>
parents:
diff changeset
127
4244
e8fb186265b7 Added some hg patch apply things
Pygi <pygi@users.sourceforge.net>
parents: 4207
diff changeset
128 # Patch
e8fb186265b7 Added some hg patch apply things
Pygi <pygi@users.sourceforge.net>
parents: 4207
diff changeset
129 patch = FileClass(db, "patch",
e8fb186265b7 Added some hg patch apply things
Pygi <pygi@users.sourceforge.net>
parents: 4207
diff changeset
130 name=String(),
e8fb186265b7 Added some hg patch apply things
Pygi <pygi@users.sourceforge.net>
parents: 4207
diff changeset
131 description=String(indexme='yes'),
e8fb186265b7 Added some hg patch apply things
Pygi <pygi@users.sourceforge.net>
parents: 4207
diff changeset
132 repository=String(),
e8fb186265b7 Added some hg patch apply things
Pygi <pygi@users.sourceforge.net>
parents: 4207
diff changeset
133 revision=String())
e8fb186265b7 Added some hg patch apply things
Pygi <pygi@users.sourceforge.net>
parents: 4207
diff changeset
134
4122
115e9883311e Add new tracker template sandbox.
Stefan Seefeld <stefan@seefeld.name>
parents:
diff changeset
135 # Bug Type
115e9883311e Add new tracker template sandbox.
Stefan Seefeld <stefan@seefeld.name>
parents:
diff changeset
136 bug_type = Class(db, 'bug_type',
115e9883311e Add new tracker template sandbox.
Stefan Seefeld <stefan@seefeld.name>
parents:
diff changeset
137 name=String(),
115e9883311e Add new tracker template sandbox.
Stefan Seefeld <stefan@seefeld.name>
parents:
diff changeset
138 description=String(),
115e9883311e Add new tracker template sandbox.
Stefan Seefeld <stefan@seefeld.name>
parents:
diff changeset
139 order=Number())
115e9883311e Add new tracker template sandbox.
Stefan Seefeld <stefan@seefeld.name>
parents:
diff changeset
140 bug_type.setkey('name')
115e9883311e Add new tracker template sandbox.
Stefan Seefeld <stefan@seefeld.name>
parents:
diff changeset
141
115e9883311e Add new tracker template sandbox.
Stefan Seefeld <stefan@seefeld.name>
parents:
diff changeset
142 # IssueClass automatically gets these properties in addition to the Class ones:
115e9883311e Add new tracker template sandbox.
Stefan Seefeld <stefan@seefeld.name>
parents:
diff changeset
143 # title = String()
115e9883311e Add new tracker template sandbox.
Stefan Seefeld <stefan@seefeld.name>
parents:
diff changeset
144 # messages = Multilink("msg")
115e9883311e Add new tracker template sandbox.
Stefan Seefeld <stefan@seefeld.name>
parents:
diff changeset
145 # files = Multilink("file")
4244
e8fb186265b7 Added some hg patch apply things
Pygi <pygi@users.sourceforge.net>
parents: 4207
diff changeset
146 # patches = Multilink("patches")
4122
115e9883311e Add new tracker template sandbox.
Stefan Seefeld <stefan@seefeld.name>
parents:
diff changeset
147 # nosy = Multilink("user")
115e9883311e Add new tracker template sandbox.
Stefan Seefeld <stefan@seefeld.name>
parents:
diff changeset
148 # superseder = Multilink("issue")
115e9883311e Add new tracker template sandbox.
Stefan Seefeld <stefan@seefeld.name>
parents:
diff changeset
149 bug = IssueClass(db, "bug",
115e9883311e Add new tracker template sandbox.
Stefan Seefeld <stefan@seefeld.name>
parents:
diff changeset
150 type=Link('bug_type'),
115e9883311e Add new tracker template sandbox.
Stefan Seefeld <stefan@seefeld.name>
parents:
diff changeset
151 components=Multilink('component'),
115e9883311e Add new tracker template sandbox.
Stefan Seefeld <stefan@seefeld.name>
parents:
diff changeset
152 versions=Multilink('version'),
115e9883311e Add new tracker template sandbox.
Stefan Seefeld <stefan@seefeld.name>
parents:
diff changeset
153 severity=Link('severity'),
115e9883311e Add new tracker template sandbox.
Stefan Seefeld <stefan@seefeld.name>
parents:
diff changeset
154 priority=Link('priority'),
115e9883311e Add new tracker template sandbox.
Stefan Seefeld <stefan@seefeld.name>
parents:
diff changeset
155 dependencies=Multilink('bug'),
115e9883311e Add new tracker template sandbox.
Stefan Seefeld <stefan@seefeld.name>
parents:
diff changeset
156 assignee=Link('user'),
115e9883311e Add new tracker template sandbox.
Stefan Seefeld <stefan@seefeld.name>
parents:
diff changeset
157 status=Link('status'),
115e9883311e Add new tracker template sandbox.
Stefan Seefeld <stefan@seefeld.name>
parents:
diff changeset
158 resolution=Link('resolution'),
115e9883311e Add new tracker template sandbox.
Stefan Seefeld <stefan@seefeld.name>
parents:
diff changeset
159 superseder=Link('bug'),
115e9883311e Add new tracker template sandbox.
Stefan Seefeld <stefan@seefeld.name>
parents:
diff changeset
160 keywords=Multilink('keyword'))
115e9883311e Add new tracker template sandbox.
Stefan Seefeld <stefan@seefeld.name>
parents:
diff changeset
161
115e9883311e Add new tracker template sandbox.
Stefan Seefeld <stefan@seefeld.name>
parents:
diff changeset
162 # Task Type
115e9883311e Add new tracker template sandbox.
Stefan Seefeld <stefan@seefeld.name>
parents:
diff changeset
163 task_type = Class(db, 'task_type',
115e9883311e Add new tracker template sandbox.
Stefan Seefeld <stefan@seefeld.name>
parents:
diff changeset
164 name=String(),
115e9883311e Add new tracker template sandbox.
Stefan Seefeld <stefan@seefeld.name>
parents:
diff changeset
165 description=String(),
115e9883311e Add new tracker template sandbox.
Stefan Seefeld <stefan@seefeld.name>
parents:
diff changeset
166 order=Number())
115e9883311e Add new tracker template sandbox.
Stefan Seefeld <stefan@seefeld.name>
parents:
diff changeset
167 task_type.setkey('name')
115e9883311e Add new tracker template sandbox.
Stefan Seefeld <stefan@seefeld.name>
parents:
diff changeset
168
115e9883311e Add new tracker template sandbox.
Stefan Seefeld <stefan@seefeld.name>
parents:
diff changeset
169 # IssueClass automatically gets these properties in addition to the Class ones:
115e9883311e Add new tracker template sandbox.
Stefan Seefeld <stefan@seefeld.name>
parents:
diff changeset
170 # title = String()
115e9883311e Add new tracker template sandbox.
Stefan Seefeld <stefan@seefeld.name>
parents:
diff changeset
171 # messages = Multilink("msg")
115e9883311e Add new tracker template sandbox.
Stefan Seefeld <stefan@seefeld.name>
parents:
diff changeset
172 # files = Multilink("file")
115e9883311e Add new tracker template sandbox.
Stefan Seefeld <stefan@seefeld.name>
parents:
diff changeset
173 # nosy = Multilink("user")
115e9883311e Add new tracker template sandbox.
Stefan Seefeld <stefan@seefeld.name>
parents:
diff changeset
174 # superseder = Multilink("issue")
115e9883311e Add new tracker template sandbox.
Stefan Seefeld <stefan@seefeld.name>
parents:
diff changeset
175 task = IssueClass(db, "task",
115e9883311e Add new tracker template sandbox.
Stefan Seefeld <stefan@seefeld.name>
parents:
diff changeset
176 type=Link('task_type'),
115e9883311e Add new tracker template sandbox.
Stefan Seefeld <stefan@seefeld.name>
parents:
diff changeset
177 components=Multilink('component'),
115e9883311e Add new tracker template sandbox.
Stefan Seefeld <stefan@seefeld.name>
parents:
diff changeset
178 priority=Link('priority'),
115e9883311e Add new tracker template sandbox.
Stefan Seefeld <stefan@seefeld.name>
parents:
diff changeset
179 dependencies=Multilink('task'),
115e9883311e Add new tracker template sandbox.
Stefan Seefeld <stefan@seefeld.name>
parents:
diff changeset
180 assignee=Multilink('user'),
115e9883311e Add new tracker template sandbox.
Stefan Seefeld <stefan@seefeld.name>
parents:
diff changeset
181 status=Link('status'),
115e9883311e Add new tracker template sandbox.
Stefan Seefeld <stefan@seefeld.name>
parents:
diff changeset
182 resolution=Link('resolution'),
115e9883311e Add new tracker template sandbox.
Stefan Seefeld <stefan@seefeld.name>
parents:
diff changeset
183 solves=Link('bug'))
115e9883311e Add new tracker template sandbox.
Stefan Seefeld <stefan@seefeld.name>
parents:
diff changeset
184
115e9883311e Add new tracker template sandbox.
Stefan Seefeld <stefan@seefeld.name>
parents:
diff changeset
185 milestone = IssueClass(db, "milestone",
115e9883311e Add new tracker template sandbox.
Stefan Seefeld <stefan@seefeld.name>
parents:
diff changeset
186 bugs=Multilink("bug"),
115e9883311e Add new tracker template sandbox.
Stefan Seefeld <stefan@seefeld.name>
parents:
diff changeset
187 tasks=Multilink("task"),
115e9883311e Add new tracker template sandbox.
Stefan Seefeld <stefan@seefeld.name>
parents:
diff changeset
188 status=Link("status"),
115e9883311e Add new tracker template sandbox.
Stefan Seefeld <stefan@seefeld.name>
parents:
diff changeset
189 release_date=String())
115e9883311e Add new tracker template sandbox.
Stefan Seefeld <stefan@seefeld.name>
parents:
diff changeset
190
115e9883311e Add new tracker template sandbox.
Stefan Seefeld <stefan@seefeld.name>
parents:
diff changeset
191 #
115e9883311e Add new tracker template sandbox.
Stefan Seefeld <stefan@seefeld.name>
parents:
diff changeset
192 # TRACKER SECURITY SETTINGS
115e9883311e Add new tracker template sandbox.
Stefan Seefeld <stefan@seefeld.name>
parents:
diff changeset
193 #
115e9883311e Add new tracker template sandbox.
Stefan Seefeld <stefan@seefeld.name>
parents:
diff changeset
194 # See the configuration and customisation document for information
115e9883311e Add new tracker template sandbox.
Stefan Seefeld <stefan@seefeld.name>
parents:
diff changeset
195 # about security setup.
115e9883311e Add new tracker template sandbox.
Stefan Seefeld <stefan@seefeld.name>
parents:
diff changeset
196
115e9883311e Add new tracker template sandbox.
Stefan Seefeld <stefan@seefeld.name>
parents:
diff changeset
197 db.security.addRole(name='Developer', description='A developer')
115e9883311e Add new tracker template sandbox.
Stefan Seefeld <stefan@seefeld.name>
parents:
diff changeset
198 db.security.addRole(name='Coordinator', description='A coordinator')
115e9883311e Add new tracker template sandbox.
Stefan Seefeld <stefan@seefeld.name>
parents:
diff changeset
199
115e9883311e Add new tracker template sandbox.
Stefan Seefeld <stefan@seefeld.name>
parents:
diff changeset
200 #
115e9883311e Add new tracker template sandbox.
Stefan Seefeld <stefan@seefeld.name>
parents:
diff changeset
201 # REGULAR USERS
115e9883311e Add new tracker template sandbox.
Stefan Seefeld <stefan@seefeld.name>
parents:
diff changeset
202 #
115e9883311e Add new tracker template sandbox.
Stefan Seefeld <stefan@seefeld.name>
parents:
diff changeset
203 # Give the regular users access to the web and email interface
115e9883311e Add new tracker template sandbox.
Stefan Seefeld <stefan@seefeld.name>
parents:
diff changeset
204 for r in 'User', 'Developer', 'Coordinator':
115e9883311e Add new tracker template sandbox.
Stefan Seefeld <stefan@seefeld.name>
parents:
diff changeset
205 db.security.addPermissionToRole(r, 'Web Access')
115e9883311e Add new tracker template sandbox.
Stefan Seefeld <stefan@seefeld.name>
parents:
diff changeset
206 db.security.addPermissionToRole(r, 'Email Access')
115e9883311e Add new tracker template sandbox.
Stefan Seefeld <stefan@seefeld.name>
parents:
diff changeset
207
115e9883311e Add new tracker template sandbox.
Stefan Seefeld <stefan@seefeld.name>
parents:
diff changeset
208 ##########################
115e9883311e Add new tracker template sandbox.
Stefan Seefeld <stefan@seefeld.name>
parents:
diff changeset
209 # User permissions
115e9883311e Add new tracker template sandbox.
Stefan Seefeld <stefan@seefeld.name>
parents:
diff changeset
210 ##########################
115e9883311e Add new tracker template sandbox.
Stefan Seefeld <stefan@seefeld.name>
parents:
diff changeset
211
115e9883311e Add new tracker template sandbox.
Stefan Seefeld <stefan@seefeld.name>
parents:
diff changeset
212 for cl in ('severity', 'component',
115e9883311e Add new tracker template sandbox.
Stefan Seefeld <stefan@seefeld.name>
parents:
diff changeset
213 'version', 'priority', 'status', 'resolution',
115e9883311e Add new tracker template sandbox.
Stefan Seefeld <stefan@seefeld.name>
parents:
diff changeset
214 'bug_type', 'bug', 'task_type', 'task', 'milestone',
115e9883311e Add new tracker template sandbox.
Stefan Seefeld <stefan@seefeld.name>
parents:
diff changeset
215 'keyword', 'file', 'msg'):
115e9883311e Add new tracker template sandbox.
Stefan Seefeld <stefan@seefeld.name>
parents:
diff changeset
216 db.security.addPermissionToRole('User', 'View', cl)
115e9883311e Add new tracker template sandbox.
Stefan Seefeld <stefan@seefeld.name>
parents:
diff changeset
217 db.security.addPermissionToRole('Anonymous', 'View', cl)
115e9883311e Add new tracker template sandbox.
Stefan Seefeld <stefan@seefeld.name>
parents:
diff changeset
218 db.security.addPermissionToRole('User', 'Create', cl)
115e9883311e Add new tracker template sandbox.
Stefan Seefeld <stefan@seefeld.name>
parents:
diff changeset
219
115e9883311e Add new tracker template sandbox.
Stefan Seefeld <stefan@seefeld.name>
parents:
diff changeset
220
115e9883311e Add new tracker template sandbox.
Stefan Seefeld <stefan@seefeld.name>
parents:
diff changeset
221 def may_edit_file(db, userid, itemid):
115e9883311e Add new tracker template sandbox.
Stefan Seefeld <stefan@seefeld.name>
parents:
diff changeset
222 return userid == db.file.get(itemid, "creator")
115e9883311e Add new tracker template sandbox.
Stefan Seefeld <stefan@seefeld.name>
parents:
diff changeset
223
115e9883311e Add new tracker template sandbox.
Stefan Seefeld <stefan@seefeld.name>
parents:
diff changeset
224 p = db.security.addPermission(name='Edit', klass='file', check=may_edit_file,
115e9883311e Add new tracker template sandbox.
Stefan Seefeld <stefan@seefeld.name>
parents:
diff changeset
225 description="User is allowed to remove their own files")
115e9883311e Add new tracker template sandbox.
Stefan Seefeld <stefan@seefeld.name>
parents:
diff changeset
226 db.security.addPermissionToRole('User', p)
115e9883311e Add new tracker template sandbox.
Stefan Seefeld <stefan@seefeld.name>
parents:
diff changeset
227
115e9883311e Add new tracker template sandbox.
Stefan Seefeld <stefan@seefeld.name>
parents:
diff changeset
228 p = db.security.addPermission(name='Create', klass='bug',
115e9883311e Add new tracker template sandbox.
Stefan Seefeld <stefan@seefeld.name>
parents:
diff changeset
229 properties=('title', 'bug_type',
115e9883311e Add new tracker template sandbox.
Stefan Seefeld <stefan@seefeld.name>
parents:
diff changeset
230 'components', 'versions',
115e9883311e Add new tracker template sandbox.
Stefan Seefeld <stefan@seefeld.name>
parents:
diff changeset
231 'severity',
115e9883311e Add new tracker template sandbox.
Stefan Seefeld <stefan@seefeld.name>
parents:
diff changeset
232 'messages', 'files', 'nosy'),
115e9883311e Add new tracker template sandbox.
Stefan Seefeld <stefan@seefeld.name>
parents:
diff changeset
233 description='User can report and discuss bugs')
115e9883311e Add new tracker template sandbox.
Stefan Seefeld <stefan@seefeld.name>
parents:
diff changeset
234 db.security.addPermissionToRole('User', p)
115e9883311e Add new tracker template sandbox.
Stefan Seefeld <stefan@seefeld.name>
parents:
diff changeset
235
115e9883311e Add new tracker template sandbox.
Stefan Seefeld <stefan@seefeld.name>
parents:
diff changeset
236 p = db.security.addPermission(name='Edit', klass='bug',
115e9883311e Add new tracker template sandbox.
Stefan Seefeld <stefan@seefeld.name>
parents:
diff changeset
237 properties=('title', 'bug_type',
115e9883311e Add new tracker template sandbox.
Stefan Seefeld <stefan@seefeld.name>
parents:
diff changeset
238 'components', 'versions',
115e9883311e Add new tracker template sandbox.
Stefan Seefeld <stefan@seefeld.name>
parents:
diff changeset
239 'severity',
115e9883311e Add new tracker template sandbox.
Stefan Seefeld <stefan@seefeld.name>
parents:
diff changeset
240 'messages', 'files', 'nosy'),
115e9883311e Add new tracker template sandbox.
Stefan Seefeld <stefan@seefeld.name>
parents:
diff changeset
241 description='User can report and discuss bugs')
115e9883311e Add new tracker template sandbox.
Stefan Seefeld <stefan@seefeld.name>
parents:
diff changeset
242 db.security.addPermissionToRole('User', p)
115e9883311e Add new tracker template sandbox.
Stefan Seefeld <stefan@seefeld.name>
parents:
diff changeset
243
115e9883311e Add new tracker template sandbox.
Stefan Seefeld <stefan@seefeld.name>
parents:
diff changeset
244 p = db.security.addPermission(name='Create', klass='task',
115e9883311e Add new tracker template sandbox.
Stefan Seefeld <stefan@seefeld.name>
parents:
diff changeset
245 properties=('title', 'task_type',
115e9883311e Add new tracker template sandbox.
Stefan Seefeld <stefan@seefeld.name>
parents:
diff changeset
246 'components',
115e9883311e Add new tracker template sandbox.
Stefan Seefeld <stefan@seefeld.name>
parents:
diff changeset
247 'messages', 'files', 'nosy'),
115e9883311e Add new tracker template sandbox.
Stefan Seefeld <stefan@seefeld.name>
parents:
diff changeset
248 description='Developer can create and discuss tasks')
115e9883311e Add new tracker template sandbox.
Stefan Seefeld <stefan@seefeld.name>
parents:
diff changeset
249 db.security.addPermissionToRole('Developer', p)
115e9883311e Add new tracker template sandbox.
Stefan Seefeld <stefan@seefeld.name>
parents:
diff changeset
250
115e9883311e Add new tracker template sandbox.
Stefan Seefeld <stefan@seefeld.name>
parents:
diff changeset
251 p = db.security.addPermission(name='Edit', klass='task',
115e9883311e Add new tracker template sandbox.
Stefan Seefeld <stefan@seefeld.name>
parents:
diff changeset
252 properties=('title', 'task_type',
115e9883311e Add new tracker template sandbox.
Stefan Seefeld <stefan@seefeld.name>
parents:
diff changeset
253 'components',
115e9883311e Add new tracker template sandbox.
Stefan Seefeld <stefan@seefeld.name>
parents:
diff changeset
254 'messages', 'files', 'nosy'),
115e9883311e Add new tracker template sandbox.
Stefan Seefeld <stefan@seefeld.name>
parents:
diff changeset
255 description='Developer can create and discuss tasks')
115e9883311e Add new tracker template sandbox.
Stefan Seefeld <stefan@seefeld.name>
parents:
diff changeset
256 db.security.addPermissionToRole('Developer', p)
115e9883311e Add new tracker template sandbox.
Stefan Seefeld <stefan@seefeld.name>
parents:
diff changeset
257
115e9883311e Add new tracker template sandbox.
Stefan Seefeld <stefan@seefeld.name>
parents:
diff changeset
258 p = db.security.addPermission(name='Create', klass='milestone',
115e9883311e Add new tracker template sandbox.
Stefan Seefeld <stefan@seefeld.name>
parents:
diff changeset
259 description='Coordinator can create and discuss milestones')
115e9883311e Add new tracker template sandbox.
Stefan Seefeld <stefan@seefeld.name>
parents:
diff changeset
260 db.security.addPermissionToRole('Coordinator', p)
115e9883311e Add new tracker template sandbox.
Stefan Seefeld <stefan@seefeld.name>
parents:
diff changeset
261
115e9883311e Add new tracker template sandbox.
Stefan Seefeld <stefan@seefeld.name>
parents:
diff changeset
262 p = db.security.addPermission(name='Edit', klass='milestone',
115e9883311e Add new tracker template sandbox.
Stefan Seefeld <stefan@seefeld.name>
parents:
diff changeset
263 description='Coordinator can create and discuss milestones')
115e9883311e Add new tracker template sandbox.
Stefan Seefeld <stefan@seefeld.name>
parents:
diff changeset
264 db.security.addPermissionToRole('Coordinator', p)
115e9883311e Add new tracker template sandbox.
Stefan Seefeld <stefan@seefeld.name>
parents:
diff changeset
265
115e9883311e Add new tracker template sandbox.
Stefan Seefeld <stefan@seefeld.name>
parents:
diff changeset
266
115e9883311e Add new tracker template sandbox.
Stefan Seefeld <stefan@seefeld.name>
parents:
diff changeset
267 ##########################
115e9883311e Add new tracker template sandbox.
Stefan Seefeld <stefan@seefeld.name>
parents:
diff changeset
268 # Developer permissions
115e9883311e Add new tracker template sandbox.
Stefan Seefeld <stefan@seefeld.name>
parents:
diff changeset
269 ##########################
115e9883311e Add new tracker template sandbox.
Stefan Seefeld <stefan@seefeld.name>
parents:
diff changeset
270 for cl in ('bug_type', 'severity', 'component',
115e9883311e Add new tracker template sandbox.
Stefan Seefeld <stefan@seefeld.name>
parents:
diff changeset
271 'version', 'priority', 'status', 'resolution',
115e9883311e Add new tracker template sandbox.
Stefan Seefeld <stefan@seefeld.name>
parents:
diff changeset
272 'bug', 'file', 'msg', 'keyword'):
115e9883311e Add new tracker template sandbox.
Stefan Seefeld <stefan@seefeld.name>
parents:
diff changeset
273 db.security.addPermissionToRole('Developer', 'View', cl)
115e9883311e Add new tracker template sandbox.
Stefan Seefeld <stefan@seefeld.name>
parents:
diff changeset
274
115e9883311e Add new tracker template sandbox.
Stefan Seefeld <stefan@seefeld.name>
parents:
diff changeset
275 for cl in ('bug', 'file', 'msg', 'keyword'):
115e9883311e Add new tracker template sandbox.
Stefan Seefeld <stefan@seefeld.name>
parents:
diff changeset
276 db.security.addPermissionToRole('Developer', 'Edit', cl)
115e9883311e Add new tracker template sandbox.
Stefan Seefeld <stefan@seefeld.name>
parents:
diff changeset
277 db.security.addPermissionToRole('Developer', 'Create', cl)
115e9883311e Add new tracker template sandbox.
Stefan Seefeld <stefan@seefeld.name>
parents:
diff changeset
278
115e9883311e Add new tracker template sandbox.
Stefan Seefeld <stefan@seefeld.name>
parents:
diff changeset
279
115e9883311e Add new tracker template sandbox.
Stefan Seefeld <stefan@seefeld.name>
parents:
diff changeset
280 ##########################
115e9883311e Add new tracker template sandbox.
Stefan Seefeld <stefan@seefeld.name>
parents:
diff changeset
281 # Coordinator permissions
115e9883311e Add new tracker template sandbox.
Stefan Seefeld <stefan@seefeld.name>
parents:
diff changeset
282 ##########################
115e9883311e Add new tracker template sandbox.
Stefan Seefeld <stefan@seefeld.name>
parents:
diff changeset
283 for cl in ('bug_type', 'task_type', 'severity', 'component',
115e9883311e Add new tracker template sandbox.
Stefan Seefeld <stefan@seefeld.name>
parents:
diff changeset
284 'version', 'priority', 'status', 'resolution', 'bug', 'task', 'file', 'msg'):
115e9883311e Add new tracker template sandbox.
Stefan Seefeld <stefan@seefeld.name>
parents:
diff changeset
285 db.security.addPermissionToRole('Coordinator', 'View', cl)
115e9883311e Add new tracker template sandbox.
Stefan Seefeld <stefan@seefeld.name>
parents:
diff changeset
286 db.security.addPermissionToRole('Coordinator', 'Edit', cl)
115e9883311e Add new tracker template sandbox.
Stefan Seefeld <stefan@seefeld.name>
parents:
diff changeset
287 db.security.addPermissionToRole('Coordinator', 'Create', cl)
115e9883311e Add new tracker template sandbox.
Stefan Seefeld <stefan@seefeld.name>
parents:
diff changeset
288
115e9883311e Add new tracker template sandbox.
Stefan Seefeld <stefan@seefeld.name>
parents:
diff changeset
289 # May users view other user information? Comment these lines out
115e9883311e Add new tracker template sandbox.
Stefan Seefeld <stefan@seefeld.name>
parents:
diff changeset
290 # if you don't want them to
115e9883311e Add new tracker template sandbox.
Stefan Seefeld <stefan@seefeld.name>
parents:
diff changeset
291 db.security.addPermissionToRole('User', 'View', 'user')
115e9883311e Add new tracker template sandbox.
Stefan Seefeld <stefan@seefeld.name>
parents:
diff changeset
292 db.security.addPermissionToRole('Developer', 'View', 'user')
115e9883311e Add new tracker template sandbox.
Stefan Seefeld <stefan@seefeld.name>
parents:
diff changeset
293 db.security.addPermissionToRole('Coordinator', 'View', 'user')
115e9883311e Add new tracker template sandbox.
Stefan Seefeld <stefan@seefeld.name>
parents:
diff changeset
294
115e9883311e Add new tracker template sandbox.
Stefan Seefeld <stefan@seefeld.name>
parents:
diff changeset
295 # Allow Coordinator to edit any user, including their roles.
115e9883311e Add new tracker template sandbox.
Stefan Seefeld <stefan@seefeld.name>
parents:
diff changeset
296 db.security.addPermissionToRole('Coordinator', 'Edit', 'user')
115e9883311e Add new tracker template sandbox.
Stefan Seefeld <stefan@seefeld.name>
parents:
diff changeset
297 db.security.addPermissionToRole('Coordinator', 'Web Roles')
115e9883311e Add new tracker template sandbox.
Stefan Seefeld <stefan@seefeld.name>
parents:
diff changeset
298
115e9883311e Add new tracker template sandbox.
Stefan Seefeld <stefan@seefeld.name>
parents:
diff changeset
299 # Users should be able to edit their own details -- this permission is
115e9883311e Add new tracker template sandbox.
Stefan Seefeld <stefan@seefeld.name>
parents:
diff changeset
300 # limited to only the situation where the Viewed or Edited item is their own.
115e9883311e Add new tracker template sandbox.
Stefan Seefeld <stefan@seefeld.name>
parents:
diff changeset
301 def own_record(db, userid, itemid):
115e9883311e Add new tracker template sandbox.
Stefan Seefeld <stefan@seefeld.name>
parents:
diff changeset
302 '''Determine whether the userid matches the item being accessed.'''
115e9883311e Add new tracker template sandbox.
Stefan Seefeld <stefan@seefeld.name>
parents:
diff changeset
303 return userid == itemid
115e9883311e Add new tracker template sandbox.
Stefan Seefeld <stefan@seefeld.name>
parents:
diff changeset
304 p = db.security.addPermission(name='View', klass='user', check=own_record,
115e9883311e Add new tracker template sandbox.
Stefan Seefeld <stefan@seefeld.name>
parents:
diff changeset
305 description="User is allowed to view their own user details")
115e9883311e Add new tracker template sandbox.
Stefan Seefeld <stefan@seefeld.name>
parents:
diff changeset
306 for r in 'User', 'Developer', 'Coordinator':
115e9883311e Add new tracker template sandbox.
Stefan Seefeld <stefan@seefeld.name>
parents:
diff changeset
307 db.security.addPermissionToRole(r, p)
115e9883311e Add new tracker template sandbox.
Stefan Seefeld <stefan@seefeld.name>
parents:
diff changeset
308 p = db.security.addPermission(name='Edit', klass='user', check=own_record,
115e9883311e Add new tracker template sandbox.
Stefan Seefeld <stefan@seefeld.name>
parents:
diff changeset
309 description="User is allowed to edit their own user details",
115e9883311e Add new tracker template sandbox.
Stefan Seefeld <stefan@seefeld.name>
parents:
diff changeset
310 properties=('username', 'password',
115e9883311e Add new tracker template sandbox.
Stefan Seefeld <stefan@seefeld.name>
parents:
diff changeset
311 'address', 'realname',
115e9883311e Add new tracker template sandbox.
Stefan Seefeld <stefan@seefeld.name>
parents:
diff changeset
312 'phone', 'organization',
115e9883311e Add new tracker template sandbox.
Stefan Seefeld <stefan@seefeld.name>
parents:
diff changeset
313 'alternate_addresses',
115e9883311e Add new tracker template sandbox.
Stefan Seefeld <stefan@seefeld.name>
parents:
diff changeset
314 'queries',
115e9883311e Add new tracker template sandbox.
Stefan Seefeld <stefan@seefeld.name>
parents:
diff changeset
315 'timezone')) # Note: 'roles' excluded - users should not be able to edit their own roles.
115e9883311e Add new tracker template sandbox.
Stefan Seefeld <stefan@seefeld.name>
parents:
diff changeset
316 for r in 'User', 'Developer':
115e9883311e Add new tracker template sandbox.
Stefan Seefeld <stefan@seefeld.name>
parents:
diff changeset
317 db.security.addPermissionToRole(r, p)
115e9883311e Add new tracker template sandbox.
Stefan Seefeld <stefan@seefeld.name>
parents:
diff changeset
318
115e9883311e Add new tracker template sandbox.
Stefan Seefeld <stefan@seefeld.name>
parents:
diff changeset
319 # Users should be able to edit and view their own queries. They should also
115e9883311e Add new tracker template sandbox.
Stefan Seefeld <stefan@seefeld.name>
parents:
diff changeset
320 # be able to view any marked as not private. They should not be able to
115e9883311e Add new tracker template sandbox.
Stefan Seefeld <stefan@seefeld.name>
parents:
diff changeset
321 # edit others' queries, even if they're not private
115e9883311e Add new tracker template sandbox.
Stefan Seefeld <stefan@seefeld.name>
parents:
diff changeset
322 def view_query(db, userid, itemid):
115e9883311e Add new tracker template sandbox.
Stefan Seefeld <stefan@seefeld.name>
parents:
diff changeset
323 private_for = db.query.get(itemid, 'private_for')
115e9883311e Add new tracker template sandbox.
Stefan Seefeld <stefan@seefeld.name>
parents:
diff changeset
324 if not private_for: return True
115e9883311e Add new tracker template sandbox.
Stefan Seefeld <stefan@seefeld.name>
parents:
diff changeset
325 return userid == private_for
115e9883311e Add new tracker template sandbox.
Stefan Seefeld <stefan@seefeld.name>
parents:
diff changeset
326 def edit_query(db, userid, itemid):
115e9883311e Add new tracker template sandbox.
Stefan Seefeld <stefan@seefeld.name>
parents:
diff changeset
327 return userid == db.query.get(itemid, 'creator')
115e9883311e Add new tracker template sandbox.
Stefan Seefeld <stefan@seefeld.name>
parents:
diff changeset
328 p = db.security.addPermission(name='View', klass='query', check=view_query,
115e9883311e Add new tracker template sandbox.
Stefan Seefeld <stefan@seefeld.name>
parents:
diff changeset
329 description="User is allowed to view their own and public queries")
115e9883311e Add new tracker template sandbox.
Stefan Seefeld <stefan@seefeld.name>
parents:
diff changeset
330 for r in 'User', 'Developer', 'Coordinator':
115e9883311e Add new tracker template sandbox.
Stefan Seefeld <stefan@seefeld.name>
parents:
diff changeset
331 db.security.addPermissionToRole(r, p)
115e9883311e Add new tracker template sandbox.
Stefan Seefeld <stefan@seefeld.name>
parents:
diff changeset
332 p = db.security.addPermission(name='Edit', klass='query', check=edit_query,
115e9883311e Add new tracker template sandbox.
Stefan Seefeld <stefan@seefeld.name>
parents:
diff changeset
333 description="User is allowed to edit their queries")
115e9883311e Add new tracker template sandbox.
Stefan Seefeld <stefan@seefeld.name>
parents:
diff changeset
334 for r in 'User', 'Developer', 'Coordinator':
115e9883311e Add new tracker template sandbox.
Stefan Seefeld <stefan@seefeld.name>
parents:
diff changeset
335 db.security.addPermissionToRole(r, p)
115e9883311e Add new tracker template sandbox.
Stefan Seefeld <stefan@seefeld.name>
parents:
diff changeset
336 p = db.security.addPermission(name='Create', klass='query',
115e9883311e Add new tracker template sandbox.
Stefan Seefeld <stefan@seefeld.name>
parents:
diff changeset
337 description="User is allowed to create queries")
115e9883311e Add new tracker template sandbox.
Stefan Seefeld <stefan@seefeld.name>
parents:
diff changeset
338 for r in 'User', 'Developer', 'Coordinator':
115e9883311e Add new tracker template sandbox.
Stefan Seefeld <stefan@seefeld.name>
parents:
diff changeset
339 db.security.addPermissionToRole(r, p)
115e9883311e Add new tracker template sandbox.
Stefan Seefeld <stefan@seefeld.name>
parents:
diff changeset
340
115e9883311e Add new tracker template sandbox.
Stefan Seefeld <stefan@seefeld.name>
parents:
diff changeset
341
115e9883311e Add new tracker template sandbox.
Stefan Seefeld <stefan@seefeld.name>
parents:
diff changeset
342 #
115e9883311e Add new tracker template sandbox.
Stefan Seefeld <stefan@seefeld.name>
parents:
diff changeset
343 # ANONYMOUS USER PERMISSIONS
115e9883311e Add new tracker template sandbox.
Stefan Seefeld <stefan@seefeld.name>
parents:
diff changeset
344 #
115e9883311e Add new tracker template sandbox.
Stefan Seefeld <stefan@seefeld.name>
parents:
diff changeset
345 # Let anonymous users access the web interface. Note that almost all
115e9883311e Add new tracker template sandbox.
Stefan Seefeld <stefan@seefeld.name>
parents:
diff changeset
346 # trackers will need this Permission. The only situation where it's not
115e9883311e Add new tracker template sandbox.
Stefan Seefeld <stefan@seefeld.name>
parents:
diff changeset
347 # required is in a tracker that uses an HTTP Basic Authenticated front-end.
115e9883311e Add new tracker template sandbox.
Stefan Seefeld <stefan@seefeld.name>
parents:
diff changeset
348 db.security.addPermissionToRole('Anonymous', 'Web Access')
115e9883311e Add new tracker template sandbox.
Stefan Seefeld <stefan@seefeld.name>
parents:
diff changeset
349
115e9883311e Add new tracker template sandbox.
Stefan Seefeld <stefan@seefeld.name>
parents:
diff changeset
350 # Let anonymous users access the email interface (note that this implies
115e9883311e Add new tracker template sandbox.
Stefan Seefeld <stefan@seefeld.name>
parents:
diff changeset
351 # that they will be registered automatically, hence they will need the
115e9883311e Add new tracker template sandbox.
Stefan Seefeld <stefan@seefeld.name>
parents:
diff changeset
352 # "Create" user Permission below)
115e9883311e Add new tracker template sandbox.
Stefan Seefeld <stefan@seefeld.name>
parents:
diff changeset
353 # This is disabled by default to stop spam from auto-registering users on
115e9883311e Add new tracker template sandbox.
Stefan Seefeld <stefan@seefeld.name>
parents:
diff changeset
354 # public trackers.
115e9883311e Add new tracker template sandbox.
Stefan Seefeld <stefan@seefeld.name>
parents:
diff changeset
355 #db.security.addPermissionToRole('Anonymous', 'Email Access')
115e9883311e Add new tracker template sandbox.
Stefan Seefeld <stefan@seefeld.name>
parents:
diff changeset
356
115e9883311e Add new tracker template sandbox.
Stefan Seefeld <stefan@seefeld.name>
parents:
diff changeset
357 # Assign the appropriate permissions to the anonymous user's Anonymous
115e9883311e Add new tracker template sandbox.
Stefan Seefeld <stefan@seefeld.name>
parents:
diff changeset
358 # Role. Choices here are:
115e9883311e Add new tracker template sandbox.
Stefan Seefeld <stefan@seefeld.name>
parents:
diff changeset
359 # - Allow anonymous users to register
115e9883311e Add new tracker template sandbox.
Stefan Seefeld <stefan@seefeld.name>
parents:
diff changeset
360 db.security.addPermissionToRole('Anonymous', 'Create', 'user')
115e9883311e Add new tracker template sandbox.
Stefan Seefeld <stefan@seefeld.name>
parents:
diff changeset
361
115e9883311e Add new tracker template sandbox.
Stefan Seefeld <stefan@seefeld.name>
parents:
diff changeset
362 # Allow anonymous users access to view issues (and the related, linked
115e9883311e Add new tracker template sandbox.
Stefan Seefeld <stefan@seefeld.name>
parents:
diff changeset
363 # information).
115e9883311e Add new tracker template sandbox.
Stefan Seefeld <stefan@seefeld.name>
parents:
diff changeset
364
115e9883311e Add new tracker template sandbox.
Stefan Seefeld <stefan@seefeld.name>
parents:
diff changeset
365 for cl in 'bug', 'task', 'milestone', 'severity', 'status', 'resolution', 'msg', 'file':
115e9883311e Add new tracker template sandbox.
Stefan Seefeld <stefan@seefeld.name>
parents:
diff changeset
366 db.security.addPermissionToRole('Anonymous', 'View', cl)
115e9883311e Add new tracker template sandbox.
Stefan Seefeld <stefan@seefeld.name>
parents:
diff changeset
367
115e9883311e Add new tracker template sandbox.
Stefan Seefeld <stefan@seefeld.name>
parents:
diff changeset
368 # [OPTIONAL]
115e9883311e Add new tracker template sandbox.
Stefan Seefeld <stefan@seefeld.name>
parents:
diff changeset
369 # Allow anonymous users access to create or edit "issue" items (and the
115e9883311e Add new tracker template sandbox.
Stefan Seefeld <stefan@seefeld.name>
parents:
diff changeset
370 # related file and message items)
115e9883311e Add new tracker template sandbox.
Stefan Seefeld <stefan@seefeld.name>
parents:
diff changeset
371 #for cl in 'issue', 'file', 'msg':
115e9883311e Add new tracker template sandbox.
Stefan Seefeld <stefan@seefeld.name>
parents:
diff changeset
372 # db.security.addPermissionToRole('Anonymous', 'Create', cl)
115e9883311e Add new tracker template sandbox.
Stefan Seefeld <stefan@seefeld.name>
parents:
diff changeset
373 # db.security.addPermissionToRole('Anonymous', 'Edit', cl)
115e9883311e Add new tracker template sandbox.
Stefan Seefeld <stefan@seefeld.name>
parents:
diff changeset
374
115e9883311e Add new tracker template sandbox.
Stefan Seefeld <stefan@seefeld.name>
parents:
diff changeset
375
115e9883311e Add new tracker template sandbox.
Stefan Seefeld <stefan@seefeld.name>
parents:
diff changeset
376 # vim: set filetype=python sts=4 sw=4 et si :
115e9883311e Add new tracker template sandbox.
Stefan Seefeld <stefan@seefeld.name>
parents:
diff changeset
377
Roundup Issue Tracker: http://roundup-tracker.org/