annotate modules/web_view/roundup_content_data/__init__.py @ 26:d7856a645ea8

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