fix db consistency 'IntegryErrors'

diff --git a/checksync.py b/checksync.py
new file mode 100755 (executable)
index 0000000..2a17687
--- /dev/null
+++ b/checksync.py
@@ -0,0 +1,31 @@
+#!/usr/bin/python
+
+from monitor.database.info.model import *
+import sys
+
+fbquery = HistoryNodeRecord.query.all()
+hostnames = [ n.hostname for n in fbquery ]
+
+if True:
+       for hn in hostnames:
+               fbrec = FindbadNodeRecord.query.filter_by(hostname=hn).order_by(FindbadNodeRecord.version.desc()).first()
+               if len(fbrec.versions) >= 2:
+                       if fbrec.version != fbrec.versions[-2].version + 1:
+                               print fbrec.hostname, fbrec.version, fbrec.versions[-2].version
+                               fbrec.version = fbrec.versions[-2].version + 1
+                               fbrec.flush()
+
+       session.flush()
+
+fbquery = HistoryPCURecord.query.all()
+pcus = [ n.plc_pcuid for n in fbquery ]
+
+for pcuid in pcus:
+       fbrec = FindbadPCURecord.query.filter_by(plc_pcuid=pcuid).order_by(FindbadPCURecord.version.desc()).first()
+       if len(fbrec.versions) >= 2:
+               if fbrec.version != fbrec.versions[-2].version + 1:
+                       print fbrec.plc_pcuid, fbrec.version, fbrec.versions[-2].version
+                       fbrec.version = fbrec.versions[-2].version + 1
+                       fbrec.flush()
+
+session.flush()