1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
|
#
# rtevaldb.py
# Function for registering a rteval summary.xml report into the database
#
# Copyright 2009 David Sommerseth <davids@redhat.com>
#
# This program is free software; you can redistribute it and/or modify
# it under the terms of the GNU General Public License as published by
# the Free Software Foundation; either version 2 of the License, or
# (at your option) any later version.
#
# This program is distributed in the hope that it will be useful,
# but WITHOUT ANY WARRANTY; without even the implied warranty of
# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
# GNU General Public License for more details.
#
# You should have received a copy of the GNU General Public License
# along with this program; if not, write to the Free Software
# Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA
#
# For the avoidance of doubt the "preferred form" of this code is one which
# is in an open unpatent encumbered format. Where cryptographic key signing
# forms part of the process of creating an executable the information
# including keys needed to generate an equivalently functional executable
# are deemed to be part of the source code.
#
import os
from database import Database
def register_submission(config, clientid, filename, debug=False, noaction=False):
"Registers a submission of a rteval report which signalises the rteval_parserd process"
dbc = Database(host=config.db_server, port=config.db_port, database=config.database,
user=config.db_username, password=config.db_password,
debug=debug, noaction=noaction)
submvars = {"table": "submissionqueue",
"fields": ["clientid", "filename"],
"records": [[clientid, filename]],
"returning": "submid"
}
res = dbc.INSERT(submvars)
if len(res) != 1:
raise Exception("Could not register the submission")
dbc.COMMIT()
return res[0]
def database_status(config, debug=False, noaction=False):
dbc = Database(host=config.db_server, port=config.db_port, database=config.database,
user=config.db_username, password=config.db_password,
debug=debug, noaction=noaction)
if not dbc:
return {"status": "No connection to pgsql://%s:%s/%s" % (config.db_server,
config.db_port,
config.database)}
res = dbc.SELECT('rtevalruns',
["to_char(CURRENT_TIMESTAMP, 'YYYY-MM-DD HH24:MI:SS') AS server_time",
"max(rterid) AS last_rterid",
"max(submid) AS last_submid"]
)
if len(res) != 3:
return {"status": "Could not query database pgsql://%s:%s/%s" % (config.db_server,
config.db_port,
config.database)}
last_rterid = res['records'][0][1] and res['records'][0][1] or "(None)"
last_submid = res['records'][0][1] and res['records'][0][2] or "(None)"
return {"status": "OK",
"server_time": res['records'][0][0],
"last_rterid": last_rterid,
"last_submid": last_submid
}
|
