1 # $Id: dbinit.py,v 1.6 2001-07-25 01:23:07 richard Exp $
3 import os
5 import instance_config
6 from roundup import roundupdb
7 import select_db
8 from roundup.roundupdb import Class, FileClass
10 class Database(roundupdb.Database, select_db.Database):
11 ''' Creates a hybrid database from:
12 . the selected database back-end from select_db
13 . the roundup extensions from roundupdb
14 '''
15 pass
17 class IssueClass(roundupdb.IssueClass):
18 ''' issues need the email information
19 '''
20 ISSUE_TRACKER_EMAIL = instance_config.ISSUE_TRACKER_EMAIL
21 ADMIN_EMAIL = instance_config.ADMIN_EMAIL
22 MAILHOST = instance_config.MAILHOST
25 def open(name=None):
26 ''' as from the roundupdb method openDB
28 '''
29 from roundup.hyperdb import String, Date, Link, Multilink
31 # open the database
32 db = Database(instance_config.DATABASE, name)
34 # Now initialise the schema. Must do this each time.
35 pri = Class(db, "priority",
36 name=String(), order=String())
37 pri.setkey("name")
39 stat = Class(db, "status",
40 name=String(), order=String())
41 stat.setkey("name")
43 keywords = Class(db, "keyword",
44 name=String())
46 user = Class(db, "user",
47 username=String(), password=String(),
48 address=String(), realname=String(),
49 phone=String(), organisation=String())
50 user.setkey("username")
52 msg = FileClass(db, "msg",
53 author=Link("user"), recipients=Multilink("user"),
54 date=Date(), summary=String(),
55 files=Multilink("file"))
57 file = FileClass(db, "file",
58 name=String(), type=String())
60 # bugs and support calls etc
61 rate = Class(db, "rate",
62 name=String(), order=String())
63 rate.setkey("name")
65 source = Class(db, "source",
66 name=String(), order=String())
67 source.setkey("name")
69 platform = Class(db, "platform",
70 name=String(), order=String())
71 platform.setkey("name")
73 product = Class(db, "product",
74 name=String(), order=String())
75 product.setkey("name")
77 timelog = Class(db, "timelog",
78 date=Date(), time=String(),
79 performedby=Link("user"), description=String())
81 issue = IssueClass(db, "issue",
82 assignedto=Link("user"), priority=Link("priority"),
83 status=Link("status"), rate=Link("rate"),
84 source=Link("source"), product=Link("product"),
85 platform=Multilink("platform"), version=String(),
86 timelog=Multilink("timelog"), customername=String())
87 issue.setkey('title')
89 import detectors
90 detectors.init(db)
92 return db
94 def init(adminpw):
95 ''' as from the roundupdb method initDB
97 Open the new database, and set up a bunch of attributes.
99 '''
100 dbdir = os.path.join(instance_config.DATABASE, 'files')
101 if not os.path.isdir(dbdir):
102 os.makedirs(dbdir)
104 db = open("admin")
105 db.clear()
107 pri = db.getclass('priority')
108 pri.create(name="fatal-bug", order="1")
109 pri.create(name="bug", order="2")
110 pri.create(name="usability", order="3")
111 pri.create(name="feature", order="4")
112 pri.create(name="support", order="5")
114 stat = db.getclass('status')
115 stat.create(name="unread", order="1")
116 stat.create(name="deferred", order="2")
117 stat.create(name="chatting", order="3")
118 stat.create(name="need-eg", order="4")
119 stat.create(name="in-progress", order="5")
120 stat.create(name="testing", order="6")
121 stat.create(name="done-cbb", order="7")
122 stat.create(name="resolved", order="8")
124 rate = db.getclass("rate")
125 rate.create(name='basic', order="1")
126 rate.create(name='premium', order="2")
127 rate.create(name='internal', order="3")
129 source = db.getclass("source")
130 source.create(name='phone', order="1")
131 source.create(name='e-mail', order="2")
132 source.create(name='internal', order="3")
133 source.create(name='internal-qa', order="4")
135 platform = db.getclass("platform")
136 platform.create(name='linux', order="1")
137 platform.create(name='windows', order="2")
138 platform.create(name='mac', order="3")
140 product = db.getclass("product")
141 product.create(name='Bizar Shop', order="1")
142 product.create(name='Bizar Shop Developer', order="2")
143 product.create(name='Bizar Shop Manual', order="3")
144 product.create(name='Bizar Shop Developer Manual', order="4")
146 user = db.getclass('user')
147 user.create(username="admin", password=adminpw,
148 address=instance_config.ADMIN_EMAIL)
150 db.close()
152 #
153 # $Log: not supported by cvs2svn $
154 # Revision 1.5 2001/07/23 23:20:35 richard
155 # forgot to remove the interfaces from the dbinit module ;)
156 #
157 # Revision 1.4 2001/07/23 08:45:28 richard
158 # ok, so now "./roundup-admin init" will ask questions in an attempt to get a
159 # workable instance_home set up :)
160 # _and_ anydbm has had its first test :)
161 #
162 # Revision 1.3 2001/07/23 07:14:41 richard
163 # Moved the database backends off into backends.
164 #
165 # Revision 1.2 2001/07/23 06:25:50 richard
166 # relfected the move to roundup/backends
167 #
168 # Revision 1.1 2001/07/23 04:33:21 anthonybaxter
169 # split __init__.py into 2. dbinit and instance_config.
170 #
171 # Revision 1.1 2001/07/23 03:50:46 anthonybaxter
172 # moved templates to proper location
173 #
174 # Revision 1.2 2001/07/22 12:09:32 richard
175 # Final commit of Grande Splite
176 #
177 #