git://git.onelab.eu
/
monitor.git
/ blobdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
|
commitdiff
|
tree
raw
|
inline
| side by side
fix installation and order of monitor db creation in init
[monitor.git]
/
nodequery.py
diff --git
a/nodequery.py
b/nodequery.py
index
781e841
..
e9001a6
100755
(executable)
--- a/
nodequery.py
+++ b/
nodequery.py
@@
-13,11
+13,10
@@
import time
import re
import string
import re
import string
-from pcucontrol import reboot
from monitor.wrapper import plc, plccache
api = plc.getAuthAPI()
from monitor.wrapper import plc, plccache
api = plc.getAuthAPI()
-from monitor.database.info.model import FindbadNodeRecord
Sync, FindbadNodeRecord
, FindbadPCURecord, session
+from monitor.database.info.model import FindbadNodeRecord, FindbadPCURecord, session
from monitor import util
from monitor import config
from monitor import util
from monitor import config
@@
-383,8
+382,6
@@
def main():
#fbnodes = FindbadNodeRecord.select(FindbadNodeRecord.q.hostname, orderBy='date_checked',distinct=True).reversed()
fb = None
#fbnodes = FindbadNodeRecord.select(FindbadNodeRecord.q.hostname, orderBy='date_checked',distinct=True).reversed()
fb = None
- #reboot.fb = fbpcu
-
if config.nodelist:
nodelist = util.file.getListFromFile(config.nodelist)
else:
if config.nodelist:
nodelist = util.file.getListFromFile(config.nodelist)
else:
@@
-415,13
+412,14
@@
def main():
try:
# Find the most recent record
try:
# Find the most recent record
- fb_noderec = FindbadNodeRecord.query.filter(FindbadNodeRecord.hostname==node).order_by(FindbadNodeRecord.date_checked.desc()).first()
+ fb_noderec = FindbadNodeRecord.get_latest_by(hostname=node)
+ if not fb_noderec: continue
+ fb_nodeinfo = fb_noderec.to_dict()
except:
print traceback.print_exc()
except:
print traceback.print_exc()
- pass
+ continue
if config.listkeys:
if config.listkeys:
- fb_nodeinfo = fb_noderec.to_dict()
print "Primary keys available in the findbad object:"
for key in fb_nodeinfo.keys():
print "\t",key
print "Primary keys available in the findbad object:"
for key in fb_nodeinfo.keys():
print "\t",key
@@
-434,7
+432,6
@@
def main():
if config.daysdown:
daysdown_print_nodeinfo(fb_nodeinfo, node)
else:
if config.daysdown:
daysdown_print_nodeinfo(fb_nodeinfo, node)
else:
- fb_nodeinfo = fb_noderec.to_dict()
if config.select:
if config.fields:
fields = config.fields.split(",")
if config.select:
if config.fields:
fields = config.fields.split(",")