Mercurial > roundup-cc > roundup-cc
diff roundup_content_data/__init__.py @ 1:2df45f6ecd81
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 |
line wrap: on
line diff
--- a/roundup_content_data/__init__.py Thu Apr 02 09:51:19 2015 +0200 +++ b/roundup_content_data/__init__.py Tue Apr 14 13:32:12 2015 +0200 @@ -16,23 +16,17 @@ import os -#rather use a real database for productiv use. -#this database NEEDS to chmod "777" or "666", wich is a major security issue -DATABASE_FILE = os.path.dirname(os.path.realpath(__file__)) + "/test.db" +#Add desired sqlite databases here +DATABASE_REFERENCCE = os.path.dirname(os.path.realpath(__file__)) + "/test_reference.db" +DATABASE_DEMO = os.path.dirname(os.path.realpath(__file__)) + "/demo.db" +DATABASE_ERRORDB = os.path.dirname(os.path.realpath(__file__)) + "/errordatabase.db" +DATABASE_TECH_INTERN = os.path.dirname(os.path.realpath(__file__)) + "/tech_intern.db" +DATABASE_INT_TEST = os.path.dirname(os.path.realpath(__file__)) + "/int_test.db" -COLUMNS = [ +COLUMNS= [ "critical", "urgent", "bug", "feature", "wish", ] - -# types of errors -CRITICAL = 1 -URGENT = 2 -BUG = 3 -FEATURE = 4 -WISH = 5 - - data_dict = { "date": [], "critical": [], @@ -42,8 +36,9 @@ "wish": [] } +#SQL -#SQL +#DEMO System SELECT_ALL = """ SELECT strftime("%Y-%m-%dT%H:%M:%S", timestamp), critical, @@ -71,4 +66,17 @@ INSERT_NEW = """ INSERT INTO issues (critical, urgent, bug, feature, wish) VALUES (?, ?, ?, ?, ?) +""" + +#Referecen DB: +SELECT_ALL_REFERENCE = """ +SELECT strftime("%Y-%m-%dT%H:%M:%S", sample_time), + critical, + major, + crash, + normal, + minor, + wishlist +FROM issues +ORDER BY sample_time """ \ No newline at end of file