Mercurial > p > roundup > code

annotate templates/classic/dbinit.py @ 2119:cc4667ef3f12

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Added the ability to toggle where error messages go. They either go to the user (default, for backwards compatibility), the dispatcher, or both. These are able to be toggled via settings in config.py. Please refer to upgrading.txt for more details. (And Richard, let me know if I've done anything wrong with this checkin. :))
author Eddie Parker <eparker@users.sourceforge.net>
date Thu, 25 Mar 2004 19:27:15 +0000
parents 8e13768d02af
children ee3cf6a44f29
Ignore whitespace changes - Everywhere: Within whitespace: At end of lines:
rev   line source
1591
21312a7564fd moving templates around
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
1 #
21312a7564fd moving templates around
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
2 # Copyright (c) 2001 Bizar Software Pty Ltd (http://www.bizarsoftware.com.au/)
21312a7564fd moving templates around
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
3 # This module is free software, and you may redistribute it and/or modify
21312a7564fd moving templates around
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
4 # under the same terms as Python, so long as this copyright message and
21312a7564fd moving templates around
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
5 # disclaimer are retained in their original form.
21312a7564fd moving templates around
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
6 #
21312a7564fd moving templates around
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
7 # IN NO EVENT SHALL BIZAR SOFTWARE PTY LTD BE LIABLE TO ANY PARTY FOR
21312a7564fd moving templates around
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
8 # DIRECT, INDIRECT, SPECIAL, INCIDENTAL, OR CONSEQUENTIAL DAMAGES ARISING
21312a7564fd moving templates around
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
9 # OUT OF THE USE OF THIS CODE, EVEN IF THE AUTHOR HAS BEEN ADVISED OF THE
21312a7564fd moving templates around
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
10 # POSSIBILITY OF SUCH DAMAGE.
21312a7564fd moving templates around
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
11 #
21312a7564fd moving templates around
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
12 # BIZAR SOFTWARE PTY LTD SPECIFICALLY DISCLAIMS ANY WARRANTIES, INCLUDING,
21312a7564fd moving templates around
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
13 # BUT NOT LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS
21312a7564fd moving templates around
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
14 # FOR A PARTICULAR PURPOSE. THE CODE PROVIDED HEREUNDER IS ON AN "AS IS"
21312a7564fd moving templates around
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
15 # BASIS, AND THERE IS NO OBLIGATION WHATSOEVER TO PROVIDE MAINTENANCE,
21312a7564fd moving templates around
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
16 # SUPPORT, UPDATES, ENHANCEMENTS, OR MODIFICATIONS.
21312a7564fd moving templates around
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
17 #
2078
8e13768d02af permission fix for anonymous
Richard Jones <richard@users.sourceforge.net>
parents: 2077
diff changeset
18 # $Id: dbinit.py,v 1.6 2004-03-15 05:51:23 richard Exp $
1591
21312a7564fd moving templates around
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
19
21312a7564fd moving templates around
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
20 import os
21312a7564fd moving templates around
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
21
21312a7564fd moving templates around
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
22 import config
21312a7564fd moving templates around
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
23 from select_db import Database, Class, FileClass, IssueClass
21312a7564fd moving templates around
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
24
21312a7564fd moving templates around
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
25 def open(name=None):
21312a7564fd moving templates around
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
26 ''' as from the roundupdb method openDB
21312a7564fd moving templates around
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
27 '''
21312a7564fd moving templates around
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
28 from roundup.hyperdb import String, Password, Date, Link, Multilink
21312a7564fd moving templates around
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
29 from roundup.hyperdb import Interval, Boolean, Number
21312a7564fd moving templates around
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
30
21312a7564fd moving templates around
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
31 # open the database
21312a7564fd moving templates around
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
32 db = Database(config, name)
21312a7564fd moving templates around
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
33
21312a7564fd moving templates around
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
34 #
21312a7564fd moving templates around
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
35 # Now initialise the schema. Must do this each time the database is
21312a7564fd moving templates around
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
36 # opened.
21312a7564fd moving templates around
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
37 #
21312a7564fd moving templates around
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
38
21312a7564fd moving templates around
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
39 # Class automatically gets these properties:
21312a7564fd moving templates around
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
40 # creation = Date()
21312a7564fd moving templates around
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
41 # activity = Date()
21312a7564fd moving templates around
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
42 # creator = Link('user')
21312a7564fd moving templates around
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
43 pri = Class(db, "priority",
21312a7564fd moving templates around
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
44 name=String(), order=String())
21312a7564fd moving templates around
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
45 pri.setkey("name")
21312a7564fd moving templates around
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
46
21312a7564fd moving templates around
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
47 stat = Class(db, "status",
21312a7564fd moving templates around
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
48 name=String(), order=String())
21312a7564fd moving templates around
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
49 stat.setkey("name")
21312a7564fd moving templates around
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
50
21312a7564fd moving templates around
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
51 keyword = Class(db, "keyword",
21312a7564fd moving templates around
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
52 name=String())
21312a7564fd moving templates around
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
53 keyword.setkey("name")
21312a7564fd moving templates around
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
54
21312a7564fd moving templates around
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
55 query = Class(db, "query",
21312a7564fd moving templates around
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
56 klass=String(), name=String(),
21312a7564fd moving templates around
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
57 url=String())
21312a7564fd moving templates around
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
58 query.setkey("name")
21312a7564fd moving templates around
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
59
21312a7564fd moving templates around
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
60 # add any additional database schema configuration here
21312a7564fd moving templates around
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
61
21312a7564fd moving templates around
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
62 # Note: roles is a comma-separated string of Role names
21312a7564fd moving templates around
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
63 user = Class(db, "user",
21312a7564fd moving templates around
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
64 username=String(), password=Password(),
21312a7564fd moving templates around
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
65 address=String(), realname=String(),
21312a7564fd moving templates around
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
66 phone=String(), organisation=String(),
21312a7564fd moving templates around
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
67 alternate_addresses=String(),
21312a7564fd moving templates around
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
68 queries=Multilink('query'), roles=String(),
21312a7564fd moving templates around
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
69 timezone=String())
21312a7564fd moving templates around
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
70 user.setkey("username")
21312a7564fd moving templates around
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
71
21312a7564fd moving templates around
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
72 # FileClass automatically gets these properties:
21312a7564fd moving templates around
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
73 # content = String() [saved to disk in <tracker home>/db/files/]
21312a7564fd moving templates around
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
74 # (it also gets the Class properties creation, activity and creator)
21312a7564fd moving templates around
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
75 msg = FileClass(db, "msg",
21312a7564fd moving templates around
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
76 author=Link("user", do_journal='no'),
21312a7564fd moving templates around
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
77 recipients=Multilink("user", do_journal='no'),
21312a7564fd moving templates around
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
78 date=Date(), summary=String(),
21312a7564fd moving templates around
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
79 files=Multilink("file"),
21312a7564fd moving templates around
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
80 messageid=String(), inreplyto=String())
21312a7564fd moving templates around
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
81
21312a7564fd moving templates around
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
82 file = FileClass(db, "file",
21312a7564fd moving templates around
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
83 name=String(), type=String())
21312a7564fd moving templates around
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
84
21312a7564fd moving templates around
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
85 # IssueClass automatically gets these properties:
21312a7564fd moving templates around
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
86 # title = String()
21312a7564fd moving templates around
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
87 # messages = Multilink("msg")
21312a7564fd moving templates around
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
88 # files = Multilink("file")
21312a7564fd moving templates around
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
89 # nosy = Multilink("user")
21312a7564fd moving templates around
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
90 # superseder = Multilink("issue")
21312a7564fd moving templates around
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
91 # (it also gets the Class properties creation, activity and creator)
21312a7564fd moving templates around
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
92 issue = IssueClass(db, "issue",
21312a7564fd moving templates around
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
93 assignedto=Link("user"), topic=Multilink("keyword"),
21312a7564fd moving templates around
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
94 priority=Link("priority"), status=Link("status"))
21312a7564fd moving templates around
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
95
21312a7564fd moving templates around
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
96 #
21312a7564fd moving templates around
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
97 # SECURITY SETTINGS
21312a7564fd moving templates around
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
98 #
21312a7564fd moving templates around
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
99 # See the configuration and customisation document for information
21312a7564fd moving templates around
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
100 # about security setup.
21312a7564fd moving templates around
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
101 # Assign the access and edit Permissions for issue, file and message
21312a7564fd moving templates around
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
102 # to regular users now
21312a7564fd moving templates around
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
103 for cl in 'issue', 'file', 'msg', 'query', 'keyword':
21312a7564fd moving templates around
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
104 p = db.security.getPermission('View', cl)
21312a7564fd moving templates around
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
105 db.security.addPermissionToRole('User', p)
21312a7564fd moving templates around
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
106 p = db.security.getPermission('Edit', cl)
21312a7564fd moving templates around
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
107 db.security.addPermissionToRole('User', p)
2076
2a4309450202 security fixes and doc updates
Richard Jones <richard@users.sourceforge.net>
parents: 1978
diff changeset
108 for cl in 'priority', 'status':
2a4309450202 security fixes and doc updates
Richard Jones <richard@users.sourceforge.net>
parents: 1978
diff changeset
109 p = db.security.getPermission('View', cl)
2077
3e0961d6d44d Added the "actor" property.
Richard Jones <richard@users.sourceforge.net>
parents: 2076
diff changeset
110 db.security.addPermissionToRole('User', p)
1591
21312a7564fd moving templates around
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
111
21312a7564fd moving templates around
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
112 # and give the regular users access to the web and email interface
21312a7564fd moving templates around
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
113 p = db.security.getPermission('Web Access')
21312a7564fd moving templates around
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
114 db.security.addPermissionToRole('User', p)
21312a7564fd moving templates around
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
115 p = db.security.getPermission('Email Access')
21312a7564fd moving templates around
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
116 db.security.addPermissionToRole('User', p)
21312a7564fd moving templates around
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
117
21312a7564fd moving templates around
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
118 # May users view other user information? Comment these lines out
21312a7564fd moving templates around
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
119 # if you don't want them to
21312a7564fd moving templates around
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
120 p = db.security.getPermission('View', 'user')
21312a7564fd moving templates around
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
121 db.security.addPermissionToRole('User', p)
21312a7564fd moving templates around
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
122
21312a7564fd moving templates around
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
123 # Assign the appropriate permissions to the anonymous user's Anonymous
21312a7564fd moving templates around
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
124 # Role. Choices here are:
21312a7564fd moving templates around
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
125 # - Allow anonymous users to register through the web
21312a7564fd moving templates around
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
126 p = db.security.getPermission('Web Registration')
21312a7564fd moving templates around
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
127 db.security.addPermissionToRole('Anonymous', p)
21312a7564fd moving templates around
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
128 # - Allow anonymous (new) users to register through the email gateway
21312a7564fd moving templates around
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
129 p = db.security.getPermission('Email Registration')
21312a7564fd moving templates around
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
130 db.security.addPermissionToRole('Anonymous', p)
1978
eb043e7d0899 changed template to remove duplicate display table...
Richard Jones <richard@users.sourceforge.net>
parents: 1904
diff changeset
131 # - Allow anonymous users access to view issues (which implies being
eb043e7d0899 changed template to remove duplicate display table...
Richard Jones <richard@users.sourceforge.net>
parents: 1904
diff changeset
132 # able to view all linked information too
2078
8e13768d02af permission fix for anonymous
Richard Jones <richard@users.sourceforge.net>
parents: 2077
diff changeset
133 for cl in 'issue', 'file', 'msg', 'keyword', 'priority', 'status':
1978
eb043e7d0899 changed template to remove duplicate display table...
Richard Jones <richard@users.sourceforge.net>
parents: 1904
diff changeset
134 p = db.security.getPermission('View', cl)
eb043e7d0899 changed template to remove duplicate display table...
Richard Jones <richard@users.sourceforge.net>
parents: 1904
diff changeset
135 db.security.addPermissionToRole('Anonymous', p)
1591
21312a7564fd moving templates around
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
136 # - Allow anonymous users access to edit the "issue" class of data
21312a7564fd moving templates around
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
137 # Note: this also grants access to create related information like
21312a7564fd moving templates around
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
138 # files and messages etc that are linked to issues
21312a7564fd moving templates around
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
139 #p = db.security.getPermission('Edit', 'issue')
21312a7564fd moving templates around
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
140 #db.security.addPermissionToRole('Anonymous', p)
21312a7564fd moving templates around
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
141
21312a7564fd moving templates around
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
142 # oh, g'wan, let anonymous access the web interface too
21312a7564fd moving templates around
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
143 p = db.security.getPermission('Web Access')
21312a7564fd moving templates around
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
144 db.security.addPermissionToRole('Anonymous', p)
21312a7564fd moving templates around
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
145
21312a7564fd moving templates around
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
146 import detectors
21312a7564fd moving templates around
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
147 detectors.init(db)
21312a7564fd moving templates around
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
148
21312a7564fd moving templates around
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
149 # schema is set up - run any post-initialisation
21312a7564fd moving templates around
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
150 db.post_init()
21312a7564fd moving templates around
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
151 return db
21312a7564fd moving templates around
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
152
21312a7564fd moving templates around
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
153 def init(adminpw):
21312a7564fd moving templates around
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
154 ''' as from the roundupdb method initDB
21312a7564fd moving templates around
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
155
21312a7564fd moving templates around
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
156 Open the new database, and add new nodes - used for initialisation. You
21312a7564fd moving templates around
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
157 can edit this before running the "roundup-admin initialise" command to
21312a7564fd moving templates around
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
158 change the initial database entries.
21312a7564fd moving templates around
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
159 '''
21312a7564fd moving templates around
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
160 dbdir = os.path.join(config.DATABASE, 'files')
21312a7564fd moving templates around
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
161 if not os.path.isdir(dbdir):
21312a7564fd moving templates around
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
162 os.makedirs(dbdir)
21312a7564fd moving templates around
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
163
21312a7564fd moving templates around
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
164 db = open("admin")
21312a7564fd moving templates around
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
165 db.clear()
21312a7564fd moving templates around
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
166
21312a7564fd moving templates around
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
167 #
21312a7564fd moving templates around
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
168 # INITIAL PRIORITY AND STATUS VALUES
21312a7564fd moving templates around
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
169 #
21312a7564fd moving templates around
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
170 pri = db.getclass('priority')
21312a7564fd moving templates around
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
171 pri.create(name="critical", order="1")
21312a7564fd moving templates around
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
172 pri.create(name="urgent", order="2")
21312a7564fd moving templates around
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
173 pri.create(name="bug", order="3")
21312a7564fd moving templates around
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
174 pri.create(name="feature", order="4")
21312a7564fd moving templates around
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
175 pri.create(name="wish", order="5")
21312a7564fd moving templates around
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
176
21312a7564fd moving templates around
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
177 stat = db.getclass('status')
21312a7564fd moving templates around
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
178 stat.create(name="unread", order="1")
21312a7564fd moving templates around
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
179 stat.create(name="deferred", order="2")
21312a7564fd moving templates around
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
180 stat.create(name="chatting", order="3")
21312a7564fd moving templates around
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
181 stat.create(name="need-eg", order="4")
21312a7564fd moving templates around
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
182 stat.create(name="in-progress", order="5")
21312a7564fd moving templates around
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
183 stat.create(name="testing", order="6")
21312a7564fd moving templates around
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
184 stat.create(name="done-cbb", order="7")
21312a7564fd moving templates around
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
185 stat.create(name="resolved", order="8")
21312a7564fd moving templates around
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
186
21312a7564fd moving templates around
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
187 # create the two default users
21312a7564fd moving templates around
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
188 user = db.getclass('user')
21312a7564fd moving templates around
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
189 user.create(username="admin", password=adminpw,
21312a7564fd moving templates around
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
190 address=config.ADMIN_EMAIL, roles='Admin')
21312a7564fd moving templates around
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
191 user.create(username="anonymous", roles='Anonymous')
21312a7564fd moving templates around
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
192
21312a7564fd moving templates around
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
193 # add any additional database create steps here - but only if you
21312a7564fd moving templates around
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
194 # haven't initialised the database with the admin "initialise" command
21312a7564fd moving templates around
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
195
21312a7564fd moving templates around
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
196 db.commit()
1904
9445caec3ff5 more database closing cleanups, finally mysql has no dangling references
Richard Jones <richard@users.sourceforge.net>
parents: 1591
diff changeset
197 db.close()
1591
21312a7564fd moving templates around
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
198
21312a7564fd moving templates around
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
199 # vim: set filetype=python ts=4 sw=4 et si
21312a7564fd moving templates around
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
200
1978
eb043e7d0899 changed template to remove duplicate display table...
Richard Jones <richard@users.sourceforge.net>
parents: 1904
diff changeset
201 #SHA: 92c54c05ba9f59453dc74fa9fdbbae34f7a9c077
Roundup Issue Tracker: http://roundup-tracker.org/