3 from monitor.database.info.model import *
8 fbquery = HistorySiteRecord.query.all()
9 loginbases = [ h.loginbase for h in fbquery ]
12 h = HistorySiteRecord.query.filter_by(loginbase=lb).first()
13 if len(h.versions) >= 2:
14 if h.version != h.versions[-2].version + 1:
15 print h.loginbase, h.version, h.versions[-2].version
16 h.version = h.versions[-2].version + 1
24 fbquery = HistoryNodeRecord.query.all()
25 hostnames = [ n.hostname for n in fbquery ]
28 fbrec = FindbadNodeRecord.query.filter_by(hostname=hn).order_by(FindbadNodeRecord.version.desc()).first()
29 if len(fbrec.versions) >= 2:
30 if fbrec.version != fbrec.versions[-2].version + 1:
31 print fbrec.hostname, fbrec.version, fbrec.versions[-2].version
32 fbrec.version = fbrec.versions[-2].version + 1
39 fbquery = HistoryPCURecord.query.all()
40 pcus = [ n.plc_pcuid for n in fbquery ]
43 fbrec = FindbadPCURecord.query.filter_by(plc_pcuid=pcuid).order_by(FindbadPCURecord.version.desc()).first()
44 if len(fbrec.versions) >= 2:
45 if fbrec.version != fbrec.versions[-2].version + 1:
46 print fbrec.plc_pcuid, fbrec.version, fbrec.versions[-2].version
47 fbrec.version = fbrec.versions[-2].version + 1