Mercurial > p > roundup > code
annotate roundup/templates/extended/dbinit.py @ 36:41e49de57a85
split __init__.py into 2. dbinit and instance_config.
| author | Anthony Baxter <anthonybaxter@users.sourceforge.net> |
|---|---|
| date | Mon, 23 Jul 2001 04:33:21 +0000 |
| parents | |
| children | 4b9ecc926ad7 |
| rev | line source |
|---|---|
|
36
41e49de57a85
split __init__.py into 2. dbinit and instance_config.
Anthony Baxter <anthonybaxter@users.sourceforge.net>
parents:
diff
changeset
|
1 # $Id: dbinit.py,v 1.1 2001-07-23 04:33:21 anthonybaxter Exp $ |
|
41e49de57a85
split __init__.py into 2. dbinit and instance_config.
Anthony Baxter <anthonybaxter@users.sourceforge.net>
parents:
diff
changeset
|
2 |
|
41e49de57a85
split __init__.py into 2. dbinit and instance_config.
Anthony Baxter <anthonybaxter@users.sourceforge.net>
parents:
diff
changeset
|
3 import instance_config |
|
41e49de57a85
split __init__.py into 2. dbinit and instance_config.
Anthony Baxter <anthonybaxter@users.sourceforge.net>
parents:
diff
changeset
|
4 from roundup import hyperdb, hyper_bsddb, roundupdb, cgi_client, mailgw |
|
41e49de57a85
split __init__.py into 2. dbinit and instance_config.
Anthony Baxter <anthonybaxter@users.sourceforge.net>
parents:
diff
changeset
|
5 |
|
41e49de57a85
split __init__.py into 2. dbinit and instance_config.
Anthony Baxter <anthonybaxter@users.sourceforge.net>
parents:
diff
changeset
|
6 from roundup.roundupdb import Class, FileClass |
|
41e49de57a85
split __init__.py into 2. dbinit and instance_config.
Anthony Baxter <anthonybaxter@users.sourceforge.net>
parents:
diff
changeset
|
7 import os |
|
41e49de57a85
split __init__.py into 2. dbinit and instance_config.
Anthony Baxter <anthonybaxter@users.sourceforge.net>
parents:
diff
changeset
|
8 |
|
41e49de57a85
split __init__.py into 2. dbinit and instance_config.
Anthony Baxter <anthonybaxter@users.sourceforge.net>
parents:
diff
changeset
|
9 |
|
41e49de57a85
split __init__.py into 2. dbinit and instance_config.
Anthony Baxter <anthonybaxter@users.sourceforge.net>
parents:
diff
changeset
|
10 class Database(roundupdb.Database, hyper_bsddb.Database): |
|
41e49de57a85
split __init__.py into 2. dbinit and instance_config.
Anthony Baxter <anthonybaxter@users.sourceforge.net>
parents:
diff
changeset
|
11 ''' Creates a hybrid database from: |
|
41e49de57a85
split __init__.py into 2. dbinit and instance_config.
Anthony Baxter <anthonybaxter@users.sourceforge.net>
parents:
diff
changeset
|
12 . the base Database class given in hyperdb (basic functionlity) |
|
41e49de57a85
split __init__.py into 2. dbinit and instance_config.
Anthony Baxter <anthonybaxter@users.sourceforge.net>
parents:
diff
changeset
|
13 . the BSDDB implementation in hyperdb_bsddb |
|
41e49de57a85
split __init__.py into 2. dbinit and instance_config.
Anthony Baxter <anthonybaxter@users.sourceforge.net>
parents:
diff
changeset
|
14 . the roundup extensions from roundupdb |
|
41e49de57a85
split __init__.py into 2. dbinit and instance_config.
Anthony Baxter <anthonybaxter@users.sourceforge.net>
parents:
diff
changeset
|
15 ''' |
|
41e49de57a85
split __init__.py into 2. dbinit and instance_config.
Anthony Baxter <anthonybaxter@users.sourceforge.net>
parents:
diff
changeset
|
16 pass |
|
41e49de57a85
split __init__.py into 2. dbinit and instance_config.
Anthony Baxter <anthonybaxter@users.sourceforge.net>
parents:
diff
changeset
|
17 |
|
41e49de57a85
split __init__.py into 2. dbinit and instance_config.
Anthony Baxter <anthonybaxter@users.sourceforge.net>
parents:
diff
changeset
|
18 class IssueClass(roundupdb.IssueClass): |
|
41e49de57a85
split __init__.py into 2. dbinit and instance_config.
Anthony Baxter <anthonybaxter@users.sourceforge.net>
parents:
diff
changeset
|
19 ''' issues need the email information |
|
41e49de57a85
split __init__.py into 2. dbinit and instance_config.
Anthony Baxter <anthonybaxter@users.sourceforge.net>
parents:
diff
changeset
|
20 ''' |
|
41e49de57a85
split __init__.py into 2. dbinit and instance_config.
Anthony Baxter <anthonybaxter@users.sourceforge.net>
parents:
diff
changeset
|
21 ISSUE_TRACKER_EMAIL = instance_config.ISSUE_TRACKER_EMAIL |
|
41e49de57a85
split __init__.py into 2. dbinit and instance_config.
Anthony Baxter <anthonybaxter@users.sourceforge.net>
parents:
diff
changeset
|
22 ADMIN_EMAIL = instance_config.ADMIN_EMAIL |
|
41e49de57a85
split __init__.py into 2. dbinit and instance_config.
Anthony Baxter <anthonybaxter@users.sourceforge.net>
parents:
diff
changeset
|
23 MAILHOST = instance_config.MAILHOST |
|
41e49de57a85
split __init__.py into 2. dbinit and instance_config.
Anthony Baxter <anthonybaxter@users.sourceforge.net>
parents:
diff
changeset
|
24 |
|
41e49de57a85
split __init__.py into 2. dbinit and instance_config.
Anthony Baxter <anthonybaxter@users.sourceforge.net>
parents:
diff
changeset
|
25 |
|
41e49de57a85
split __init__.py into 2. dbinit and instance_config.
Anthony Baxter <anthonybaxter@users.sourceforge.net>
parents:
diff
changeset
|
26 class Client(cgi_client.Client): |
|
41e49de57a85
split __init__.py into 2. dbinit and instance_config.
Anthony Baxter <anthonybaxter@users.sourceforge.net>
parents:
diff
changeset
|
27 ''' derives basic mail gateway implementation from the standard module, |
|
41e49de57a85
split __init__.py into 2. dbinit and instance_config.
Anthony Baxter <anthonybaxter@users.sourceforge.net>
parents:
diff
changeset
|
28 with any specific extensions |
|
41e49de57a85
split __init__.py into 2. dbinit and instance_config.
Anthony Baxter <anthonybaxter@users.sourceforge.net>
parents:
diff
changeset
|
29 ''' |
|
41e49de57a85
split __init__.py into 2. dbinit and instance_config.
Anthony Baxter <anthonybaxter@users.sourceforge.net>
parents:
diff
changeset
|
30 TEMPLATES = instance_config.TEMPLATES |
|
41e49de57a85
split __init__.py into 2. dbinit and instance_config.
Anthony Baxter <anthonybaxter@users.sourceforge.net>
parents:
diff
changeset
|
31 pass |
|
41e49de57a85
split __init__.py into 2. dbinit and instance_config.
Anthony Baxter <anthonybaxter@users.sourceforge.net>
parents:
diff
changeset
|
32 |
|
41e49de57a85
split __init__.py into 2. dbinit and instance_config.
Anthony Baxter <anthonybaxter@users.sourceforge.net>
parents:
diff
changeset
|
33 class MailGW(mailgw.MailGW): |
|
41e49de57a85
split __init__.py into 2. dbinit and instance_config.
Anthony Baxter <anthonybaxter@users.sourceforge.net>
parents:
diff
changeset
|
34 ''' derives basic mail gateway implementation from the standard module, |
|
41e49de57a85
split __init__.py into 2. dbinit and instance_config.
Anthony Baxter <anthonybaxter@users.sourceforge.net>
parents:
diff
changeset
|
35 with any specific extensions |
|
41e49de57a85
split __init__.py into 2. dbinit and instance_config.
Anthony Baxter <anthonybaxter@users.sourceforge.net>
parents:
diff
changeset
|
36 ''' |
|
41e49de57a85
split __init__.py into 2. dbinit and instance_config.
Anthony Baxter <anthonybaxter@users.sourceforge.net>
parents:
diff
changeset
|
37 ISSUE_TRACKER_EMAIL = instance_config.ISSUE_TRACKER_EMAIL |
|
41e49de57a85
split __init__.py into 2. dbinit and instance_config.
Anthony Baxter <anthonybaxter@users.sourceforge.net>
parents:
diff
changeset
|
38 ADMIN_EMAIL = instance_config.ADMIN_EMAIL |
|
41e49de57a85
split __init__.py into 2. dbinit and instance_config.
Anthony Baxter <anthonybaxter@users.sourceforge.net>
parents:
diff
changeset
|
39 MAILHOST = instance_config.MAILHOST |
|
41e49de57a85
split __init__.py into 2. dbinit and instance_config.
Anthony Baxter <anthonybaxter@users.sourceforge.net>
parents:
diff
changeset
|
40 |
|
41e49de57a85
split __init__.py into 2. dbinit and instance_config.
Anthony Baxter <anthonybaxter@users.sourceforge.net>
parents:
diff
changeset
|
41 def open(name=None): |
|
41e49de57a85
split __init__.py into 2. dbinit and instance_config.
Anthony Baxter <anthonybaxter@users.sourceforge.net>
parents:
diff
changeset
|
42 ''' as from the roundupdb method openDB |
|
41e49de57a85
split __init__.py into 2. dbinit and instance_config.
Anthony Baxter <anthonybaxter@users.sourceforge.net>
parents:
diff
changeset
|
43 |
|
41e49de57a85
split __init__.py into 2. dbinit and instance_config.
Anthony Baxter <anthonybaxter@users.sourceforge.net>
parents:
diff
changeset
|
44 storagelocator must be the directory the __init__.py file is in |
|
41e49de57a85
split __init__.py into 2. dbinit and instance_config.
Anthony Baxter <anthonybaxter@users.sourceforge.net>
parents:
diff
changeset
|
45 - os.path.split(__file__)[0] gives us that I think |
|
41e49de57a85
split __init__.py into 2. dbinit and instance_config.
Anthony Baxter <anthonybaxter@users.sourceforge.net>
parents:
diff
changeset
|
46 ''' |
|
41e49de57a85
split __init__.py into 2. dbinit and instance_config.
Anthony Baxter <anthonybaxter@users.sourceforge.net>
parents:
diff
changeset
|
47 from roundup.hyperdb import String, Date, Link, Multilink |
|
41e49de57a85
split __init__.py into 2. dbinit and instance_config.
Anthony Baxter <anthonybaxter@users.sourceforge.net>
parents:
diff
changeset
|
48 |
|
41e49de57a85
split __init__.py into 2. dbinit and instance_config.
Anthony Baxter <anthonybaxter@users.sourceforge.net>
parents:
diff
changeset
|
49 # open the database |
|
41e49de57a85
split __init__.py into 2. dbinit and instance_config.
Anthony Baxter <anthonybaxter@users.sourceforge.net>
parents:
diff
changeset
|
50 db = Database(instance_config.DATABASE, name) |
|
41e49de57a85
split __init__.py into 2. dbinit and instance_config.
Anthony Baxter <anthonybaxter@users.sourceforge.net>
parents:
diff
changeset
|
51 |
|
41e49de57a85
split __init__.py into 2. dbinit and instance_config.
Anthony Baxter <anthonybaxter@users.sourceforge.net>
parents:
diff
changeset
|
52 # Now initialise the schema. Must do this each time. |
|
41e49de57a85
split __init__.py into 2. dbinit and instance_config.
Anthony Baxter <anthonybaxter@users.sourceforge.net>
parents:
diff
changeset
|
53 pri = Class(db, "priority", |
|
41e49de57a85
split __init__.py into 2. dbinit and instance_config.
Anthony Baxter <anthonybaxter@users.sourceforge.net>
parents:
diff
changeset
|
54 name=String(), order=String()) |
|
41e49de57a85
split __init__.py into 2. dbinit and instance_config.
Anthony Baxter <anthonybaxter@users.sourceforge.net>
parents:
diff
changeset
|
55 pri.setkey("name") |
|
41e49de57a85
split __init__.py into 2. dbinit and instance_config.
Anthony Baxter <anthonybaxter@users.sourceforge.net>
parents:
diff
changeset
|
56 |
|
41e49de57a85
split __init__.py into 2. dbinit and instance_config.
Anthony Baxter <anthonybaxter@users.sourceforge.net>
parents:
diff
changeset
|
57 stat = Class(db, "status", |
|
41e49de57a85
split __init__.py into 2. dbinit and instance_config.
Anthony Baxter <anthonybaxter@users.sourceforge.net>
parents:
diff
changeset
|
58 name=String(), order=String()) |
|
41e49de57a85
split __init__.py into 2. dbinit and instance_config.
Anthony Baxter <anthonybaxter@users.sourceforge.net>
parents:
diff
changeset
|
59 stat.setkey("name") |
|
41e49de57a85
split __init__.py into 2. dbinit and instance_config.
Anthony Baxter <anthonybaxter@users.sourceforge.net>
parents:
diff
changeset
|
60 |
|
41e49de57a85
split __init__.py into 2. dbinit and instance_config.
Anthony Baxter <anthonybaxter@users.sourceforge.net>
parents:
diff
changeset
|
61 keywords = Class(db, "keyword", |
|
41e49de57a85
split __init__.py into 2. dbinit and instance_config.
Anthony Baxter <anthonybaxter@users.sourceforge.net>
parents:
diff
changeset
|
62 name=String()) |
|
41e49de57a85
split __init__.py into 2. dbinit and instance_config.
Anthony Baxter <anthonybaxter@users.sourceforge.net>
parents:
diff
changeset
|
63 |
|
41e49de57a85
split __init__.py into 2. dbinit and instance_config.
Anthony Baxter <anthonybaxter@users.sourceforge.net>
parents:
diff
changeset
|
64 user = Class(db, "user", |
|
41e49de57a85
split __init__.py into 2. dbinit and instance_config.
Anthony Baxter <anthonybaxter@users.sourceforge.net>
parents:
diff
changeset
|
65 username=String(), password=String(), |
|
41e49de57a85
split __init__.py into 2. dbinit and instance_config.
Anthony Baxter <anthonybaxter@users.sourceforge.net>
parents:
diff
changeset
|
66 address=String(), realname=String(), |
|
41e49de57a85
split __init__.py into 2. dbinit and instance_config.
Anthony Baxter <anthonybaxter@users.sourceforge.net>
parents:
diff
changeset
|
67 phone=String(), organisation=String()) |
|
41e49de57a85
split __init__.py into 2. dbinit and instance_config.
Anthony Baxter <anthonybaxter@users.sourceforge.net>
parents:
diff
changeset
|
68 user.setkey("username") |
|
41e49de57a85
split __init__.py into 2. dbinit and instance_config.
Anthony Baxter <anthonybaxter@users.sourceforge.net>
parents:
diff
changeset
|
69 |
|
41e49de57a85
split __init__.py into 2. dbinit and instance_config.
Anthony Baxter <anthonybaxter@users.sourceforge.net>
parents:
diff
changeset
|
70 msg = FileClass(db, "msg", |
|
41e49de57a85
split __init__.py into 2. dbinit and instance_config.
Anthony Baxter <anthonybaxter@users.sourceforge.net>
parents:
diff
changeset
|
71 author=Link("user"), recipients=Multilink("user"), |
|
41e49de57a85
split __init__.py into 2. dbinit and instance_config.
Anthony Baxter <anthonybaxter@users.sourceforge.net>
parents:
diff
changeset
|
72 date=Date(), summary=String(), |
|
41e49de57a85
split __init__.py into 2. dbinit and instance_config.
Anthony Baxter <anthonybaxter@users.sourceforge.net>
parents:
diff
changeset
|
73 files=Multilink("file")) |
|
41e49de57a85
split __init__.py into 2. dbinit and instance_config.
Anthony Baxter <anthonybaxter@users.sourceforge.net>
parents:
diff
changeset
|
74 |
|
41e49de57a85
split __init__.py into 2. dbinit and instance_config.
Anthony Baxter <anthonybaxter@users.sourceforge.net>
parents:
diff
changeset
|
75 file = FileClass(db, "file", |
|
41e49de57a85
split __init__.py into 2. dbinit and instance_config.
Anthony Baxter <anthonybaxter@users.sourceforge.net>
parents:
diff
changeset
|
76 name=String(), type=String()) |
|
41e49de57a85
split __init__.py into 2. dbinit and instance_config.
Anthony Baxter <anthonybaxter@users.sourceforge.net>
parents:
diff
changeset
|
77 |
|
41e49de57a85
split __init__.py into 2. dbinit and instance_config.
Anthony Baxter <anthonybaxter@users.sourceforge.net>
parents:
diff
changeset
|
78 # bugs and support calls etc |
|
41e49de57a85
split __init__.py into 2. dbinit and instance_config.
Anthony Baxter <anthonybaxter@users.sourceforge.net>
parents:
diff
changeset
|
79 rate = Class(db, "rate", |
|
41e49de57a85
split __init__.py into 2. dbinit and instance_config.
Anthony Baxter <anthonybaxter@users.sourceforge.net>
parents:
diff
changeset
|
80 name=String(), order=String()) |
|
41e49de57a85
split __init__.py into 2. dbinit and instance_config.
Anthony Baxter <anthonybaxter@users.sourceforge.net>
parents:
diff
changeset
|
81 rate.setkey("name") |
|
41e49de57a85
split __init__.py into 2. dbinit and instance_config.
Anthony Baxter <anthonybaxter@users.sourceforge.net>
parents:
diff
changeset
|
82 |
|
41e49de57a85
split __init__.py into 2. dbinit and instance_config.
Anthony Baxter <anthonybaxter@users.sourceforge.net>
parents:
diff
changeset
|
83 source = Class(db, "source", |
|
41e49de57a85
split __init__.py into 2. dbinit and instance_config.
Anthony Baxter <anthonybaxter@users.sourceforge.net>
parents:
diff
changeset
|
84 name=String(), order=String()) |
|
41e49de57a85
split __init__.py into 2. dbinit and instance_config.
Anthony Baxter <anthonybaxter@users.sourceforge.net>
parents:
diff
changeset
|
85 source.setkey("name") |
|
41e49de57a85
split __init__.py into 2. dbinit and instance_config.
Anthony Baxter <anthonybaxter@users.sourceforge.net>
parents:
diff
changeset
|
86 |
|
41e49de57a85
split __init__.py into 2. dbinit and instance_config.
Anthony Baxter <anthonybaxter@users.sourceforge.net>
parents:
diff
changeset
|
87 platform = Class(db, "platform", |
|
41e49de57a85
split __init__.py into 2. dbinit and instance_config.
Anthony Baxter <anthonybaxter@users.sourceforge.net>
parents:
diff
changeset
|
88 name=String(), order=String()) |
|
41e49de57a85
split __init__.py into 2. dbinit and instance_config.
Anthony Baxter <anthonybaxter@users.sourceforge.net>
parents:
diff
changeset
|
89 platform.setkey("name") |
|
41e49de57a85
split __init__.py into 2. dbinit and instance_config.
Anthony Baxter <anthonybaxter@users.sourceforge.net>
parents:
diff
changeset
|
90 |
|
41e49de57a85
split __init__.py into 2. dbinit and instance_config.
Anthony Baxter <anthonybaxter@users.sourceforge.net>
parents:
diff
changeset
|
91 product = Class(db, "product", |
|
41e49de57a85
split __init__.py into 2. dbinit and instance_config.
Anthony Baxter <anthonybaxter@users.sourceforge.net>
parents:
diff
changeset
|
92 name=String(), order=String()) |
|
41e49de57a85
split __init__.py into 2. dbinit and instance_config.
Anthony Baxter <anthonybaxter@users.sourceforge.net>
parents:
diff
changeset
|
93 product.setkey("name") |
|
41e49de57a85
split __init__.py into 2. dbinit and instance_config.
Anthony Baxter <anthonybaxter@users.sourceforge.net>
parents:
diff
changeset
|
94 |
|
41e49de57a85
split __init__.py into 2. dbinit and instance_config.
Anthony Baxter <anthonybaxter@users.sourceforge.net>
parents:
diff
changeset
|
95 timelog = Class(db, "timelog", |
|
41e49de57a85
split __init__.py into 2. dbinit and instance_config.
Anthony Baxter <anthonybaxter@users.sourceforge.net>
parents:
diff
changeset
|
96 date=Date(), time=String(), |
|
41e49de57a85
split __init__.py into 2. dbinit and instance_config.
Anthony Baxter <anthonybaxter@users.sourceforge.net>
parents:
diff
changeset
|
97 performedby=Link("user"), description=String()) |
|
41e49de57a85
split __init__.py into 2. dbinit and instance_config.
Anthony Baxter <anthonybaxter@users.sourceforge.net>
parents:
diff
changeset
|
98 |
|
41e49de57a85
split __init__.py into 2. dbinit and instance_config.
Anthony Baxter <anthonybaxter@users.sourceforge.net>
parents:
diff
changeset
|
99 issue = IssueClass(db, "issue", |
|
41e49de57a85
split __init__.py into 2. dbinit and instance_config.
Anthony Baxter <anthonybaxter@users.sourceforge.net>
parents:
diff
changeset
|
100 assignedto=Link("user"), priority=Link("priority"), |
|
41e49de57a85
split __init__.py into 2. dbinit and instance_config.
Anthony Baxter <anthonybaxter@users.sourceforge.net>
parents:
diff
changeset
|
101 status=Link("status"), rate=Link("rate"), |
|
41e49de57a85
split __init__.py into 2. dbinit and instance_config.
Anthony Baxter <anthonybaxter@users.sourceforge.net>
parents:
diff
changeset
|
102 source=Link("source"), product=Link("product"), |
|
41e49de57a85
split __init__.py into 2. dbinit and instance_config.
Anthony Baxter <anthonybaxter@users.sourceforge.net>
parents:
diff
changeset
|
103 platform=Multilink("platform"), version=String(), |
|
41e49de57a85
split __init__.py into 2. dbinit and instance_config.
Anthony Baxter <anthonybaxter@users.sourceforge.net>
parents:
diff
changeset
|
104 timelog=Multilink("timelog"), customername=String()) |
|
41e49de57a85
split __init__.py into 2. dbinit and instance_config.
Anthony Baxter <anthonybaxter@users.sourceforge.net>
parents:
diff
changeset
|
105 issue.setkey('title') |
|
41e49de57a85
split __init__.py into 2. dbinit and instance_config.
Anthony Baxter <anthonybaxter@users.sourceforge.net>
parents:
diff
changeset
|
106 |
|
41e49de57a85
split __init__.py into 2. dbinit and instance_config.
Anthony Baxter <anthonybaxter@users.sourceforge.net>
parents:
diff
changeset
|
107 import detectors |
|
41e49de57a85
split __init__.py into 2. dbinit and instance_config.
Anthony Baxter <anthonybaxter@users.sourceforge.net>
parents:
diff
changeset
|
108 detectors.init(db) |
|
41e49de57a85
split __init__.py into 2. dbinit and instance_config.
Anthony Baxter <anthonybaxter@users.sourceforge.net>
parents:
diff
changeset
|
109 |
|
41e49de57a85
split __init__.py into 2. dbinit and instance_config.
Anthony Baxter <anthonybaxter@users.sourceforge.net>
parents:
diff
changeset
|
110 return db |
|
41e49de57a85
split __init__.py into 2. dbinit and instance_config.
Anthony Baxter <anthonybaxter@users.sourceforge.net>
parents:
diff
changeset
|
111 |
|
41e49de57a85
split __init__.py into 2. dbinit and instance_config.
Anthony Baxter <anthonybaxter@users.sourceforge.net>
parents:
diff
changeset
|
112 def init(adminpw): |
|
41e49de57a85
split __init__.py into 2. dbinit and instance_config.
Anthony Baxter <anthonybaxter@users.sourceforge.net>
parents:
diff
changeset
|
113 ''' as from the roundupdb method initDB |
|
41e49de57a85
split __init__.py into 2. dbinit and instance_config.
Anthony Baxter <anthonybaxter@users.sourceforge.net>
parents:
diff
changeset
|
114 |
|
41e49de57a85
split __init__.py into 2. dbinit and instance_config.
Anthony Baxter <anthonybaxter@users.sourceforge.net>
parents:
diff
changeset
|
115 storagelocator must be the directory the __init__.py file is in |
|
41e49de57a85
split __init__.py into 2. dbinit and instance_config.
Anthony Baxter <anthonybaxter@users.sourceforge.net>
parents:
diff
changeset
|
116 - os.path.split(__file__)[0] gives us that I think |
|
41e49de57a85
split __init__.py into 2. dbinit and instance_config.
Anthony Baxter <anthonybaxter@users.sourceforge.net>
parents:
diff
changeset
|
117 |
|
41e49de57a85
split __init__.py into 2. dbinit and instance_config.
Anthony Baxter <anthonybaxter@users.sourceforge.net>
parents:
diff
changeset
|
118 Open the new database, and set up a bunch of attributes. |
|
41e49de57a85
split __init__.py into 2. dbinit and instance_config.
Anthony Baxter <anthonybaxter@users.sourceforge.net>
parents:
diff
changeset
|
119 |
|
41e49de57a85
split __init__.py into 2. dbinit and instance_config.
Anthony Baxter <anthonybaxter@users.sourceforge.net>
parents:
diff
changeset
|
120 ''' |
|
41e49de57a85
split __init__.py into 2. dbinit and instance_config.
Anthony Baxter <anthonybaxter@users.sourceforge.net>
parents:
diff
changeset
|
121 dbdir = os.path.join(instance_config.DATABASE, 'files') |
|
41e49de57a85
split __init__.py into 2. dbinit and instance_config.
Anthony Baxter <anthonybaxter@users.sourceforge.net>
parents:
diff
changeset
|
122 if not os.path.isdir(dbdir): |
|
41e49de57a85
split __init__.py into 2. dbinit and instance_config.
Anthony Baxter <anthonybaxter@users.sourceforge.net>
parents:
diff
changeset
|
123 os.makedirs(dbdir) |
|
41e49de57a85
split __init__.py into 2. dbinit and instance_config.
Anthony Baxter <anthonybaxter@users.sourceforge.net>
parents:
diff
changeset
|
124 |
|
41e49de57a85
split __init__.py into 2. dbinit and instance_config.
Anthony Baxter <anthonybaxter@users.sourceforge.net>
parents:
diff
changeset
|
125 db = open("admin") |
|
41e49de57a85
split __init__.py into 2. dbinit and instance_config.
Anthony Baxter <anthonybaxter@users.sourceforge.net>
parents:
diff
changeset
|
126 db.clear() |
|
41e49de57a85
split __init__.py into 2. dbinit and instance_config.
Anthony Baxter <anthonybaxter@users.sourceforge.net>
parents:
diff
changeset
|
127 |
|
41e49de57a85
split __init__.py into 2. dbinit and instance_config.
Anthony Baxter <anthonybaxter@users.sourceforge.net>
parents:
diff
changeset
|
128 pri = db.getclass('priority') |
|
41e49de57a85
split __init__.py into 2. dbinit and instance_config.
Anthony Baxter <anthonybaxter@users.sourceforge.net>
parents:
diff
changeset
|
129 pri.create(name="fatal-bug", order="1") |
|
41e49de57a85
split __init__.py into 2. dbinit and instance_config.
Anthony Baxter <anthonybaxter@users.sourceforge.net>
parents:
diff
changeset
|
130 pri.create(name="bug", order="2") |
|
41e49de57a85
split __init__.py into 2. dbinit and instance_config.
Anthony Baxter <anthonybaxter@users.sourceforge.net>
parents:
diff
changeset
|
131 pri.create(name="usability", order="3") |
|
41e49de57a85
split __init__.py into 2. dbinit and instance_config.
Anthony Baxter <anthonybaxter@users.sourceforge.net>
parents:
diff
changeset
|
132 pri.create(name="feature", order="4") |
|
41e49de57a85
split __init__.py into 2. dbinit and instance_config.
Anthony Baxter <anthonybaxter@users.sourceforge.net>
parents:
diff
changeset
|
133 pri.create(name="support", order="5") |
|
41e49de57a85
split __init__.py into 2. dbinit and instance_config.
Anthony Baxter <anthonybaxter@users.sourceforge.net>
parents:
diff
changeset
|
134 |
|
41e49de57a85
split __init__.py into 2. dbinit and instance_config.
Anthony Baxter <anthonybaxter@users.sourceforge.net>
parents:
diff
changeset
|
135 stat = db.getclass('status') |
|
41e49de57a85
split __init__.py into 2. dbinit and instance_config.
Anthony Baxter <anthonybaxter@users.sourceforge.net>
parents:
diff
changeset
|
136 stat.create(name="unread", order="1") |
|
41e49de57a85
split __init__.py into 2. dbinit and instance_config.
Anthony Baxter <anthonybaxter@users.sourceforge.net>
parents:
diff
changeset
|
137 stat.create(name="deferred", order="2") |
|
41e49de57a85
split __init__.py into 2. dbinit and instance_config.
Anthony Baxter <anthonybaxter@users.sourceforge.net>
parents:
diff
changeset
|
138 stat.create(name="chatting", order="3") |
|
41e49de57a85
split __init__.py into 2. dbinit and instance_config.
Anthony Baxter <anthonybaxter@users.sourceforge.net>
parents:
diff
changeset
|
139 stat.create(name="need-eg", order="4") |
|
41e49de57a85
split __init__.py into 2. dbinit and instance_config.
Anthony Baxter <anthonybaxter@users.sourceforge.net>
parents:
diff
changeset
|
140 stat.create(name="in-progress", order="5") |
|
41e49de57a85
split __init__.py into 2. dbinit and instance_config.
Anthony Baxter <anthonybaxter@users.sourceforge.net>
parents:
diff
changeset
|
141 stat.create(name="testing", order="6") |
|
41e49de57a85
split __init__.py into 2. dbinit and instance_config.
Anthony Baxter <anthonybaxter@users.sourceforge.net>
parents:
diff
changeset
|
142 stat.create(name="done-cbb", order="7") |
|
41e49de57a85
split __init__.py into 2. dbinit and instance_config.
Anthony Baxter <anthonybaxter@users.sourceforge.net>
parents:
diff
changeset
|
143 stat.create(name="resolved", order="8") |
|
41e49de57a85
split __init__.py into 2. dbinit and instance_config.
Anthony Baxter <anthonybaxter@users.sourceforge.net>
parents:
diff
changeset
|
144 |
|
41e49de57a85
split __init__.py into 2. dbinit and instance_config.
Anthony Baxter <anthonybaxter@users.sourceforge.net>
parents:
diff
changeset
|
145 rate = db.getclass("rate") |
|
41e49de57a85
split __init__.py into 2. dbinit and instance_config.
Anthony Baxter <anthonybaxter@users.sourceforge.net>
parents:
diff
changeset
|
146 rate.create(name='basic', order="1") |
|
41e49de57a85
split __init__.py into 2. dbinit and instance_config.
Anthony Baxter <anthonybaxter@users.sourceforge.net>
parents:
diff
changeset
|
147 rate.create(name='premium', order="2") |
|
41e49de57a85
split __init__.py into 2. dbinit and instance_config.
Anthony Baxter <anthonybaxter@users.sourceforge.net>
parents:
diff
changeset
|
148 rate.create(name='internal', order="3") |
|
41e49de57a85
split __init__.py into 2. dbinit and instance_config.
Anthony Baxter <anthonybaxter@users.sourceforge.net>
parents:
diff
changeset
|
149 |
|
41e49de57a85
split __init__.py into 2. dbinit and instance_config.
Anthony Baxter <anthonybaxter@users.sourceforge.net>
parents:
diff
changeset
|
150 source = db.getclass("source") |
|
41e49de57a85
split __init__.py into 2. dbinit and instance_config.
Anthony Baxter <anthonybaxter@users.sourceforge.net>
parents:
diff
changeset
|
151 source.create(name='phone', order="1") |
|
41e49de57a85
split __init__.py into 2. dbinit and instance_config.
Anthony Baxter <anthonybaxter@users.sourceforge.net>
parents:
diff
changeset
|
152 source.create(name='e-mail', order="2") |
|
41e49de57a85
split __init__.py into 2. dbinit and instance_config.
Anthony Baxter <anthonybaxter@users.sourceforge.net>
parents:
diff
changeset
|
153 source.create(name='internal', order="3") |
|
41e49de57a85
split __init__.py into 2. dbinit and instance_config.
Anthony Baxter <anthonybaxter@users.sourceforge.net>
parents:
diff
changeset
|
154 source.create(name='internal-qa', order="4") |
|
41e49de57a85
split __init__.py into 2. dbinit and instance_config.
Anthony Baxter <anthonybaxter@users.sourceforge.net>
parents:
diff
changeset
|
155 |
|
41e49de57a85
split __init__.py into 2. dbinit and instance_config.
Anthony Baxter <anthonybaxter@users.sourceforge.net>
parents:
diff
changeset
|
156 platform = db.getclass("platform") |
|
41e49de57a85
split __init__.py into 2. dbinit and instance_config.
Anthony Baxter <anthonybaxter@users.sourceforge.net>
parents:
diff
changeset
|
157 platform.create(name='linux', order="1") |
|
41e49de57a85
split __init__.py into 2. dbinit and instance_config.
Anthony Baxter <anthonybaxter@users.sourceforge.net>
parents:
diff
changeset
|
158 platform.create(name='windows', order="2") |
|
41e49de57a85
split __init__.py into 2. dbinit and instance_config.
Anthony Baxter <anthonybaxter@users.sourceforge.net>
parents:
diff
changeset
|
159 platform.create(name='mac', order="3") |
|
41e49de57a85
split __init__.py into 2. dbinit and instance_config.
Anthony Baxter <anthonybaxter@users.sourceforge.net>
parents:
diff
changeset
|
160 |
|
41e49de57a85
split __init__.py into 2. dbinit and instance_config.
Anthony Baxter <anthonybaxter@users.sourceforge.net>
parents:
diff
changeset
|
161 product = db.getclass("product") |
|
41e49de57a85
split __init__.py into 2. dbinit and instance_config.
Anthony Baxter <anthonybaxter@users.sourceforge.net>
parents:
diff
changeset
|
162 product.create(name='Bizar Shop', order="1") |
|
41e49de57a85
split __init__.py into 2. dbinit and instance_config.
Anthony Baxter <anthonybaxter@users.sourceforge.net>
parents:
diff
changeset
|
163 product.create(name='Bizar Shop Developer', order="2") |
|
41e49de57a85
split __init__.py into 2. dbinit and instance_config.
Anthony Baxter <anthonybaxter@users.sourceforge.net>
parents:
diff
changeset
|
164 product.create(name='Bizar Shop Manual', order="3") |
|
41e49de57a85
split __init__.py into 2. dbinit and instance_config.
Anthony Baxter <anthonybaxter@users.sourceforge.net>
parents:
diff
changeset
|
165 product.create(name='Bizar Shop Developer Manual', order="4") |
|
41e49de57a85
split __init__.py into 2. dbinit and instance_config.
Anthony Baxter <anthonybaxter@users.sourceforge.net>
parents:
diff
changeset
|
166 |
|
41e49de57a85
split __init__.py into 2. dbinit and instance_config.
Anthony Baxter <anthonybaxter@users.sourceforge.net>
parents:
diff
changeset
|
167 user = db.getclass('user') |
|
41e49de57a85
split __init__.py into 2. dbinit and instance_config.
Anthony Baxter <anthonybaxter@users.sourceforge.net>
parents:
diff
changeset
|
168 user.create(username="admin", password=adminpw, |
|
41e49de57a85
split __init__.py into 2. dbinit and instance_config.
Anthony Baxter <anthonybaxter@users.sourceforge.net>
parents:
diff
changeset
|
169 address=instance_config.ADMIN_EMAIL) |
|
41e49de57a85
split __init__.py into 2. dbinit and instance_config.
Anthony Baxter <anthonybaxter@users.sourceforge.net>
parents:
diff
changeset
|
170 |
|
41e49de57a85
split __init__.py into 2. dbinit and instance_config.
Anthony Baxter <anthonybaxter@users.sourceforge.net>
parents:
diff
changeset
|
171 db.close() |
|
41e49de57a85
split __init__.py into 2. dbinit and instance_config.
Anthony Baxter <anthonybaxter@users.sourceforge.net>
parents:
diff
changeset
|
172 |
|
41e49de57a85
split __init__.py into 2. dbinit and instance_config.
Anthony Baxter <anthonybaxter@users.sourceforge.net>
parents:
diff
changeset
|
173 # |
|
41e49de57a85
split __init__.py into 2. dbinit and instance_config.
Anthony Baxter <anthonybaxter@users.sourceforge.net>
parents:
diff
changeset
|
174 # $Log: not supported by cvs2svn $ |
|
41e49de57a85
split __init__.py into 2. dbinit and instance_config.
Anthony Baxter <anthonybaxter@users.sourceforge.net>
parents:
diff
changeset
|
175 # Revision 1.1 2001/07/23 03:50:46 anthonybaxter |
|
41e49de57a85
split __init__.py into 2. dbinit and instance_config.
Anthony Baxter <anthonybaxter@users.sourceforge.net>
parents:
diff
changeset
|
176 # moved templates to proper location |
|
41e49de57a85
split __init__.py into 2. dbinit and instance_config.
Anthony Baxter <anthonybaxter@users.sourceforge.net>
parents:
diff
changeset
|
177 # |
|
41e49de57a85
split __init__.py into 2. dbinit and instance_config.
Anthony Baxter <anthonybaxter@users.sourceforge.net>
parents:
diff
changeset
|
178 # Revision 1.2 2001/07/22 12:09:32 richard |
|
41e49de57a85
split __init__.py into 2. dbinit and instance_config.
Anthony Baxter <anthonybaxter@users.sourceforge.net>
parents:
diff
changeset
|
179 # Final commit of Grande Splite |
|
41e49de57a85
split __init__.py into 2. dbinit and instance_config.
Anthony Baxter <anthonybaxter@users.sourceforge.net>
parents:
diff
changeset
|
180 # |
|
41e49de57a85
split __init__.py into 2. dbinit and instance_config.
Anthony Baxter <anthonybaxter@users.sourceforge.net>
parents:
diff
changeset
|
181 # |
|
41e49de57a85
split __init__.py into 2. dbinit and instance_config.
Anthony Baxter <anthonybaxter@users.sourceforge.net>
parents:
diff
changeset
|
182 |
|
41e49de57a85
split __init__.py into 2. dbinit and instance_config.
Anthony Baxter <anthonybaxter@users.sourceforge.net>
parents:
diff
changeset
|
183 |
