Mercurial > p > roundup > code

annotate roundup/templates/minimal/dbinit.py @ 1562:b975da59cd11

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
handle invalid data input in forms better
author Richard Jones <richard@users.sourceforge.net>
date Wed, 26 Mar 2003 06:46:17 +0000
parents 5a44e8cf1a62
children
Ignore whitespace changes - Everywhere: Within whitespace: At end of lines:
rev   line source
1226
0ef27b438916 adding the "minimal" template
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
1 #
0ef27b438916 adding the "minimal" template
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
2 # Copyright (c) 2001 Bizar Software Pty Ltd (http://www.bizarsoftware.com.au/)
0ef27b438916 adding the "minimal" template
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
3 # This module is free software, and you may redistribute it and/or modify
0ef27b438916 adding the "minimal" template
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
4 # under the same terms as Python, so long as this copyright message and
0ef27b438916 adding the "minimal" template
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
5 # disclaimer are retained in their original form.
0ef27b438916 adding the "minimal" template
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
6 #
0ef27b438916 adding the "minimal" template
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
7 # IN NO EVENT SHALL BIZAR SOFTWARE PTY LTD BE LIABLE TO ANY PARTY FOR
0ef27b438916 adding the "minimal" template
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
8 # DIRECT, INDIRECT, SPECIAL, INCIDENTAL, OR CONSEQUENTIAL DAMAGES ARISING
0ef27b438916 adding the "minimal" template
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
0ef27b438916 adding the "minimal" template
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
10 # POSSIBILITY OF SUCH DAMAGE.
0ef27b438916 adding the "minimal" template
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
11 #
0ef27b438916 adding the "minimal" template
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
12 # BIZAR SOFTWARE PTY LTD SPECIFICALLY DISCLAIMS ANY WARRANTIES, INCLUDING,
0ef27b438916 adding the "minimal" template
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
13 # BUT NOT LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS
0ef27b438916 adding the "minimal" template
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
14 # FOR A PARTICULAR PURPOSE. THE CODE PROVIDED HEREUNDER IS ON AN "AS IS"
0ef27b438916 adding the "minimal" template
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
15 # BASIS, AND THERE IS NO OBLIGATION WHATSOEVER TO PROVIDE MAINTENANCE,
0ef27b438916 adding the "minimal" template
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
16 # SUPPORT, UPDATES, ENHANCEMENTS, OR MODIFICATIONS.
0ef27b438916 adding the "minimal" template
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
17 #
1260
5a44e8cf1a62 shipped templates didn't import all hyperdb types in dbinit.py
Richard Jones <richard@users.sourceforge.net>
parents: 1235
diff changeset
18 # $Id: dbinit.py,v 1.3 2002-10-10 07:17:39 richard Exp $
1226
0ef27b438916 adding the "minimal" template
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
19
0ef27b438916 adding the "minimal" template
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
20 import os
0ef27b438916 adding the "minimal" template
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
21
0ef27b438916 adding the "minimal" template
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
22 import config
0ef27b438916 adding the "minimal" template
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
23 from select_db import Database, Class, FileClass, IssueClass
0ef27b438916 adding the "minimal" template
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
24
0ef27b438916 adding the "minimal" template
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
25 def open(name=None):
0ef27b438916 adding the "minimal" template
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
26 ''' as from the roundupdb method openDB
0ef27b438916 adding the "minimal" template
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
27 '''
0ef27b438916 adding the "minimal" template
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
28 from roundup.hyperdb import String, Password, Date, Link, Multilink
1260
5a44e8cf1a62 shipped templates didn't import all hyperdb types in dbinit.py
Richard Jones <richard@users.sourceforge.net>
parents: 1235
diff changeset
29 from roundup.hyperdb import Interval, Boolean, Number
1226
0ef27b438916 adding the "minimal" template
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
30
0ef27b438916 adding the "minimal" template
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
31 # open the database
0ef27b438916 adding the "minimal" template
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
32 db = Database(config, name)
0ef27b438916 adding the "minimal" template
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
33
0ef27b438916 adding the "minimal" template
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
34 #
0ef27b438916 adding the "minimal" template
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
35 # Now initialise the schema. Must do this each time the database is
0ef27b438916 adding the "minimal" template
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
36 # opened.
0ef27b438916 adding the "minimal" template
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
37 #
0ef27b438916 adding the "minimal" template
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
38
0ef27b438916 adding the "minimal" template
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
39 # The "Minimal" template gets only one class, the required "user"
0ef27b438916 adding the "minimal" template
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
40 # class. That's it. And even that has the bare minimum of properties.
0ef27b438916 adding the "minimal" template
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
41
0ef27b438916 adding the "minimal" template
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
42 # Note: roles is a comma-separated string of Role names
0ef27b438916 adding the "minimal" template
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
43 user = Class(db, "user", username=String(), password=Password(),
0ef27b438916 adding the "minimal" template
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
44 address=String(), alternate_addresses=String(), roles=String())
0ef27b438916 adding the "minimal" template
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
45 user.setkey("username")
0ef27b438916 adding the "minimal" template
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
46
1235
7441653e5330 added hook for external password validation, and some more docco
Richard Jones <richard@users.sourceforge.net>
parents: 1226
diff changeset
47 # add any additional database schema configuration here
7441653e5330 added hook for external password validation, and some more docco
Richard Jones <richard@users.sourceforge.net>
parents: 1226
diff changeset
48
1226
0ef27b438916 adding the "minimal" template
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
49 #
0ef27b438916 adding the "minimal" template
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
50 # SECURITY SETTINGS
0ef27b438916 adding the "minimal" template
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
51 #
0ef27b438916 adding the "minimal" template
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
52 # new permissions for this schema
0ef27b438916 adding the "minimal" template
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
53 for cl in ('user', ):
0ef27b438916 adding the "minimal" template
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
54 db.security.addPermission(name="Edit", klass=cl,
0ef27b438916 adding the "minimal" template
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
55 description="User is allowed to edit "+cl)
0ef27b438916 adding the "minimal" template
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
56 db.security.addPermission(name="View", klass=cl,
0ef27b438916 adding the "minimal" template
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
57 description="User is allowed to access "+cl)
0ef27b438916 adding the "minimal" template
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
58
0ef27b438916 adding the "minimal" template
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
59 # and give the regular users access to the web and email interface
0ef27b438916 adding the "minimal" template
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
60 p = db.security.getPermission('Web Access')
0ef27b438916 adding the "minimal" template
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
61 db.security.addPermissionToRole('User', p)
0ef27b438916 adding the "minimal" template
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
62 p = db.security.getPermission('Email Access')
0ef27b438916 adding the "minimal" template
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
63 db.security.addPermissionToRole('User', p)
0ef27b438916 adding the "minimal" template
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
64
0ef27b438916 adding the "minimal" template
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
65 # May users view other user information? Comment these lines out
0ef27b438916 adding the "minimal" template
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
66 # if you don't want them to
0ef27b438916 adding the "minimal" template
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
67 p = db.security.getPermission('View', 'user')
0ef27b438916 adding the "minimal" template
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
68 db.security.addPermissionToRole('User', p)
0ef27b438916 adding the "minimal" template
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
69
0ef27b438916 adding the "minimal" template
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
70 # Assign the appropriate permissions to the anonymous user's Anonymous
0ef27b438916 adding the "minimal" template
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
71 # Role. Choices here are:
0ef27b438916 adding the "minimal" template
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
72 # - Allow anonymous users to register through the web
0ef27b438916 adding the "minimal" template
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
73 p = db.security.getPermission('Web Registration')
0ef27b438916 adding the "minimal" template
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
74 db.security.addPermissionToRole('Anonymous', p)
0ef27b438916 adding the "minimal" template
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
75 # - Allow anonymous (new) users to register through the email gateway
0ef27b438916 adding the "minimal" template
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
76 p = db.security.getPermission('Email Registration')
0ef27b438916 adding the "minimal" template
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
77 db.security.addPermissionToRole('Anonymous', p)
0ef27b438916 adding the "minimal" template
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
78
0ef27b438916 adding the "minimal" template
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
79 import detectors
0ef27b438916 adding the "minimal" template
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
80 detectors.init(db)
0ef27b438916 adding the "minimal" template
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
81
0ef27b438916 adding the "minimal" template
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
82 # schema is set up - run any post-initialisation
0ef27b438916 adding the "minimal" template
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
83 db.post_init()
0ef27b438916 adding the "minimal" template
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
84 return db
0ef27b438916 adding the "minimal" template
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
85
0ef27b438916 adding the "minimal" template
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
86 def init(adminpw):
0ef27b438916 adding the "minimal" template
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
87 ''' as from the roundupdb method initDB
0ef27b438916 adding the "minimal" template
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
88
0ef27b438916 adding the "minimal" template
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
89 Open the new database, and add new nodes - used for initialisation. You
0ef27b438916 adding the "minimal" template
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
90 can edit this before running the "roundup-admin initialise" command to
0ef27b438916 adding the "minimal" template
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
91 change the initial database entries.
0ef27b438916 adding the "minimal" template
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
92 '''
0ef27b438916 adding the "minimal" template
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
93 dbdir = os.path.join(config.DATABASE, 'files')
0ef27b438916 adding the "minimal" template
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
94 if not os.path.isdir(dbdir):
0ef27b438916 adding the "minimal" template
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
95 os.makedirs(dbdir)
0ef27b438916 adding the "minimal" template
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
96
0ef27b438916 adding the "minimal" template
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
97 db = open("admin")
0ef27b438916 adding the "minimal" template
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
98 db.clear()
0ef27b438916 adding the "minimal" template
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
99
0ef27b438916 adding the "minimal" template
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
100 # create the two default users
0ef27b438916 adding the "minimal" template
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
101 user = db.getclass('user')
0ef27b438916 adding the "minimal" template
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
102 user.create(username="admin", password=adminpw,
0ef27b438916 adding the "minimal" template
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
103 address=config.ADMIN_EMAIL, roles='Admin')
0ef27b438916 adding the "minimal" template
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
104 user.create(username="anonymous", roles='Anonymous')
0ef27b438916 adding the "minimal" template
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
105
1235
7441653e5330 added hook for external password validation, and some more docco
Richard Jones <richard@users.sourceforge.net>
parents: 1226
diff changeset
106 # add any additional database create steps here - but only if you
7441653e5330 added hook for external password validation, and some more docco
Richard Jones <richard@users.sourceforge.net>
parents: 1226
diff changeset
107 # haven't initialised the database with the admin "initialise" command
7441653e5330 added hook for external password validation, and some more docco
Richard Jones <richard@users.sourceforge.net>
parents: 1226
diff changeset
108
1226
0ef27b438916 adding the "minimal" template
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
109 db.commit()
0ef27b438916 adding the "minimal" template
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
110
0ef27b438916 adding the "minimal" template
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
111 # vim: set filetype=python ts=4 sw=4 et si
0ef27b438916 adding the "minimal" template
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
112
Roundup Issue Tracker: http://roundup-tracker.org/