ac7c6549e1a0f0ea44c9f91fa4487f70c102656c
1 # $Id: dbinit.py,v 1.5 2001-07-23 23:20:35 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 storagelocator must be the directory the __init__.py file is in
29 - os.path.split(__file__)[0] gives us that I think
30 '''
31 from roundup.hyperdb import String, Date, Link, Multilink
33 # open the database
34 db = Database(instance_config.DATABASE, name)
36 # Now initialise the schema. Must do this each time.
37 pri = Class(db, "priority",
38 name=String(), order=String())
39 pri.setkey("name")
41 stat = Class(db, "status",
42 name=String(), order=String())
43 stat.setkey("name")
45 keywords = Class(db, "keyword",
46 name=String())
48 user = Class(db, "user",
49 username=String(), password=String(),
50 address=String(), realname=String(),
51 phone=String(), organisation=String())
52 user.setkey("username")
54 msg = FileClass(db, "msg",
55 author=Link("user"), recipients=Multilink("user"),
56 date=Date(), summary=String(),
57 files=Multilink("file"))
59 file = FileClass(db, "file",
60 name=String(), type=String())
62 # bugs and support calls etc
63 rate = Class(db, "rate",
64 name=String(), order=String())
65 rate.setkey("name")
67 source = Class(db, "source",
68 name=String(), order=String())
69 source.setkey("name")
71 platform = Class(db, "platform",
72 name=String(), order=String())
73 platform.setkey("name")
75 product = Class(db, "product",
76 name=String(), order=String())
77 product.setkey("name")
79 timelog = Class(db, "timelog",
80 date=Date(), time=String(),
81 performedby=Link("user"), description=String())
83 issue = IssueClass(db, "issue",
84 assignedto=Link("user"), priority=Link("priority"),
85 status=Link("status"), rate=Link("rate"),
86 source=Link("source"), product=Link("product"),
87 platform=Multilink("platform"), version=String(),
88 timelog=Multilink("timelog"), customername=String())
89 issue.setkey('title')
91 import detectors
92 detectors.init(db)
94 return db
96 def init(adminpw):
97 ''' as from the roundupdb method initDB
99 storagelocator must be the directory the __init__.py file is in
100 - os.path.split(__file__)[0] gives us that I think
102 Open the new database, and set up a bunch of attributes.
104 '''
105 dbdir = os.path.join(instance_config.DATABASE, 'files')
106 if not os.path.isdir(dbdir):
107 os.makedirs(dbdir)
109 db = open("admin")
110 db.clear()
112 pri = db.getclass('priority')
113 pri.create(name="fatal-bug", order="1")
114 pri.create(name="bug", order="2")
115 pri.create(name="usability", order="3")
116 pri.create(name="feature", order="4")
117 pri.create(name="support", order="5")
119 stat = db.getclass('status')
120 stat.create(name="unread", order="1")
121 stat.create(name="deferred", order="2")
122 stat.create(name="chatting", order="3")
123 stat.create(name="need-eg", order="4")
124 stat.create(name="in-progress", order="5")
125 stat.create(name="testing", order="6")
126 stat.create(name="done-cbb", order="7")
127 stat.create(name="resolved", order="8")
129 rate = db.getclass("rate")
130 rate.create(name='basic', order="1")
131 rate.create(name='premium', order="2")
132 rate.create(name='internal', order="3")
134 source = db.getclass("source")
135 source.create(name='phone', order="1")
136 source.create(name='e-mail', order="2")
137 source.create(name='internal', order="3")
138 source.create(name='internal-qa', order="4")
140 platform = db.getclass("platform")
141 platform.create(name='linux', order="1")
142 platform.create(name='windows', order="2")
143 platform.create(name='mac', order="3")
145 product = db.getclass("product")
146 product.create(name='Bizar Shop', order="1")
147 product.create(name='Bizar Shop Developer', order="2")
148 product.create(name='Bizar Shop Manual', order="3")
149 product.create(name='Bizar Shop Developer Manual', order="4")
151 user = db.getclass('user')
152 user.create(username="admin", password=adminpw,
153 address=instance_config.ADMIN_EMAIL)
155 db.close()
157 #
158 # $Log: not supported by cvs2svn $
159 # Revision 1.4 2001/07/23 08:45:28 richard
160 # ok, so now "./roundup-admin init" will ask questions in an attempt to get a
161 # workable instance_home set up :)
162 # _and_ anydbm has had its first test :)
163 #
164 # Revision 1.3 2001/07/23 07:14:41 richard
165 # Moved the database backends off into backends.
166 #
167 # Revision 1.2 2001/07/23 06:25:50 richard
168 # relfected the move to roundup/backends
169 #
170 # Revision 1.1 2001/07/23 04:33:21 anthonybaxter
171 # split __init__.py into 2. dbinit and instance_config.
172 #
173 # Revision 1.1 2001/07/23 03:50:46 anthonybaxter
174 # moved templates to proper location
175 #
176 # Revision 1.2 2001/07/22 12:09:32 richard
177 # Final commit of Grande Splite
178 #
179 #