Mercurial > roundup-cc > roundup-cc

annotate roundup_content_data/__init__.py @ 1:2df45f6ecd81

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
new appereance (solid and dotted lines), resonsive layout, new legend, new structure, cronjob-friendly dynamic generation of search-strings, dynamic recognition of error-values, ignores non-numeric priority-IDs
author sean
date Tue, 14 Apr 2015 13:32:12 +0200
parents 3f139db894f1
children 99e2e0e17103
rev   line source
0
3f139db894f1 initial commit
sean
parents:
diff changeset
1 #!/usr/bin/env python
3f139db894f1 initial commit
sean
parents:
diff changeset
2
3f139db894f1 initial commit
sean
parents:
diff changeset
3 """ supplys the data needed to comunicate with the roundup-server,
3f139db894f1 initial commit
sean
parents:
diff changeset
4 and the sqlite database. Represents the types of errors used in roundup.
3f139db894f1 initial commit
sean
parents:
diff changeset
5
3f139db894f1 initial commit
sean
parents:
diff changeset
6 author: Sascha L. Teichmann <sascha.teichmann@intevation.de>
3f139db894f1 initial commit
sean
parents:
diff changeset
7 author: Bernhard Reiter <bernhard@intevation.de>
3f139db894f1 initial commit
sean
parents:
diff changeset
8 author: Sean Engelhardt <sean.engelhardt@intevation.de>
3f139db894f1 initial commit
sean
parents:
diff changeset
9
3f139db894f1 initial commit
sean
parents:
diff changeset
10 (c) 2010,2015 by Intevation GmbH
3f139db894f1 initial commit
sean
parents:
diff changeset
11
3f139db894f1 initial commit
sean
parents:
diff changeset
12 This is Free Software unter the terms of the
3f139db894f1 initial commit
sean
parents:
diff changeset
13 GNU GENERAL PUBLIC LICENSE Version 3 or later.
3f139db894f1 initial commit
sean
parents:
diff changeset
14 See http://www.gnu.org/licenses/gpl-3.0.txt for details
3f139db894f1 initial commit
sean
parents:
diff changeset
15 """
3f139db894f1 initial commit
sean
parents:
diff changeset
16
3f139db894f1 initial commit
sean
parents:
diff changeset
17 import os
3f139db894f1 initial commit
sean
parents:
diff changeset
18
1
2df45f6ecd81 new appereance (solid and dotted lines), resonsive layout, new legend,
sean
parents: 0
diff changeset
19 #Add desired sqlite databases here
2df45f6ecd81 new appereance (solid and dotted lines), resonsive layout, new legend,
sean
parents: 0
diff changeset
20 DATABASE_REFERENCCE = os.path.dirname(os.path.realpath(__file__)) + "/test_reference.db"
2df45f6ecd81 new appereance (solid and dotted lines), resonsive layout, new legend,
sean
parents: 0
diff changeset
21 DATABASE_DEMO = os.path.dirname(os.path.realpath(__file__)) + "/demo.db"
2df45f6ecd81 new appereance (solid and dotted lines), resonsive layout, new legend,
sean
parents: 0
diff changeset
22 DATABASE_ERRORDB = os.path.dirname(os.path.realpath(__file__)) + "/errordatabase.db"
2df45f6ecd81 new appereance (solid and dotted lines), resonsive layout, new legend,
sean
parents: 0
diff changeset
23 DATABASE_TECH_INTERN = os.path.dirname(os.path.realpath(__file__)) + "/tech_intern.db"
2df45f6ecd81 new appereance (solid and dotted lines), resonsive layout, new legend,
sean
parents: 0
diff changeset
24 DATABASE_INT_TEST = os.path.dirname(os.path.realpath(__file__)) + "/int_test.db"
0
3f139db894f1 initial commit
sean
parents:
diff changeset
25
1
2df45f6ecd81 new appereance (solid and dotted lines), resonsive layout, new legend,
sean
parents: 0
diff changeset
26 COLUMNS= [
0
3f139db894f1 initial commit
sean
parents:
diff changeset
27 "critical", "urgent", "bug", "feature", "wish",
3f139db894f1 initial commit
sean
parents:
diff changeset
28 ]
3f139db894f1 initial commit
sean
parents:
diff changeset
29
3f139db894f1 initial commit
sean
parents:
diff changeset
30 data_dict = {
3f139db894f1 initial commit
sean
parents:
diff changeset
31 "date": [],
3f139db894f1 initial commit
sean
parents:
diff changeset
32 "critical": [],
3f139db894f1 initial commit
sean
parents:
diff changeset
33 "urgent": [],
3f139db894f1 initial commit
sean
parents:
diff changeset
34 "bug": [],
3f139db894f1 initial commit
sean
parents:
diff changeset
35 "feature": [],
3f139db894f1 initial commit
sean
parents:
diff changeset
36 "wish": []
3f139db894f1 initial commit
sean
parents:
diff changeset
37 }
3f139db894f1 initial commit
sean
parents:
diff changeset
38
1
2df45f6ecd81 new appereance (solid and dotted lines), resonsive layout, new legend,
sean
parents: 0
diff changeset
39 #SQL
0
3f139db894f1 initial commit
sean
parents:
diff changeset
40
1
2df45f6ecd81 new appereance (solid and dotted lines), resonsive layout, new legend,
sean
parents: 0
diff changeset
41 #DEMO System
0
3f139db894f1 initial commit
sean
parents:
diff changeset
42 SELECT_ALL = """
3f139db894f1 initial commit
sean
parents:
diff changeset
43 SELECT strftime("%Y-%m-%dT%H:%M:%S", timestamp),
3f139db894f1 initial commit
sean
parents:
diff changeset
44 critical,
3f139db894f1 initial commit
sean
parents:
diff changeset
45 urgent,
3f139db894f1 initial commit
sean
parents:
diff changeset
46 bug,
3f139db894f1 initial commit
sean
parents:
diff changeset
47 feature,
3f139db894f1 initial commit
sean
parents:
diff changeset
48 wish
3f139db894f1 initial commit
sean
parents:
diff changeset
49 FROM issues
3f139db894f1 initial commit
sean
parents:
diff changeset
50 ORDER BY timestamp
3f139db894f1 initial commit
sean
parents:
diff changeset
51 """
3f139db894f1 initial commit
sean
parents:
diff changeset
52
3f139db894f1 initial commit
sean
parents:
diff changeset
53
3f139db894f1 initial commit
sean
parents:
diff changeset
54 CREATE_DB = """
3f139db894f1 initial commit
sean
parents:
diff changeset
55 CREATE TABLE issues (
3f139db894f1 initial commit
sean
parents:
diff changeset
56 timestamp TIMESTAMP NOT NULL UNIQUE DEFAULT current_timestamp,
3f139db894f1 initial commit
sean
parents:
diff changeset
57 critical INTEGER NOT NULL DEFAULT 0,
3f139db894f1 initial commit
sean
parents:
diff changeset
58 urgent INTEGER NOT NULL DEFAULT 0,
3f139db894f1 initial commit
sean
parents:
diff changeset
59 bug INTEGER NOT NULL DEFAULT 0,
3f139db894f1 initial commit
sean
parents:
diff changeset
60 feature INTEGER NOT NULL DEFAULT 0,
3f139db894f1 initial commit
sean
parents:
diff changeset
61 wish INTEGER NOT NULL DEFAULT 0
3f139db894f1 initial commit
sean
parents:
diff changeset
62 )
3f139db894f1 initial commit
sean
parents:
diff changeset
63 """
3f139db894f1 initial commit
sean
parents:
diff changeset
64
3f139db894f1 initial commit
sean
parents:
diff changeset
65
3f139db894f1 initial commit
sean
parents:
diff changeset
66 INSERT_NEW = """
3f139db894f1 initial commit
sean
parents:
diff changeset
67 INSERT INTO issues (critical, urgent, bug, feature, wish)
3f139db894f1 initial commit
sean
parents:
diff changeset
68 VALUES (?, ?, ?, ?, ?)
1
2df45f6ecd81 new appereance (solid and dotted lines), resonsive layout, new legend,
sean
parents: 0
diff changeset
69 """
2df45f6ecd81 new appereance (solid and dotted lines), resonsive layout, new legend,
sean
parents: 0
diff changeset
70
2df45f6ecd81 new appereance (solid and dotted lines), resonsive layout, new legend,
sean
parents: 0
diff changeset
71 #Referecen DB:
2df45f6ecd81 new appereance (solid and dotted lines), resonsive layout, new legend,
sean
parents: 0
diff changeset
72 SELECT_ALL_REFERENCE = """
2df45f6ecd81 new appereance (solid and dotted lines), resonsive layout, new legend,
sean
parents: 0
diff changeset
73 SELECT strftime("%Y-%m-%dT%H:%M:%S", sample_time),
2df45f6ecd81 new appereance (solid and dotted lines), resonsive layout, new legend,
sean
parents: 0
diff changeset
74 critical,
2df45f6ecd81 new appereance (solid and dotted lines), resonsive layout, new legend,
sean
parents: 0
diff changeset
75 major,
2df45f6ecd81 new appereance (solid and dotted lines), resonsive layout, new legend,
sean
parents: 0
diff changeset
76 crash,
2df45f6ecd81 new appereance (solid and dotted lines), resonsive layout, new legend,
sean
parents: 0
diff changeset
77 normal,
2df45f6ecd81 new appereance (solid and dotted lines), resonsive layout, new legend,
sean
parents: 0
diff changeset
78 minor,
2df45f6ecd81 new appereance (solid and dotted lines), resonsive layout, new legend,
sean
parents: 0
diff changeset
79 wishlist
2df45f6ecd81 new appereance (solid and dotted lines), resonsive layout, new legend,
sean
parents: 0
diff changeset
80 FROM issues
2df45f6ecd81 new appereance (solid and dotted lines), resonsive layout, new legend,
sean
parents: 0
diff changeset
81 ORDER BY sample_time
0
3f139db894f1 initial commit
sean
parents:
diff changeset
82 """
This site is hosted by Intevation GmbH (Datenschutzerklärung und Impressum | Privacy Policy and Imprint)